• I’m runing MySQL on a Mac OS X 10.11.4, MySQL 5.7.11, phpMyAdmin 4.5.5.1, WordPress 4.4.2 and Apache 2.4.18.
    One of the databases for one website has the wp_options table messed up. The options_id is all over the place with the normal options_id being 1 is now 302456. I have run repair table in phpMyAdmin and repair, & repair and optimize in wp-config.php. All the repairs come back OK. It there another way to fix this? I know what some options_id’s should be but there are so much more that I don’t know what id they need to be.
    Here’s what I mean.
    The Temple I’m using is woffice and fileaway is a plugin it uses, I manually changed the options_id for siteurl, home,blogname,blogdescription, users_can_register,admin_email, start_of_week, use_smiles, mail server_url, mail server_login, mail server_pass, mail server_port, date_format, time_format, links_updated_date_format. All of them had option_id’s staring in 302000’s.
    Here’s what is still in those numbers, plus some option_id’s I think should have a different option_id.

    1377
    widget_fw_woffice_poll
    a:2:{i:2;a:1:{s:5:”title”;s:4:”Poll”;}s:12:”_multi…
    yes

    1408
    fw_ext_settings_options:woffice-poll
    a:5:{s:11:”information”;s:0:””;s:4:”name”;s:16:”Fa…
    yes

    1414
    widget_woffice_projects
    a:3:{i:2;a:1:{s:5:”title”;s:8:”Projects”;}i:3;a:2:…
    yes

    30664
    theme_mods_woffice-1-4-3
    a:3:{i:0;b:0;s:18:”nav_menu_locations”;a:1:{s:7:”p…
    yes

    47902
    theme_mods_woffice-1-4-4
    a:3:{i:0;b:0;s:18:”nav_menu_locations”;a:1:{s:7:”p…
    yes

    47913
    fileaway_options
    a:71:{s:13:”rootdirectory”;s:7:”install”;s:11:”str…
    yes

    47917
    fileaway_db_version
    1.0
    yes

    47918
    fileaway_db2_version
    1.0
    yes

    83199
    theme_mods_woffice-1-4-5
    a:3:{i:0;b:0;s:18:”nav_menu_locations”;a:1:{s:7:”p…
    yes

    116049
    theme_mods_woffice-1-4-6
    a:3:{i:0;b:0;s:18:”nav_menu_locations”;a:1:{s:7:”p…
    yes

    150113
    theme_mods_woffice-1-4-7
    a:3:{i:0;b:0;s:18:”nav_menu_locations”;a:1:{s:7:”p…
    yes

    176884
    theme_mods_woffice-1-4-8
    a:3:{i:0;b:0;s:18:”nav_menu_locations”;a:1:{s:7:”p…
    yes

    210014
    category_children
    a:0:{}
    yes

    210329
    widget_woffice_funfacts
    a:1:{s:12:”_multiwidget”;i:1;}
    yes

    210460
    widget_woffice_usersmap
    a:2:{i:2;a:1:{s:5:”title”;s:9:”Users Map”;}s:12:”_…
    yes

    216093
    theme_mods_woffice-1-5-0
    a:3:{i:0;b:0;s:18:”nav_menu_locations”;a:1:{s:7:”p…
    yes

    272918
    theme_mods_woffice-1-5-2
    a:2:{i:0;b:0;s:18:”nav_menu_locations”;a:1:{s:7:”p…
    yes

    302406
    revslider-update-check-short
    1460473208
    yes

    302407
    revslider-templates-check
    1460473208
    yes

    302408
    rs-templates-new
    yes

    302409
    rs-templates
    a:2:{s:6:”slider”;a:67:{i:0;a:20:{s:2:”id”;s:1:”1″…
    yes

    302410
    revslider_checktables
    1
    yes

    302411
    revslider_table_version
    1.0.6
    yes

    302412
    revslider_update_version
    5.1.1
    yes

    302413
    widget_pages
    a:1:{s:12:”_multiwidget”;i:1;}
    yes

    302414
    widget_calendar
    a:1:{s:12:”_multiwidget”;i:1;}
    yes

    Is there a way to get this fixed? I’ve run repair in both WordPress config and in the MySQL database but it doesn’t seem to fix it.

The topic ‘wp_options’ is closed to new replies.