• Resolved sissi

    (@ebiebzh0)


    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:

    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

    (@tmmtechnology)

    @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

    (@ebiebzh0)

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

    Plugin Author TMM Technology

    (@tmmtechnology)

    @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

    (@ebiebzh0)

    @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

    (@ebiebzh0)

    @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
    Plugin Author TMM Technology

    (@tmmtechnology)

    @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

    (@ebiebzh0)

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

    Plugin Author TMM Technology

    (@tmmtechnology)

    @ebiebzh0 Can you try updating the plugin?

    Thread Starter sissi

    (@ebiebzh0)

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