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

How to extend database with efficiency

I've been wondering what is the best way to insert new values to a plugin built over a plugin. I'm using QSM quiz plugin for Wordpress, but I also need custom feature to include. It would add some ...
0
votes
1answer
13 views

Why theme options are dissappeared after migration

I would like to get data from production environment into test environment. To be faster, I would like only export the prod database and import it into the test database after drop the last one This ...
1
vote
1answer
13 views

Why is it that not all users have a 'session_tokens' meta_key record in the usermeta table?

I've created my own code based on this good article - https://shocksolution.com/2019/04/16/find-last-login-time-for-wordpress-users-in-the-sql-database/ to get the last login date for a user. I'm ...
1
vote
1answer
10 views

WP All Import - Using Xpath to set a select value

I'm working on setting up an import using WP All Import, the idea is to update/add/remove posts within a custom post type which contain ACF fields. The CSV we are importing contains a column called &...
0
votes
1answer
18 views

Any other way of storing plugin admin data setting

I created a plugin, and used the add_admin_menu() to add some page for users to put their Api keys and secret word. My page content is just a form to collect those data the users puts in, now my ...
0
votes
1answer
23 views

Sending posts from Python to WordPress

We are working on a platform that gets news from various sources and runs some NLP analysis on it. We have the backbone of the backend down, we're now trying to output our results on a feed. Since ...
0
votes
1answer
12 views

Will memcached improve performance with WP Super Cache already running?

I'm working on a WordPress site that is expected to host up to 1000 concurrent users, so I'm exploring ways to make it run as fast as possible. I've heard that memcached helps WordPress sites load ...
0
votes
1answer
17 views

Will there be any concern if I upgrade my current Wordpress Database server from Centos 7 Mariadb 5.5 to Centos 8 Mariadb 10.3?

Currently I am using a dedicated web server connected via private network to a dedicated database server to run Wordpress. The database server is running on Centos 7 and mariadb 5.5. I am considering ...
0
votes
1answer
16 views

Writing a function for WP Cron to run a SQL command daily

I usually use the events manager in PHP MyAdmin to set up scheduled events but since migrating to WP Engine they do not allow it and I must write a function to use WP Cron instead. What should this ...
-2
votes
1answer
30 views

Where are database files of a WordPress website?

There are many threads talking about managing database of WordPress via phpMyAdmin. But surprisingly, not many threads show where these files exactly are in the server. There is a thread here: ...
0
votes
0answers
5 views

I want to schedule email (date, time is in database->table) wp_schedule_event() not working

I want to schedule email (date, time is in database->table) wp_schedule_event() not working, I want to send emails to clients on future different dates and times from database, I am developing ...
0
votes
0answers
6 views

Insert Registration Form(using ultimate member plugin for Registration Form) data into Database

I am trying to insert the Custom Registration Form data into Database. I have used ultimate member plugin to create Form. Then I am using a Page to Display this Form. I have seen php code in google to ...
0
votes
1answer
21 views

Having issues with wp_postmeta and wp_usermeta tables too big

We've got a WP+woocommerce site that is over 8 years old. The site has over 60,000 users and a similar number of orders. The wp_postmeta has over 4,000,000 records and wp_usermeta has over 1,500,000. ...
0
votes
1answer
48 views

Error establishing a database connection (configuration)

I hope you can help me to fix my problem. I am using WordPress for the first time, and I don't know why I am getting Error establishing a database connection knowing that I have created the file wp-...
0
votes
0answers
17 views

How performant is update_option relative to update_post_meta when updating on each post load?

I've created an AJAX function that updates the views count of each post load. public function updateViewCount() { // ... $postID = $_REQUEST['post_id']; $key = 'post_views_count'; $...
0
votes
1answer
13 views

Why do database examples sometimes finish with an add_option call?

Take for an example this perfectly ordinary demo of adding a table. I'm assuming we've all seen examples like this before. function create_table() { global $wpdb; $table_name = $wpdb->prefix ....
1
vote
2answers
25 views

How much of my site can I recover from public_html?

While exporting our site in order to migrate it to another hosting, I failed to import the database. This is necessary since all the posts and pages are kept only in the database, and I'm afraid the ...
0
votes
2answers
41 views

WordPress Development Workflow

Hello WP DEV Community, I understand this question has been asked ad nauseam... I'm trying to customize a development workflow (WordPress + WooCommerce) that allows me to develop locally (to speed up ...
1
vote
1answer
20 views

Migrating Wordpress from DreamHost to Azure Wordpress Resource via UpdraftPlus “wp_options table does not exist…” error

Goal Our goal is to migrate a wordpress site from DreamHost to an Azure Wordpress resource. Process and Errors We installed UpdraftPlus (pro version) on both builds. We utilized it's Send a backup to ...
0
votes
1answer
13 views

In which format the data is stored in Wordpress Databases?

In lot of cases, I have seen the wordpress stores data in JSON like structure but not exactly JSON. For example, in usermeta table, this is the value (with meta key as wpkgbe_capabilities) a:1:{s:13:&...
0
votes
1answer
17 views

Is there a way to edit the WP content database in an admin panel or external page?

I have a lot of content and some of it needs to be updated and edited. I was wondering (hoping) that there is a way to access the database from an external linked source, i.e. Excel, or in a table on ...
0
votes
2answers
45 views

WP 5.5, child themes, customizer and a weird cache issue

Update: I created a fresh new installation of WordPress, copied both Base and Base Child themes and activated Base Child. The Appearance/Customize gives the same white screen as described in point 1 ...
0
votes
1answer
20 views

How to list all categories and their IDs using SQL query?

I am looking for a SQL Query that can give the list of all categories created in WordPress Site along with it's category IDs. Please advise a query to get it as category/term relationship is quite ...
-1
votes
0answers
16 views

How can I store form data in wp_options?

I have created a new custom plugin and now I want to store from data into the wp_options table. How can I store form data in wp_options?
0
votes
0answers
23 views

How to Submit Form in Admin

I have a Form in Admin. How can I Submit Form in Admin Panel ? I searched a lot in Google but did not get any good result. How the Add New User for is submitted ? I would like to follow the way.
0
votes
0answers
18 views

How to filter database data based on select options using jquery

I found this code on a website which works fine for filtering data from two different select box but I have totally five comboboxes. I want to extend this functionality to work for the other three ...
0
votes
0answers
14 views

How do you tie a database to a block?

I am rather new to wordpress, and need help tying a database to a block and get it to function like a search engine for a candidate.
0
votes
0answers
11 views

Delete Custom Post Types via SQL

I have a website that operates similarly to many freelancing websites where people can make bids. Its become painfully slow in recent weeks and I used query monitor to find out the issue is likely ...
0
votes
1answer
27 views

Update wp_postmeta table based on 2 keys

I want to update the wp_postmeta table in the database based on 2 keys, is there a way to do that using any of the wordpress default functions. This is my DB query which is working fine: $sql = "...
0
votes
1answer
30 views

/wp-admin not accessible after migrating to local host (no plugin issue)

I migrated my local Wordpress site to my WPEngine account and it's been working without any problem! After adding some content, I decided to export the database from the live version and import it to ...
0
votes
1answer
15 views

Any risk to changing WP table col CHARACTER_MAXIMUM_LENGTH?

I made a li'l module to help myself develop sites for various clients, and one thing it provides is an easy template for custom post types. It allows me to register post types much more easily and ...
3
votes
1answer
29 views

Prevent changing the length of post_name column on WordPress Update

We've some Arabic websites running on WordPress, and use Arabic slugs in the posts' URLs. You know that post slug is stored in the post_name column in wp_posts table, and the default length of this ...
1
vote
1answer
42 views

Saving data from block editor to the database

I'm developing a wordpress plugin and looking to save data entered in a block to a mySQL table. That's it. But how can data be sent from the block editor to the server side? I've spent two weeks ...
0
votes
1answer
20 views

How to re-connect WP files in lampp/htdocs to new SQL database to recover site under development

First time here, facing a bigtime wordpress situation. My Ubuntu installation crashed beyond repair during upgrading version. Managed only to copy the wordpress files, installed in /opt/lampp/htdocs, ...
0
votes
1answer
37 views

Should I use docker in wordpress production?

My question is, is it a good idea to use docker for a big woocommerce website (more than 100k products)? Or will this incur a noticable performance cost compared to running wordpress straight on the ...
0
votes
1answer
21 views

when looping through custom post data not appearing

i have a loop that fetch custom post type from the database now when i go to the page the data doesnt appear but when i refresh the page 2 times the data shows here is the code: <div class=&...
0
votes
1answer
52 views

Problem migrating to localhost

Hey guys :) I have to following case. I was given a WP site for "fixing". The website is huge in size. It's around 3GB and the DB is around 350MB. Most of the DB size is coming from postmeta ...
0
votes
1answer
20 views

How to do database for download stats?

So I have a existing wordpress site and we are building now download section for it. Downloads will be custom post type and files. Now we need to have some stats, like number of downloads per cpt (...
1
vote
2answers
29 views

Where does WordPress store plugin (enabled/disabled) status for multisite?

A recent update to one of the plugins I use broke my multisite blog and in the process of debugging it, all of the plugins got disabled. Now I have to try to figure out which plugins used to be ...
1
vote
0answers
17 views

Updating Media Published Date When Parent Post Is Modified in Wordpress

I am hoping to make the published date of my media files always equal the modified date of the post it's attached to. e.g. Image 1 (date: 1/1/20 5:00PM) is attached to Post 1 (date: 1/1/20 5:00PM) ...
0
votes
0answers
18 views

Export database from WordPress.com? [closed]

Is there any way to export the database from a site at WordPress.com on the business premium plan? I have the XML file and I have media files. What I am really after is theme settings, but the entire ...
-2
votes
1answer
27 views

How to create a table [closed]

This code doesn't work for me. Do you have one where I can create a table in my database? function creation() { global $wpdb; $table_name = $wpdb->prefix . 'form'; $sql = "...
1
vote
1answer
34 views

WooCommerce sku location in DB

I need a little help. We want to connect our physical shop system with our virtual shop developed with woocommerce. So we need to be able to find where the SKU numbers are registred in the database so ...
0
votes
0answers
14 views

Recurring 502 Bad Gateway issue

Hoping one of you out there can offer suggestions or at least tell me I'm not alone. Our WP site has had a random 502 Bad Gateway problem for few days now - happens once every few page loads. I've ...
0
votes
0answers
18 views

Display user data in numbered list

We sell a downloadable product. Each download requires registration and those who register for a download are assigned to a user role called "TFWPdownload". The registrants are further ...
0
votes
0answers
19 views

How to use WordPress header function and footer function and not load word press database

I am no longer able to access my database after including WordPress functions in my index.php file. I used the following WordPress functions to access the WordPress header and footer <?php @...
0
votes
0answers
16 views

Job and Employee Performance Tracking with Product Safety

We are looking to connect a WordPress site to our database where an employee can scan an order barcode with an RFID scanner that was generated from our database and have the WordPress site query the ...
2
votes
0answers
22 views

Storing Email Account Passwords for SMTP Mailing for a WordPress Plugin

I am currently converting a client booking system I created into a WordPress plugin. It uses the PHPMailer library to send emails. I am using SMTP security to send the emails and thus need the email ...
0
votes
1answer
15 views

How to fix Uploaded to this post option to see group of images uploaded to a post?

I'm transferring a site using the WordPress importer and Exporter settings. First, I downloaded the Posts content and the Media content, so I have two xml files. After importing in the new site, I ...
0
votes
0answers
29 views

wp_update_post gives 500 internal error

i'm editing a wordpress plugin and im trying to call a function within the thank you page, and in that function it has wp_update_post function to change the status in the database, the function works ...

1
2 3 4 5
47