I'm using traccar 4.6. ihave the below configuration in conf/traccar.xml
<entry key='database.url'>jdbc:mysql://localhost:3306/at2018?serverTimezone=UTC&useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</entry>
<entry key='database.user'>traccar</entry>
<entry key='database.password'>i87HaF0CMjAN71tm8x</entry>
<entry key='server.timeout'>120</entry>
<entry key='database.insertPosition'>
START TRANSACTION
INSERT INTO teste(protocol, address)
VALUSE(:protocol, :address);
COMMIT;
</entry>
but i can insert into my table(test) , the traccar server log show me that and i dont now what is wrong? any help please!!!
2020-04-16 10:01:20 WARN: Failed to store position - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO test(protocol, address)
VALUSE('gps103', null);
CO' at line 2 - SQLSyntaxErrorException (... < QueryBuilder:480 < DataManager:458 < DefaultDataHandler:40 < ...)
isn't VALUSE but VALUES just a typing error
Should be VALUES yep, spelling error
I'm using traccar 4.6. ihave the below configuration in conf/traccar.xml
<entry key='database.url'>jdbc:mysql://localhost:3306/at2018?serverTimezone=UTC&useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</entry> <entry key='database.user'>traccar</entry> <entry key='database.password'>i87HaF0CMjAN71tm8x</entry> <entry key='server.timeout'>120</entry> <entry key='database.insertPosition'> START TRANSACTION INSERT INTO teste(protocol, address) VALUSE(:protocol, :address); COMMIT; </entry>
but i can insert into my table(test) , the traccar server log show me that and i dont now what is wrong? any help please!!!