I am trying to do the Google Calendar integration through the settings in Amelia. I went through the instructions given on the Amelia website to do this. First, I noticed the redirect URI does not match the correct domain name / url link, and there is no way to edit the field to reflect the correct domain. It's reflecting "http," and my site is "https." That's one problem. I notice that I can not complete my calendar set up because of this issue.
Second, I received a "Request failed with status code 500" the moment I click on the EMPLOYEE tab. Not sure why I am receiving that error.
The Amelia plug-in was manually updated as requested in an earlier ticket. Can someone please help with issue? My site is now live and I would like my booking setup to work correctly.
I am experiencing the same problem. The redirect address in Amelia settings is http (not https), which can not be changed. If I try to login to calendar I receive error 400: redirect_url_mismatch. However, when I change in the Google API the address to be httpS then it goes one step further on the sign in- process. Then it will give me error 403:access denied.
There are two ways to change the URI. One is by inspecting the page, and the other one is by going through the database.
1. Open Amelia Settings/Integrations/Google Calendar (or Outlook calendar; or both) and right click/inspect on the Redirect URI field. Then, modify the highlighted line and delete "readonly="readonly"". After that you will be able to change the URI right there, through settings.
That's it, just save the new settings.
2. More complicated method - You'll need to go into your database, but please be careful when you update the table, because if you delete or add anything else, it can cause the plugin not to work properly.
When you access your database via PHPMyAdmin (or some other tool), access wp_options table:
It is possible that your prefix is not "wp_", but something else, so if that is the case, please look for "your_prefix_options" table.
When you access it, you can search through the column "option_name". Search for the term "amelia_settings":
When you find that, you need to edit the property under "option_value" column and find the string "redirectURI". It will look something like this :
So, all you need to do is replace it with your new website's URI:
So basically you need to replace newsite.com with youroldsite.com and it will be shown in Google settings properly. Please note that if you use https you will need to update it also in redirectURI option. Please don't remove the escape characters ( \ ), it needs to stay in \/\/ format
When you're done with this, please check if the URL from “Redirect URI” field and on "Create OAuth client ID" section are the same:
As for the employee error (500), the employee probably has a few tokens that the plugin attempted to assign. You need to log into your database, and go to wp_amelia_providers_to_google_calendar table. Delete all rows from there, and that should resolve the issue.
Martin - the 403 error is coming from Google. The server understood the request, but is denying to follow it due to a security issue. You need to review our Google Calendar integration section, and push to production.
Thank for your reply. However, I am having a hard time understanding your solution for the 500 error when I click on the employee tab within the plugin. What database are talking about exactly?
I'm talking about the database of your website. It can't be navigated to from wp-admin dashboard.
Please provide me a temporary WP-admin login 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 party.
You can write credentials here just check Private Reply so nobody can see them except us.
I am trying to do the Google Calendar integration through the settings in Amelia. I went through the instructions given on the Amelia website to do this. First, I noticed the redirect URI does not match the correct domain name / url link, and there is no way to edit the field to reflect the correct domain. It's reflecting "http," and my site is "https." That's one problem. I notice that I can not complete my calendar set up because of this issue.
Second, I received a "Request failed with status code 500" the moment I click on the EMPLOYEE tab. Not sure why I am receiving that error.
The Amelia plug-in was manually updated as requested in an earlier ticket. Can someone please help with issue? My site is now live and I would like my booking setup to work correctly.
I am experiencing the same problem. The redirect address in Amelia settings is http (not https), which can not be changed. If I try to login to calendar I receive error 400: redirect_url_mismatch. However, when I change in the Google API the address to be httpS then it goes one step further on the sign in- process. Then it will give me error 403:access denied.
This is the second error after changing in the Google API the address in httpS
Hello Cheryl and Martin.
There are two ways to change the URI. One is by inspecting the page, and the other one is by going through the database.
1. Open Amelia Settings/Integrations/Google Calendar (or Outlook calendar; or both) and right click/inspect on the Redirect URI field. Then, modify the highlighted line and delete "readonly="readonly"". After that you will be able to change the URI right there, through settings.
That's it, just save the new settings.
2. More complicated method - You'll need to go into your database, but please be careful when you update the table, because if you delete or add anything else, it can cause the plugin not to work properly.
When you access your database via PHPMyAdmin (or some other tool), access wp_options table:
It is possible that your prefix is not "wp_", but something else, so if that is the case, please look for "your_prefix_options" table.
When you access it, you can search through the column "option_name". Search for the term "amelia_settings":
When you find that, you need to edit the property under "option_value" column and find the string "redirectURI". It will look something like this :
So, all you need to do is replace it with your new website's URI:
So basically you need to replace newsite.com with youroldsite.com and it will be shown in Google settings properly. Please note that if you use https you will need to update it also in redirectURI option. Please don't remove the escape characters ( \ ), it needs to stay in \/\/ format
When you're done with this, please check if the URL from “Redirect URI” field and on "Create OAuth client ID" section are the same:
As for the employee error (500), the employee probably has a few tokens that the plugin attempted to assign. You need to log into your database, and go to wp_amelia_providers_to_google_calendar table. Delete all rows from there, and that should resolve the issue.
Martin - the 403 error is coming from Google. The server understood the request, but is denying to follow it due to a security issue. You need to review our Google Calendar integration section, and push to production.
Kind Regards,
Aleksandar Vuković
[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
Hello Aleksander,
Thank for your reply. However, I am having a hard time understanding your solution for the 500 error when I click on the employee tab within the plugin. What database are talking about exactly?
I also receive an error message saying the employee's google calendar won't connect as well.
Hi again Cheryl
I'm talking about the database of your website. It can't be navigated to from wp-admin dashboard.
Please provide me a temporary WP-admin login 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 party.
You can write credentials here just check Private Reply so nobody can see them except us.
Kind Regards,
Aleksandar Vuković
[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