Hi all,

i would try to use the connection to google calendar but i'm not able to get it work.
What i did so far:

1. Register at cloud.google.com/console
2. turn on access to calendar api
3. create a new project
4. in Joomla: Fill out google client_id and secret.

When i try to load the google calendars to Joomla, i got the error "redirect_uri_mismatch".

For sure, i can add the REDIRECT URI to my google project, but the parameters are not stored. Instead of

<website>/administrator/index.php?option=com_booking&task=google.authenticate

i can only store

<website>/administrator/index.php?option=com_booking

It seems, google is checking the whole String. When i remove the task parameter in the google URL, i'm able to get access to my calendar.

Is there any solution to fix that issue?

I'm using Book IT 2 - Version 2.2.2.

I was able to enter the redirect URI with the "Client ID for web applications" settings, but was then confronted with a "1054 - An error has occurred" when clicking on the "synchronize events" button.

I had entered the supplied client ID and client secret supplied on the API Project - API Access console, into the sections under the "Options", then "google" tab. The error is below and heads up to where I can find the documentation for this new feature would be appreciated.

1054 - An error has occurred.

Unknown column 'g.modified' in 'where clause' SQL=SELECT i.id, i.subject_title, i.from, i.to, i.google_calendar_id, r.title_before, r.firstname, r.middlename, r.surname, r.title_after, r.company, r.street, r.city, r.country, r.zip, r.email, r.telephone, s.google_calendar FROM j25_booking_reservation_items AS i JOIN j25_booking_reservation AS r ON r.id = i.reservation_id LEFT JOIN j25_booking_subject AS s ON i.subject = s.id LEFT JOIN j25_booking_google_calendar AS g ON g.id = s.google_calendar WHERE (i.google_calendar_id = '' AND r.state = 1) OR (i.google_calendar_id <> '' AND g.id IS NOT NULL AND r.modified > g.modified)

I am using joomla 2.5.14 and bookit2 2.2.2

Hello

had the same problem, for an uknown reason table booking_google_calendar misses field modified, so create such a field and you are ok.

Thanks!! It worked!!

Fewo: Try highlighting the URI in the API Access Console, copying and then pasting into the "redirect URI" area in the edit settings. This worked for me.

Hello!
Having problems to connect to Google Calendar… how do I create the missing field in table booking_google_calendar that user "ahapsas" tell us to do - I only have basic knowledge of MySQL, usually find a detailed instruction for needed tasks, but not for this. Please help.