Menu Content

Support

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

Google Calender Sync Event Error: 1054
(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: Google Calender Sync Event Error: 1054

Google Calender Sync Event Error: 1054 5 years, 9 months ago #45462

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)

------------------------------------------------->
The topic has been locked.

Re: Google Calender Sync Event Error: 1054 5 years, 9 months ago #45508

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
Last Edit: 5 years, 9 months ago by alexrah.
The topic has been locked.

Re: Google Calender Sync Event Error: 1054 5 years, 7 months ago #45713

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

Re: Google Calender Sync Event Error: 1054 5 years, 4 months ago #45971

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

Re: Google Calender Sync Event Error: 1054 5 years, 4 months ago #45976

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