WordPress.org

Forums

5th installation on server won't work (2 posts)

  1. chuckmanley
    Member
    Posted 3 years ago #

    I currently have 5 installations of wordpress on my server. I'm trying to put up a new site to develop for a client, but running wp-config.php produces a laundry list of errors relating to wp_options.

    I started off trying to install a fresh download of 3.3. After not being able to get that to work, I switched to the last install I did that worked, which was 3.1. Neither work.

    It's a new database, separate folder, on a server that hosts my other wordpress sites.

    The errors are:

    WordPress database error: [Table 'badotorg_bts.wp_options' doesn't exist]
    SELECT option_value FROM wp_options WHERE option_name = 'embed_autourls' LIMIT 1

    WordPress database error: [Table 'badotorg_bts.wp_options' doesn't exist]
    SELECT option_value FROM wp_options WHERE option_name = 'siteurl' LIMIT 1

    WordPress database error: [Table 'badotorg_bts.wp_options' doesn't exist]
    SELECT option_value FROM wp_options WHERE option_name = 'home' LIMIT 1

    WordPress database error: [Table 'badotorg_bts.wp_options' doesn't exist]
    SELECT option_value FROM wp_options WHERE option_name = 'active_plugins' LIMIT 1

    WordPress database error: [Table 'badotorg_bts.wp_options' doesn't exist]
    SELECT option_value FROM wp_options WHERE option_name = 'hack_file' LIMIT 1

    WordPress database error: [Table 'badotorg_bts.wp_options' doesn't exist]
    SELECT option_value FROM wp_options WHERE option_name = 'blog_charset' LIMIT 1

    WordPress database error: [Table 'badotorg_bts.wp_options' doesn't exist]
    SELECT option_value FROM wp_options WHERE option_name = 'cron' LIMIT 1

    WordPress database error: [Table 'badotorg_bts.wp_options' doesn't exist]
    SELECT option_value FROM wp_options WHERE option_name = 'permalink_structure' LIMIT 1

    WordPress database error: [Table 'badotorg_bts.wp_options' doesn't exist]
    SELECT option_value FROM wp_options WHERE option_name = 'template' LIMIT 1

    WordPress database error: [Table 'badotorg_bts.wp_options' doesn't exist]
    SELECT option_value FROM wp_options WHERE option_name = 'stylesheet' LIMIT 1

    WordPress database error: [Table 'badotorg_bts.wp_options' doesn't exist]
    SELECT option_value FROM wp_options WHERE option_name = 'category_base' LIMIT 1

    WordPress database error: [Table 'badotorg_bts.wp_options' doesn't exist]
    SELECT option_value FROM wp_options WHERE option_name = 'tag_base' LIMIT 1

    WordPress database error: [Table 'badotorg_bts.wp_options' doesn't exist]
    SELECT option_value FROM wp_options WHERE option_name = 'use_smilies' LIMIT 1

    WordPress database error: [Table 'badotorg_bts.wp_options' doesn't exist]
    INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('cron', 'a:2:{i:1324252400;a:1:{s:16:\"wp_version_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

    WordPress database error: [Table 'badotorg_bts.wp_options' doesn't exist]
    UPDATE wp_options SET option_value = 'a:2:{i:1324252400;a:2:{s:16:\"wp_version_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:17:\"wp_update_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}' WHERE option_name = 'cron'

    WordPress database error: [Table 'badotorg_bts.wp_options' doesn't exist]
    UPDATE wp_options SET option_value = 'a:2:{i:1324252400;a:3:{s:16:\"wp_version_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:17:\"wp_update_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:16:\"wp_update_themes\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}' WHERE option_name = 'cron'

    WordPress database error: [Table 'badotorg_bts.wp_options' doesn't exist]
    SELECT option_value FROM wp_options WHERE option_name = 'theme_switched' LIMIT 1

  2. Tim S
    Member
    Posted 3 years ago #

    All the errors are because a table in the database doesn't exist. The specific table is:
    badotorg_bts.wp_options

    Make sure you have assigned the user the correct permissions to be able to work with the database.

Topic Closed

This topic has been closed to new replies.

About this Topic