New answers tagged database
0
votes
Updates applied to staging WordPress site affecting production even with different databases
I have resolved my issues by reviewing the Redis Cache plugin installation guide and making the following changes inside the wp-config.php files on each WordPress installation.
The define( '...
0
votes
Re-creating a Wordpress database
SSH in and use the wp-cli command:
wp db reset
After that you will have to go through the WordPress installation process again. The installation won't delete any plugin or theme files (tested in 2023)...
1
vote
Can't change login logo & css - older plugin data blocking?
Found it!
If you are googling ypyp-sym-tsym, almost nothing comes up, so I'm adding the answer here, in case somebody else stumbles upon this issue.
The plugin that added this was yellowpencil (ypyp), ...
0
votes
Wordpress post on home page of my website
Step 1: Update WordPress General Settings
Log in to your WordPress admin dashboard.
Go to Settings > General.
Look for the fields labeled "WordPress Address (URL)" and "Site Address (...
0
votes
WordPress hook which triggers on post import
I checked and found none in WordPress Importer 0.8.1 fireing after all insertion of a posts have been made (terms, postmeta, comments)
Solution 1:
You can use the built in WordPress hook that fires ...
0
votes
Where is the order of a menu saved in the database
old post but a weird answer, maybe this is more current: fields for a post are either in the wp_posts table or the wp_postmeta, the one for menu_order is in wp_posts.
You can use the menu_order ...
-1
votes
WPDB Insert or if exists Update
use $wpdb->insert, $wpdb->insert can insert and update too.. IN 2023
EDIT
$wpdb->insert not update the row , use $wpdb->replace
1
vote
Accepted
Understanding Redundant postmeta Tables in WordPress Database
Is it normal to have multiple postmeta tables in a WordPress database?
No, each site has a single post/user/term and comment meta table.
A multisite will have a set of those tables for each site in ...
Top 50 recent answers are included
Related Tags
database × 2528mysql × 396
php × 265
plugins × 251
wpdb × 238
plugin-development × 173
sql × 141
multisite × 118
posts × 116
customization × 112
custom-post-types × 108
query × 103
wp-query × 100
users × 96
migration × 93
forms × 77
custom-field × 72
options × 72
errors × 66
phpmyadmin × 62
table × 60
post-meta × 58
performance × 49
user-meta × 47
functions × 46