Menu Content

Support

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

Profile for alexrah

  • OFFLINE
  • Time Zone: GMT +0:00
  • Local Time: 04:26
  • Posts: 1
  • Profile Views: 2308
  • Location: Unknown
  • Gender: Unknown
  • Birthdate: Unknown

Signature

Posts

Posts

emo
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
Google Calender Sync ...
Category: Community Support
More
User Login Empty