Questions tagged [database]

WordPress stores user generated content, along with other configurable information, in a database (typically MySQL).

Filter by
Sorted by
Tagged with
0
votes
0answers
17 views

why not selecting multiple rows of same standard_id using SQL query from database?

i have invested much more time in simple query ,i was trying to select different rows of same standard_id and in my database is two such rows which have same standard_id but from them i only getting ...
0
votes
1answer
12 views

Bulk find & replace on Wordpress posts/pages (minus image paths)

I'm dealing with a tricky issue and wondering if anyone has a good way to solve this. I am trying to change everything on my Wordpress site that has "2019" in my posts/pages with "2020", however when ...
0
votes
0answers
10 views

wordpress user database transfer

I want to trasfer my wordpress user database to my native php coded database which not contains wordpress cms installation. Is it possible to transfer my user data base so that existing user never ...
0
votes
0answers
12 views

“Additional CSS” data keeps reverting back to default example, multiple rows in database created

Not really sure the best way to word this. WordPress stores the CSS in Customizer->Additional CSS in the wp_posts table, with the post_type set to 'custom_css' and the post_name set to the theme slug. ...
0
votes
1answer
169 views

How do I have now a duplicated user entry if this is not allowed (and I cannot replicate it)?

In my website I have users registering with the email as the username If I try to manually add a new user and I use a username (which is a mail) that already exists, WP complains and tells me that ...
0
votes
0answers
32 views

Can’t access wp-admin after update, db_version mismatch

I performed an update from 5.1.3 to 5.3 first locally, and now on the server. Locally I had no problem, but on the server, I get redirected to /wp-admin/upgrade.php?_wp_http_referer=%2Fwp-admin%2F ...
1
vote
0answers
24 views

How do I delete these post types in my WordPress database?

I have two post types from an old template I'd like to delete but I can't figure out where to remove them. I thought I saw them in MySQL database but I can't locate them again to remove them.
1
vote
0answers
17 views

Multisite with subfolders- can't access main site- Error establishing a database connection

I guess the issue might be somewhere in the database with ip instead of the domain, but I can't access the database. I can access the subfolder site mydomain.com/site, but can't access the main ...
0
votes
0answers
55 views

How to fix broken database (plugin editor always shows 'active')

I have a multisite. I tried to disable plugins by using phpmyadmin wp_sitemeta -> active_sitewide_plugins. I think I put the wrong value for a bit and it was broken. I was able to restore to the ...
1
vote
0answers
12 views

WP character encoding error after sharing post on Facebook �

I'm running a WordPress website with a custom theme that's having some problems lately. After clicking a shared link on Facebook that points to my website, I sometimes get an character encoding error. ...
0
votes
0answers
67 views

wp query search multi terms

i have this code it work perfect if i search for 1 term but when i add 2 terms to search it fail protected function process_item ( $data ) { try { $data = array_map ( 'trim', $data ); ...
1
vote
0answers
24 views

How to select from two different tables to display orders list with custom column from other table

I have a table which contains additional data about customers orders I want to create a table output on specific page when user loges in. when the user logs in I want to display to him all his orders ...
3
votes
1answer
36 views

Export User Info to CSV from Front End

Trying to export to CSV from WordPress front end. Here is what I have so far. I was able to export to CSV from the admin area, but for some reason I am unable to export from the front end. What am I ...
1
vote
0answers
11 views

Catalina an MAMP Database Conenction Error

Ive updated my MACOS to Catalina and MAMP Pro 5.5.1 to find none of my existing site work. All I get is 'Error establishing a database connection'. Ive moved over my httdocs and db folders. Everything ...
1
vote
0answers
26 views

Sending data with multi step form to wp database

I have a multi step form and I need to save data from each step to the db. First step is contact details and by clicking button "Next" data should be saved to db. In my form template I have js code ...
0
votes
0answers
118 views

Wordpress database problem wp_posts, primary key

Repende my website in wordpress did not let me work properly, did not let me publish an article and showed me a problem in the editor show the message: "You are editing the page that shows your latest ...
2
votes
1answer
104 views

Block search SQL from happening

I need to block some accesses to search results not the whole page, just the results. The problem is, I need the search SQL query to not happen AT ALL. (I can conditionaly hide the output loop ...
0
votes
2answers
51 views

How to submit the custom form data in database in WordPress without plugin?

I have a created a contact form in the function.php and added short code on my page and it's working. I am getting my form. function st_contact_form(){ ob_start(); ?> <div class="...
1
vote
0answers
169 views

Slow queries constantly getting stuck on Wordpress database of ~100,000 posts

I am constantly getting stuck SELECT queries on my wordpress databases like the following: Many of the SELECT queries that get stuck are fairly ordinary, such as pulling the last 10 posts of an ...
0
votes
0answers
14 views

Wordpress plugins always deactivates by itself after “Database is required” loop

After updating the latest update in wordpress, this "Database is required" loop keeps going and it deactivates the plugins. I already tried the solution that the other sites/forums gave which is to ...
0
votes
0answers
48 views

Generate PDF form on click a button

I developed a WordPress website that has a game developed by unity, and once the player finished the game he got a result button once he clicked the button I need some API to create a database record ...
0
votes
0answers
27 views

Change user_nickname for author page link

I have a page where user can change their personal info. Now I want to give them a possibility to change their personal page link by changing theire user nickname. So I want to create simple form with ...
1
vote
1answer
188 views

Why is the post meta[] empty when I make a call to the wordpress rest api?

I am getting posts with a certain term by using /wp-json/wp/v2/my_post_type?my_categorie=43 but upon inspecting the JSON object I noticed that the meta is empty? I am using Advanced Custom Fields and ...
0
votes
0answers
18 views

How do I cleanup my database with data that is no longer being used?

I am working with Advanced Custom Fields and I noticed that once I delete a field for a custom post type it will stay in the database. Is there a way that Wordpress can do a cleanup for everything ...
0
votes
0answers
14 views

How to allow URL with filename & extension in wordpress?

How to create custom URL routes? I wanted to generate csv using specific url for ex. https://www.example.com/exportcsv.csv Is this possible via WordPress? I have tried with querystring and all the ...
0
votes
0answers
28 views

Plugin Data not stored in Database

I am using a Wordpress plugin called ****Easy Accordion****. The problem is plugin data is not stored in the database. How can i do that? Pls, help me to get out of this. Thank you
0
votes
0answers
67 views

Insert variables into wpdb in custom post template

I'm rewriting this to try to make it easier. I am inserting into a database table information which is sent when I click on a button in the page. When I insert the data it works, unless I try to ...
0
votes
1answer
32 views

Using Transients

I am new to the transient concept. But I am not sure about the efficient method to use it. I really liked it as it removed the duplicate queries that I had. I have set set_transient( '...
0
votes
2answers
594 views

How to store ACF custom fields data in a custom table

I am using the ACF Custom Fields plugin to store some info, but to my understanding, it is stored in the wp_postmeta table. Is it possible to store it in a custom table instead? So for example, the ...
0
votes
0answers
12 views

Database & Post Search

Such as my site will include 10.000 posts with wp-category and 10 different taxonomies (age, country etc) and i can filter all posts by taxonomies and category. Which is better for database health? 1 ...
0
votes
0answers
15 views

How to import products in host instead of database on wordpress?

Once I add new product in WordPress, this product adds in MySQL database and database gets bigger and bigger after months I would like to write post/page/products on the host instead of the database ...
0
votes
2answers
76 views

Is it necessary to auto delete my WP plugin database tables when users deactivate/delete my plugin?

Is it actually a necessity to auto delete all the corresponding table rows when users are attempting to delete my plugin? From my experience, I've encountered a few plugins where the db tables would ...
0
votes
0answers
19 views

Calling wp-load from a subdomain of a site not using wordpress

I am building a mobile specific site that does lots of things. One of these things is get data from the primary wordpress website. I had assumed I could just call wp-load.php from the subdomain and it ...
1
vote
1answer
29 views

Merging two databases without borking it

Does anyone have a solution to the following issue: I have a staging and production server. We've done work on staging but things have been changed on production so we can't just move the DB from ST->...
0
votes
0answers
12 views

How to set up a login system with file upload?

Hope you are having a great day. I am trying to find a user registration system for Wordpress that does the following: A user will register by their first name, last name, home address, P.O Box and ...
0
votes
0answers
25 views

What is recommended data type and encryption type for password in a database

I want to know what data type and encryption type best to use in a database for user passwords. Thank you in advance.
0
votes
0answers
22 views

In which table is saved the original publish date for each post? [duplicate]

I often modify the publish date, but I keep every revision. Where can I find when the post was published for the first time?
0
votes
0answers
13 views

How to Modify a specific Cell in Google sheets via Gravity Forms

So basically I am able to successfully send data from gravity forms to a google spreadsheet. However, my work now requires that I would need to pass data to a specific cell. Is this even possible? ...
0
votes
0answers
17 views

How do I give the user the option to toggle the sidebar to the left or right side of the theme?

I know how to create a settings page with add_menu_page, and add a drop-down menu with two options using add_settings_field. What I need to find out is how do I then allow the user to save their ...
0
votes
1answer
31 views

Unable to login to a https website via the app after changing from http

Put simply, I am unable to login to my site through the wordpress app. I was able to previously login, but since the update I have not been able to. I believe this may have happened since I moved the ...
0
votes
1answer
25 views

Using custom php to connect to database blocks wp from accessing galery pictures

I'm using simplepie to get a bunch of rss feeds and post them in a database from which I later show them on my page. I've added a custom php file with a shortcode to do this. // Connect to DB $...
0
votes
0answers
52 views

$wpdb->insert duplicating rows

I'm using $wpdb->insert to insert data into a custom table on my wordpress database. Unfortunately, it is inserting the data multiple times. I have searched through other topics posted, and haven't ...
0
votes
1answer
18 views

Move posts from a non-wordpress site to wordpress

an old web site (not created in wordpress) has many posts and its schema database differs from wordpress schema database. I need to move posts from that site to wordpress. What is the best way? I ...
0
votes
1answer
17 views

A query to substitute images paths in gutenberg (website migration)?

I was used to do something like update wp_posts set post_content = replace(post_content,'http://dev.example.com/website', 'http://www.website.com'); This seems not to work anymore for texts that ...
0
votes
0answers
13 views

wordpress page title (html title tag)

First of all, I am working on a website that is using flywheel for its hosting. I develop the theme locally then push the changes via sftp to the staging server and then from there to production. ...
0
votes
0answers
56 views

Is there an actual way to synchronize 'production' and 'develop' WordPress databases?

I work with WordPress and I work with git. My code is versioned and I am happy with the workflow. What bugs me is database synchronization. I need to work with cloned database on my local ...
1
vote
1answer
120 views

wp_insert_post not working

I'm trying to get the movie info from the omdb web service and it worked fine but it doesn't work when I want to use wp_insert_post to create new posts. This script acts as the user enters the movie ...
1
vote
1answer
35 views

For WordPress is there content in the database which I can safely ignore?

I am exploring possibilities to minimize the size of the database dump (for backing up the WordPress content automatically) of several WordPress instances. What I am wondering about most of all is if ...
0
votes
0answers
11 views

How to Rename Error Messeage “Establishing A Database Connection”

my vps under ddos attack and i need to rename the error message of Establishing A Database Connection" where could i rename this error? which file?
0
votes
0answers
14 views

Restrict adding more administrator accounts

How to limit number of WP site admins to i.e. 2. So if current WP admin wants to create new admin, old account need to be deleted. (this can be added even on database level) I need this feature to ...

1 2 3
4
5
46