Support » Installing WordPress » Upgrade – Step 1 – Long error message about wp_options and database

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

Viewing 7 replies - 1 through 7 (of 7 total)
  • 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…

    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?

    Mark (podz)

    (@podz)

    Support Maven

    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

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

    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.

    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! =)

    Try turning off plugins before running upgrade.php too

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Upgrade – Step 1 – Long error message about wp_options and database’ is closed to new replies.