Our events take place Every Saturday and Sunday 14:00-15:00, there is 1 host, and 13 people can attend.
I made an event, and set it for June 1 14:00-15:00 and June 2 14:00-15:00, I set the event to reoccur 1 time a week through the end of August.
But when it was finished, it showed me only June 1, June 3 and June 8. These are random dates and not what I wanted. BUT when I put the code in and look at the front end, it does show dates through August.
I tried to re-enter the event, I tried making a new event, I tried clearing my cache. Half way through my many trials, it started to not load, and it freezes on "Please Wait" until I close the window (I literally waited all night).
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,
I am trying to set up reoccurring events.
Our events take place Every Saturday and Sunday 14:00-15:00, there is 1 host, and 13 people can attend.
I made an event, and set it for June 1 14:00-15:00 and June 2 14:00-15:00, I set the event to reoccur 1 time a week through the end of August.
But when it was finished, it showed me only June 1, June 3 and June 8. These are random dates and not what I wanted. BUT when I put the code in and look at the front end, it does show dates through August.
I tried to re-enter the event, I tried making a new event, I tried clearing my cache. Half way through my many trials, it started to not load, and it freezes on "Please Wait" until I close the window (I literally waited all night).
Screen shot attached.
Please help!
Thank you,
Pavia
Attached files: Screen Shot 2024-05-28 at 11.42.05 AM.png
Hello Pavia,
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