wp_options
-
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…
yes1408
fw_ext_settings_options:woffice-poll
a:5:{s:11:”information”;s:0:””;s:4:”name”;s:16:”Fa…
yes1414
widget_woffice_projects
a:3:{i:2;a:1:{s:5:”title”;s:8:”Projects”;}i:3;a:2:…
yes30664
theme_mods_woffice-1-4-3
a:3:{i:0;b:0;s:18:”nav_menu_locations”;a:1:{s:7:”p…
yes47902
theme_mods_woffice-1-4-4
a:3:{i:0;b:0;s:18:”nav_menu_locations”;a:1:{s:7:”p…
yes47913
fileaway_options
a:71:{s:13:”rootdirectory”;s:7:”install”;s:11:”str…
yes47917
fileaway_db_version
1.0
yes47918
fileaway_db2_version
1.0
yes83199
theme_mods_woffice-1-4-5
a:3:{i:0;b:0;s:18:”nav_menu_locations”;a:1:{s:7:”p…
yes116049
theme_mods_woffice-1-4-6
a:3:{i:0;b:0;s:18:”nav_menu_locations”;a:1:{s:7:”p…
yes150113
theme_mods_woffice-1-4-7
a:3:{i:0;b:0;s:18:”nav_menu_locations”;a:1:{s:7:”p…
yes176884
theme_mods_woffice-1-4-8
a:3:{i:0;b:0;s:18:”nav_menu_locations”;a:1:{s:7:”p…
yes210014
category_children
a:0:{}
yes210329
widget_woffice_funfacts
a:1:{s:12:”_multiwidget”;i:1;}
yes210460
widget_woffice_usersmap
a:2:{i:2;a:1:{s:5:”title”;s:9:”Users Map”;}s:12:”_…
yes216093
theme_mods_woffice-1-5-0
a:3:{i:0;b:0;s:18:”nav_menu_locations”;a:1:{s:7:”p…
yes272918
theme_mods_woffice-1-5-2
a:2:{i:0;b:0;s:18:”nav_menu_locations”;a:1:{s:7:”p…
yes302406
revslider-update-check-short
1460473208
yes302407
revslider-templates-check
1460473208
yes302408
rs-templates-new
yes302409
rs-templates
a:2:{s:6:”slider”;a:67:{i:0;a:20:{s:2:”id”;s:1:”1″…
yes302410
revslider_checktables
1
yes302411
revslider_table_version
1.0.6
yes302412
revslider_update_version
5.1.1
yes302413
widget_pages
a:1:{s:12:”_multiwidget”;i:1;}
yes302414
widget_calendar
a:1:{s:12:”_multiwidget”;i:1;}
yesIs 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.