Title: wp_options
Last modified: August 31, 2016

---

# wp_options

 *  [dewrdpresssed50](https://wordpress.org/support/users/dewrdpresssed50/)
 * (@dewrdpresssed50)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/wp_options-2/)
 * 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.

## Tags

 * [wp_options](https://wordpress.org/support/topic-tag/wp_options/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [dewrdpresssed50](https://wordpress.org/support/users/dewrdpresssed50/)
 * Last activity: [10 years, 1 month ago](https://wordpress.org/support/topic/wp_options-2/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics