Error when using on multi site network

  • Resolved odecharette

    (@odecharette)


    1 year ago

    Hi,
    Thanks for your plugin, it seems really cool !
    I installed the plugin on a multisite network (5 shops).

    I can see abandonned carts on 1st shop, but then I have Error 500 on the admin page of other shops inside the same network.

    Here is the log. FYI we have the plugin W3 total cache installed.

    Can you help us?

    Thanks

    [23-Nov-2023 09:50:38 UTC] PHP Fatal error:  Uncaught TypeError: mysqli_num_fields(): Argument #1 ($result) must be of type mysqli_result, bool given in /srv/www/$$$$MY-WEBSITE.fr$$$/releases/20231123090730Z/wp-includes/wp-db.php:3547
Stack trace:
#0 /srv/www/$$$$MY-WEBSITE.fr$$$/releases/20231123090730Z/wp-includes/wp-db.php(3547): mysqli_num_fields(false)
#1 /srv/www/$$$$MY-WEBSITE.fr$$$/releases/20231123090730Z/wp-includes/wp-db.php(737): wpdb->load_col_info()
#2 /srv/www/$$$$MY-WEBSITE.fr$$$/releases/20231123090730Z/wp-content/plugins/w3-total-cache/DbCache_WpdbInjection_QueryCaching.php(218): wpdb->__get('col_info')
#3 /srv/www/$$$$MY-WEBSITE.fr$$$/releases/20231123090730Z/wp-content/plugins/w3-total-cache/DbCache_WpdbNew.php(122): W3TC\DbCache_WpdbInjection_QueryCaching->query('DESCRIBE wp_2_c...')
#4 /srv/www/$$$$MY-WEBSITE.fr$$$/releases/20231123090730Z/wp-includes/wp-db.php(2836): W3TC\DbCache_WpdbNew->query('DESCRIBE wp_2_c...')
#5 /srv/www/$$$$MY-WEBSITE.fr$$$/releases/20231123090730Z/wp-admin/includes/upgrade.php(2803): wpdb->get_results('DESCRIBE wp_2_c...')
#6 /srv/www/$$$$MY-WEBSITE.fr$$$/releases/20231123090730Z/wp-content/plugins/woo-save-abandoned-carts/includes/class-cartbounty-activator.php(60): dbDelta(Array)
#7 /srv/www/$$$$MY-WEBSITE.fr$$$/releases/20231123090730Z/wp-content/plugins/woo-save-abandoned-carts/cartbounty-abandoned-carts.php(72): CartBounty_Activator::activate()
#8 /srv/www/$$$$MY-WEBSITE.fr$$$/releases/20231123090730Z/wp-content/plugins/woo-save-abandoned-carts/admin/class-cartbounty-admin.php(2541): activate_cartbounty()
#9 /srv/www/$$$$MY-WEBSITE.fr$$$/releases/20231123090730Z/wp-includes/class-wp-hook.php(307): CartBounty_Admin->check_version('')
#10 /srv/www/$$$$MY-WEBSITE.fr$$$/releases/20231123090730Z/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters(NULL, Array)
#11 /srv/www/$$$$MY-WEBSITE.fr$$$/releases/20231123090730Z/wp-includes/plugin.php(476): WP_Hook->do_action(Array)
#12 /srv/www/$$$$MY-WEBSITE.fr$$$/releases/20231123090730Z/wp-settings.php(461): do_action('plugins_loaded')
#13 /srv/www/$$$$MY-WEBSITE.fr$$$/shared/wp-config.php(124): require_once('/srv/www/config...')
#14 /srv/www/$$$$MY-WEBSITE.fr$$$/releases/20231123090730Z/wp-load.php(50): require_once('/srv/www/config...')
#15 /srv/www/$$$$MY-WEBSITE.fr$$$/releases/20231123090730Z/wp-blog-header.php(13): require_once('/srv/www/config...')
#16 /srv/www/$$$$MY-WEBSITE.fr$$$/releases/20231123090730Z/index.php(17): require('/srv/www/config...')
#17 {main}
  thrown in /srv/www/$$$$MY-WEBSITE.fr$$$/releases/20231123090730Z/wp-includes/wp-db.php on line 3547
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Nauriskolats

    (@nauriskolats)

    Hi @odecharette, thank you for posting about your issue here.
    This is the first time we have received an issue with using CartBounty on a multi-site WordPress installation.

    We will try to recreate this on our own testing environment and let you know about our findings.

    Kind regards,
    Nauris

    Plugin Contributor Nauriskolats

    (@nauriskolats)

    Have just returned with solid and good test results. Here is what we did:
    1) Installed and setup a new multi-site WordPress installation
    2) Added 3 sites total
    3) Installed CartBounty plugin while located on the Network Admin Plugins page
    4) Network activated CartBounty plugin to make sure all sites can use it

    After that we switched between different sites and did not find any issues or errors. Maybe you can share your experience or some additional testing scenario that you used?

    Thread Starter odecharette

    (@odecharette)

    Hi @nauriskolats

    Thanks for your testing !

    The scenario seams good. I’ll have a look on it with my developper, next week. I’ll come back to you

    Many thanks

    Olivia

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Error when using on multi site network’ is closed to new replies.