Multisite installation missing db tables

@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).

sent the images via mail to you at [email protected]

@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.

@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.

@tmmtechnology

here a new case on activating the plugin on the second site on a multisite installation

[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 query
ALTER TABLE f1u7e_wp_2_cache_warmer_warm_ups_logs
ADD CONSTRAINT fk_warm_ups_list_id
FOREIGN KEY (list_id)
REFERENCES f1u7e_wp_2_cache_warmer_warm_ups_list(id) ON DELETE CASCADE
made 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 query
ALTER TABLE f1u7e_wp_2_cache_warmer_warm_ups_logs
ADD CONSTRAINT fk_warm_ups_list_id
FOREIGN KEY (list_id)
REFERENCES f1u7e_wp_2_cache_warmer_warm_ups_list(id) ON DELETE CASCADE
made 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 query
ALTER TABLE f1u7e_wp_2_cache_warmer_warm_ups_logs
ADD CONSTRAINT fk_warm_ups_list_id
FOREIGN KEY (list_id)
REFERENCES f1u7e_wp_2_cache_warmer_warm_ups_list(id) ON DELETE CASCADE
made 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 query
ALTER TABLE f1u7e_wp_2_cache_warmer_warm_ups_logs
ADD CONSTRAINT fk_warm_ups_list_id
FOREIGN KEY (list_id)
REFERENCES f1u7e_wp_2_cache_warmer_warm_ups_list(id) ON DELETE CASCADE
made 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 query
ALTER TABLE f1u7e_wp_2_cache_warmer_warm_ups_logs
ADD CONSTRAINT fk_warm_ups_list_id
FOREIGN KEY (list_id)
REFERENCES f1u7e_wp_2_cache_warmer_warm_ups_list(id) ON DELETE CASCADE
made 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

@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.

@tmmtechnology sent you an email with all details for the staging site

@ebiebzh0 Can you try updating the plugin?

@tmmtechnology looks good! thank you.