Msql Sql Error Messages

takipedecek 9 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
takipedecek 9 years ago

No one to help?

Anton Tananaev 9 years ago

Are you expecting instant reply?

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

takipedecek 9 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 Tananaev 9 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.

takipedecek 9 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 Tananaev 9 years ago

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

takipedecek 9 years ago

was successful. thanks for support

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