After getting the google calender set up and Loading the Calenders I am receiving the below error when I try and Sync Events. This error seems to occur even with other calenders.

Any help is greatly appreciated.


----------------------------------------------------------<
1054 - An error has occurred.

Unknown column 'p.google_calendar_id' in 'field list' SQL=SELECT COALESCE(p.id,i.id) AS id, i.rtype, i.subject_title, COALESCE(p.from,i.from) AS `from`, COALESCE(p.to,i.to) AS `to`, COALESCE(p.google_calendar_id,i.google_calendar_id) AS 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, r.state, r.modified AS rmodified, g.id AS gid, g.modified AS gmodified, s.google_calendar FROM rzlj8_booking_reservation_items AS i JOIN rzlj8_booking_reservation AS r ON r.id = i.reservation_id LEFT JOIN rzlj8_booking_subject AS s ON i.subject = s.id LEFT JOIN rzlj8_booking_google_calendar AS g ON g.id = s.google_calendar LEFT JOIN rzlj8_booking_reservation_period AS p ON p.reservation_item_id = i.id HAVING (google_calendar_id = '' AND state = 1) OR (google_calendar_id <> '' AND gid IS NOT NULL AND rmodified > gmodified)

------------------------------------------------->

Hi, Im having the same problem:

1054 Unknown column 'p.google_calendar_id' in 'field list' SQL=SELECT COALESCE(p.id,i.id) AS id, i.rtype, i.subject_title, COALESCE(p.from,i.from) AS `from`, COALESCE(p.to,i.to) AS `to`, COALESCE(p.google_calendar_id,i.google_calendar_id) AS 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, r.state, r.modified AS rmodified, g.id AS gid, g.modified AS gmodified, s.google_calendar FROM s13us_booking_reservation_items AS i JOIN s13us_booking_reservation AS r ON r.id = i.reservation_id LEFT JOIN s13us_booking_subject AS s ON i.subject = s.id LEFT JOIN s13us_booking_google_calendar AS g ON g.id = s.google_calendar LEFT JOIN s13us_booking_reservation_period AS p ON p.reservation_item_id = i.id HAVING (google_calendar_id = '' AND state = 1) OR (google_calendar_id <> '' AND gid IS NOT NULL AND rmodified > gmodified)

I tried a couple of things before posting here:

1) the table affected is "s13us_booking_google_calendar" which has 3 fields: 'id', 'title', 'modified' but NOT 'google_calendar_id'

2) seems that the value required by 'google_calendar_id' has been stored in 'id'.

3) trying creating the 'google_calendar_id' field and re-updating calendars still doesn't populate it.

4) trying to manually add the field and then add the value doesnt work either

5) trying to rename 'id' field to 'google_calendar_id' return error about missing column 'id'

then I posted here....
Help would be greatly appreciated!
Regards

Joomla! Version Joomla! 3.2.4 Stable [ Ember ] 30-April-2014 14:00 GMT
ARTIO Booking Version: 2.3.0

Hi Guys

Any news on this error? I'd like to license the plugin but without getting this to work I really have no further interest. :(

Here my error:
1054 Unknown column 'p.google_calendar_id' in 'field list' SQL=SELECT COALESCE(p.id,i.id) AS id, i.rtype, i.subject_title, COALESCE(p.from,i.from) AS `from`, COALESCE(p.to,i.to) AS `to`, COALESCE(p.google_calendar_id,i.google_calendar_id) AS 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, r.state, r.modified AS rmodified, g.id AS gid, g.modified AS gmodified, s.google_calendar FROM gdc0z_booking_reservation_items AS i JOIN gdc0z_booking_reservation AS r ON r.id = i.reservation_id LEFT JOIN gdc0z_booking_subject AS s ON i.subject = s.id LEFT JOIN gdc0z_booking_google_calendar AS g ON g.id = s.google_calendar LEFT JOIN gdc0z_booking_reservation_period AS p ON p.reservation_item_id = i.id HAVING (google_calendar_id = '' AND state = 1) OR (google_calendar_id <> '' AND gid IS NOT NULL AND rmodified > gmodified)


The load event went through perfect, but its not synching.

Thanks!
xeno

Maybe too late, but this is what I did today to make it work. Add a field in the MYSQL period table:

google_calendar_id VARCHAR 254 default: NULL

the fields itself is of no use for me, but being present in the table did the trick for making the query work

Thanks for the help Peterg. did as you said and added google_calendar_id VARCHAR 254 default: NULL as a new line to the booking_reservation_period table and all was working great.

Thanks so much for the clarification, and the solution to the issue.