Multisite compatibility

  • Resolved pluspol

    (@pluspol)


    1 year, 11 months ago

    Hi,

    We regularly get the following error when WP-CLI runs the crons for our Multisite setup:

    WordPress database error Table 'wp_2_cf7a_blacklist' doesn't exist for query UPDATE wp_2_cf7a_blacklist SET status = status - 1 WHERE 1 made by include('/srv/www/htdocs/public/vendor/johnpbloch/wp-cli-phar/wp'), include('phar:///srv/www/htdocs/public/vendor/johnpbloch/wp-cli-phar/wp/php/boot-phar.php'), include('phar:///srv/www/htdocs/public/vendor/johnpbloch/wp-cli-phar/wp/vendor/wp-cli/wp-cli/php/wp-cli.php'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->run_command_and_exit, WP_CLI\Runner->run_command, WP_CLI\Dispatcher\Subcommand->invoke, call_user_func, WP_CLI\Dispatcher\CommandFactory::WP_CLI\Dispatcher\{closure}, call_user_func, Cron_Event_Command->run, Cron_Event_Command::run_event, do_action_ref_array('cf7a_cron'), WP_Hook->do_action, WP_Hook->apply_filters, CF7_AntiSpam_Filters->cf7a_cron_unban

    There’s a table wp_cf7a_blacklist but no similar ones for the blogs.

    Are we missing something?
    Best

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Erik

    (@codekraft)

    thank you @pluspol for reporting.
    I think you are right and that there is some issues with the multisite table! Give me time to check it out better and I will try to release a fix in the next version! thanks again and apologize for the inconvenience.

    Plugin Author Erik

    (@codekraft)

    The new version (v0.4.5) should be 100% multisite compatible, let me know if you still have issues but, for what I had a chance to test, even the “standard” installation was being correctly “upgraded” to the multisite one without any warning.

    PS. If the issue is solved mark this as completed, thanks!

    Thread Starter pluspol

    (@pluspol)

    Thanks for the update!
    We could install the update without any problems. However we can’t really tell atm whether it works as expected as the problem occurred only once in a while. So we might need to wait a bit.

    Am I assuming correctly that the plugin creates tables for every blog? In this case upgrading the plugin hasn’t created the tables for our system. We only see the tables for the root instance.

    Best

    Thread Starter pluspol

    (@pluspol)

    Hi @codekraft ,

    Unfortunately we can confirm that the issue still exists as it came up again just now.

    Can you have a look at it again please? And also at my previous comment.

    Best

    Plugin Author Erik

    (@codekraft)

    hi @pluspol ,
    sorry but it took me a while to test it and I can confirm what you say… with the update the problem is not solved, in order to install the tables correctly you have to uninstall the plugin and reinstall it. In this case the installation process will “restart” correctly (in multisite mode) but probably the tables related to the B8 dictionary will be deleted (and plugin options too).

    If you want to keep B8’s dictionary, you will have to back it up, then reload it by replacing the empty dictionary that is created during installation. However, I think this step is unnecessary, a fairly effective dictionary is rebuilt after about 20-30 mails received

    Thread Starter pluspol

    (@pluspol)

    HI @codekraft ,

    Thanks for the hint. We can confirm that reactivating the plugin created the missing tables. So we’ll wait a bit whether the issue comes up again.

    Best

    Thread Starter pluspol

    (@pluspol)

    Hi @codekraft ,
    Today the issue came up again, but on an unpatched installation. In the post we got errors on both instances at the same time, so we think that the issue is fixed.

    Therefore I’m closing here. Thanks for your support!

    Best.

    Plugin Author Erik

    (@codekraft)

    thank you for the feedback!

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Multisite compatibility’ is closed to new replies.

Tags