Title: Multisite installation missing db tables
Last modified: March 28, 2024

---

# Multisite installation missing db tables

 *  Resolved [sissi](https://wordpress.org/support/users/ebiebzh0/)
 * (@ebiebzh0)
 * [2 years, 2 months ago](https://wordpress.org/support/topic/multisite-installation-missing-db-tables/)
 * i tried to install cache warmer on a multisite – on the main page (blog id 1)
   it is working great, after activating the plugin on another site (blog id 3) 
   not all tables were created:
 *     ```wp-block-code
       WordPress database error Table 'xxx_db1.xxxxxx_wp_3_cache_warmer_warm_ups_user_agents' doesn't exist for query 
                       SELECT id 
                       FROM xxxxxx_wp_3_cache_warmer_warm_ups_user_agents 
       ------------------------------------------------------
       WordPress database error Unknown column 'user_agent_id' in 'field list' for query 
                       INSERT INTO xxxxxx_wp_3_cache_warmer_warm_ups_logs
       ```
   

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

 *  Plugin Author [TMM Technology](https://wordpress.org/support/users/tmmtechnology/)
 * (@tmmtechnology)
 * [2 years, 2 months ago](https://wordpress.org/support/topic/multisite-installation-missing-db-tables/#post-17543271)
 * [@ebiebzh0](https://wordpress.org/support/users/ebiebzh0/)
   Thanks for the bug
   report, we will check it later.If possible, maybe you could send a screenshot
   of this page on blog id 3:_/admin.php?page=cache-warmer&tmm-do=db-migrations-
   log_So open cache-warmer settings, then add to it “_&tmm-do=db-migrations-log_“.
   There should be a log of all DB migraitons. Maybe you could share the screenshots
   with me.And the same for blog 1 also would be nice (so 2 screens for 2 sites,
   for migration log).
 *  Thread Starter [sissi](https://wordpress.org/support/users/ebiebzh0/)
 * (@ebiebzh0)
 * [2 years, 2 months ago](https://wordpress.org/support/topic/multisite-installation-missing-db-tables/#post-17544517)
 * sent the images via mail to you at [wp@tmm.ventures](https://wordpress.org/support/topic/multisite-installation-missing-db-tables/wp@tmm.ventures?output_format=md)
 *  Plugin Author [TMM Technology](https://wordpress.org/support/users/tmmtechnology/)
 * (@tmmtechnology)
 * [2 years, 2 months ago](https://wordpress.org/support/topic/multisite-installation-missing-db-tables/#post-17552764)
 * [@ebiebzh0](https://wordpress.org/support/users/ebiebzh0/) Yes, looks strange.
   
   I don’t have an accessible multi-site at hand currently.Would it be possible 
   to setup a separate multisite for us, or give acces to the current blog 3 multisite(
   with MySQL DB access or plugins install permission)?We could try to run the queries
   manually and see why it fails. So on the plugin activation, it should run every
   query on the screenshot #2 you shared, but some of them fail. Obviously, #4. 
   But I assume before that, query #2 failed, without giving any error.So I assume
   _warm_ups_logs table is not created.But it’s hard to find the issue from the 
   screenshots.
 *  Thread Starter [sissi](https://wordpress.org/support/users/ebiebzh0/)
 * (@ebiebzh0)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/multisite-installation-missing-db-tables/#post-17651810)
 * [@tmmtechnology](https://wordpress.org/support/users/tmmtechnology/) I will try
   to set up a staging env for this, on the live site I cannot grant you access.
 * There are some tables missing and some tables were created but with no db fields(
   so table was there but no columns) … will get back to you with details.
 *  Thread Starter [sissi](https://wordpress.org/support/users/ebiebzh0/)
 * (@ebiebzh0)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/multisite-installation-missing-db-tables/#post-17686978)
 * [@tmmtechnology](https://wordpress.org/support/users/tmmtechnology/)
 * here a new case on activating the plugin on the second site on a multisite installation
 *     ```wp-block-code
       [15-Apr-2024 09:31:40 UTC] WordPress database error Can't create table dbname.f1u7e_wp_2_cache_warmer_warm_ups_logs (errno: 121 "Duplicate key on write or update") for queryALTER TABLE f1u7e_wp_2_cache_warmer_warm_ups_logsADD CONSTRAINT fk_warm_ups_list_idFOREIGN KEY (list_id)REFERENCES f1u7e_wp_2_cache_warmer_warm_ups_list(id) ON DELETE CASCADEmade by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, Cache_Warmer\Cache_Warmer->Cache_Warmer{closure}, Cache_Warmer\Cache_Warmer->handle_version_update, Cache_Warmer\DB::do_migrations[15-Apr-2024 09:31:41 UTC] WordPress database error Can't create table dbname.f1u7e_wp_2_cache_warmer_warm_ups_logs (errno: 121 "Duplicate key on write or update") for queryALTER TABLE f1u7e_wp_2_cache_warmer_warm_ups_logsADD CONSTRAINT fk_warm_ups_list_idFOREIGN KEY (list_id)REFERENCES f1u7e_wp_2_cache_warmer_warm_ups_list(id) ON DELETE CASCADEmade by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, Cache_Warmer\Cache_Warmer->Cache_Warmer{closure}, Cache_Warmer\Cache_Warmer->handle_version_update, Cache_Warmer\DB::do_migrations[15-Apr-2024 09:31:42 UTC] WordPress database error Can't create table dbname.f1u7e_wp_2_cache_warmer_warm_ups_logs (errno: 121 "Duplicate key on write or update") for queryALTER TABLE f1u7e_wp_2_cache_warmer_warm_ups_logsADD CONSTRAINT fk_warm_ups_list_idFOREIGN KEY (list_id)REFERENCES f1u7e_wp_2_cache_warmer_warm_ups_list(id) ON DELETE CASCADEmade by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, Cache_Warmer\Cache_Warmer->Cache_Warmer{closure}, Cache_Warmer\Cache_Warmer->handle_version_update, Cache_Warmer\DB::do_migrations[15-Apr-2024 09:31:43 UTC] WordPress database error Can't create table dbname.f1u7e_wp_2_cache_warmer_warm_ups_logs (errno: 121 "Duplicate key on write or update") for queryALTER TABLE f1u7e_wp_2_cache_warmer_warm_ups_logsADD CONSTRAINT fk_warm_ups_list_idFOREIGN KEY (list_id)REFERENCES f1u7e_wp_2_cache_warmer_warm_ups_list(id) ON DELETE CASCADEmade by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, Cache_Warmer\Cache_Warmer->Cache_Warmer{closure}, Cache_Warmer\Cache_Warmer->handle_version_update, Cache_Warmer\DB::do_migrations[15-Apr-2024 09:31:44 UTC] WordPress database error Can't create table dbname.f1u7e_wp_2_cache_warmer_warm_ups_logs (errno: 121 "Duplicate key on write or update") for queryALTER TABLE f1u7e_wp_2_cache_warmer_warm_ups_logsADD CONSTRAINT fk_warm_ups_list_idFOREIGN KEY (list_id)REFERENCES f1u7e_wp_2_cache_warmer_warm_ups_list(id) ON DELETE CASCADEmade by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, Cache_Warmer\Cache_Warmer->Cache_Warmer{closure}, Cache_Warmer\Cache_Warmer->handle_version_update, Cache_Warmer\DB::do_migrations
       ```
   
 *  Plugin Author [TMM Technology](https://wordpress.org/support/users/tmmtechnology/)
 * (@tmmtechnology)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/multisite-installation-missing-db-tables/#post-17702158)
 * [@ebiebzh0](https://wordpress.org/support/users/ebiebzh0/) I think if you could
   setup multisite staging env, that would be great.
   And give me the access to 2
   blogs there, so I could test with the plugin myself and see what exactly happens.
   I can’t find out the reason from the debug log, unfortunately.
 *  Thread Starter [sissi](https://wordpress.org/support/users/ebiebzh0/)
 * (@ebiebzh0)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/multisite-installation-missing-db-tables/#post-17726032)
 * [@tmmtechnology](https://wordpress.org/support/users/tmmtechnology/) sent you
   an email with all details for the staging site
 *  Plugin Author [TMM Technology](https://wordpress.org/support/users/tmmtechnology/)
 * (@tmmtechnology)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/multisite-installation-missing-db-tables/#post-17734148)
 * [@ebiebzh0](https://wordpress.org/support/users/ebiebzh0/) Can you try updating
   the plugin?
 *  Thread Starter [sissi](https://wordpress.org/support/users/ebiebzh0/)
 * (@ebiebzh0)
 * [2 years ago](https://wordpress.org/support/topic/multisite-installation-missing-db-tables/#post-17751258)
 * [@tmmtechnology](https://wordpress.org/support/users/tmmtechnology/) looks good!
   thank you.

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

The topic ‘Multisite installation missing db tables’ is closed to new replies.

 * ![](https://ps.w.org/cache-warmer/assets/icon.svg?rev=2869611)
 * [Cache Warmer](https://wordpress.org/plugins/cache-warmer/)
 * [Support Threads](https://wordpress.org/support/plugin/cache-warmer/)
 * [Active Topics](https://wordpress.org/support/plugin/cache-warmer/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/cache-warmer/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/cache-warmer/reviews/)

## Tags

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

 * 9 replies
 * 2 participants
 * Last reply from: [sissi](https://wordpress.org/support/users/ebiebzh0/)
 * Last activity: [2 years ago](https://wordpress.org/support/topic/multisite-installation-missing-db-tables/#post-17751258)
 * Status: resolved