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.
I just had the same problem, and solved it using the Participants Database plugin. The pdb_list shortcode supports filters, e.g. [pdb_list filter=”state=NY”]. You can generate any shortcodes from a PHP script by running a script with the do_shortcode() function, like this: echo do_shortcode(‘[pdb_list filter=”state=NY”]’); Now you have all the building blocks you need to generate … Read more
Those are not Core entries so far as I know. That means that a plugin or a theme has inserted them. Since I don’t know which plugin or theme it is, or whether you are still using that plugin/theme, I can’t say whether you should delete the entries. If you are still using the plugin … Read more
Author ID mismatch from database
I would suggest to use double prefix like wp_hm_account, since it will allow you to recognize the tables (as you mentioned in comment) and you will be also able to use wpdb class properly.
$leader_result = $wpdb->get_results(“SELECT user_first_name, user_last_name FROM “.$wpdb->prefix.”mro_attendees WHERE event_id = “.$project_id.” AND user_role=”team_leader” LIMIT 0,1″) foreach($leader_result as $row=>$value) { echo $value->column_name; }
Ok… So after some more research I found: http://andrewapeterson.com/2012/08/fix-wordpress-media-library-and-attachments-broken-after-movingcloning-site/ which explains that you can’t just do a find and replace in a text editor and be good to go. Fortunately, I still had the original database, so I dropped all the tables in the tsi_ database and restored the original wp_ database. All my images … Read more