System error.

The following error message was returned:

Unknown column 'c.private' in 'where clause'

Database is not currently up to date! Visit Tiki Installer to resolve this issue. If you have shell (SSH) access, you can also use the following, on the command line, from the root of your Tiki installation: php console.php database:update
Please note that the Tiki schema does not support downgrading the database. It can only perform upgrades. For more info, you may check the database status by opening the tiki-check page.

The query was:

select i.`calitemId` as `calitemId` from `tiki_calendar_items` as i left join `tiki_calendars` as c on i.`calendarId`=c.`calendarId` where ((i.`calendarId`=? or i.`calendarId`=? or i.`calendarId`=? or i.`calendarId`=?) and ((i.`start` > ? and i.`end` < ?) or (i.`start` < ? and i.`end` > ?)) and (c.`personal` != 'y' or (c.`personal`='y' and c.`private` = 'n' and i.`user`=?) or (c.`personal` = 'y' and c.`private` = 'y' and (i.`user` = ? or c.calendarId in (0))))) order by i.`start` asc,i.`calendarId` asc

Values:

  1. 1
  2. 9
  3. 3
  4. 2
  5. 1714368438
  6. 1745904438
  7. 1745904438
  8. 1714368438

The built query was likely:

select i.`calitemId` as `calitemId` from `tiki_calendar_items` as i left join `tiki_calendars` as c on i.`calendarId`=c.`calendarId` where ((i.`calendarId`='1' or i.`calendarId`='9' or i.`calendarId`='3' or i.`calendarId`='2') and ((i.`start` > '1714368438' and i.`end` < '1745904438') or (i.`start` < '1745904438' and i.`end` > '1714368438')) and (c.`personal` != 'y' or (c.`personal`='y' and c.`private` = 'n' and i.`user`='') or (c.`personal` = 'y' and c.`private` = 'y' and (i.`user` = '' or c.calendarId in (0))))) order by i.`start` asc,i.`calendarId` asc

Things to check:

  1. Is your database up and running?

  2. Is your database corrupt? Please see how to repair your database

  3. Are your database settings accurate? (username, schema name, etc in db/local.php)

  4. Did you complete the Tiki Installer?

Please see the documentation for more information.