That looks like it is a template file. If so, the function add_header_info is hooked into send_headers long after send_headers had fired. You will need to move that code so that it executes earlier. It should work from a mu-plugin file, a plugin file or from your theme’s functions.php. However, $FileType and those other variables … Read more
The table isn’t defined on your insert function. So you will need to add – $table_name = $wpdb->prefix . ‘countries’; as you did for the create table function.
“The Loop” is WordPress. Trying to get rid of it is impossible. It may return no results, but it will always be called. That being said, it does not mean that you have to call a listing of posts on your home page. If you instead plan on customizing the front page to be “static … Read more
I found what was causing the problem in this case: we are using APC Cache and the WP APC Panel plugin for WordPress. I fixed it with the following steps: go to WordPress->Tools->WP APC Panel click on the User Cache Entries tab then click Clear user cache As soon as I did this, all the … Read more
For security issues, Hostgator requires more parameters – like port, etc. – in wp-config.php to connect to a remote – non-localhost – mysql server. Read http://support.hostgator.com/articles/cpanel/how-to-connect-to-the-mysql-database-remotely
Log queries: You could collect all the queries during core/plugin/theme upgrades to see what happens. Just follow these two steps: 1) You should add: define( ‘SAVEQUERIES’, TRUE ); to your wp-config.php file to collect all queries during a page load into the $wpdb->queries array. Just remember to remove it afterwards. 2) Then you could log … Read more
$wpdb->get_var will do exactly what the name suggests– return a single value. So this: $sum = $wpdb->get_var(“select sum(first), sum(second) from sums_test where id > 1”); var_dump($sum); Will return the result of sum(first). The rest of the result is lost (though cached I believe). The method you want is get_row which will return a complete row … Read more
Don’t store serialised PHP data in the database! It can be a major security risk! When the contents of the value are deserialised, any objects get recreated and their constructors and wakeup methods run, this can be used to launch an attack. Additionally, that data can’t be search replaced, because PHP serialised strings contain values … Read more
I had an issue similar to this with two separate machines (db and web). Calls from web server to the db server were taking an extraordinary amount of time and it turned out to be that MySQL was trying to do IP resolution on each call to it, causing a DNS lookup. Because the db … Read more
I think you are jumping a gun with custom SQL, complexity of this seems still in realm of WP_Query. Even if not it’s a good idea to start with it to have more solid base for custom SQL. If I try something like this: $meta_query = array( array( ‘key’ => ‘body_type’, ‘value’ => ‘bt’ ), … Read more