Msql Sql Error Messages

takipedecek9 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
takipedecek9 years ago

No one to help?

Anton Tananaev9 years ago

Are you expecting instant reply?

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

takipedecek9 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 Tananaev9 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.

takipedecek9 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 Tananaev9 years ago

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

takipedecek9 years ago

was successful. thanks for support

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