There are $wpdb->charset and $wpdb->collate. I am not sure if or when one of these values might be empty, so it is better to prepare for empty values … From my DB class: /** * Get table charset and collation. * * @since 2012.10.22 * @return string */ protected static function get_wp_charset_collate() { global $wpdb; … Read more
Download user generated data from WordPress
Alright. I think I cracked it. <dateTime.iso8601>20140111T20:39:15</dateTime.iso8601> Should be: <dateTime.iso8601>20140111T20:39:15Z</dateTime.iso8601> Looks like the toolkit I was using didn’t quite implement iso8601 perfectly (or wordpress isn’t – not sure). I’m using Node WordPress and tracked down that it uses the module Node XML RPC to actually send the XML RPC. This seems to be where the … Read more
The query itself may need to be optimized (SQL is not my speciality, though). However, don’t forget you can store the results of an expensive operation in cached memory. WordPress offers a Transients API to make things easy. Here’s a quick example: // Try to load the value from cache $transient_key = ‘my_query’; $value = … Read more
Definitely time for an upgrade. 🙂 Try logging into your admin and following the link below. Just make sure to change ‘yoururl.com’ to whatever your website name is. If you have posts in the trash, that should take you to your trash to see them. http://yoururl.com/wp-admin/edit.php?post_status=trash&post_type=post
Every time I update or install a plugin I get “Error Establishing a Database Connection in WordPress”
As you already deleted all the posts in the table, this is going to be quite a bit of work manually. For the next time you do something like that, use wp_delete_post( $postid, $force_delete ); (Codex) while looping through all the posts with that posttype, as this function deletes all the data associated with that … Read more
Fixed this by setting max_allowed_packet = 16M in my.cnf and restarting mysql
For database caching you should try Memcached instead, in PHP 5.5, APC for W3 Total Cache will not work like for 5.4 or 5.3.
Category not displaying in add post, edit post, and categories page.