ERROR: SQLSTATE[22S03]: <>: 3617 Latitude 122.232690 is out of range in function st_pointfromtext. about gps-tracker HOT 11 CLOSED

Hi, I just sent the 8091.log on your email.
Thanks

from gps-tracker.

I have found the error, but to be fixed the trips outside valid latitude range (>90) will be automatically deleted.

You can import the trips again from logs using the command:

php artisan server:log:read --file storage/logs/server/2023-04-XX/8091.log --protocol h02

If it's ok, you can execute the command to upgrade your project:

composer deploy

from gps-tracker.

Hi, here's the update. it's now working.

I think this is now resolved. thanks a lot.

from gps-tracker.

Thank you very much for your collaboration!

Closing :)

from gps-tracker.

What GPT tracking device are you using? And MySQL version?

from gps-tracker.

I think is related with MySQL version: https://dba.stackexchange.com/a/242004/23729

Anyway I have sent a patch to force always same parameters order: https://dba.stackexchange.com/a/313905/23729

from gps-tracker.

Im using ST-901M Sinotrack GPS Tracker

from gps-tracker.

Ok, update the code and test it again :)

from gps-tracker.

Hi, here's the update. Data are now saving. here's another issue. see the image attached.

coordinates are not working on map.

from gps-tracker.

I think it should be Lat-Long order.

from gps-tracker.

Can you send me the socket log stored in Server > Logs > server / 2023-04-27 / 8091.log

Please, send the trace to lito at eordes.com to avoid expose your device IDs.

from gps-tracker.