econpy / 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.
MIT License
285 stars 120 forks source link

SQL errors #28

Open cg089 opened 9 years ago

cg089 commented 9 years ago

Hello, I installed torque manually on my mysql/php webspace.

The (Android) client seems to work just fine, when i look at the database with myphpadmin, there are lots of entries coming.

However, the front end results in various errors.

session.php: "/get_sessions.php on line 8

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /xxx/torque/get_columns.php on line 5

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /xxx/torque/plot.php on line 6

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /xxx/torque/session.php on line 12

After selecting an entry, I get:

url.php

Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in /xxx/torque/url.php on line 30

Warning: Cannot modify header information - headers already sent by (output started at /xxx/torque/url.php:30) in /xxx/torque/url.php on line 39

After editing the url.php on line 30 with mysql_real_escape_string() i get:

Deprecated: mysql_real_escape_string(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /xxx/torque/url.php on line 30

Warning: mysql_real_escape_string(): Access denied for user 'u1234'@'localhost' (using password: NO) in /xxx/torque/url.php on line 30

Warning: mysql_real_escape_string(): A link to the server could not be established in /xxx/torque/url.php on line 30

Warning: Cannot modify header information - headers already sent by (output started at /xxx/torque/url.php:30) in /xxx/torque/url.php on line 39

Especially the line Warning: mysql_real_escape_string(): Access denied for user 'u1234'@'localhost' (using password: NO) in /xxx/torque/url.php on line 30 i weird. In the creds.php I don't use localhost, but mysql5.mydomain.tld and another db1234 instead of "u1234" ??

Any help appreciated.