I'm not sure what is going on....Amelia was breaking my site again so I had to delete the plugin again and start over again. When I reloaded it, employees were missing and it says everything I click on is a premium feature. I purchased the basic edition, my purchase key is in. All my customers loaded but none of my employees! Please help me!!! I am trying to use this to run my business and it keeps breaking everything. Can I get someone to chat with me live?
Did you use the lite version before purchasing the paid version?
You need to download premium version form email that you get when you make this purchase(some hostings treat it like a Spam so please check your Spam folder as well). Also, you receive email with credentials for our store https://store.tms-plugins.com/login where you can download premium version.
My suggestion is to update the plugin manually by following these steps:
1.) Download zip from our store or from email that you receive when you make purchase
2.) Use FTP to open /yourwordpressfolder/wp-content/plugins
3.) Delete existing ameliabooking folder.
4.) Upload previously downloaded ameliabooking folder through FTP to plugins folder (unzip it)
5.) Go to WP-admin panel, open Plugins section.
6.) Deactivate Amelia Plugin, and then activate it again.
If you are using hosting where you are not allowed to your FTP then follow those instructions:
1.) Download zip from our store or from email that you receive when you make purchase
2.) Delete Amelia plugin from WordPress Plugins page
3) Click on Add new on Plugins page
4) Click on Upload plugin on Plugins page
5.) Choose previously downloaded ameliabooking zip file
6.) When uploading is done, please Activate Amelia plugin
7.) Clear server and browser cache.
Please note that deleting plugin from Plugins page you WILL NOT lose your data, because it is already saved in database.
Please note that our plugin have size around 6 MB so if yo are not able to upload plugin through WordPress plugins page, then you need to increase
upload_max_file size,
post_max_size ,
max_execution_time
You should be able to find these values in your php.ini file or on your hosting panel. If you can't find it yourself please ask your hosting provider to provide it.
I contacted wordpress for my error log, this is it:
07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FOREIGN KEY (serviceId) REFERENCES wp_amelia_services(id) ON DELETE CASCADE' at line 1 for query ALTER TABLE wp_amelia_providers_to_services ADD COLUMN FOREIGN KEY (serviceId) REFERENCES wp_amelia_services(id) ON DELETE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FOREIGN KEY (`serviceId`) REFERENCES wp_amelia_services(`id`) ON DELETE CASCADE' at line 1 for query ALTER TABLE wp_amelia_extras ADD COLUMN FOREIGN KEY (`serviceId`) REFERENCES wp_amelia_services(`id`) ON DELETE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT FOREIGN KEY (`providerId`) REFERENCES wp_amelia_users(`id`)' at line 1 for query ALTER TABLE wp_amelia_appointments ADD COLUMN CONSTRAINT FOREIGN KEY (`providerId`) REFERENCES wp_amelia_users(`id`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DELETE CASCADE ON UPDATE CASCADE' at line 1 for query ALTER TABLE wp_amelia_appointments ADD COLUMN ON DELETE CASCADE ON UPDATE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT FOREIGN KEY (`parentId`) REFERENCES wp_amelia_events(`id`)' at line 1 for query ALTER TABLE wp_amelia_events ADD COLUMN CONSTRAINT FOREIGN KEY (`parentId`) REFERENCES wp_amelia_events(`id`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DELETE SET NULL' at line 1 for query ALTER TABLE wp_amelia_events ADD COLUMN ON DELETE SET NULL made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT FOREIGN KEY (`eventId`) REFERENCES wp_amelia_events(`id`)' at line 1 for query ALTER TABLE wp_amelia_events_tags ADD COLUMN CONSTRAINT FOREIGN KEY (`eventId`) REFERENCES wp_amelia_events(`id`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DELETE CASCADE ON UPDATE CASCADE' at line 1 for query ALTER TABLE wp_amelia_events_tags ADD COLUMN ON DELETE CASCADE ON UPDATE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT FOREIGN KEY (`eventId`) REFERENCES wp_amelia_events(`id`)' at line 1 for query ALTER TABLE wp_amelia_events_periods ADD COLUMN CONSTRAINT FOREIGN KEY (`eventId`) REFERENCES wp_amelia_events(`id`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DELETE CASCADE ON UPDATE CASCADE' at line 1 for query ALTER TABLE wp_amelia_events_periods ADD COLUMN ON DELETE CASCADE ON UPDATE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT FOREIGN KEY (`userId`) REFERENCES wp_amelia_users(`id`)' at line 1 for query ALTER TABLE wp_amelia_events_to_providers ADD COLUMN CONSTRAINT FOREIGN KEY (`userId`) REFERENCES wp_amelia_users(`id`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DELETE CASCADE ON UPDATE CASCADE' at line 1 for query ALTER TABLE wp_amelia_events_to_providers ADD COLUMN ON DELETE CASCADE ON UPDATE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FOREIGN KEY (`eventId`) REFERENCES wp_amelia_events(`id`)' at line1 for query ALTER TABLE wp_amelia_coupons_to_events ADD COLUMN FOREIGN KEY (`eventId`) REFERENCES wp_amelia_events(`id`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DELETE CASCADE ON UPDATE CASCADE' at line 1 for query ALTER TABLE wp_amelia_coupons_to_events ADD COLUMN ON DELETE CASCADE ON UPDATE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FOREIGN KEY (eventId) REFERENCES wp_amelia_events(id) ON DELETE CASCADE' at line 1 for query ALTER TABLE wp_amelia_providers_to_events ADD COLUMN FOREIGN KEY (eventId) REFERENCES wp_amelia_events(id) ON DELETE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT FOREIGN KEY (`couponId`) REFERENCES wp_amelia_coupons(`id`)' at line 1 for query ALTER TABLE wp_amelia_customer_bookings ADD COLUMN CONSTRAINT FOREIGN KEY (`couponId`) REFERENCES wp_amelia_coupons(`id`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DELETE SET NULL' at line 1 for query ALTER TABLE wp_amelia_customer_bookings ADD COLUMN ON DELETE SET NULL made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT' at line 1 for query ALTER TABLE wp_amelia_customer_bookings_to_extras ADD COLUMN CONSTRAINT made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FOREIGN KEY (`extraId`) REFERENCES wp_amelia_extras(`id`)' at line1 for query ALTER TABLE wp_amelia_customer_bookings_to_extras ADD COLUMN FOREIGN KEY (`extraId`) REFERENCES wp_amelia_extras(`id`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DELETE CASCADE ON UPDATE CASCADE' at line 1 for query ALTER TABLE wp_amelia_customer_bookings_to_extras ADD COLUMN ON DELETE CASCADE ON UPDATE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT `wp_amelia_c_b_t_e_p_ibfk_2` FOREIGN KEY (`eventPeriodId`) REFERENCES' at line 1 for query ALTER TABLE wp_amelia_customer_bookings_to_events_periods ADD COLUMN CONSTRAINT `wp_amelia_c_b_t_e_p_ibfk_2` FOREIGN KEY (`eventPeriodId`) REFERENCES wp_amelia_events_periods(`id`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DELETE CASCADE ON UPDATE CASCADE' at line 1 for query ALTER TABLE wp_amelia_customer_bookings_to_events_periods ADD COLUMN ON DELETE CASCADE ON UPDATE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT FOREIGN KEY (`customerBookingId`) REFERENCES wp_amelia_customer_booki' at line 1 for query ALTER TABLE wp_amelia_payments ADD COLUMN CONSTRAINT FOREIGN KEY (`customerBookingId`) REFERENCES wp_amelia_customer_bookings(`id`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DELETE CASCADE' at line 1 for query ALTER TABLE wp_amelia_payments ADD COLUMN ON DELETE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FOREIGN KEY (locationId) REFERENCES wp_amelia_locations(id) ON DELETE CASCADE' at line 1 for query ALTER TABLE wp_amelia_locations_views ADD COLUMN FOREIGN KEY (locationId) REFERENCES wp_amelia_locations(id) ON DELETE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT FOREIGN KEY (`eventId`) REFERENCES wp_amelia_events(`id`)' at line 1 for query ALTER TABLE wp_amelia_notifications_log ADD COLUMN CONSTRAINT FOREIGN KEY (`eventId`) REFERENCES wp_amelia_events(`id`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DELETE CASCADE ON UPDATE CASCADE' at line 1 for query ALTER TABLE wp_amelia_notifications_log ADD COLUMN ON DELETE CASCADE ON UPDATE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error Can't DROP FOREIGN KEY `wp_amelia_notifications_sms_history_ibfk_1`; check that it 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,AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\Notification\NotificationsSMSHistoryTable::buildTable [07-Sep-2019 01:20:01 UTC] WordPress database error Can't DROP INDEX `notificationId`; check that it 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, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\Notification\NotificationsSMSHistoryTable::buildTable [07-Sep-2019 01:20:01 UTC] WordPress database error Can't DROP FOREIGN KEY `wp_amelia_notifications_sms_history_ibfk_2`; check that it 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,AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\Notification\NotificationsSMSHistoryTable::buildTable [07-Sep-2019 01:20:01 UTC] WordPress database error Can't DROP INDEX `userId`; check that it 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, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\Notification\NotificationsSMSHistoryTable::buildTable [07-Sep-2019 01:20:01 UTC] WordPress database error Can't DROP FOREIGN KEY `wp_amelia_notifications_sms_history_ibfk_3`; check that it exists for query ALTER TABLE wp_amelia_notifications_sms_history DROP FOREIGN KEY wp_amelia_notifications_sms_history_ibfk_3 made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters,AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\Notification\NotificationsSMSHistoryTable::buildTable [07-Sep-2019 01:20:01 UTC] WordPress database error Can't DROP INDEX `appointmentId`; check that it exists for query ALTER TABLE wp_amelia_notifications_sms_history DROP INDEX appointmentId made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\Notification\NotificationsSMSHistoryTable::buildTable [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FOREIGN KEY (customFieldId) REFERENCES wp_amelia_custom_fields(id)ON DELETE CAS' at line 1 for query ALTER TABLE wp_amelia_custom_fields_options ADD COLUMN FOREIGN KEY (customFieldId) REFERENCES wp_amelia_custom_fields(id) ON DELETE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FOREIGN KEY (`serviceId`) REFERENCES wp_amelia_services(id) ON DELETE CASCADE' at line 1 for query ALTER TABLE wp_amelia_custom_fields_services ADD COLUMN FOREIGN KEY (`serviceId`) REFERENCES wp_amelia_services(id) ON DELETE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta [07-Sep-2019 01:21:05 UTC] PHP Warning: Invalid argument supplied for foreach() in /wordpress/core/5.2.3/wp-includes/rest-api/endpoints/class-wp-rest-controller.php on line 287 [07-Sep-2019 01:21:05 UTC] PHP Warning: Invalid argument supplied for foreach() in /wordpress/core/5.2.3/wp-includes/rest-api/endpoints/class-wp-rest-controller.php on line 287
Like I said on your other ticket, I will install the latest plugin on your site and I will take a look at those relations with the tables as I can see from the error log.
I have uninstalled and reinstalled per instructions several times and it still isn't working. I received a response on the other ticket as well so I will send my credentials there so that you can login
I'm not sure what is going on....Amelia was breaking my site again so I had to delete the plugin again and start over again. When I reloaded it, employees were missing and it says everything I click on is a premium feature. I purchased the basic edition, my purchase key is in. All my customers loaded but none of my employees! Please help me!!! I am trying to use this to run my business and it keeps breaking everything. Can I get someone to chat with me live?
Hi Michelle,
Thank you for your purchase,
Unfortunately we do not have live chat support.
Did you use the lite version before purchasing the paid version?
You need to download premium version form email that you get when you make this purchase(some hostings treat it like a Spam so please check your Spam folder as well). Also, you receive email with credentials for our store https://store.tms-plugins.com/login where you can download premium version.
My suggestion is to update the plugin manually by following these steps:
1.) Download zip from our store or from email that you receive when you make purchase
2.) Use FTP to open /yourwordpressfolder/wp-content/plugins
3.) Delete existing ameliabooking folder.
4.) Upload previously downloaded ameliabooking folder through FTP to plugins folder (unzip it)
5.) Go to WP-admin panel, open Plugins section.
6.) Deactivate Amelia Plugin, and then activate it again.
7.) Clear server and browser cache
____________________________________________________________________________________________
If you are using hosting where you are not allowed to your FTP then follow those instructions:
1.) Download zip from our store or from email that you receive when you make purchase
2.) Delete Amelia plugin from WordPress Plugins page
3) Click on Add new on Plugins page
4) Click on Upload plugin on Plugins page
5.) Choose previously downloaded ameliabooking zip file
6.) When uploading is done, please Activate Amelia plugin
7.) Clear server and browser cache.
Please note that deleting plugin from Plugins page you WILL NOT lose your data, because it is already saved in database.
Please note that our plugin have size around 6 MB so if yo are not able to upload plugin through WordPress plugins page, then you need to increase
upload_max_file size,
post_max_size ,
max_execution_time
You should be able to find these values in your php.ini file or on your hosting panel. If you can't find it yourself please ask your hosting provider to provide it.
Best regards.
Kind Regards,
Miloš Jovanović
[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
I really need someone from support to help me on these tickets.
I contacted wordpress for my error log, this is it:
07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FOREIGN KEY (serviceId) REFERENCES wp_amelia_services(id) ON DELETE CASCADE' at line 1 for query ALTER TABLE wp_amelia_providers_to_services ADD COLUMN FOREIGN KEY (serviceId) REFERENCES wp_amelia_services(id) ON DELETE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FOREIGN KEY (`serviceId`) REFERENCES wp_amelia_services(`id`) ON DELETE CASCADE' at line 1 for query ALTER TABLE wp_amelia_extras ADD COLUMN FOREIGN KEY (`serviceId`) REFERENCES wp_amelia_services(`id`) ON DELETE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT FOREIGN KEY (`providerId`) REFERENCES wp_amelia_users(`id`)' at line 1 for query ALTER TABLE wp_amelia_appointments ADD COLUMN CONSTRAINT FOREIGN KEY (`providerId`) REFERENCES wp_amelia_users(`id`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DELETE CASCADE ON UPDATE CASCADE' at line 1 for query ALTER TABLE wp_amelia_appointments ADD COLUMN ON DELETE CASCADE ON UPDATE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT FOREIGN KEY (`parentId`) REFERENCES wp_amelia_events(`id`)' at line 1 for query ALTER TABLE wp_amelia_events ADD COLUMN CONSTRAINT FOREIGN KEY (`parentId`) REFERENCES wp_amelia_events(`id`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DELETE SET NULL' at line 1 for query ALTER TABLE wp_amelia_events ADD COLUMN ON DELETE SET NULL made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT FOREIGN KEY (`eventId`) REFERENCES wp_amelia_events(`id`)' at line 1 for query ALTER TABLE wp_amelia_events_tags ADD COLUMN CONSTRAINT FOREIGN KEY (`eventId`) REFERENCES wp_amelia_events(`id`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DELETE CASCADE ON UPDATE CASCADE' at line 1 for query ALTER TABLE wp_amelia_events_tags ADD COLUMN ON DELETE CASCADE ON UPDATE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT FOREIGN KEY (`eventId`) REFERENCES wp_amelia_events(`id`)' at line 1 for query ALTER TABLE wp_amelia_events_periods ADD COLUMN CONSTRAINT FOREIGN KEY (`eventId`) REFERENCES wp_amelia_events(`id`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DELETE CASCADE ON UPDATE CASCADE' at line 1 for query ALTER TABLE wp_amelia_events_periods ADD COLUMN ON DELETE CASCADE ON UPDATE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT FOREIGN KEY (`userId`) REFERENCES wp_amelia_users(`id`)' at line 1 for query ALTER TABLE wp_amelia_events_to_providers ADD COLUMN CONSTRAINT FOREIGN KEY (`userId`) REFERENCES wp_amelia_users(`id`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DELETE CASCADE ON UPDATE CASCADE' at line 1 for query ALTER TABLE wp_amelia_events_to_providers ADD COLUMN ON DELETE CASCADE ON UPDATE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FOREIGN KEY (`eventId`) REFERENCES wp_amelia_events(`id`)' at line1 for query ALTER TABLE wp_amelia_coupons_to_events ADD COLUMN FOREIGN KEY (`eventId`) REFERENCES wp_amelia_events(`id`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DELETE CASCADE ON UPDATE CASCADE' at line 1 for query ALTER TABLE wp_amelia_coupons_to_events ADD COLUMN ON DELETE CASCADE ON UPDATE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FOREIGN KEY (eventId) REFERENCES wp_amelia_events(id) ON DELETE CASCADE' at line 1 for query ALTER TABLE wp_amelia_providers_to_events ADD COLUMN FOREIGN KEY (eventId) REFERENCES wp_amelia_events(id) ON DELETE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT FOREIGN KEY (`couponId`) REFERENCES wp_amelia_coupons(`id`)' at line 1 for query ALTER TABLE wp_amelia_customer_bookings ADD COLUMN CONSTRAINT FOREIGN KEY (`couponId`) REFERENCES wp_amelia_coupons(`id`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DELETE SET NULL' at line 1 for query ALTER TABLE wp_amelia_customer_bookings ADD COLUMN ON DELETE SET NULL made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT' at line 1 for query ALTER TABLE wp_amelia_customer_bookings_to_extras ADD COLUMN CONSTRAINT made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FOREIGN KEY (`extraId`) REFERENCES wp_amelia_extras(`id`)' at line1 for query ALTER TABLE wp_amelia_customer_bookings_to_extras ADD COLUMN FOREIGN KEY (`extraId`) REFERENCES wp_amelia_extras(`id`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DELETE CASCADE ON UPDATE CASCADE' at line 1 for query ALTER TABLE wp_amelia_customer_bookings_to_extras ADD COLUMN ON DELETE CASCADE ON UPDATE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT `wp_amelia_c_b_t_e_p_ibfk_2` FOREIGN KEY (`eventPeriodId`) REFERENCES' at line 1 for query ALTER TABLE wp_amelia_customer_bookings_to_events_periods ADD COLUMN CONSTRAINT `wp_amelia_c_b_t_e_p_ibfk_2` FOREIGN KEY (`eventPeriodId`) REFERENCES wp_amelia_events_periods(`id`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DELETE CASCADE ON UPDATE CASCADE' at line 1 for query ALTER TABLE wp_amelia_customer_bookings_to_events_periods ADD COLUMN ON DELETE CASCADE ON UPDATE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT FOREIGN KEY (`customerBookingId`) REFERENCES wp_amelia_customer_booki' at line 1 for query ALTER TABLE wp_amelia_payments ADD COLUMN CONSTRAINT FOREIGN KEY (`customerBookingId`) REFERENCES wp_amelia_customer_bookings(`id`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DELETE CASCADE' at line 1 for query ALTER TABLE wp_amelia_payments ADD COLUMN ON DELETE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FOREIGN KEY (locationId) REFERENCES wp_amelia_locations(id) ON DELETE CASCADE' at line 1 for query ALTER TABLE wp_amelia_locations_views ADD COLUMN FOREIGN KEY (locationId) REFERENCES wp_amelia_locations(id) ON DELETE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT FOREIGN KEY (`eventId`) REFERENCES wp_amelia_events(`id`)' at line 1 for query ALTER TABLE wp_amelia_notifications_log ADD COLUMN CONSTRAINT FOREIGN KEY (`eventId`) REFERENCES wp_amelia_events(`id`) made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON DELETE CASCADE ON UPDATE CASCADE' at line 1 for query ALTER TABLE wp_amelia_notifications_log ADD COLUMN ON DELETE CASCADE ON UPDATE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error Can't DROP FOREIGN KEY `wp_amelia_notifications_sms_history_ibfk_1`; check that it 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,AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\Notification\NotificationsSMSHistoryTable::buildTable
[07-Sep-2019 01:20:01 UTC] WordPress database error Can't DROP INDEX `notificationId`; check that it 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, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\Notification\NotificationsSMSHistoryTable::buildTable
[07-Sep-2019 01:20:01 UTC] WordPress database error Can't DROP FOREIGN KEY `wp_amelia_notifications_sms_history_ibfk_2`; check that it 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,AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\Notification\NotificationsSMSHistoryTable::buildTable
[07-Sep-2019 01:20:01 UTC] WordPress database error Can't DROP INDEX `userId`; check that it 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, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\Notification\NotificationsSMSHistoryTable::buildTable
[07-Sep-2019 01:20:01 UTC] WordPress database error Can't DROP FOREIGN KEY `wp_amelia_notifications_sms_history_ibfk_3`; check that it exists for query ALTER TABLE wp_amelia_notifications_sms_history DROP FOREIGN KEY wp_amelia_notifications_sms_history_ibfk_3 made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters,AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\Notification\NotificationsSMSHistoryTable::buildTable
[07-Sep-2019 01:20:01 UTC] WordPress database error Can't DROP INDEX `appointmentId`; check that it exists for query ALTER TABLE wp_amelia_notifications_sms_history DROP INDEX appointmentId made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\Notification\NotificationsSMSHistoryTable::buildTable
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FOREIGN KEY (customFieldId) REFERENCES wp_amelia_custom_fields(id)ON DELETE CAS' at line 1 for query ALTER TABLE wp_amelia_custom_fields_options ADD COLUMN FOREIGN KEY (customFieldId) REFERENCES wp_amelia_custom_fields(id) ON DELETE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:20:01 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FOREIGN KEY (`serviceId`) REFERENCES wp_amelia_services(id) ON DELETE CASCADE' at line 1 for query ALTER TABLE wp_amelia_custom_fields_services ADD COLUMN FOREIGN KEY (`serviceId`) REFERENCES wp_amelia_services(id) ON DELETE CASCADE made by activate_plugin, do_action('activate_ameliabooking/ameliabooking.php'), WP_Hook->do_action, WP_Hook->apply_filters, AmeliaBooking\Plugin::activation, AmeliaBooking\Infrastructure\WP\InstallActions\ActivationDatabaseHook::init, AmeliaBooking\Infrastructure\WP\InstallActions\DB\AbstractDatabaseTable::init, dbDelta
[07-Sep-2019 01:21:05 UTC] PHP Warning: Invalid argument supplied for foreach() in /wordpress/core/5.2.3/wp-includes/rest-api/endpoints/class-wp-rest-controller.php on line 287
[07-Sep-2019 01:21:05 UTC] PHP Warning: Invalid argument supplied for foreach() in /wordpress/core/5.2.3/wp-includes/rest-api/endpoints/class-wp-rest-controller.php on line 287
I also can't access the ftp files because I have wordpress.com business account. I really need someone to respond to me and help me fix these issues.
Hi Michelle,
Like I said on your other ticket, I will install the latest plugin on your site and I will take a look at those relations with the tables as I can see from the error log.
Best regards.
Kind Regards,
Miloš Jovanović
[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
I have uninstalled and reinstalled per instructions several times and it still isn't working. I received a response on the other ticket as well so I will send my credentials there so that you can login