Title: [Plugin: Theme My Login] WordPress database error Table
Last modified: August 20, 2016

---

# [Plugin: Theme My Login] WordPress database error Table

 *  [12sp](https://wordpress.org/support/users/sp12/)
 * (@sp12)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-theme-my-login-wordpress-database-error-table/)
 * Running on multisite on a site by site basis.
 * `[05-Jul-2012 12:05:00] WordPress database error Table 'zport_wrd1.wp_7_options'
   doesn't exist for query INSERT INTO`wp_7_options`(`option_name`,`option_value`,`
   autoload`) VALUES ('theme_my_login', 'a:12:{s:7:\"page_id\";i:24;s:9:\"show_page\";
   b:1;s:10:\"enable_css\";b:1;s:11:\"email_login\";b:1;s:14:\"active_modules\";
   a:0:{}s:10:\"permalinks\";a:0:{}s:11:\"initial_nag\";i:0;s:11:\"redirection\";
   a:5:{s:13:\"administrator\";a:4:{s:10:\"login_type\";s:7:\"default\";s:9:\"login_url\";
   s:0:\"\";s:11:\"logout_type\";s:7:\"default\";s:10:\"logout_url\";s:0:\"\";}s:
   6:\"editor\";a:4:{s:10:\"login_type\";s:7:\"default\";s:9:\"login_url\";s:0:\"\";
   s:11:\"logout_type\";s:7:\"default\";s:10:\"logout_url\";s:0:\"\";}s:6:\"author\";
   a:4:{s:10:\"login_type\";s:7:\"default\";s:9:\"login_url\";s:0:\"\";s:11:\"logout_type\";
   s:7:\"default\";s:10:\"logout_url\";s:0:\"\";}s:11:\"contributor\";a:4:{s:10:\"
   login_type\";s:7:\"default\";s:9:\"login_url\";s:0:\"\";s:11:\"logout_type\";
   s:7:\"default\";s:10:\"logout_url\";s:0:\"\";}s:10:\"subscriber\";a:4:{s:10:\"
   login_type\";s:7:\"default\";s:9:\"login_url\";s:0:\"\";s:11:\"logout_type\";
   s:7:\"default\";s:10:\"logout_url\";s:0:\"\";}}s:8:\"security\";a:2:{s:12:\"private_site\";
   b:0;s:12:\"failed_login\";a:5:{s:9:\"threshold\";i:5;s:18:\"threshold_duration\";
   i:1;s:23:\"threshold_duration_unit\";s:4:\"hour\";s:16:\"lockout_duration\";i:
   24;s:21:\"lockout_duration_unit\";s:4:\"hour\";}}s:15:\"themed_profiles\";a:10:{
   s:13:\"administrator\";a:2:{s:13:\"theme_profile\";i:0;s:14:\"restrict_admin\";
   i:0;}s:6:\"author\";a:2:{s:13:\"theme_profile\";i:0;s:14:\"restrict_admin\";i:
   0;}s:7:\"blocked\";a:2:{s:13:\"theme_profile\";i:0;s:14:\"restrict_admin\";i:
   0;}s:11:\"contributor\";a:2:{s:13:\"theme_profile\";i:0;s:14:\"restrict_admin\";
   i:0;}s:6:\"editor\";a:2:{s:13:\"theme_profile\";i:0;s:14:\"restrict_admin\";i:
   0;}s:8:\"inactive\";a:2:{s:13:\"theme_profile\";i:0;s:14:\"restrict_admin\";i:
   0;}s:9:\"keymaster\";a:2:{s:13:\"theme_profile\";i:0;s:14:\"restrict_admin\";
   i:0;}s:6:\"member\";a:2:{s:13:\"theme_profile\";i:0;s:14:\"restrict_admin\";i:
   0;}s:9:\"moderator\";a:2:{s:13:\"theme_profile\";i:0;s:14:\"restrict_admin\";
   i:0;}s:10:\"subscriber\";a:2:{s:13:\"theme_profile\";i:0;s:14:\"restrict_admin\";
   i:0;}}s:5:\"email\";a:4:{s:8:\"new_user\";a:12:{s:9:\"mail_from\";s:0:\"\";s:
   14:\"mail_from_name\";s:0:\"\";s:17:\"mail_content_type\";s:5:\"plain\";s:5:\"
   title\";s:0:\"\";s:7:\"message\";s:0:\"\";s:13:\"admin_mail_to\";s:0:\"\";s:15:\"
   admin_mail_from\";s:0:\"\";s:20:\"admin_mail_from_name\";s:0:\"\";s:23:\"admin_mail_content_type\";
   s:5:\"plain\";s:11:\"admin_title\";s:0:\"\";s:13:\"admin_message\";s:0:\"\";s:
   13:\"admin_disable\";b:0;}s:13:\"retrieve_pass\";a:5:{s:9:\"mail_from\";s:0:\"\";
   s:14:\"mail_from_name\";s:0:\"\";s:17:\"mail_content_type\";s:5:\"plain\";s:5:\"
   title\";s:0:\"\";s:7:\"message\";s:0:\"\";}s:10:\"reset_pass\";a:7:{s:13:\"admin_mail_to\";
   s:0:\"\";s:15:\"admin_mail_from\";s:0:\"\";s:20:\"admin_mail_from_name\";s:0:\"\";
   s:23:\"admin_mail_content_type\";s:5:\"plain\";s:11:\"admin_title\";s:0:\"\";
   s:13:\"admin_message\";s:0:\"\";s:13:\"admin_disable\";b:0;}s:13:\"user_approval\";
   a:1:{s:13:\"admin_disable\";b:0;}}s:7:\"version\";s:5:\"6.2.1\";}', 'yes') ON
   DUPLICATE KEY UPDATE`option_name`= VALUES(`option_name`),`option_value`= VALUES(`
   option_value`),`autoload`= VALUES(`autoload`) made by wpmu_create_blog, switch_to_blog,
   do_action(‘switch_blog’), call_user_func_array, Theme_My_Login->init_options,
   WDBJ_Plugin_Options->WDBJ_Plugin_Options, WDBJ_Plugin_Options->load, update_option,
   sanitize_option, apply_filters(‘sanitize_option_theme_my_login’), call_user_func_array,
   Theme_My_Login_Admin->save_settings, Theme_My_Login_Admin->deactivate_modules,
   WDBJ_Plugin_Options->save, update_option, add_option
 * [05-Jul-2012 12:05:00] WordPress database error Table ‘zport_wrd1.wp_7_options’
   doesn’t exist for query INSERT INTO `wp_7_options` (`option_name`, `option_value`,`
   autoload`) VALUES (‘theme_my_login’, ‘a:12:{s:7:\”page_id\”;i:0;s:9:\”show_page\”;
   b:1;s:10:\”enable_css\”;b:1;s:11:\”email_login\”;b:1;s:14:\”active_modules\”;
   a:0:{}s:10:\”permalinks\”;a:0:{}s:11:\”initial_nag\”;i:1;s:11:\”redirection\”;
   a:10:{s:13:\”administrator\”;a:4:{s:10:\”login_type\”;s:7:\”default\”;s:9:\”login_url\”;
   s:0:\”\”;s:11:\”logout_type\”;s:7:\”default\”;s:10:\”logout_url\”;s:0:\”\”;}s:
   6:\”editor\”;a:4:{s:10:\”login_type\”;s:7:\”default\”;s:9:\”login_url\”;s:0:\”\”;
   s:11:\”logout_type\”;s:7:\”default\”;s:10:\”logout_url\”;s:0:\”\”;}s:6:\”author\”;
   a:4:{s:10:\”login_type\”;s:7:\”default\”;s:9:\”login_url\”;s:0:\”\”;s:11:\”logout_type\”;
   s:7:\”default\”;s:10:\”logout_url\”;s:0:\”\”;}s:11:\”contributor\”;a:4:{s:10:\”
   login_type\”;s:7:\”default\”;s:9:\”login_url\”;s:0:\”\”;s:11:\”logout_type\”;
   s:7:\”default\”;s:10:\”logout_url\”;s:0:\”\”;}s:10:\”subscriber\”;a:4:{s:10:\”
   login_type\”;s:7:\”default\”;s:9:\”login_url\”;s:0:\”\”;s:11:\”logout_type\”;
   s:7:\”default\”;s:10:\”logout_url\”;s:0:\”\”;}s:7:\”blocked\”;a:4:{s:10:\”login_type\”;
   s:7:\”default\”;s:9:\”login_url\”;s:0:\”\”;s:11:\”logout_type\”;s:7:\”default\”;
   s:10:\”logout_url\”;s:0:\”\”;}s:8:\”inactive\”;a:4:{s:10:\”login_type\”;s:7:\”
   default\”;s:9:\”login_url\”;s:0:\”\”;s:11:\”logout_type\”;s:7:\”default\”;s:10:\”
   logout_url\”;s:0:\”\”;}s:9:\”keymaster\”;a:4:{s:10:\”login_type\”;s:7:\”default\”;
   s:9:\”login_url\”;s:0:\”\”;s:11:\”logout_type\”;s:7:\”default\”;s:10:\”logout_url\”;
   s:0:\”\”;}s:6:\”member\”;a:4:{s:10:\”login_type\”;s:7:\”default\”;s:9:\”login_url\”;
   s:0:\”\”;s:11:\”logout_type\”;s:7:\”default\”;s:10:\”logout_url\”;s:0:\”\”;}s:
   9:\”moderator\”;a:4:{s:10:\”login_type\”;s:7:\”default\”;s:9:\”login_url\”;s:
   0:\”\”;s:11:\”logout_type\”;s:7:\”default\”;s:10:\”logout_url\”;s:0:\”\”;}}s:
   8:\”security\”;a:2:{s:12:\”private_site\”;b:0;s:12:\”failed_login\”;a:5:{s:9:\”
   threshold\”;i:5;s:18:\”threshold_duration\”;i:1;s:23:\”threshold_duration_unit\”;
   s:4:\”hour\”;s:16:\”lockout_duration\”;i:24;s:21:\”lockout_duration_unit\”;s:
   4:\”hour\”;}}s:15:\”themed_profiles\”;a:10:{s:13:\”administrator\”;a:2:{s:13:\”
   theme_profile\”;i:0;s:14:\”restrict_admin\”;i:0;}s:6:\”author\”;a:2:{s:13:\”theme_profile\”;
   i:0;s:14:\”restrict_admin\”;i:0;}s:7:\”blocked\”;a:2:{s:13:\”theme_profile\”;
   i:0;s:14:\”restrict_admin\”;i:0;}s:11:\”contributor\”;a:2:{s:13:\”theme_profile\”;
   i:0;s:14:\”restrict_admin\”;i:0;}s:6:\”editor\”;a:2:{s:13:\”theme_profile\”;i:
   0;s:14:\”restrict_admin\”;i:0;}s:8:\”inactive\”;a:2:{s:13:\”theme_profile\”;i:
   0;s:14:\”restrict_admin\”;i:0;}s:9:\”keymaster\”;a:2:{s:13:\”theme_profile\”;
   i:0;s:14:\”restrict_admin\”;i:0;}s:6:\”member\”;a:2:{s:13:\”theme_profile\”;i:
   0;s:14:\”restrict_admin\”;i:0;}s:9:\”moderator\”;a:2:{s:13:\”theme_profile\”;
   i:0;s:14:\”restrict_admin\”;i:0;}s:10:\”subscriber\”;a:2:{s:13:\”theme_profile\”;
   i:0;s:14:\”restrict_admin\”;i:0;}}s:5:\”email\”;a:4:{s:8:\”new_user\”;a:12:{s:
   9:\”mail_from\”;s:0:\”\”;s:14:\”mail_from_name\”;s:0:\”\”;s:17:\”mail_content_type\”;
   s:5:\”plain\”;s:5:\”title\”;s:0:\”\”;s:7:\”message\”;s:0:\”\”;s:13:\”admin_mail_to\”;
   s:0:\”\”;s:15:\”admin_mail_from\”;s:0:\”\”;s:20:\”admin_mail_from_name\”;s:0:\”\”;
   s:23:\”admin_mail_content_type\”;s:5:\”plain\”;s:11:\”admin_title\”;s:0:\”\”;
   s:13:\”admin_message\”;s:0:\”\”;s:13:\”admin_disable\”;b:0;}s:13:\”retrieve_pass\”;
   a:5:{s:9:\”mail_from\”;s:0:\”\”;s:14:\”mail_from_name\”;s:0:\”\”;s:17:\”mail_content_type\”;
   s:5:\”plain\”;s:5:\”title\”;s:0:\”\”;s:7:\”message\”;s:0:\”\”;}s:10:\”reset_pass\”;
   a:7:{s:13:\”admin_mail_to\”;s:0:\”\”;s:15:\”admin_mail_from\”;s:0:\”\”;s:20:\”
   admin_mail_from_name\”;s:0:\”\”;s:23:\”admin_mail_content_type\”;s:5:\”plain\”;
   s:11:\”admin_title\”;s:0:\”\”;s:13:\”admin_message\”;s:0:\”\”;s:13:\”admin_disable\”;
   b:0;}s:13:\”user_approval\”;a:1:{s:13:\”admin_disable\”;b:0;}}s:7:\”version\”;
   s:5:\”6.2.1\”;}’, ‘yes’) ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`),`
   option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`) made 
   by wpmu_create_blog, switch_to_blog, do_action(‘switch_blog’), call_user_func_array,
   Theme_My_Login->init_options, WDBJ_Plugin_Options->WDBJ_Plugin_Options, WDBJ_Plugin_Options-
   >load, update_option, add_option
    `
 * [http://wordpress.org/extend/plugins/theme-my-login/](http://wordpress.org/extend/plugins/theme-my-login/)

The topic ‘[Plugin: Theme My Login] WordPress database error Table’ is closed to
new replies.

 * ![](https://ps.w.org/theme-my-login/assets/icon-256x256.png?rev=1891232)
 * [Theme My Login](https://wordpress.org/plugins/theme-my-login/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/theme-my-login/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/theme-my-login/)
 * [Active Topics](https://wordpress.org/support/plugin/theme-my-login/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/theme-my-login/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/theme-my-login/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [WordPress database error Table](https://wordpress.org/support/topic-tag/wordpress-database-error-table/)

 * 0 replies
 * 1 participant
 * Last reply from: [12sp](https://wordpress.org/support/users/sp12/)
 * Last activity: [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-theme-my-login-wordpress-database-error-table/)
 * Status: not resolved