I can’t simulate this on a clean install of WordPress. So probably there is some extra filtering of XSS/Injection prevention happening on the server side. You should probably check that out first.
How can we speed up wp_get_nav_menu_items()?
It would be bad practice to have two sites running off the same database. This is especially true if you were to perform plugin / core updates on one or the other. You would be much better off using something like migrate-db (https://wordpress.org/plugins/wp-migrate-db/) to perform a migration. The maintainers of migrate db are also working … Read more
Add following in WHERE condition of your SQL query. WHERE t1.meta_key = “<?php echo $wpdb->prefix; ?>capabilities” AND ( t1.meta_value LIKE ‘%ROLE_YOU_WANT_TO_FILTER%’) Let me know if it works for you or not.
The site and home URLs aren’t serialized, if you access to the database export, you can change them directly in that file with a text editor. You can also override the database values temporarily in wp-config.php with some defines: define(‘WP_HOME’,’http://example.com’); define(‘WP_SITEURL’,’http://example.com’);
Did you check if the table prefixe in wp-config is same as per your database.. To check the table prefix of your database go to phpmyadmin. Click on your database and expand it If you notice in following image , you will find out that all the table have prefix “wp_” .. so that means … Read more
How to optimise this database query?
WPDB delivers wrong results from complex queries
This error is usually caused by incorrect database credentials in your wp-config.php file. Open that file and verify that the database server, name, user, and password are correct.
Check that you have assigned the user/pass to the database via your cPanel. And that those credentials match what WordPress expects. Usually, the WP install process will do this for you. (I assume that you created a new WP installation, and are not trying to re-use an existing database.) Also, you should obfuscate the URL … Read more