Hello Janis,

Thank you for reaching out to us.

Please check these points:

1. Are these services visible on the site? 

2. If they are, is the employee assigned to these services?

3. If he is, check his working hours. Working hours where services are defined in the intervals will only show the services defined in there. Make sure these two services are also included:

In the example above, the employee is assigned to 3 services, but 2 newly added services are not automatically assigned to the employee's working hours, even though they may be assigned to him/her in the Assigned Services tab. If you want the employee to work on all services that you have, you should clear this selection, and every new service will be added automatically.

4. Did you assign the employee to another location? If you did, please go to Amelia/Locations, and make sure that the location is visible.

5. Check the shortcode on the front-end - if you (for example) used [ameliabooking category=1], and you added the service to Category with ID: 2, the new service from category 2 will not appear in the front-end.

Hope this helps.

Hi, Janis

Sorry for the waiting time.

I found the issue, we have seen this before.

Let's first focus on the main issue with the appointments, and when we fix that, I will also check the Google Calendar connection for you.

Here is a screenshot of the error text, this is the most important part of the error :

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 "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.

But if you send me database access, please make sure to mark reply as Private.

Let me know how it goes. Thank you