This usually happens when your database is configured to use SQL_BIG_SELECTS, but Amelia has that turned off by default because the majority of databases don't use it.
If you know your way around the database, you can enable this yourself by going into the wp_options database table (wp_ is the default database prefix, but it could be anything on your end):
In there, click on SEARCH at the top, and in the "option_name" column search for "amelia_settings":
The search will return only one row, and you need to edit it:
In the "option_value" column, search for "pdoBigSelect":
It is currently set to false, as you can see in the screenshot above, so just change that to true, save the settings, and try editing the event again.
If that fails, or if you're not familiar with phpMyAdmin, please provide us with a temporary wp-admin (administrator) user for your website, along with the database access credentials (phpMyAdmin or cPanel), and I'll gladly take a look.
Hello Arnal,
Thank you for reaching out to us.
This usually happens when your database is configured to use SQL_BIG_SELECTS, but Amelia has that turned off by default because the majority of databases don't use it.
If you know your way around the database, you can enable this yourself by going into the wp_options database table (wp_ is the default database prefix, but it could be anything on your end):
In there, click on SEARCH at the top, and in the "option_name" column search for "amelia_settings":
The search will return only one row, and you need to edit it:
In the "option_value" column, search for "pdoBigSelect":
It is currently set to false, as you can see in the screenshot above, so just change that to true, save the settings, and try editing the event again.
If that fails, or if you're not familiar with phpMyAdmin, please provide us with a temporary wp-admin (administrator) user for your website, along with the database access credentials (phpMyAdmin or cPanel), and I'll gladly take a look.
Kind Regards,
Uros Jovanovic
[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