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
20 views

Creating a custom form with ability to query and submit to SQL

I need to create a rather unique customer invoice/purchase form and I have been searching google with different questions for a week without finding an answer, hopefully someone here can point me in ...
0
votes
1answer
31 views

Shortcode select another dbbase

i need connect another database in same host and return product value(woocomerce). The return is null add_shortcode('product_project_test', 'product_project_test'); function product_project_test() { ...
0
votes
0answers
9 views

VPS - WordPress - issue with permalink and database connection

I am using VPS (Ubuntu 18.04) and have a WordPress setup in it. After a successful installation, I faced a permalink issue. Only the homepage shows output and all other pages show 404 in front-end. I ...
0
votes
0answers
18 views

How do I change several broken URLs in a several wordpress databases in the fastest way?

I tried and searched but not yet achieved. I have a 167 wordpress websites on my host and for almost every website the logo URL is broken (pointing to an unavailable IP address). I found the right ...
0
votes
2answers
16 views

How select query is generated in a Custom Post Type?

I have this table that is generated in a Custom Post Type (CPT) Is there an option that I can modify the query? For example, I have this post_type = 'my-type' in wp_posts table. I want to do a JOIN ...
0
votes
0answers
14 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
0answers
26 views

What should I use to develop a activity logger? [closed]

I'm developing a plugin with Wordpress and I want to save all user activity regarding my plugin. I would like to know if the best way to code it is to use CPT or create a custom MySQL table. I think ...
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
7 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
10 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
35 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
19 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
23 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
12 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 ...
1
vote
0answers
25 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 ...
0
votes
0answers
26 views

How to insert JSON using WPDB

how to save json using wpdb same as the image below. can you give me a code on how to achieve this.
1
vote
0answers
10 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
23 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
15 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
20 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
7 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
19 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
26 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
86 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
46 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
68 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
13 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
20 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
18 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
34 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
16 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
23 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
17 views

Form submission in WordPress Admin Panel

I am new in WordPress. I am learning WordPress plugin development. I have a Form in Admin panel like below. <div id="ajax-response"></div> <form method="post" name="newAddress" id=...
0
votes
0answers
30 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
15 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
71 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
35 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
12 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
22 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
9 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
24 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
12 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
14 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
23 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
24 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
19 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 ...