Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

Problem connecting with google calendar
(1 viewing) (1) Guest
Support forum for users using free edition of Book it!. These forums are for mutual help among users.

NOTE: Due to our capacity limitations, ARTIO does not monitor this forum category regularly. If you want direct support from ARTIO, please start a ticket at Support Dashboard. If you have no support ticket available, you need to purchase it. .
  • Page:
  • 1

TOPIC: Problem connecting with google calendar

Problem connecting with google calendar 10 years, 5 months ago #41511

  • fewo
  • OFFLINE
  • Posts: 3
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.
The topic has been locked.

Re: Problem connecting with google calendar 10 years, 4 months ago #41562

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
The topic has been locked.

Re: Problem connecting with google calendar 10 years, 4 months ago #41565

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.
The topic has been locked.

Re: Problem connecting with google calendar 10 years, 4 months ago #41568

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.
Last Edit: 10 years, 4 months ago by Kuniyo.
The topic has been locked.

Re: Problem connecting with google calendar 10 years, 2 months ago #42243

  • msd
  • OFFLINE
  • Posts: 1
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.
The topic has been locked.
  • Page:
  • 1
User Login Empty