Unknown column 'twelveHourFormat' in 'field list'

Christian Vidal Martinez5 months ago

Hi.

I have updated to 6.2 then decided to move back to 5.9, reason, the units seem in the same place, but they are moving checking the position history.

Once I back to 5.9 and 5.10 this error appears every time that I want to add new user or modify preferences.

Can you please help me with this issue:

Unknown column 'twelveHourFormat' in 'field list' - SQLSyntaxErrorException (... < QueryBuilder:469 < DatabaseStorage:95 < UserResource:113 < ...)

Please advise, thank you.

Anton Tananaev5 months ago

It seems like you didn't downgrade the database schema when you moved back to an old version.

Christian Vidal Martinez5 months ago

Hi Anton.

Thanks for your quick reply, can you please tell me how to do this?

Really appreciate it.

Anton Tananaev5 months ago

You have to look at the database schema change logs and manually revert the relevant changes.

Christian Vidal Martinez5 months ago

Hi Anton.

I really appreciate your quick response; however, I just move back to 6.2 and let's see how it works.

Sorry for the inconvenience, and once again, really appreciate your help.

Now I have another issue with the PUSH Notifications, but this is another thread.