Wonlex gps watch (KT17S 4G) > Failed to store position - Data truncation: Incorrect datetime value
Best would be to sent the HEX from the log. To see what the device sends.
But how about setting the correct time in the watch.. You can send the time as custom command from traccar as your time like this example:
time,03.51.00,date,2023.03.10#1969-12-31 14:00:00 (i was almost born in that year :)
Hello Track-trace2,
Time is correct in the watch, it automatically set from operator network.
Below HEX log :
2023-03-09 15:37:47 INFO: [Tb0b39be7] connected
2023-03-09 15:37:47 INFO: [Tb0b39be7: watch < ip-source ] 5b33472a393032343133373338302a303030392a4c4b2c302c302c39305d
2023-03-09 15:37:47 INFO: [Tb0b39be7: watch > ip-source ] 5b33472a393032343133373338302a303030322a4c4b5d
2023-03-09 15:37:47 WARN: Failed to store position - Data truncation: Incorrect datetime value: '1969-12-31 14:00:00' for column 'fixtime' at row 1 - MysqlDataTruncation (... < QueryBuilder:469 < DatabaseStorage:95 < DefaultDataHandler:47 < ...)
2023-03-09 15:37:47 INFO: [Tb0b39be7] id: 9024137380, time: 1969-12-31 14:00:00, lat: 0.00000, lon: 0.00000, course: 0.0
2023-03-09 15:37:47 INFO: [Tb0b39be7: watch < ip-source ] 5b33472a393032343133373338302a303031362a5259494d45492c3335333239303234313337333830325dThank you !
Your log only shows Link keep message.
Did you sent the time to the device as i suggested?
Also sent this custom command: ts
Also sent this custom command: cr
Then past what is in the log
Ps.
Meaby it has nothing to do with it but your log should give the clues. There must be a reason why your fixtime is in the past time.
Hi Track-Trace,
Below the return about command beetween traccar app and watch (I decoded HEX and voluntarily hidden the imei and the url) :
TS :
[SG*9024137380*0002*ts]CR :
[3G*9024137380*0133*ts,ver:G4CH_EMMC_XT_D32-Elder_OVERSEAS_En_N_RQ_2022.11.14_11.01.00_2022.11.29;
ID:9024137380;
imei:..........;
url:...........;
port:5093;
upload:60000;
lk:300;
batlevel:63;
language:fr;
zone:-10:00;
profile:1;
GPS:OK(0);
wifiOpen:false;
wifiConnect:false;
gprsOpen:true;
NET:OK(100)]Thank for your help !
What is the data in the log when you send: cr
Cr request the current position, which should also report the device time.
Because the only output you sent is the output from: ts (the device config).
From your config, upload:60000; means upload interval 1 x per 60000 secs position update, which basicly turnes off the reporting position function.
So also sent: upload,60#
Which should make the device report once every minute when cr doesnt report anything in the log (which it should, with cr command it should sent position info for three minutes every 20 seconds).
Track-trace,
Below return of CR command from traccar app :
[3G*9024137380*00f6*UD_LTE,100323,205430,V,0,N,0,E,0,0,0,0,100,60,0,0,00000000,2,1,547,15,262156,13,100,40114,262156,13,5,SSID1,f0:c4:2f:9e:6e:14,-45,SSID2,28:a1:eb:9b:0f:36,-48,SSID3,dc:90:88:42:55:87,-52,SSID4,30:cb:c7:1d:21:a1,-53,,f0:c4:2f:9e:6e:18,-53,0]There's no return of sms command : pw,123456,upload,60#
We can see that your device date / time is ok.
[3G902413738000f6*UD_LTE,100323,205430From your config i see that your timezone is zone: -10:00;
Thats correct with your country ?
We can also see that your device does not report coordinates at all. V = invalid + zero coordinates.
V,0,N,0,E,0Did you try it outside to get a gps fix (put the device outside and reguest position with CR after 10 minutes).
Some watches have gps disabled, which can be enabled through the manufacturer app (and then point it to your server again). You might try that also if you do not get coordinates after testing it outside.
Anyway this goes beyond your initial question. Failed to store position - Data truncation: Incorrect datetime value
Meaby Anton has a clue about that time issue. from which i can learn also.
Track-trace2,
Yes timezone is correct.
I just tested watches outside but couldn't send CR command. The problem persists.
GPS seems active, I see it with sms command TS > GPS:OK(0);
Do you know what the value between brackets (0) ?
Thanks again to you !
If your data does not show coordinates when the device is online and outside. Then GPS is not enabled.
Do you know what the value between brackets (0) ?
It might be that it would there show the amount of detected satellites.
But as said with this in your config upload:60000; it wont report.
But did you do this ? Since you did not reply to it.
Some watches have gps disabled, which can be enabled through the manufacturer app (and then point it to your server again). You might try that also if you do not get coordinates after testing it outside. You can actually change the ip to the manufacturer server again to check the above ?
But you should be able the send cr through the app as customs command (not as sms).
Hi Track-trace2,
I think that GPS is enable like GPS:OK(0); from TS sms command.
But no satelites are detected.
Wonlex said that ip_url must be configured at manufacture so i cant modify it.
I understand that upload:60000 is too long and wont report position.
I asked Wonlex Support how to change the upload value, I'm waiting for their response...
Do you have any other leads?
Regards,
Its not logic what you are thinking, Why do you think gps is enabled when the gps position values are zero in your data ?
Normally You can point your watch to wonlex server again to change the workmode and enable gps.
But they did point the watch to your server correct ? And thats the reason you cant change it back ? I wonder why you didnt tell that ? They changed the firmware to point it to your server and then shipped the watch to you correct ?
Can you also give some more context about your idea of setting this up ? Because a company like them wont invest time to modify the firmware for just one watch to make it work with an external server. They might do it when its business related for testing and future business.
Track-trace2,
Yes, Wonlex configure to point to our server and port 5093 before send me watches.
They said me that is only in manufacture for change url and port.
I will try to reset watch and see if wonlex server is default url value.
And i will use wonlex app to enable gps.
Regards,
We have specific needs and their application can accommodate a maximum of 50 watches on the same interface, our needs may exceed this limit.
Hello,
The watch is online in traccar but geolocalisation doesn't work.
I have this warning in traccar logs :
Somebody can help me please ?
Informations :