Have you also renamed the plugin database tables after you changed the database prefix? You can also define the following constant in your wp-config.php for viewing the database errors:
define('WP_DEBUG', true);
when I transferred the wordpress site to another host,prefix and wordpress database were changed. Database tables where not touched.
I’m getting these errors:
01-Apr-2012 11:59:06 PHP Warning: Module ‘uploadprogress’ already loaded in Unknown on line 0
LEFT JOIN gjih_admin_blog_tags t ON t.tag_ID = r.tag_ID WHERE t.tag_ID = ’12’ made by do_action, call_user_func_array, wpam_page
LEFT JOIN gjih_admin_blog_relations r ON r.post_ID = p.post_ID
01-Apr-2012 16:58:53 WordPress database error Unknown column ‘p.is_sticky’ in ‘field list’ for query SELECT DISTINCT p.post_ID, p.post_parent, p.text, p.date, p.user, p.is_sticky FROM gjih_admin_blog_posts p
01-Apr-2012 11:58:52 PHP Warning: Module ‘uploadprogress’ already loaded in Unknown on line 0
01-Apr-2012 16:58:49 WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ORDER BY post_ID ASC’ at line 1 for query SELECT * FROM gjih_admin_blog_posts WHERE ORDER BY post_ID ASC made by do_action, call_user_func_array, wpam_page
01-Apr-2012 16:58:49 WordPress database error Unknown column ‘is_sticky’ in ‘order clause’ for query SELECT * FROM gjih_admin_blog_posts WHERE post_parent = ‘0’ ORDER BY is_sticky DESC, post_ID DESC LIMIT 0, 10 made by do_action, call_user_func_array, wpam_page
Have the following tables the same table prefix as the normal wordpress database tables?:
*admin_blog_posts
*admin_blog_tags
*admin_blog_relations
*admin_blog_meta
If yes, check if these tables have the same structure as here:
http://plugins.trac.wordpress.org/browser/wp-admin-microblog/trunk/wp-admin-microblog.php?rev=504885#L459
