Msql Sql Error Messages

takipedecek8 years ago

Hi, Traccar MsSql is giving an error. I have done field operations on this link. I have sql tables, but I am trying to add devices. what can I do?

Error Message : Invalid column name 'uniqueId'. - SQLServerException (... < QueryBuilder:443 < DataManager:203 < DeviceManager:164 < ...)

Version Info: Traccar : 3.9 Ms Sql : MS SQL 2016 Os: Windows 8.1 Pro
takipedecek8 years ago

No one to help?

Anton Tananaev8 years ago

Are you expecting instant reply?

So, does the devices table have the "uniqueId" column?

takipedecek8 years ago

Thanks for the reply Anton. I looked at the sql table, but there is no "uniqueId" column .. instead it has a "uniqueid" column. What do you suggest me to do?

Anton Tananaev8 years ago

I believe the name should be case-insensitive, so everything should work. Not sure why it doesn't. I know that many people are using Traccar with MS SQL.

takipedecek8 years ago

Correcting 1 columb gives warning for the other columb . I think the script generates the wrong tables.
Version Info:
Traccar : 3.9
Ms Sql : MS SQL 2016
Os: Windows 8.1 Pro

Anton Tananaev8 years ago

What script? As I said, it works for many other users with MS SQL. There must be some problem with your configuration.

takipedecek8 years ago

was successful. thanks for support

What I did:
Change all "Id" in Default.xml to "id"