• I am getting a weird db error. I usually install on godaddy and it works out fine!

    Im now doing a install with a different web hosting company and getting a weird database error. I have never seen this before and it sounds like it is unable to write a table into the db I purchased from the hosting company.

    Any suggestions would be welcomed!

    site: blog.racy-lady.com

    Thanks for all of you help!

    The error messages changes slightly when u hit refresh multiple times…
    ————

    WordPress database error Table ‘racylad_racylady.wp_blogoptions’ doesn’t exist for query INSERT INTO wp_blogoptions (option_name, option_value, autoload) VALUES (‘cron’, ‘a:2:{i:1219937836;a:1:{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;}’, ‘yes’) made by add_option WordPress database error Table ‘racylad_racylady.wp_blogoptions’ doesn’t exist for query INSERT INTO wp_blogoptions (option_name, option_value, autoload) VALUES (‘auth_salt’, ‘#I0jkp2GGBxo’, ‘yes’) made by add_option

Viewing 15 replies - 1 through 15 (of 15 total)
  • I’m guessing you misnamed the database when you typed it in at the install prompt. I see you are calling the database “racylad_racylady”. Are you sure that is correct?

    I am getting a similar (slightly different) error message. And I checked, there is no typo in the config file. The error reads:

    WordPress database error Table ‘hemuji_wordpress.wp_options’ doesn’t exist for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘cron’, ‘a:2:{i:1219955351;a:1:{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;}’, ‘yes’) made by add_option

    If you have phpmyadmin on your host, you should use that to examine what the table names are.

    I too am getting the same like error message
    on browsing to wp-admin/install.php….

    WordPress database error Table ‘geekeboyblog.geek_options’ doesn’t exist for query INSERT INTO geek_options (option_name, option_value, autoload) VALUES (‘cron’, ‘a:2:{i:1220028880;a:1:{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;}’, ‘yes’) made by add_option

    There are no tables in my database

    I’m getting a similar message. Any idea what to do? I ignored the message and installed WordPress, but it didn’t work. So I uninstalled it, deleted the database, made a new database and want to reinstall.

    Here’s what I’m getting:

    WordPress database error Table ‘cpentle_languagelore.wp_options’ doesn’t exist for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘cron’, ‘a:2:{i:1220038903;a:1:{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;}’, ‘yes’) made by add_option

    Ogre,
    I did check using phpmyadmin and there is a table called wp_options there!
    The list of the tables are below:

    hemuji_wordpress (10)

    * Browse wp_comments
    * Browse wp_links
    * Browse wp_options
    * Browse wp_postmeta
    * Browse wp_posts
    * Browse wp_terms
    * Browse wp_term_relationships
    * Browse wp_term_taxonomy
    * Browse wp_usermeta
    * Browse wp_users

    Thanks for any help!

    What is it that you are trying to do when these errors come up, and in what version of WordPress?

    I get this same error.

    I upload the files to the directory.

    On step 1 of the install I see this error and can not go any further.

    I roll back to version 2.5.1 and don’t see the error.

    Any clues?

    After upgrading, did you run /wp-admin/upgrade.php?

    OK fresh install of WP 2.6.1 and when I go to the URL to begin the install I see thei error

    WordPress database error Table ‘name.wp_options’ doesn’t exist for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘cron’, ‘a:2:{i:1220302981;a:1:{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;}’, ‘yes’) made by add_option WordPress database error Table ‘name.wp_options’ doesn’t exist for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘auth_salt’, ‘lberkAab^vzv’, ‘yes’) made by add_option

    It’s my server or WP…..

    Please anyone got a fix, I tried the above upgarde and deleting the plugins but that didn’t work.

    Thanks

    Getting the same error here. Luckily it’s a fresh install. Tried earlier version 2.3.3 and had similar (more) errors.

    First thought it was that my username somehow didn’t have proper privileges to manipulate the table. Checked out php panel for the tables and seems I have full rights and can submit and execute queries. Rebuilt MySQL table multiple times, and reloaded WP too to no avail.

    If its of any help I’m using EasyCGI.

    Any help would be appreciated.

    Thanks,
    Chimbles

    Probably repeating the obvious, but make you you did the following:

    1. Disabled all plugins BEFORE installing the new files.

    2. Updated wp-config.php. Your best best is to copy the example and edit it instead of copying the old one over since newer versions have additional things in this file.

    3. You ran https://yourdomain.com/path/wp-admin/update.php and didn’t see any errors.

    Here’s what I did to successfully update my blog.

    I backed up the existing wordpress directory (all the files) and dumped a backup of the database.

    I renamed my blog directory (name.backup) so I can undo things if necessary.

    I unzipped the wordpress package then renamed the directory (wordpress) to the original blog directory name.

    I created wp-config.php from the example, then added my own settings for the database connection. Special note, if your table name prefix is not ‘wp_’, adjust the setting here. I overlooked this the first time through so wordpress thought it was a new install.

    With my browser, I ran the update.php file as mentioned above.

    Once everything worked (but was ugly), I copied my theme and image directory from the old directory, fixed the owner and permissions on the entire directory structure, then logged in and selected that theme. Again, I verified everything was working.

    I copied my old .htaccess file over to the new install so my links would work.

    Finally, I installed all the plugins I wanted.

    I have the advantage of running my own server. Things are a whole lot easier when you are root.

    I knew I could get to the bottom of this!!

    Make sure PHP is set to

    ‘run as ISAPI extension’

    That fixed it for me.

    Big thanks to https://www.fastservers.net

    How may I ask did you install PHP as ISAPI? Are you using the latest version of PHP and Apache because the php5isapi.dll will not run with it.
    The problem is that Apache comes up with new versions that aren’t compatible with older versions of PHP and the newer version of PHP will not work properly with the latest version of WordPress.
    There is also a problem with mysql with PHP because php comes with its own libmysql which will only work on the version it was programmed to, not necessarily with the version that has been pre-installed.
    So basically you have people developing all these packages not in conjunction with each other and depending on certain versions which are installed so it becomes a pain in the ass compatibility issue.

    [On windows Only]
    After following everything in the famouse 5 minute guide – if you’re stuck with loading the admin page – it could be as simple as adding PHP install folder to the path ( https://oviya.me/?p=1 )

Viewing 15 replies - 1 through 15 (of 15 total)
  • The topic ‘Can any help diagnose wordpress install error? Thanks!’ is closed to new replies.