What version of MS SQL are you using?
the versoin fo is SQL Server 2014- 12.0.2000.8
Same Problem SqlExpress
FINEST|684/0|Service traccar|18-08-10 19:14:12| Reason: liquibase.exception.DatabaseException: The object 'DF_notifications_web' is dependent on column 'web'. [Failed SQL: ALTER TABLE tc_notifications DROP COLUMN web]
Operating System 6.3.17134
Microsoft SQL Server Management Studio 11.0.2100.60
Microsoft Data Access Components (MDAC) 10.0.17134.1
Microsoft MSXML 3.0 4.0 6.0
Microsoft Internet Explorer 9.11.17134.0
Microsoft .NET Framework 4.0.30319.42000
Check following thread:
Thanks Anton. I downloaded new changelog-4.0.xml. And paste in shema folder . Now working OK.
can you please send the link for the new changelog-4.0.xml ?
Thanks ,
I downloaded new changelog-4.0.xml. And paste in shema folder and now new error
INFO|6104/0|Service traccar|18-08-12 07:26:38|Caused by: liquibase.exception.SetupException: Error parsing line 8 column 17 of schema/changelog-4.0.xml: cvc-elt.1: Cannot find the declaration of element 'html'.
can you advice ?
You make a restore of database to point before first atttemp to upgrade ??
it is new server and new database , i don't have any old DB to restore
Have you looked at your xml file? Why does it have "html" element?
Anton, you are the best .
Apparently I downloaded the wrong file .Now it is up and running correctly
Thanks :)
I installed traccar 4 on new server.
it was runing fine with the h2 db .
I tryed to connect the server to my mssql DB (it is runing fine with oher server on 3.17) and im getting this error on the wrapper log file
and the traccar service is stoped
can you please advice ?
Thanks
shay