PS: Duplicate this ticket as PUBLIC, while waiting for TMS Support to response on my PRIVATE TICKET #2590426. There is no option to make the submitted ticket public. Hopefully someone from this forum/community who hit the same issue can shed some lights.
I have tried deactivate, re-install (dropped tables related to ameliabooking) and re-activate the plugins, but error the persists. Kindly advise.
** Below is log messages generated on 1st attempt to active the plugins **
[04-Nov-2020 16:28:52 UTC] PHP Warning: Invalid argument supplied for foreach() in /var/www/ifincarelab/public_html/wp-content/plugins/ameliabooking/src/Infrastructure/WP/InstallActions/DB/AbstractDatabaseTable.php on line 44 [04-Nov-2020 16:28:52 UTC] PHP Notice: Undefined index: hash in /var/www/ifincarelab/public_html/wp-content/plugins/ameliabooking/src/Infrastructure/WP/InstallActions/ActivationSettingsHook.php on line 441 [04-Nov-2020 16:28:52 UTC] PHP Notice: Trying to access array offset on value of type null in /var/www/ifincarelab/public_html/wp-content/plugins/ameliabooking/vendor/oyejorge/less.php/lib/Less/Tree/Import.php on line 221 [04-Nov-2020 16:28:52 UTC] PHP Notice: Trying to access array offset on value of type null in /var/www/ifincarelab/public_html/wp-content/plugins/ameliabooking/vendor/oyejorge/less.php/lib/Less/Tree/Import.php on line 221 [04-Nov-2020 16:28:52 UTC] PHP Notice: Trying to access array offset on value of type null in /var/www/ifincarelab/public_html/wp-content/plugins/ameliabooking/vendor/oyejorge/less.php/lib/Less/Tree/Import.php on line 221 [04-Nov-2020 16:28:52 UTC] PHP Notice: Trying to access array offset on value of type null in /var/www/ifincarelab/public_html/wp-content/plugins/ameliabooking/vendor/oyejorge/less.php/lib/Less/Tree/Import.php on line 221
** Below is log messages generated on 2nd attempt to re-active the plugins **
[04-Nov-2020 09:51:09 UTC] WordPress database error Can't DROP 'name'; check that column/key exists for query ALTER TABLE wp_amelia_notifications DROP INDEX name made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBookingPlugin::activation, AmeliaBookingInfrastructureWPInstallActionsActivationDatabaseHook::init, AmeliaBookingInfrastructureWPInstallActionsDBAbstractDatabaseTable::init, AmeliaBookingInfrastructureWPInstallActionsDBNotificationNotificationsTable::buildTable [04-Nov-2020 09:51:09 UTC] WordPress database error Duplicate key name 'userlocation' for query ALTER TABLE wp_amelia_providers_to_locations ADD UNIQUE KEY `userlocation` (`userid`,`locationId`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBookingPlugin::activation, AmeliaBookingInfrastructureWPInstallActionsActivationDatabaseHook::init, AmeliaBookingInfrastructureWPInstallActionsDBAbstractDatabaseTable::init, dbDelta [04-Nov-2020 09:51:10 UTC] PHP Warning: Invalid argument supplied for foreach() in /var/www/ifincarelab/public_html/wp-content/plugins/ameliabooking/src/Infrastructure/WP/InstallActions/DB/AbstractDatabaseTable.php on line 44 [04-Nov-2020 09:51:10 UTC] WordPress database error Can't DROP 'wp_amelia_notifications_sms_history_ibfk_1'; check that column/key exists for query ALTER TABLE wp_amelia_notifications_sms_history DROP FOREIGN KEY wp_amelia_notifications_sms_history_ibfk_1 made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBookingPlugin::activation, AmeliaBookingInfrastructureWPInstallActionsActivationDatabaseHook::init, AmeliaBookingInfrastructureWPInstallActionsDBAbstractDatabaseTable::init, AmeliaBookingInfrastructureWPInstallActionsDBNotificationNotificationsSMSHistoryTable::buildTable [04-Nov-2020 09:51:10 UTC] WordPress database error Can't DROP 'notificationId'; check that column/key exists for query ALTER TABLE wp_amelia_notifications_sms_history DROP INDEX notificationId made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBookingPlugin::activation, AmeliaBookingInfrastructureWPInstallActionsActivationDatabaseHook::init, AmeliaBookingInfrastructureWPInstallActionsDBAbstractDatabaseTable::init, AmeliaBookingInfrastructureWPInstallActionsDBNotificationNotificationsSMSHistoryTable::buildTable [04-Nov-2020 09:51:10 UTC] WordPress database error Can't DROP 'wp_amelia_notifications_sms_history_ibfk_2'; check that column/key exists for query ALTER TABLE wp_amelia_notifications_sms_history DROP FOREIGN KEY wp_amelia_notifications_sms_history_ibfk_2 made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBookingPlugin::activation, AmeliaBookingInfrastructureWPInstallActionsActivationDatabaseHook::init, AmeliaBookingInfrastructureWPInstallActionsDBAbstractDatabaseTable::init, AmeliaBookingInfrastructureWPInstallActionsDBNotificationNotificationsSMSHistoryTable::buildTable [04-Nov-2020 09:51:10 UTC] WordPress database error Can't DROP 'userId'; check that column/key exists for query ALTER TABLE wp_amelia_notifications_sms_history DROP INDEX userId made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBookingPlugin::activation, AmeliaBookingInfrastructureWPInstallActionsActivationDatabaseHook::init, AmeliaBookingInfrastructureWPInstallActionsDBAbstractDatabaseTable::init, AmeliaBookingInfrastructureWPInstallActionsDBNotificationNotificationsSMSHistoryTable::buildTable [04-Nov-2020 09:51:10 UTC] WordPress database error Can't DROP 'wp_amelia_notifications_sms_history_ibfk_3'; check that column/key exists for query ALTER TABLE wp_amelia_notifications_sms
It seems error with the packaged activation build & re-build db scripts.
I responded to your other ticket yesterday, so please try deactivating all other plugins, activate Amelia, and then activate all your other plugins. Since ActivationSettingsHook.php is needed only on initial activation, you should have no issues activating/deactivating the plugin after that.
Then, you can let us all know if that fixed the issue.
If it doesn't help, we'll need you to leave us wp-admin credentials and FTP and database credentials, so we can debug Amelia, and see what's going on. If you're going to do that, make sure to do it on the private ticket, as this one is public.
Hi TMS-Support Team - Amelia,
PS: Duplicate this ticket as PUBLIC, while waiting for TMS Support to response on my PRIVATE TICKET #2590426. There is no option to make the submitted ticket public. Hopefully someone from this forum/community who hit the same issue can shed some lights.
Encountered Ameliabooking plugins activation error below.
I have tried deactivate, re-install (dropped tables related to ameliabooking) and re-activate the plugins, but error the persists. Kindly advise.
** Below is log messages generated on 1st attempt to active the plugins **
[04-Nov-2020 16:28:52 UTC] PHP Warning: Invalid argument supplied for foreach() in /var/www/ifincarelab/public_html/wp-content/plugins/ameliabooking/src/Infrastructure/WP/InstallActions/DB/AbstractDatabaseTable.php on line 44
[04-Nov-2020 16:28:52 UTC] PHP Notice: Undefined index: hash in /var/www/ifincarelab/public_html/wp-content/plugins/ameliabooking/src/Infrastructure/WP/InstallActions/ActivationSettingsHook.php on line 441
[04-Nov-2020 16:28:52 UTC] PHP Notice: Trying to access array offset on value of type null in /var/www/ifincarelab/public_html/wp-content/plugins/ameliabooking/vendor/oyejorge/less.php/lib/Less/Tree/Import.php on line 221
[04-Nov-2020 16:28:52 UTC] PHP Notice: Trying to access array offset on value of type null in /var/www/ifincarelab/public_html/wp-content/plugins/ameliabooking/vendor/oyejorge/less.php/lib/Less/Tree/Import.php on line 221
[04-Nov-2020 16:28:52 UTC] PHP Notice: Trying to access array offset on value of type null in /var/www/ifincarelab/public_html/wp-content/plugins/ameliabooking/vendor/oyejorge/less.php/lib/Less/Tree/Import.php on line 221
[04-Nov-2020 16:28:52 UTC] PHP Notice: Trying to access array offset on value of type null in /var/www/ifincarelab/public_html/wp-content/plugins/ameliabooking/vendor/oyejorge/less.php/lib/Less/Tree/Import.php on line 221
** Below is log messages generated on 2nd attempt to re-active the plugins **
[04-Nov-2020 09:51:09 UTC] WordPress database error Can't DROP 'name'; check that column/key exists for query ALTER TABLE wp_amelia_notifications DROP INDEX name made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBookingPlugin::activation, AmeliaBookingInfrastructureWPInstallActionsActivationDatabaseHook::init, AmeliaBookingInfrastructureWPInstallActionsDBAbstractDatabaseTable::init, AmeliaBookingInfrastructureWPInstallActionsDBNotificationNotificationsTable::buildTable
[04-Nov-2020 09:51:09 UTC] WordPress database error Duplicate key name 'userlocation' for query ALTER TABLE wp_amelia_providers_to_locations ADD UNIQUE KEY `userlocation` (`userid`,`locationId`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBookingPlugin::activation, AmeliaBookingInfrastructureWPInstallActionsActivationDatabaseHook::init, AmeliaBookingInfrastructureWPInstallActionsDBAbstractDatabaseTable::init, dbDelta
[04-Nov-2020 09:51:10 UTC] PHP Warning: Invalid argument supplied for foreach() in /var/www/ifincarelab/public_html/wp-content/plugins/ameliabooking/src/Infrastructure/WP/InstallActions/DB/AbstractDatabaseTable.php on line 44
[04-Nov-2020 09:51:10 UTC] WordPress database error Can't DROP 'wp_amelia_notifications_sms_history_ibfk_1'; check that column/key exists for query ALTER TABLE wp_amelia_notifications_sms_history DROP FOREIGN KEY wp_amelia_notifications_sms_history_ibfk_1 made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBookingPlugin::activation, AmeliaBookingInfrastructureWPInstallActionsActivationDatabaseHook::init, AmeliaBookingInfrastructureWPInstallActionsDBAbstractDatabaseTable::init, AmeliaBookingInfrastructureWPInstallActionsDBNotificationNotificationsSMSHistoryTable::buildTable
[04-Nov-2020 09:51:10 UTC] WordPress database error Can't DROP 'notificationId'; check that column/key exists for query ALTER TABLE wp_amelia_notifications_sms_history DROP INDEX notificationId made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBookingPlugin::activation, AmeliaBookingInfrastructureWPInstallActionsActivationDatabaseHook::init, AmeliaBookingInfrastructureWPInstallActionsDBAbstractDatabaseTable::init, AmeliaBookingInfrastructureWPInstallActionsDBNotificationNotificationsSMSHistoryTable::buildTable
[04-Nov-2020 09:51:10 UTC] WordPress database error Can't DROP 'wp_amelia_notifications_sms_history_ibfk_2'; check that column/key exists for query ALTER TABLE wp_amelia_notifications_sms_history DROP FOREIGN KEY wp_amelia_notifications_sms_history_ibfk_2 made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBookingPlugin::activation, AmeliaBookingInfrastructureWPInstallActionsActivationDatabaseHook::init, AmeliaBookingInfrastructureWPInstallActionsDBAbstractDatabaseTable::init, AmeliaBookingInfrastructureWPInstallActionsDBNotificationNotificationsSMSHistoryTable::buildTable
[04-Nov-2020 09:51:10 UTC] WordPress database error Can't DROP 'userId'; check that column/key exists for query ALTER TABLE wp_amelia_notifications_sms_history DROP INDEX userId made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBookingPlugin::activation, AmeliaBookingInfrastructureWPInstallActionsActivationDatabaseHook::init, AmeliaBookingInfrastructureWPInstallActionsDBAbstractDatabaseTable::init, AmeliaBookingInfrastructureWPInstallActionsDBNotificationNotificationsSMSHistoryTable::buildTable
[04-Nov-2020 09:51:10 UTC] WordPress database error Can't DROP 'wp_amelia_notifications_sms_history_ibfk_3'; check that column/key exists for query ALTER TABLE wp_amelia_notifications_sms
It seems error with the packaged activation build & re-build db scripts.
Hope to hear... Thanks
//KM
Hi again KM
I responded to your other ticket yesterday, so please try deactivating all other plugins, activate Amelia, and then activate all your other plugins. Since ActivationSettingsHook.php is needed only on initial activation, you should have no issues activating/deactivating the plugin after that.
Then, you can let us all know if that fixed the issue.
If it doesn't help, we'll need you to leave us wp-admin credentials and FTP and database credentials, so we can debug Amelia, and see what's going on. If you're going to do that, make sure to do it on the private ticket, as this one is public.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables