Support » Plugin: Contact Form by WPForms - Drag & Drop Form Builder for WordPress » Database Errors Upgrading from 1.5.8.2 to 1.6

  • Resolved sk1cars

    (@sk1cars)


    Hi WPForms team,

    I have recently upgraded to the latest WordPress version, upon upgrading your plugin from 1.5.8.2 to the latest version I have encountered these errors with Debug mode.

    Fatal error: Cannot declare class Action_Scheduler\Migration\Scheduler, because the name is already in use in /home/johwil186/sk1cars.co.uk/wp-content/plugins/wpforms-lite/vendor/woocommerce/action-scheduler/classes/migration/Scheduler.php on line 15
    
    Notice: Undefined property: wpdb::$actionscheduler_actions in /home/X/sk1cars.co.uk/wp-includes/wp-db.php on line 647
    WordPress database error: [Table 'sk1_wp8341.a' doesn't exist]
    SELECT a.action_id FROM a WHERE a.hook='action_scheduler/migration_hook' AND a.status='in-progress' ORDER BY scheduled_date_gmt DESC LIMIT 1
    
    Notice: Undefined property: wpdb::$actionscheduler_actions in /home/X/sk1cars.co.uk/wp-includes/wp-db.php on line 647
    WordPress database error: [Table 'sk1_wp8341.a' doesn't exist]
    SELECT a.action_id FROM a WHERE a.hook='action_scheduler/migration_hook' AND a.status='pending' ORDER BY scheduled_date_gmt ASC LIMIT 1
    
    Notice: Undefined property: wpdb::$actionscheduler_actions in /home/X/sk1cars.co.uk/wp-includes/wp-db.php on line 647
    WordPress database error: [Table 'sk1_wp8341.a' doesn't exist]
    SELECT a.action_id FROM a WHERE a.hook='action_scheduler/migration_hook' AND a.status='in-progress' ORDER BY scheduled_date_gmt DESC LIMIT 1
    
    Notice: Undefined property: wpdb::$actionscheduler_actions in /home/X/sk1cars.co.uk/wp-includes/wp-db.php on line 647
    WordPress database error: [Table 'sk1_wp8341.a' doesn't exist]
    SELECT a.action_id FROM a WHERE a.hook='action_scheduler/migration_hook' AND a.status='pending' ORDER BY scheduled_date_gmt ASC LIMIT 1
    
    Notice: Undefined property: wpdb::$actionscheduler_groups in /home/X/sk1cars.co.uk/wp-includes/wp-db.php on line 647
    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE slug='action-scheduler-migration'' at line 1]
    SELECT group_id FROM WHERE slug='action-scheduler-migration'
    
    Notice: Undefined property: wpdb::$actionscheduler_groups in /home/X/sk1cars.co.uk/wp-includes/wp-db.php on line 647
    WordPress database error: [Incorrect table name '']
    SHOW FULL COLUMNS FROM

    I’ve tried dropping the ‘wpvf_wpforms_tasks_meta’ table in phpmyadmin, which doesn’t make a difference.

    I have also tried:

    1. Please open /wp-admin/options.php on your site
    2. Find on the page these keys: wpforms_version_lite and wpforms_version
    3. Change their values to the previous version of the plugin: 1.5.8.2
    4. Save the options.

    Also tried:

    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.

    Is there a way I can clean-install the plugin/recreate the DB? I can only receive a critical error no matter what I do.

    Thanks,
    John.

    The page I need help with: [log in to see the link]

Viewing 9 replies - 1 through 9 (of 9 total)
  • The plugin is currently removed, and the website works fine. Usually the form would appear at the bottom of the contact page.

    Plugin Support Ethan Choi

    (@ethanchoi)

    Hi @sk1cars,

    Thanks for the details!

    To troubleshoot the issue, please activate WPForms Lite and then open the following page on your browser (replace example.com with your site domain):

    https://example.com/wp-admin/tools.php?page=action-scheduler

    This should trigger the ‘Action Scheduler’ code library to automatically recreate the required tables.

    Please let me know how it goes.

    Thanks!

    Hi,

    I can’t get this far, as when I enable the plugin I get a critical error, and when I enable debug mode I can only get:

    Fatal error: Cannot declare class Action_Scheduler\Migration\Scheduler, because the name is already in use in /home/johwil186/sk1cars.co.uk/wp-content/plugins/wpforms-lite/vendor/woocommerce/action-scheduler/classes/migration/Scheduler.php on line 15
    There has been a critical error on your website. Please check your site admin email inbox for instructions.
    
    Learn more about debugging in WordPress.

    In both the ACP and on the website with debug enabled.]

    Also tried updating to the latest version.

    Thanks,
    John.

    Plugin Support Ethan Choi

    (@ethanchoi)

    Hi @sk1cars,

    Thanks for the update!

    We’ve released an update that should fix the issue with the Action Scheduler code library.

    When you get the chance, could you delete the WPForms Lite plugin on your site, and install the latest version of WPForms Lite (currently this is 1.6.0.2) to see if it resolves the issue?

    Thanks!

    Plugin Support Ethan Choi

    (@ethanchoi)

    Hi @sk1cars,

    We haven’t heard back from you in about a week, so I’m going to go ahead and close this thread for now. But if you’d like us to assist, please feel welcome to continue the conversation.

    Thanks!

    It worked! I had to disable my outdated theme to access that page, but worked a charm!

    Thanks for all your help.

    Hi,

    Sorry to be a pain, I keep recreating the issue and have to go through the steps above again to access my website.

    It happens whenever I try to uninstall a plugin.

    The error I receive is
    Fatal error: Cannot declare class Action_Scheduler\Migration\Scheduler, because the name is already in use in /home/johwil186/sk1cars.co.uk/wp-content/plugins/wpforms-lite/vendor/woocommerce/action-scheduler/classes/migration/Scheduler.php on line 15

    I have to also disable my theme to access
    /wp-admin/tools.php?page=action-scheduler

    Other than that the plugin works great.

    A little frustrating as I’m trialing new plugins though.

    Plugin page also displays a red error:

    The plugin wpforms-lite/wpforms.php has been deactivated due to an error: Plugin file does not exist.

    Plugin Support Ethan Choi

    (@ethanchoi)

    Hi @sk1cars,

    Thanks for the update! If your theme is outdated, please consider updating it to its latest version. Updates include bug fixes and enhancements, and maintain compatability with newer WordPress core versions. It’s possible that this is either causing or contributing to the issues that you’re seeing, so we need to start with this.

    The error message “The plugin wpforms-lite/wpforms.php has been deactivated due to an error: Plugin file does not exist.” seems to indicate that the WPForms Lite plugin has been deleted, or its plugin folder is renamed in the site directory. To check for this you can access your site directory via FTP, and go the wp-content/plugins folder to look for the wpforms-lite folder.

    Hope this helps!

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Database Errors Upgrading from 1.5.8.2 to 1.6’ is closed to new replies.