Widgets Gone. Database Error

  • andrea2289

    (@andrea2289)


    15 years, 6 months ago

    I was able to log in fine this morning. I went to delete one widget, the site seemed to time out and then I got:

    “Error establishing a database connection”

    * Are you sure you have the correct username and password?
    * Are you sure that you have typed the correct hostname?
    * Are you sure that the database server is running?

    The site continued to time out so I just closed out of everything, waited about 15 minutes and when I logged back in, all of my widgets are gone. There are widgets showing in WP that are not showing on the site and widegets on the site that are not showing in WP.

    I checked my error log in BlueHost and this is what I got:

    MAIN error_log:

    [Tue Sep 28 08:39:26 2010] [error] [client 88.131.106.4] PHP Warning: PHP Startup: Unable to load dynamic library ‘/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so’ – /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so: cannot open shared object file: No such file or directory in Unknown on line 0

    PHP error_log:

    [28-Sep-2010 14:19:19] WordPress database error Table ‘wp_options’ is marked as crashed and should be repaired for query SELECT option_value FROM wp_options WHERE option_name = ‘widget_text’ LIMIT 1 made by require_once, require_once, require_once, do_action, call_user_func_array, wp_widgets_init, do_action, call_user_func_array, WP_Widget_Factory->_register_widgets, WP_Widget->_register, WP_Widget->get_settings, get_option

    [28-Sep-2010 14:19:19] WordPress database error Duplicate entry ‘widget_text’ for key ‘option_name’ for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘widget_text’, ‘a:2:{i:2;a:0:{}s:12:\”_multiwidget\”;i:1;}’, ‘yes’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by require_once, require_once, require_once, do_action, call_user_func_array, wp_widgets_init, do_action, call_user_func_array, WP_Widget_Factory->_register_widgets, WP_Widget->_register, WP_Widget->get_settings, wp_convert_widget_settings, update_option, add_option

    This has never happened before and I am totally lost!

Viewing 6 replies - 1 through 6 (of 6 total)
  • Samuel B

    (@samboll)

    15 years, 6 months ago

    WordPress database error Table 'wp_options' is marked as crashed and should be repaired
    this will be the problem

    use bluehost’s phpmyadmin to repair wp_options table

    log in to phpmyadmin
    select database
    check mark wp_options
    select “repair” from drop down at bottom of page

    Thread Starter andrea2289

    (@andrea2289)

    15 years, 6 months ago

    I did that and nothing changed?

    Samuel B

    (@samboll)

    15 years, 6 months ago

    well – site looks different to me
    try clearing your browser cache

    Thread Starter andrea2289

    (@andrea2289)

    15 years, 6 months ago

    I cleared everything and restarted and still no widgets in my sidebars. Just Blogroll and Admin in the top right (both of which were not showing before this happened)

    Samuel B

    (@samboll)

    15 years, 6 months ago

    those are the default widgets alright
    have you tried adding them back?

    Thread Starter andrea2289

    (@andrea2289)

    15 years, 6 months ago

    That was it! Thanks so much for your help!

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Widgets Gone. Database Error’ is closed to new replies.