Title: Multiple MySQL Errors on Changing Host Last modified: August 18, 2016 --- # Multiple MySQL Errors on Changing Host * Resolved [kouya](https://wordpress.org/support/users/kouya/) * (@kouya) * [20 years, 5 months ago](https://wordpress.org/support/topic/multiple-mysql-errors-on-changing-host/) * Hello, there are a number of other posts like this one, but none that I could find with exactly the same symptoms. I moved hosting package for my blog. You can see the site at [http://www.kouya.net](http://www.kouya.net). * Since moving, I have multiple database errors occuring, all with similar wording: * The categories section in the sidebar now says: * WordPress database error: [Unknown column ‘category_count’ in ‘field list’] SELECT cat_ID, cat_name, category_nicename, category_description, category_parent, category_count FROM wp_categories WHERE cat_ID > 0 ORDER BY cat_name asc * No categories * When I try to manage posts I get the following in the comments field: * WordPress database error: [Unknown column ‘comment_count’ in ‘field list’] SELECT comment_count FROM wp_posts WHERE ID = ’36’ 0 * And on attempting to write a post, the upload section reads: * WordPress database error: [Unknown column ‘post_mime_type’ in ‘field list’] SELECT ID, post_date, post_title, post_mime_type, guid FROM wp_posts WHERE post_status = ‘attachment’ AND post_parent = ‘-1136282218’ ORDER BY post_date_gmt DESC LIMIT 0, 10 * Warning: Cannot modify header information – headers already sent by (output started at /home/sites/kouya.net/public_html/wp-includes/wp-db.php:102) in /home/sites/ kouya.net/public_html/wp-admin/inline-uploading.php on line 138 * Any ideas? Viewing 8 replies - 1 through 8 (of 8 total) * [Mark (podz)](https://wordpress.org/support/users/podz/) * (@podz) * [20 years, 5 months ago](https://wordpress.org/support/topic/multiple-mysql-errors-on-changing-host/#post-309380) * Did you upgrade while moving ? Do you have a backup sql file ? Have you tried running upgrade.php since the move ? Have you not got a plugin here which you did have before ? * Thread Starter [kouya](https://wordpress.org/support/users/kouya/) * (@kouya) * [20 years, 5 months ago](https://wordpress.org/support/topic/multiple-mysql-errors-on-changing-host/#post-309383) * hi podz. I upgraded before the move and it was working fine. I backed up my sql file and have installed the backup. I still have the backup both as a text file and .gz file. * I have no extra plugins installed. * To verify things, I’ve tried reinstalling the database – no joy. I then reinstalled wordpress both with and without the sql database in place. In both cases the same errors keep appearing. * Since posting wordpress has locked me out of the admin page. None of the combinations of username and password that I have will give me acccess. Rather frustrating! Oh, and the ‘lost your password’ screen does not recognise me either! * [Mark (podz)](https://wordpress.org/support/users/podz/) * (@podz) * [20 years, 5 months ago](https://wordpress.org/support/topic/multiple-mysql-errors-on-changing-host/#post-309386) * [http://www.tamba2.org.uk/wordpress/phpmyadmin/](http://www.tamba2.org.uk/wordpress/phpmyadmin/) That page should allow you back in …. * Thread Starter [kouya](https://wordpress.org/support/users/kouya/) * (@kouya) * [20 years, 5 months ago](https://wordpress.org/support/topic/multiple-mysql-errors-on-changing-host/#post-309388) * Thanks for this podz. I’ve used phpmyadmin and still the password is not recognized.??? * [Mark (podz)](https://wordpress.org/support/users/podz/) * (@podz) * [20 years, 5 months ago](https://wordpress.org/support/topic/multiple-mysql-errors-on-changing-host/#post-309394) * You definitely selected the MD5 dropdown option ?? * Thread Starter [kouya](https://wordpress.org/support/users/kouya/) * (@kouya) * [20 years, 5 months ago](https://wordpress.org/support/topic/multiple-mysql-errors-on-changing-host/#post-309396) * Yes, I selected that. I tried three or four times. * I notice that my posts on the blog no longer have any name next to them. I haven’t a clue what is going on here. * Thread Starter [kouya](https://wordpress.org/support/users/kouya/) * (@kouya) * [20 years, 5 months ago](https://wordpress.org/support/topic/multiple-mysql-errors-on-changing-host/#post-309414) * I reinstalled my database from scratch and I’m still locked out. * I then followed podz insructions again – and I’m still locked out. All of the other problems are still there. * Thread Starter [kouya](https://wordpress.org/support/users/kouya/) * (@kouya) * [20 years, 5 months ago](https://wordpress.org/support/topic/multiple-mysql-errors-on-changing-host/#post-309426) * ???? Reinstalled again and now it works. I haven’t a clue what happened or why, but I’ll take a working site for now. Thanks podz. Viewing 8 replies - 1 through 8 (of 8 total) The topic ‘Multiple MySQL Errors on Changing Host’ is closed to new replies. ## Tags * [MySQL](https://wordpress.org/support/topic-tag/mysql/) * In: [Installing WordPress](https://wordpress.org/support/forum/installation/) * 8 replies * 2 participants * Last reply from: [kouya](https://wordpress.org/support/users/kouya/) * Last activity: [20 years, 5 months ago](https://wordpress.org/support/topic/multiple-mysql-errors-on-changing-host/#post-309426) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics