Plugin is not working after upgrade. Please fix ASAP

Hey @mstep,

Plugin migration should have done that for you, but it seems for some reason it failed to create the DB table.
Let’s try to help it understand that it needs to trigger table creation again.

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.
5. Open plugin settings page /wp-admin/admin.php?page=wpforms-settings.

After that, the plugin should trigger table recreation as it will think that you are upgrading from the previous version.

Thanks for responding. I am using multisite and there are no wpforms keys in /wp-admin/options.php. Should I look in the options table of the database itself for those keys?

@mstep, You can, but it won’t help, because /wp-admin/options.php displayed all keys and their values from wp_options table.
If you don’t have any wpforms_* key – that means you haven’t activated plugin at all on this site.

Again, I am using multisite and there are no keys for wpforms in /wp-admin/options.php. I have my email working again, and wpforms lite is installed and network active. For each site I can see an options table in the data base e.g., wp_options, wp_2_options, wp_3_options, etc. Each has wpforms fields for the version of wpforms.

@mstep Sure thing. I apologize for the trouble! It looks like a database table wasn’t correctly created.

I’m not sure if options.php is available in multisite. If it’s not you may need to use phpMyAdmin or similar to access the database.

As you mentioned, in multisite, there are different DB tables for each site, wp_x_ with X being the site ID.

So you’d want to search for “wpforms_version_lite” within the option table that corresponds to this site if you’re still having issues, and simply remove that option. This should trigger the database to be created.

Again, very sorry for the trouble. We have an update coming out in the next week or two, and we’re going to make sure and do more testing on multisite so this isn’t an issue.

• This reply was modified 4 years, 11 months ago by Jared Atchison.

Thanks. Yes, I decided yesterday to work on the wp_x_options table with phpAdmin. For each site in multisite (the “x”) I changed the version in the table to 1.5.8.2. Then I went to /wp-admin/admin.php?page=wpforms-settings for each site and hit “Save Settings”. I think that has fixed it.

options.php is available in multisite but it does NOT have any options settings in it. That is done via the DB.

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.

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 <code></code>

I have tried the steps in this thread, nothing seems to work. I’ve tried dropping the ‘wpvf_wpforms_tasks_meta’ table in phpmyadmin, which doesn’t make a difference.

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

Thanks,
John.

Hi @sk1cars,

When you get the chance, could you create a new post with a link to your site?

Thanks!

Hello,

I know I do not belong to this thread but this is so similar to what I am facing.

I am getting this error in my log. Please let me know how to fix this error.

[Tue Jul 07 16:40:35.393759 2020] [proxy_fcgi:error] [pid 29407:tid 140583121016576] [client 47.15.11.89:50926] AH01071: Got error 'PHP message: WordPress database error Table 'bitnami_wordpress.wp_wpforms_tasks_meta' doesn't exist for query SHOW FULL COLUMNS FROMwp_wpforms_tasks_metamade by require_once('wp-admin/admin-header.php'), do_action('in_admin_header'), WP_Hook->do_action, WP_Hook->apply_filters, wp_admin_bar_render, do_action_ref_array('admin_bar_menu'), WP_Hook->do_action, WP_Hook->apply_filters, WPForms\\Admin\\AdminBarMenu->register, WPForms\\Admin\\AdminBarMenu->main_menu, WPForms\\Admin\\AdminBarMenu->has_notifications, WPForms\\Admin\\Notifications->get_count, WPForms\\Admin\\Notifications->get, WPForms\\Tasks\\Task->register, WPForms\\Tasks\\Meta->add, WPForms_DB->addPHP message: WordPress database error Table 'bitnami_wordpress.wp_wpforms_tasks_meta' doesn't exist for query SHOW FULL COLUMNS FROMwp_wpforms_tasks_metamade by require_once('wp-admin/admin-header.php'), do_action('in_admin_header'), WP_Hook->do_action, WP_Hook->apply_filters, wp_admin_bar_render, do_action_ref_array('admin_bar_menu'), WP_Hook->do_action, WP_Hook->apply_filters, WPForms\\Admin\\AdminBarMenu->register, WPForms\\Admin\\AdminBarMenu->notification_menu, WPForms\\Admin\\AdminBarMenu->has_notifications, WPForms\\Admin\\Notifications->get_count, WPForms\\Admin\\Notifications->get, WPForms\\Tasks\\Task->register, WPForms\\Tasks\\Meta->add, WPForms_DB->add', referer: https://saosis.com/wp-admin/admin.php?page=aiowpsec_database

Hi @sdghosh,

When you get the chance, could you try navigating to WPForms > Tools > Scheduled Actions (please see screenshot here)in the plugin? This should generate the tables needed.

If that does not resolve the issue, could you please create a new post in our WPForms Lite support forum?

Thanks!

Thanks!

I have activated the plugin. Facing the same issue. I couldn’t find any options schema-ActionScheduler_LoggerSchema, schema-ActionScheduler_StoreSchema, and action_scheduler_migration_status

Facing the same issue with WP SMTP.

Hi everyone. I have the same problem to @adamkws. But my problem is to woocommerce. I read your answers but in my case. I couldn’t find any options schema-ActionScheduler_LoggerSchema, schema-ActionScheduler_StoreSchema, and action_scheduler_migration_status.

there are my pictures. Thank you.

https://drive.google.com/drive/folders/1SWJWSHNfc_vs7fVDK-blU901nvmD7erQ?usp=sharing

Hi,

This solution was supposed to be provided by the plugin author. You can manually execute this query to create the table to fix this issue

make sure to change the table name (prefix)

CREATE TABLE MU2_actionscheduler_actions (
action_id bigint(20) unsigned NOT NULL auto_increment,
hook varchar(191) NOT NULL,
status varchar(20) NOT NULL,
scheduled_date_gmt datetime NOT NULL default '0000-00-00 00:00:00',
scheduled_date_local datetime NOT NULL default '0000-00-00 00:00:00',
args varchar(191),
schedule longtext,
group_id bigint(20) unsigned NOT NULL default '0',
attempts int(11) NOT NULL default '0',
last_attempt_gmt datetime NOT NULL default '0000-00-00 00:00:00',
last_attempt_local datetime NOT NULL default '0000-00-00 00:00:00',
claim_id bigint(20) unsigned NOT NULL default '0',
extended_args varchar(8000) DEFAULT NULL,
PRIMARY KEY  (action_id),
KEY hook (hook(191)),
KEY status (status),
KEY scheduled_date_gmt (scheduled_date_gmt),
KEY args (args(191)),
KEY group_id (group_id),
KEY last_attempt_gmt (last_attempt_gmt),
KEY claim_id (claim_id)
) 

• This reply was modified 4 years, 6 months ago by manees.
• This reply was modified 4 years, 6 months ago by manees.

Hey @lindakarina,

For issues related to WooCommerce, you may want to reach out to their team in the WooCommerce support forum.

If you’d like more help with using WPForms Lite, please feel welcome to start a new thread in our WPForms Lite support forum.

Thanks!

Thank you @slaffik! I don’t use your plugin, but I had the error message in this thread and your first comment helped me solve my issue! (A BING search brought me here)