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

letrack2 years 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 Tananaev2 years ago

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

hageethr8 months ago

Hi letrack,
Where you able to solve the issue?