At first glance, I would think your query isn’t correct. Are you echoing out the variables to make sure they are correct? If you are setting ‘post_per_page’ => 4 and you are getting 5 posts, then something seems a bit off. Where it is a number, I believe you can leave off the quotes around … Read more
WordPress Query wp-terms SLOW
a simple and Not perfect solution which will do most of the job for you is to overwrite the table names like this: function custom_prefix_change($sql) { global $wpdb,$wp; $prefix = $wpdb->prefix; if(is_single()){ //check if the post exists in the genuine posts table $results = $wpdb->get_results($sql,”ARRAY_A”); if($results[0][‘ID’]){ //if exists then return return $sql; }else{ //else change … Read more
I found out what is wrong. The tutorial says to remove all double quotes ” and replace them with spaces or backticks `, but some values in the mentioned tables have double quotes around them. This one for example: INSERT INTO “wp_usermeta” VALUES(14,1,’wp_capabilities’,’a:1:{s:13:”administrator”;s:1:”1″;}’); So replacing that with backticks causes malfunction. Replace only double quotes around … Read more
DISCLAIMER : Not a WordPress Developer, Just a MySQL DBA For a given table, say link_url mysql> show create table wp_links\G *************************** 1. row *************************** Table: wp_links Create Table: CREATE TABLE `wp_links` ( `link_id` bigint(20) unsigned NOT NULL auto_increment, `link_url` varchar(255) NOT NULL default ”, `link_name` varchar(255) NOT NULL default ”, `link_image` varchar(255) NOT NULL … Read more
WordPress plugin overloading with tmp tables
The solution: I pasted the block of Mutisite code below the “That’s all, stop editing! Happy blogging.” line. I’d installed multisite so often that I didn’t pay attention to that part. So if you ever think you’ve installed multisite correctly but the My Sites button never appears, you’ve pasted the definitions too far down in … Read more
You could try what wp-cron.php does and set in your AJAX handler: ignore_user_abort(true); But this might cause other problems, for example when the API takes an hour to respond. 🙂 Try to log all API response time for while to see if that is really the problem.
How to fix database error duplicate entry
Your question isn’t much of a WordPress related question, more like a MySQL question. But I have sort of a solution in my head: You could go with a custom query and a replace on the apostrophe: SELECT * FROM `table` WHERE REPLACE( `column`, “‘”, “”) LIKE REPLACE( ‘string’, “‘”, “” ) For a combined … Read more