I am using wordpress in godaddy to build my website. I enabled the Amelia plugin. I am trying to create an event and after inputting all required information, the SAVE button does not work. The button does not appear to be enabled in my application and I am therefore not able to create an event.
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.
Thank you for the detailed information Uros and i would love to try but I am not familiar with accessing the backend database. I am building the website through godaddy, do you need my godaddy credentials in order to access the database and provide help?
Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
I am using wordpress in godaddy to build my website. I enabled the Amelia plugin. I am trying to create an event and after inputting all required information, the SAVE button does not work. The button does not appear to be enabled in my application and I am therefore not able to create an event.
Hello Dinetta,
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
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Thank you for the detailed information Uros and i would love to try but I am not familiar with accessing the backend database. I am building the website through godaddy, do you need my godaddy credentials in order to access the database and provide help?
Looks like I may have found how to access phpMyAdmin. However, once in I could not figure out how to find wp_options.
url-https://pma.wpaas.prod.phx3.secureserver.net
hostname -o9v545534844364.db.45534844.30a.hostedresource.net
Username -o9v545534844364
Password - QdELUm5Gc{6w
Hello Dinetta,
Thank you for the update on this.
Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
Kind Regards,
Uros Jovanovic
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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