Plugin is not working after upgrade. Please fix ASAP

  • Resolved adamkws

    (@adamkws)


    4 years, 7 months ago

    Dear WPForms Team,

    Your plugin is installed and activated in an AJAX call to WordPress site.

    We use activate_plugin( ‘wpforms-lite/wpforms.php’ ) method to activate your plugin.

    This is a standard way of activating any plugin.

    Right after that, site STOPS working with such errors:

    WordPress database error: [Table ‘db7dybhmv.wp_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wp_actionscheduler_actions a WHERE a.hook=’wpforms_process_entry_emails_meta_cleanup’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1

    WordPress database error: [Table ‘db7dybhmv.wp_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wp_actionscheduler_actions a WHERE a.hook=’wpforms_process_entry_emails_meta_cleanup’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

    WordPress database error: [Table ‘db7dybhmv.wp_actionscheduler_groups’ doesn’t exist]
    SELECT group_id FROM wp_actionscheduler_groups WHERE slug=’wpforms’

    WordPress database error: [Table ‘db7dybhmv.wp_actionscheduler_groups’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp_actionscheduler_groups

    WordPress database error: [Table ‘db7dybhmv.wp_actionscheduler_actions’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp_actionscheduler_actions

    Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘db7dybhmv.wp_actionscheduler_actions’ doesn’t exist in /home/customer/www/example.com/public_html/wp-content/plugins/wpforms-lite/vendor/woocommerce/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /home/customer/www/example.com/public_html/wp-content/plugins/wpforms-lite/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(225): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL) #1 /home/customer/www/example.com/public_html/wp-content/plugins/wpforms-lite/vendor/woocommerce/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action)) #2 /home/customer/www/example.com/public_html/wp-content/plugins/wpforms-lite/vendor/woocommerce/action-scheduler/classes/ActionScheduler_ActionFactory.php(105): ActionScheduler_ActionFacto in /home/customer/www/example.com/public_html/wp-content/plugins/wpforms-lite/vendor/woocommerce/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44

    WordPress database error: [Table ‘db7dybhmv.wp_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wp_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1

    WordPress database error: [Table ‘db7dybhmv.wp_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wp_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

    WordPress database error: [Table ‘db7dybhmv.wp_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wp_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1

    WordPress database error: [Table ‘db7dybhmv.wp_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wp_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

    WordPress database error: [Table ‘db7dybhmv.wp_actionscheduler_groups’ doesn’t exist]
    SELECT group_id FROM wp_actionscheduler_groups WHERE slug=’action-scheduler-migration’

    WordPress database error: [Table ‘db7dybhmv.wp_actionscheduler_groups’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp_actionscheduler_groups

    WordPress database error: [Table ‘db7dybhmv.wp_actionscheduler_actions’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp_actionscheduler_actions

    Please fix this issue ASAP!

Viewing 15 replies - 1 through 15 (of 30 total)
  • Plugin Author Slava Abakumov

    (@slaffik)

    What do you mean an “ajax call to activate the plugin”? This is NOT a standard way to do it. The standard one is to go to the Plugins page in the wp-admin area and click on the “Activate” link for a plugin you want to activate.
    The ajax way may not work because we use a 3rd party library (that is used in WooCommerce too) that has its own migration procedures, that in your case haven’t run, and thus – all those errors are generated.

    To fix the issue please process with the standard way to activate plugins.

    If the error persists please try these steps:

    1. Open /wp-admin/options.php page on your site.
    2. On this page find options schema-ActionScheduler_LoggerSchema, schema-ActionScheduler_StoreSchema, and action_scheduler_migration_status and remove their values (leave them empty), save options changes.
    3. Activate on the Plugins page the WPForms plugin again.

    This will trigger an internal library upgrade routine and that should fix the issue.

    Thread Starter adamkws

    (@adamkws)

    This file: wp-admin/admin-ajax.php

    It contains admin_init action, but not the init action, probably you DON’T HANDLE THAT.

    We make AJAX request to that endpoint and call this API:
    activate_plugin( ‘wpforms-lite/wpforms.php’ )

    activate_plugin(() is a STANDARD API OF WORDPRESS, thus your plugin must work there even if called via AJAX, as well as all other plugins work there.

    MOREOVER, the steps you provided fixes the issue PARTIALLY, after removing those options, THERE IS STILL ERROR:

    WordPress database error: [Table ‘i6336083_wp1.wp_wpforms_tasks_meta’ doesn’t exist] SHOW FULL COLUMNS FROM wp_wpforms_tasks_meta

    Thread Starter adamkws

    (@adamkws)

    PLUGIN MUST NEVER CRASH, DESPITE THE MIGRATION STATUS, PLEASE FIX THE ISSUE IN YOUR CODE

    Plugin Author Slava Abakumov

    (@slaffik)

    It contains admin_init action, but not the init action

    That’s incorrect.

    WordPress database error: [Table ‘i6336083_wp1.wp_wpforms_tasks_meta’ doesn’t exist] SHOW FULL COLUMNS FROM wp_wpforms_tasks_meta

    This particular error can be fixed like this:
    1) go to wp_options table in DB or open /wp-admin/options.php page on your site
    2) find wpforms_version_lite option and remove it (or clear its value).
    3) find wpforms_version option and change its value to 1.5.8.2.
    4) reload any admin area page.

    Thread Starter adamkws

    (@adamkws)

    FIX THE BUG! I DON’T HAVE TO GO TO OPTIONS AND DELETE MYSQL OPTIONS ON EACH SITE!

    I’m seeing this problem as well. I applied the most recent update a day or two ago (update page said “Downloading update from https://downloads.www.ads-software.com/plugin/wpforms-lite.1.5.9.1.zip”, and now I’m seeing an error on every page of my site:

    WordPress database error: [Table ‘[dbname].wp_wpforms_tasks_meta’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp_26emka_wpforms_tasks_meta

    And it’s not just us. Try googling “wp_wpforms_tasks_meta doesn’t exist”. I get this thread as the top result, followed by 9 distinct sites that are showing the error. And that’s just the front page! I didn’t try to find more, but I’m sure there are thousands. An update fixing this would be greatly appreciated.

    Plugin Support Ethan Choi

    (@ethanchoi)

    Hi @davidreedernst,

    We apologize for the trouble with that!

    We had recently included a background processing library in the plugin. However, some WooCommerce addons accidentally had included older version of that library briefly, and this causes a conflict which lead to the error.

    To fix this, please try the following steps:

    1. In the WordPress admin area, open /wp-admin/options.php page on your site.
    2. On this page find options schema-ActionScheduler_LoggerSchema, schema-ActionScheduler_StoreSchema, and action_scheduler_migration_status and remove their values (leave them empty), save options changes.
    3. Activate WPForms plugin again.

    Thank you for the reply. That worked.

    In more detail: I didn’t find action_scheduler_migration_status on the options page, but the other two were there. I deleted their values as you suggested, and re-enabled WPForms Lite. I’m no longer seeing the error messages. Thank you for your help!

    I have the same issue. I looked in wp-admin/option.php and I have not any options what you wrote above. I looked also to database this website and there is not table with name actionscheduler.
    Thanks for your advice
    Petr

    Plugin Support Ethan Choi

    (@ethanchoi)

    Hi @pvlcek7,

    Sorry for the trouble with that!

    We’ve released a fix for the issue. When you get the chance, could you update the plugin to its latest version (currently 1.5.9.5) and let us know how it goes?

    Thanks!

    Thank you for your answer, but error was on my database side. After recovery my database everything working right. I have solved it with my webhosting provider.
    Have a healthy day in this time!

    I let schema-ActionScheduler_LoggerSchema and schema-ActionScheduler_StoreSchema empty via database, and I still see the error message.

    Besides, the form suddenly stopped sending any email (admin test works)

    Plugin Support Ethan Choi

    (@ethanchoi)

    Hi @andrearanha90,

    When you get the chance, could you check if WPForms Lite on your site has been updated to its latest version (currently we’re at 1.5.9.5)?

    Please let me know. Thanks!

    Update to latest wp and plugin lite version but get this error since March 25 when I upgraded:

    [25-Mar-2020 20:49:01 UTC] WordPress database error Table ‘XXXXXXXX_wpforms_tasks_meta’ doesn’t exist for query SHOW FULL COLUMNS FROM XXXXX_wpforms_tasks_meta made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, WPForms\WPForms->WPForms\{closure}, WPForms\Tasks\Tasks->init, WPForms\Tasks\Actions\EntryEmailsMetaCleanupTask->__construct, WPForms\Tasks\Actions\EntryEmailsMetaCleanupTask->init, WPForms\Tasks\Task->register, WPForms\Tasks\Meta->add, WPForms_DB->add

    Some response would be appreciated since the plugin in no longer sending email, presumably due to the error.

Viewing 15 replies - 1 through 15 (of 30 total)
  • The topic ‘Plugin is not working after upgrade. Please fix ASAP’ is closed to new replies.