Postgresql 9.6 error

MuhHuz6 years ago

Hii Anton,

this ini stact trace of traccar when i use Postgresql 9.6 version. how can i fix it??

Reason: liquibase.exception.DatabaseException: ERROR: operator does not exist: boolean = integer
  Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
  Position: 76 [Failed SQL: UPDATE public.tc_notifications SET notificators = 'web,mail,sms' WHERE web = 1 AND mail = 1 AND sms = 1]
    at liquibase.changelog.ChangeSet.execute(ChangeSet.java:637)
    at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53)
    at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:78)
    at liquibase.Liquibase.update(Liquibase.java:202)
    at liquibase.Liquibase.update(Liquibase.java:179)
    at liquibase.Liquibase.update(Liquibase.java:175)
    at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:307)
    at org.traccar.database.DataManager.<init>(DataManager.java:88)
    at org.traccar.Context.init(Context.java:364)
    at org.traccar.Main.main(Main.java:35)
Caused by: liquibase.exception.DatabaseException: ERROR: operator does not exist: boolean = integer

Regards

Anton Tananaev6 years ago

Use search.