I found the reason: term_id is the ID of a term in the terms table. term_taxonomy_id is a unique ID for the term + taxonomy pair. see: What’s the difference between term_id and term_taxonomy_id Still, I think it’s a bit strange to do it this way. Also because I think it doesn´t make sence to … Read more
Why are my WordPress post queries so slow?
The Solution is: every normal character stored in weird starts with &# ends with ; like this ٪ So you can simply 1-open you dreamweaver 2- new HTML file 3- code tab 4- delete all the code in it 5- put one weird code like this ٪ 6- design tab 7- you can see the … Read more
You can update just joining both table on comparing same userid. like: update t1 join t2 on t1.user_id = t2.user_id set t1.meta_value = t2.desc;
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”