Multiple MySQL Errors on Changing Host

  • Resolved kouya

    (@kouya)


    19 years, 2 months 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 https://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)

  • 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

    (@kouya)

    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!

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

    Thread Starter kouya

    (@kouya)

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

    You definitely selected the MD5 dropdown option ??

    Thread Starter kouya

    (@kouya)

    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

    (@kouya)

    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

    (@kouya)

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