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

letracka year 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 Tananaeva year ago

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

hageethr2 months ago

Hi letrack,
Where you able to solve the issue?