Four changes to your script. Limit $users to users with ‘administrator’ role. Removed line if($user->caps[‘Administrator’]!=1) continue; as every user is an administrator. Changed ‘post_per_page’ to -1, to process all posts. Added wp_reset_postdata(); after each loop: $users = get_users( array( ‘role’ => ‘administrator’ ) ); foreach ( $users as $user ) { $query = new WP_Query( … Read more
Your problem is the constants OBJECT_K. In the documentation you can read that this constant ensures that duplicate keys are discarded. From the wordpress codex entry: Any of ARRAY_A | ARRAY_N | OBJECT | OBJECT_K constants. With one of the first three, return an array of rows indexed from 0 by SQL result row number. … Read more
Sorry to hear you are getting the “Error while sending QUERY packet’ message. The best we can tell, this has to do with the max_allowed_packet_size. This should be able to be set via the php.ini file. You may find more information at this post regarding the issue. Source: Branex
Your count for that query may be 0. Make sure $wpdb->tablex is correct. Also, definitely use $wpdb->prepare $user_followed = $wpdb->get_var( $wpdb->prepare( “SELECT COUNT( * ) AS total FROM {$wpdb->tablex} WHERE type = %d AND active = %d AND user_id = %d”, 4, 1, $user_id ) );
$post_content=”"Neque porro quisquam est qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit…"”; Try encoding special characters. See: http://www.w3schools.com/tags/ref_entities.asp & http://php.net/manual/en/function.htmlentities.php
It’s not clear what you are trying to acheive … but CIMY extra user fields is a good plugin and using any sql editor (like SQLyog or PHPMyAdmin) you can browse your WordPress database tables. You’ll see that CIMY creates and stores all this information in the WordPress database. You can find a lot of … Read more
195 queries for one page is a lot. 7000 queries is not a lot, it is insane. Install Query Monitor. It tracks all queries and presents them in groups. I don’t know if it can track that many queries, this is probably an interesting stress test. 🙂 Find the source of those queries, deactivate it. … Read more
Realistically: Not every kind of data fits well into the WordPress meta model. Sometimes, you’d be better off making a custom set of tables for your data. If you have to query against 7 different meta values and a taxonomy, then perhaps a custom post type is not the best way to store your data. … Read more
In SQL statement use placeholders instead of variable: %s (string) or %d (number). The second argument of prepare() is array of variables to substitute into the placeholders. $skill_select = $wpdb->get_results( $wpdb->prepare(” SELECT skill_name, char_id, um_id, c.class_id FROM `wp_ml_skill_class` sc JOIN `wp_ml_skill` s ON (s.skill_id = sc.skill_id) JOIN `wp_ml_character` c WHERE c.class_id = %d AND c.char_id … Read more
My Bad, wp_create_nav_menu() does insert MySQL