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
Thanks Milo for the answer! This block of code selects posts that have two categories at the same time. ( ( SELECT COUNT(1) FROM wp_term_relationships WHERE term_taxonomy_id IN (35,33) AND object_id = wp_posts.ID ) = 2 ) Where 35,33 are categories IDs and 2 – number of categories.
There are several things going on here Firstly, your dbDelta call never receives a CREATE SQL statement. $sql is only defined if the if statement is true, and if your developer environment is setup correctly then running this code should generate PHP Warnings. You’re actually running dbDelta(”); dbDelta already does this check though. It’s not … Read more
How to display $wpdb->insert_id; value on redirected page
If i understand well, users will update their datas in front-office, and you need to save datas in your custom table. I think you must check on wp_ajax process which will allow you to post datas in JS to a WP_ajax handler. This handler will be a PHP function, (can be written in your theme’s … Read more