Error - Unknown column 'calendarId' in 'field list' - SQLSyntaxErrorException

letrack10 months ago

After to restore a server in other virtual machine, I download the database, restore and when I run the application and save a device, I am getting this error:

Unknown column 'calendarId' in 'field list' - SQLSyntaxErrorException (... < QueryBuilder:469 < DatabaseStorage:115 < BaseObjectResource:103 < ...)

I can't see details in log.

In another piece of log, I got a WARN:

2024-03-09 16:18:50  WARN: Failed to store position - Unknown column 'geofenceIds' in 'field list' - SQLSyntaxErrorException (... < QueryBuilder:469 < DatabaseStorage:95 < DefaultDataHandler:47 < ...)
Anton Tananaev10 months ago

It means your database schema is not correct. Usually it happens when you don't upgrade correctly.

hageethr2 days ago

Hi letrack,
Where you able to solve the issue?