WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Multiple MySQL Errors on Changing Host (9 posts)

  1. kouya
    Member
    Posted 8 years ago #

    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.

    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?

  2. Mark (podz)
    Support Maven
    Posted 8 years ago #

    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 ?

  3. kouya
    Member
    Posted 8 years ago #

    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!

  4. Mark (podz)
    Support Maven
    Posted 8 years ago #

    http://www.tamba2.org.uk/wordpress/phpmyadmin/
    That page should allow you back in ....

  5. kouya
    Member
    Posted 8 years ago #

    Thanks for this podz. I've used phpmyadmin and still the password is not recognized. ???

  6. Mark (podz)
    Support Maven
    Posted 8 years ago #

    You definitely selected the MD5 dropdown option ??

  7. kouya
    Member
    Posted 8 years ago #

    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.

  8. kouya
    Member
    Posted 8 years ago #

    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.

  9. kouya
    Member
    Posted 8 years ago #

    ???? 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.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags