I modified the server configuration to use SQL Server (using SQL Server 2008 R2). It connects to the database and creates a few tables, but the log is complaining about a table constraint:
INFO | jvm 1 | 2016/07/16 09:30:39 | WrapperSimpleApp Error: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The object 'DF_users_language' is dependent on column 'language'.
This looks to me like the 'users' table is looking for a default value of 'en' in another table? Or not - I really have no idea.
Is there some missing data in some of the tables built by the server? This is causing the web interface to be non-responsive (wont allow connections).
I would really prefer to run SQL server, as I have other control systems that use it. Any help here is appreciated!
Found the answer:
ALTER TABLE users DROP CONSTRAINT DF_users_language
Now it appears to work - have spotted one vehicle already. Thanks anyway!
The issue should've been fixed. What version of Traccar are you using?
I downloaded from the Server page on July 4, don't know what version number it is...
New version has been released on 9th of July, so I would recommend to update.
Will do, Anton. Thank you
I modified the server configuration to use SQL Server (using SQL Server 2008 R2). It connects to the database and creates a few tables, but the log is complaining about a table constraint:
INFO | jvm 1 | 2016/07/16 09:30:39 | WrapperSimpleApp Error: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The object 'DF_users_language' is dependent on column 'language'.
This looks to me like the 'users' table is looking for a default value of 'en' in another table? Or not - I really have no idea.
Is there some missing data in some of the tables built by the server? This is causing the web interface to be non-responsive (wont allow connections).
I would really prefer to run SQL server, as I have other control systems that use it. Any help here is appreciated!