Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

3.3 deviceId doesn't have a default value #521

Closed
kampit opened this issue Feb 13, 2016 · 1 comment
Closed

3.3 deviceId doesn't have a default value #521

kampit opened this issue Feb 13, 2016 · 1 comment

Comments

@kampit
Copy link

kampit commented Feb 13, 2016

I'm installing new version of traccar 3.3 with MySQL.

There have no data on table positions because an error below.

WARN: Field 'deviceId' doesn't have a default value - SQLException (... < QueryBuilder:431 < DataManager:307 < DefaultDataHandler:27 < ...)

I'm missing something?

<!-- for 3.2 and 3.3 -->
<entry key='database.insertPosition'>
    INSERT INTO positions (device_id, protocol, serverTime, time, valid, latitude, longitude, altitude, speed, course, address, other)
    VALUES (:deviceId, :protocol, CURRENT_TIMESTAMP(), :time, :valid, :latitude, :longitude, :altitude, :speed, :course, :address, :attributes);
</entry>
@kampit
Copy link
Author

kampit commented Feb 13, 2016

It seems to be working..

  1. Stop traccar server
  2. Droppositions table.
  3. Start traccar server

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant