Fixtime Column (key) Sample: Null
Your image is not shown. Did you check server log for any errors?
Hello, sorry yes. I checked the logs, but found no warnings.
The image is as follows:
Response to Inquiry Describe tc_positions;
Digging into the forum I notice that I'm not the only one who needs to remove the devices from the system and re-add them to verify the actual location.
I'm not sure, but what i should do is check the HEX code in the log file when the device is on the move. To check out what the device data actually is, that the device sends at that moment and if that data is changing when the device is moving.
I would also check what the Date and Time is in the data and the coordinates that the device sends to compare it with your database.
Would also check if iuse filtering which might filter out the positions because off for instance, wrong date and time, accuracy, no cooridinates.. So show the logfile data if you want anyone to look at it.
So you would be able to check if it is the device or the service where the problem is.
Database schema is definitely not a problem here.
I understand, and it's not just that inconvenience, also with the GT06 protocol equipment the device returns to the initial location and returns to the real point and keeps weaving between the starting point and the real point.
Device problems were ruled out, since the server is working correctly:I send the image of the tour report.
I can't understand where the error lies.
How exactly did you rule out device problems?
The device sends correct coordinates and data and valuesThe device sends correct and valid coordinates and data. It's definitely a problem with the time issue or the interpretation of it on the server.
If device sends some correct data, it doesn't mean that it sends all correct data. So I'm not sure I understand the logic.
Good evening community, I have a problem with several GPS equipment.
They get stuck in one position and don't update even if they're on the move, the only quick fix is to remove the device from the server and add it back to the system.
Only then show the real location, after a few minutes it disconnects again in some cases and in others it remains static without updating the real location.
Searching and looking in many forums and topics I head towards Mariadb to check if there is any error in it.
EntWhen running DESCRIBE tc_positions; shows me the following data
Respuesta de mysql al ejecutar consulta
Is the configuration correct, or is there an error that needs to be fixed and how could you do it?
Thanks a lot.