Trying to change database tables storage engine to innodb gives error “invalid default value for ‘post_date'”
Trying to change database tables storage engine to innodb gives error “invalid default value for ‘post_date’”
Database
Can I restart MySQL engine when WordPress website is live?
Yes, service mysql restart (or systemctl restart mysql on more recent versions of Linux) will carry out a graceful shutdown and restart of mysql.
Replace/Mute/Stop Search Query
I had a quick grep for SQL_CALC_FOUND_ROWS and found a few instances. I’m not sure which one is being called in your case, but here’s an interesting one from wp-includes/class-wp-query.php line 2904 onwards: $found_rows=””; if ( ! $q[‘no_found_rows’] && ! empty( $limits ) ) { $found_rows=”SQL_CALC_FOUND_ROWS”; } $old_request = “SELECT $found_rows $distinct $fields FROM {$wpdb->posts} … Read more
Redirecting to old domain after migration website
First of all, make sure you’re domain has correct nameserver setup and you’re uploading files to correct place. When you are changing URL from database directly, here’s a checklist. The URL must be changed only from wp_options table and update only siteurl & home (basically first 2) rows. Make sure you’re setting http/https correctly. set … Read more
Allow logged in users to store and display some data
Allow logged in users to store and display some data
When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
$wpdb does not contain any reference to custom tables. So the uap_banners property doesn’t exist. You need to write in the table name the say way it was written when creating the table. So in your case that would probably be (assuming you included the database prefix): $user_checks = $wpdb->get_results( ” SELECT id, name FROM … Read more
How to move the WordPress site Layout from test site to Production site?
How to move the WordPress site Layout from test site to Production site?
Improve performance by removing unnecessary database queries
Options are persistent. You can set them when you activate your theme and then just use them. There’s no need to change them when rendering any particular page unless your logic actually changes them. And doing so may cause confusion. For example, lots of changes to image and thumbnail default sizes will make your Media … Read more
Needing to move content from postmeta to posts in sql [closed]
Needing to move content from postmeta to posts in sql [closed]
How to replicate a user plugin made table value, to this user’s custom meta table value?
How to replicate a user plugin made table value, to this user’s custom meta table value?