Failed to store position - error SQL syntax;

Abou4 years ago

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&amp;useSSL=false&amp;allowMultiQueries=true&amp;autoReconnect=true&amp;useUnicode=yes&amp;characterEncoding=UTF-8&amp;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 < ...)
Abou4 years ago

isn't VALUSE but VALUES just a typing error

Kieran Grosvenor4 years ago

Should be VALUES yep, spelling error