WordPress.org

Ready to get started?Download WordPress

Forums

Upgrade - Step 1 - Long error message about wp_options and database (8 posts)

  1. starberry
    Member
    Posted 9 years ago #

    You can see the page - http://starberry.turtelina.net/wp-admin/upgrade.php?step=1

    This is the error:
    Database error: [Unknown column 'autoload' in 'field list']
    INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES ('default_email_category', '1', 'Posts by email go to this category', 'yes')

    Database error: [Unknown column 'autoload' in 'field list']
    INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES ('recently_edited', '', '', 'yes')

    Database error: [Unknown column 'autoload' in 'field list']
    INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES ('use_linksupdate', '0', '', 'yes')

    Database error: [Unknown column 'autoload' in 'field list']
    INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES ('template', 'default', '', 'yes')

    Database error: [Unknown column 'autoload' in 'field list']
    INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES ('stylesheet', 'default', '', 'yes')

    Database error: [Unknown column 'autoload' in 'field list']
    INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES ('comment_whitelist', '1', '', 'yes')

    Database error: [Unknown column 'autoload' in 'field list']
    INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES ('page_uris', '', '', 'yes')

    Database error: [Unknown column 'autoload' in 'field list']
    INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES ('blacklist_keys', '', '', 'yes')

    Database error: [Unknown column 'autoload' in 'field list']
    INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES ('comment_registration', '0', '', 'yes')

    Database error: [Unknown column 'autoload' in 'field list']
    INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES ('open_proxy_check', '1', '', 'yes')

    Database error: [Unknown column 'autoload' in 'field list']
    INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES ('html_type', 'text/html', '', 'yes')

    Database error: [Unknown column 'autoload' in 'field list']
    UPDATE wp_options SET autoload = 'no' WHERE option_name = 'moderation_keys'

    Database error: [Unknown column 'autoload' in 'field list']
    UPDATE wp_options SET autoload = 'no' WHERE option_name = 'recently_edited'

    Database error: [Unknown column 'autoload' in 'field list']
    UPDATE wp_options SET autoload = 'no' WHERE option_name = 'blacklist_keys'

    Database error: [Unknown column 'guid' in 'field list']
    SELECT ID, post_title, post_content, post_excerpt, guid, post_date, post_name, post_status, post_author FROM wp_posts

    Database error: [Unknown column 'comment_type' in 'field list']
    UPDATE wp_comments SET comment_type='trackback', comment_content = REPLACE(comment_content, '', '') WHERE comment_content LIKE '%'

    Database error: [Unknown column 'comment_type' in 'field list']
    UPDATE wp_comments SET comment_type='pingback', comment_content = REPLACE(comment_content, '', '') WHERE comment_content LIKE '%'

    I was upgrading from 1.2 to 1.5, what do I do?! I have tried uploading the files again, any ideas what this error could be?

  2. 12thharmonic
    Member
    Posted 9 years ago #

    This happened to me as well. Be sure your FTP client didn't drop any files. Dreamweaver was very lax on this for me...10 or so files in all folders had to be uploaded individualy.
    After that it was effortless.."upgrade.php" was one of them...

  3. starberry
    Member
    Posted 9 years ago #

    I have tried to upload everything again, and I still have that message. I am using WS_FTP Le. How did you work out which ones didn't upload?

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

    Compare the file lists on the server with what came out of the wp zip.
    Check also that files are not listed with a size of 0

  5. starberry
    Member
    Posted 9 years ago #

    Ok, I'll do that now. What should I do if they are all there and it still doesn't work?

  6. ckronengold
    Member
    Posted 9 years ago #

    Don't worry. It will work. I had the exact same problem. I compared a few of the files, saw that they had different file sizes, and just rewrote over them. took about 10 mins to go through them, and all is good.

    curious -- did you have your index file in the wordpress folder or in the root directory? i have mine in the root and need to re-edit the main page.

  7. fleep
    Member
    Posted 9 years ago #

    I had this same problem this morning and took the advice of the previous poster. I manually scanned the file sizes for each and every file and re-uploaded any file that had a discrepancy. And lo and behold it worked.

    Thanks previous poster! =)

  8. somefool
    Member
    Posted 9 years ago #

    Try turning off plugins before running upgrade.php too

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.