WordPress.org

1. chuckmanley
   Member
   Posted 5 months 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 5 months 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.

Reply

You must log in to post.