search

surfrock66 / torque

A set of tools used with the Torque app for Android to store OBD2 data in MySQL, view GPS data from Torque on a map in real time using the Google Maps JavaScript API, plot OBD2 data in time series charts, and export the data to CSV or JSON.
Other
43 stars 23 forks source link

MariaDB Error #45

Open itschrisonline opened 3 years ago

itschrisonline commented 3 years ago

I am getting this error on nginx and mariadb

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE ( CONCAT(YEAR(FROMUNIXTIME(session/1000)), '', DATE_FORMAT(FROM_UNIXT...' at line 1

Any help would be great

surfrock66 commented 3 years ago

I've been on vacation, sorry for the delay.

There's not enough there for me to debug; can you confirm the rest of that debug line, and can you confirm that there is a session in the table?

mo5245 commented 3 years ago

I've been running Nginx and MariaDB (10.4) for a while now, more info on where the error is received and the MariaDB & PHP version you're running would help. I've done fresh VM test install a while back to check for errors if DB is empty on new install, only has minimal js and php vars undefined.