The issue #3 was related to PHP short tags (<? instead of <?php).

Since there are good reasons to disable the short tags (e.g. XML processing instructions are using <? syntax), you should avoid using them. The torque.php file is fixed but short tags still exist in map.php

I suggest changing the following lines:
var xlat = ;
var xlng = ;
var path = [];
to
var xlat = ;
var xlng = ;
var path = [];

Unsure if missed a step or something, folder is 755, see data in mysql, load ../session.php see date and time under Select Session, but after selecting it just reloads page. dose it need any php settings or add on needed?

I can see data now in database but it is not plotting anything
any ideas?

[Fri Aug 15 19:02:36.023918 2014] [:error] [pid 10842] [client 86.10.43.200:45125] PHP Notice: Undefined index: time in /var/www/html/torque/get_sessions.php on line 5, referer: http://www.ravilious.info/login.php
[Fri Aug 15 19:02:58.602436 2014] [:error] [pid 11159] [client 86.10.43.200:45145] PHP Notice: Undefined index: Plot! in /var/www/html/torque/plot.php on line 33, referer: http://www.ravilious.info/torque/session.php?id=1408120736981
[Fri Aug 15 19:03:18.179773 2014] [:error] [pid 10842] [client 86.10.43.200:45148] PHP Notice: Undefined offset: 1 in /var/www/html/torque/url.php on line 14, referer: http://www.ravilious.info/torque/session.php?id=1408120736981
[Fri Aug 15 19:03:18.264756 2014] [:error] [pid 10842] [client 86.10.43.200:45148] PHP Notice: Undefined index: Plot! in /var/www/html/torque/plot.php on line 32, referer: http://www.ravilious.info/torque/session.php?id=1408120736981
[Fri Aug 15 19:03:18.264804 2014] [:error] [pid 10842] [client 86.10.43.200:45148] PHP Notice: Undefined index: in /var/www/html/torque/plot.php on line 33, referer: http://www.ravilious.info/torque/session.php?id=1408120736981
[Fri Aug 15 19:10:45.854048 2014] [:error] [pid 11166] [client 109.201.154.153:65108] PHP Notice: Undefined index: time in /var/www/html/torque/get_sessions.php on line 5, referer: http://www.ravilious.info/login.php
[Fri Aug 15 19:11:01.334588 2014] [:error] [pid 10480] [client 109.201.154.153:65142] PHP Notice: Undefined index: Plot! in /var/www/html/torque/plot.php on line 33, referer: http://www.ravilious.info/torque/session.php?id=1408120736981

I need help to create a lookup table for parameters that are being stored in the Server.For eg,
What does Kf***** etc parameters mean? Some paramters such as Speed GPS are annonated.

Hi,

I had my Torque viewer working quite nicely up until last night when I upgraded my Ubuntu server and PHP got upgraded to v7, and that's where it all went wrong!! Not being a PHP guru I've been trying to hack my round it to get it working again with limited success.

One of the key errors I keep getting is in get_sessions.php where it now complains about

$timezone = $_SESSION['time'];

where it throws an error "Notice: Undefined index: time in /var/www/torque/get_sessions.php on line 14".

All the "mysql_" commands don't seem to work so have changed them to "mysqli_" which appears to make those errors disappear. Any pointers ?

Cheers, Tim.

I've enabled some extra PIDs within Torque for various things for my Passat TDI. Those extra PIDs are obviously not part of the torque_keys.csv file. I'm hoping to find out how to log these extra PIDs within the database and view the data through the web front end.

Has Torque any API's to query the db and extract the data?
Unfortunately, I searched on Google but i didn't find anything.

Who can help me?

It seems there is a small issue when viewing data on Firefox Mobile on Android. This has remained the same through Version 31 & 32. As you can see in the screenshot, the area to select plotting data seems to not be in a drop down (but the area to select a session does), it defaults to open, showing all the options. I'm thinking this is a Firefox for Android issue as it does not happen on the desktop version nor does the issue happen on Webkit based Android Mobile browsers. Just wanted to bring this to your attention.

Also, I am wondering if anyone else has issues with torque not uploading custom PID and additional data selected in what to log. I'm running the opentorque beta now and it seems torque is sending out some notifications of the Custom PIDs and other data as there are now tables with those PID names in my db, but they never contain any data. I've checked Apache logs and it appears after the first few posts telling what data to expect there is no custom PID and other selected data uploaded.
All the data requested does seem to be logged in the offline data though. Just curious if anyone else sees this issue or if it's maybe my setup. I hope this is clear.

.

Hi,

Thanks for your works, i got an issue

Running debian squeeze, (can't update)

apache2 : is ok i can acces to session.php
mysql : is ok i can upload and database is uptodate, i can see my differentes session in rawlog
php : is ok i can acces to session.php

Torque Pro is ok and upload on each trip end

But selection session stay definitively blank, like it can't see database, but no error on html page...

Partialy solve ! didn't wait for a 60 entry session...

another probleme now : 1 st time i try to upload logs (181 parts) i didn't put the good html adress,

how to force to resynchronize them ?

Hi,

I have implemented your code to push my car's obd status data to a webserver.
Works great so far. Thank you very much for providing this!

What I don't get is why the app keeps pushing requests to my server long after I finish the ride. (It keeps uploading for roughly 20 minutes)

Do you have an Idea what might cause that behavior? Do I record too much/often?

My settings:
About 30 pids
Upload to webserver: Yes
Record selected PIDs: Yes
Data logging interval: 1 second
Web logging interval: 30 seconds

Hi, I just cloned your web folder into my git and deployed it onto a web server but whenever I try to access the session.php it just shows a blank page with nothing. No HTML elements, nothing. Its completely empty. Can you kindly have a look at it and tell me what Im doing wrong? Also I had to change the name of the file session.php to index.php so that it opens that as default page. If I keep it to session.php it doesnt even deploy and gives an error. Im deploying it to heroku. Here's the link to the git and the heroku web server
https://github.com/17100113/torque/
http://torque.herokuapp.com/

I created a new db user and blindly copy-pasted the username and password into creds.php. I didn't notice that the password contained a $ character, which quite efficiently broke everything.

Stupid user error, I must admit. Still, using single quotes instead of double quotes around string values would have helped.

Hello, I'd like to start using and contributing to this, but I'm having an issue with my webserver configuration. I'm getting a permission error in my apache logs, and I haven't been able to diagnose it yet. Error:

[Thu Jul 24 12:40:41.459292 2014] [core:error] pid 4248Permission denied: [client 198.217.64.23:47298] AH00035: access to /torque/static/js/jquery.flot.updater.js denied (filesystem path '/var/www/torque/static/js') because search permissions are missing on a component of the path, referer: http://hda.surfrock66.com/torque/session.php

My www-data user has recursive permissions to /var/www which includes /var/www/torque. Thoughts?

Hi
Then i try and select a session the box does not save the session i have selected and nothing it i plotted

[Thu Aug 14 10:09:54.161573 2014] [:error] [pid 15715] [client xxxxxxxxx:39627] PHP Notice: Undefined variable: d1 in /var/www/html/torque/web/session.php on line 215, referer: http://www.xxxxxxxxx.info/torque/web/session.php?id=1407966160479
[Thu Aug 14 10:09:54.161645 2014] [:error] [pid 15715] [client xxxxxxxxx:39627] PHP Warning: Invalid argument supplied for foreach() in /var/www/html/torque/web/session.php on line 215, referer: http://www.xxxxxxxxx.info/torque/web/session.php?id=1407966160479
[Thu Aug 14 10:09:54.161663 2014] [:error] [pid 15715] [client xxxxxxxxx:39627] PHP Notice: Undefined variable: d2 in /var/www/html/torque/web/session.php on line 216, referer: http://www.xxxxxxxxx.info/torque/web/session.php?id=1407966160479
[Thu Aug 14 10:09:54.161679 2014] [:error] [pid 15715] [client xxxxxxxxx:39627] PHP Warning: Invalid argument supplied for foreach() in /var/www/html/torque/web/session.php on line 216, referer: http://www.xxxxxxxxx.info/torque/web/session.php?id=1407966160479
[Thu Aug 14 10:09:54.161696 2014] [:error] [pid 15715] [client xxxxxxxxx:39627] PHP Notice: Undefined variable: v1_label in /var/www/html/torque/web/session.php on line 219, referer: http://www.xxxxxxxxx.info/torque/web/session.php?id=1407966160479
[Thu Aug 14 10:09:54.161713 2014] [:error] [pid 15715] [client xxxxxxxxx:39627] PHP Notice: Undefined variable: v2_label in /var/www/html/torque/web/session.php on line 220, referer: http://www.xxxxxxxxx.info/torque/web/session.php?id=1407966160479
[Thu Aug 14 10:09:54.161733 2014] [:error] [pid 15715] [client xxxxxxxxx:39627] PHP Notice: Undefined variable: v1_label in /var/www/html/torque/web/session.php on line 232, referer: http://www.xxxxxxxxx.info/torque/web/session.php?id=1407966160479
[Thu Aug 14 10:09:54.161750 2014] [:error] [pid 15715] [client xxxxxxxxx:39627] PHP Notice: Undefined variable: v2_label in /var/www/html/torque/web/session.php on line 235, referer: http://www.xxxxxxxxx.info/torque/web/session.php?id=1407966160479
[Thu Aug 14 10:09:54.162422 2014] [:error] [pid 15715] [client xxxxxxxxx:39627] PHP Notice: Undefined variable: v1_label in /var/www/html/torque/web/session.php on line 366, referer: http://www.xxxxxxxxx.info/torque/web/session.php?id=1407966160479
[Thu Aug 14 10:09:54.162449 2014] [:error] [pid 15715] [client xxxxxxxxx:39627] PHP Notice: Undefined variable: min1 in /var/www/html/torque/web/session.php on line 367, referer: http://www.xxxxxxxxx.info/torque/web/session.php?id=1407966160479
[Thu Aug 14 10:09:54.162466 2014] [:error] [pid 15715] [client xxxxxxxxx:39627] PHP Notice: Undefined variable: max1 in /var/www/html/torque/web/session.php on line 367, referer: http://www.xxxxxxxxx.info/torque/web/session.php?id=1407966160479
[Thu Aug 14 10:09:54.162483 2014] [:error] [pid 15715] [client xxxxxxxxx:39627] PHP Notice: Undefined variable: pcnt25data1 in /var/www/html/torque/web/session.php on line 368, referer: http://www.xxxxxxxxx.info/torque/web/session.php?id=1407966160479
[Thu Aug 14 10:09:54.162500 2014] [:error] [pid 15715] [client xxxxxxxxx:39627] PHP Notice: Undefined variable: pcnt75data1 in /var/www/html/torque/web/session.php on line 369, referer: http://www.xxxxxxxxx.info/torque/web/session.php?id=1407966160479
[Thu Aug 14 10:09:54.162516 2014] [:error] [pid 15715] [client xxxxxxxxx:39627] PHP Notice: Undefined variable: avg1 in /var/www/html/torque/web/session.php on line 370, referer: http://www.xxxxxxxxx.info/torque/web/session.php?id=1407966160479
[Thu Aug 14 10:09:54.162533 2014] [:error] [pid 15715] [client xxxxxxxxx:39627] PHP Notice: Undefined variable: sparkdata1 in /var/www/html/torque/web/session.php on line 371, referer: http://www.xxxxxxxxx.info/torque/web/session.php?id=1407966160479
[Thu Aug 14 10:09:54.162549 2014] [:error] [pid 15715] [client xxxxxxxxx:39627] PHP Notice: Undefined variable: v2_label in /var/www/html/torque/web/session.php on line 374, referer: http://www.xxxxxxxxx.info/torque/web/session.php?id=1407966160479
[Thu Aug 14 10:09:54.162568 2014] [:error] [pid 15715] [client xxxxxxxxx:39627] PHP Notice: Undefined variable: min2 in /var/www/html/torque/web/session.php on line 375, referer: http://www.xxxxxxxxx.info/torque/web/session.php?id=1407966160479
[Thu Aug 14 10:09:54.162599 2014] [:error] [pid 15715] [client xxxxxxxxx:39627] PHP Notice: Undefined variable: max2 in /var/www/html/torque/web/session.php on line 375, referer: http://www.xxxxxxxxx.info/torque/web/session.php?id=1407966160479
[Thu Aug 14 10:09:54.162616 2014] [:error] [pid 15715] [client xxxxxxxxx:39627] PHP Notice: Undefined variable: pcnt25data2 in /var/www/html/torque/web/session.php on line 376, referer: http://www.xxxxxxxxx.info/torque/web/session.php?id=1407966160479
[Thu Aug 14 10:09:54.162632 2014] [:error] [pid 15715] [client xxxxxxxxx:39627] PHP Notice: Undefined variable: pcnt75data2 in /var/www/html/torque/web/session.php on line 377, referer: http://www.xxxxxxxxx.info/torque/web/session.php?id=1407966160479
[Thu Aug 14 10:09:54.162649 2014] [:error] [pid 15715] [client xxxxxxxxx:39627] PHP Notice: Undefined variable: avg2 in /var/www/html/torque/web/session.php on line 378, referer: http://www.xxxxxxxxx.info/torque/web/session.php?id=1407966160479
[Thu Aug 14 10:09:54.162665 2014] [:error] [pid 15715] [client xxxxxxxxx:39627] PHP Notice: Undefined variable: sparkdata2 in /var/www/html/torque/web/session.php on line 379, referer: http://www.xxxxxxxxx.info/torque/web/session.php?id=1407966160479

So, my setup is a bit different that others. I'm using a raspberry pi with a headless raspbian install.

I built the LAMP stack myself with Apache2, MySQL, and PHP5

Here is what I get when I try to load the webpage.
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY time DESC' at line 4"

Going through the setup, I did notice a discrepency when setting up the SQL database.

"GRANT USAGE, FILE TO 'steve'@'localhost';" would not work, I got back wrong Syntax.

I do know (by looking at mobile data usage after a test trip) that torque is uploading to the server. So at least I've got that going for me.

I am not SQL or PHP savvy. So any help would be appreciated.

Thanks,
Denton

On line 35 of the upload_data.php script, it states:

if (!in_array($key, $dbfields) and submitval == 1) {

At least when using nginx (with php5-fpm), this results in entries to the error.log:

PHP message: PHP Notice:  Use of undefined constant submitval - assumed 'submitval' in /var/www/torque/root/upload_data.php on line 35" while reading response header from upstream...

Adding a dollar to submitval solved the issue:

if (!in_array($key, $dbfields) and $submitval == 1) {

hi i am now getting the following when i try and select any odb2 data and click on plot
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '! FROM raw_logs WHERE sessio' at line 1

Hi,

do you want me to provision an ubuntu (or other) server with fix public IP address ?
Then you don't need to purshase anything ;-)

Will also need to know what FW ports needs to be open and what protocol you'll use so I can make the right configuration on my FW

Let me know ;-)

Hi buddy, I am a newby in this and need some help. I've made the tutorial exactly how u've said (by exception in the terminal of mysql, "GRANT USAGE, FILE TO 'steve'@'localhost';" need to be made manually in the config but is all right) but the data is not going to database and a lot of warnings appear.
i really need some help, if you have time please see it.
above some imgs of the error
PS:I am using WAMPserver.

I must install an SSL certificate on behalf of the new data protection guidelines in germany.
After i have activated ssl on my webserver the torque app is no longer uploading data to the server.
is there any configuration that i have not seen?
Torque app is configurated and tells me all is ok when i start the sync test.
Also the web adress in torque has been updated to https

Kind regards
kamikaze

Hopefully this is just a dumb noob mistake.

I've followed the tutorial and didn't think that I had run into any issues.

I can't seem to get the front end site to come up? I go to the address of my vps where I've configured this, but I just get the default ubuntu apache page?

Thanks for any help!

YaV1 is an Android app used in conjunction with the Valentine One radar detector and their V1Connection Bluetooth adapter to enhance the functionality of the V1 radar detector. The app generates log files with GPS data pertaining to the location of the bogies detected by your V1. The documentation for YaV1 can be found here.

The plan then is to layer the log data from YaV1 into the current Google Map used to display Torque data. I've ordered the V1Connection bluetooth adapter for my V1 and will begin the integration process once I receive the product and have an opportunity to look at the structure of the log files.

How about adding creds.php to .gitignore (so that Git ignores the file), remove it from version control and adding a file creds-sample.php instead?

This would make things cleaner for those who fork the project and want to update it with git pull.

hai . im galuh boy from indonesia

i want to ask about map matching issue . as u can see in my web test :

http://testobd2.eu-gb.mybluemix.net/

i try this code and make 3 session but for some reason the track on the map was not match with the road.
i look in the mr.google and he say about map matching .
so any sugestion how to make map matching on this code ?
thx for helping me

ps: sorry for bad english (student)

Need to add a variable to include your google maps API key for the map to work now. (At least for me).
I added to line 109 of session.php

..... src="https://maps.googleapis.com/maps/api/js?key=GOOGLEMAPSAPIKEY"></script>

I removed the sensor parameter as it looks like it's deprecated.

I got my key from here

https://developers.google.com/maps/documentation/javascript/

You will need a google id to get the key, then copy where GOOGLEMAPSAPIKEY is above.

In plot.php I get the following error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '!, FROM raw_logs WHERE sessi' at line 1

// Get data for session
$sessionqry = mysql_query("SELECT time,$v1,$v2
                      FROM $db_table
                      WHERE session=$session_id
                      ORDER BY time DESC;") or die(mysql_error());

mysql version (in Ubuntu 14.04) is
mysql Ver 14.14 Distrib 5.5.47, for debian-linux-gnu (x86_64) using readline 6.3

Looks like this issue has been discussed earlier.
Could you please let me know the resolution.
Thanks.

Please change http://data.mattnicklay.com/torque/session.php?id=1404557450999 to http://hda.surfrock66.com/torquetest/ in README.md file too.

I see within plot.php that there is a mention for userDefault fields in the TODO list, so just to add my +1 to that!

Currently temperature is plotted in F (converted from Celsius) whilst I would like it in C - just like I'm sure that some folk would like KMH and not MPH, etc.

As mentioned in the file, best is probably to have a profile for each username but that looks like quite a bit of work vs some settings.php effort to do it across all users at first?

Cheers,
E

I couldn't find a better way to do this. Are you interested in trying to work together on refining and updating this torque code? I've gotten started with database modifications and additional security settings. It seems rather pointless to start another project here if we can work together on the same one. Let me know please. I'm a competent PHP and MySQL developer with a fair number of projects under my belt. I also do a lot of work in Google maps/earth. Cheers!

Dan

Hello,

Today I found your Torque server and absolutely loved the idea. So, I installed in on my webserver (Ubuntu 14.04, Apache/2), configured it according to the instructions. The web interface had some issues with a missing Google Maps API key, but I got one for myself and added it to the session.php file, so that was that.

However, even though Torque on my Android phone reported "No problems" when testing the server, I couldn't get it to upload any of the 19 trips it said it had. The app kept trying to upload (when I clicked the back button to exit), I waited patiently, but in the end no information appeared in the web interface.

To test whether it was a phone issue, I switched back to the default Torque URL (in.torque-bhp.com) and was able to see my trips in their viewer online app.

The cred.php file did initially contain a torque ID, but then I removed it. There are web credentials set up, but I hope they are not an issue.

Would you be able to help me figure out where the problem is? I would really like to keep using it, instead of the official server.

If you need any additional information, let me know.

Hi,

I've two questions regarding torque pro -

1. I've purchased Torque Pro, but from my phone(Redmi note 4) the web server upload is not working,
   whereas from Moto and torque lite the same URL for web server is accessible. From that phone
   torque lite sends the PIDs to database. I'm using my own web server. Could anyone please explain
   why torque pro is not working?
2. Is there any way we can get the fault codes in database as well at runtime?

Thanks in advance!!

This project still alive?

hai , im galuh boy from indonesia,
i may have question about file "url.php"

first:
what i know : the file will make the map having some line that using to draw our track position.
And what i want to ask is on first line that have $_SERVER function,
what that function is purposed ? why the program should need that ?

second :
the function of "mysql_escape_string" , i'm looking on mr.google
there is no such function like that, the function should be "mysql_real_escape_string"
so what was that "mysql_escape_string" suppose to mean ?

anyone please help ...

sory for bad english (student)

regards, boy

Hi,
I did everything as you said. except database name, and table name. (I change it to something else, and put database and table name at creds.php correctly)
But I didn't get anything on session.php
it says:

And when I post request (with parameters:
{"v":"v","session":"session","id":"id","time":"time","kff1005":"1.0","kff1006":"1.0","kff1001":"1.0","kff1007":"1.0","k4":"1.0","k2f":"1.0","k11":"1.0","k5":"1.0","kc":"1.0","kd":"1.0","kf":"1.0","kff1226":"1.0","kff1220":"1.0","kff1221":"1.0","k46":"1.0"}
), via POSTMAN, I get this error:

<br />
<b>Notice</b>:  A session had already been started - ignoring session_start() in
<b>/var/www/vhosts/drcode.ir/drdemo.drcode.ir/geo/torque/del_session.php</b> on line
<b>4</b>
<br />
<br />
<b>Notice</b>:  A session had already been started - ignoring session_start() in
<b>/var/www/vhosts/drcode.ir/drdemo.drcode.ir/geo/torque/get_sessions.php</b> on line
<b>5</b>
<br />
<br />
<b>Notice</b>:  Undefined index: time in
<b>/var/www/vhosts/drcode.ir/drdemo.drcode.ir/geo/torque/get_sessions.php</b> on line
<b>6</b>
<br />
<br />
<b>Notice</b>:  A session had already been started - ignoring session_start() in
<b>/var/www/vhosts/drcode.ir/drdemo.drcode.ir/geo/torque/merge_sessions.php</b> on line
<b>5</b>
<br />
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

during the step of moving contents of 'web' folder to my webserver, the ubuntu 18.04 lts responded with 'could not stat web:no such file or directory.'

can anyone lend me some help, I'm new to this.

Not sure whether anyone experience this, my setup actually display some php code. I thought it should just output "ok"?

I can confirm php setup is working, info.php works as expected but torque.php output includes part of the code.

Hey,

So I have this working fine however when running in sql_mode=only_full_group_by (as default on MySQL version 5.7.17) an error is returned of: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'torque.raw_logs.time' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Anyone having the same issue and been able to resolve this?

Thanks.

Hi,

As a newbie Torque user I just want to thank the author for this! I much prefer self-hosted solutions such as this - I got my encopy-torque going today without any issues, thanks!

On to that pesky-stupid-user-requests-thing, it would be nice:

• To see where-you-were-when, the 'official' viewer implements this roughly with the marker moving on the map but it would be nice to know at what point you were at exactly what time.
• The 'official' viewer seems to identify what OBD values you have selected to upload and plot's those automatically, whilst here we have to chose which TWO to plot - whilst plotting several X and Y-axxis's are probably hell on earth it would be nice to see which choices are available (which you have uploaded) vs. the standard bunch in the drop-down menu..

Thanks again for a excellent tool!

Hello,

first I want to thank for the great job here. :-)

I need a way to get the last datas as JSON for my home automation. I want to know, when my car needs fuel. Example: I go mornigs to work and I see that there is no enouth fuel in the tank, because my son was too lazy to refuel!!! :-( If my home automation system would know that my car has not enough gas in the tank , then they could tell me right after the wake , so I have enough time to refuel.

This wold be realy great :-)

good evening, my name is galuh boy from indonesia

i really interesting in this OBD 2 project using php, and i have try to study this program since last couple month . I try to make only the "map" and "select session" only that will show in my browser (not include graph, table, etc),
but for some reason, the map doesn't work and not display on my browser, even thou i already selected the session.

can someone maybe have been study this program, have a solution?
or maybe which steps 1 by 1 that you prefer me to do for my idea ? (only showing maps and session)
need help thx.

sorry for bad english (student)

regards boy

Found an issue with lines 217 and 218 when plotting a single variable. For some reason the script is sending the Plot! button text as the variable as a URL component which causes an error. If two variables are plotted then no error occurs.

This can be viewed at http://tainteddonuts.com/torque/session.php?id=1451163674944&s1=kff1007&s2=Plot! if a username/password is requested please use the default torque / open password combo.

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.

Hi Matt, hi all,

I have succesfully installed the very handy Opn Torque Viewer. Problem is that I can not load a session. Upon loading a session, I get the error " Unknown column 'kd' in 'field list' ". Do understand the error, as there is no 'kd' column in my SQL database. I have tried solving the error by examining the code but this didn't get me anywhere. Can someone please point me in the right directions or does someone have a solution?

Many thanks in advance!

Kind regards,

Ruud van den Dries

I've enabled PID kff1201 - Miles Per Gallon(Instant). It's being stored in the raw_logs, however it's not available to plot.
Looking at the source code the issue appears to be that the column is created as a VARCHAR(255), whilst get_columns.php is only looking for FLOATS.
Changing the column type to a FLOAT through MySQL fixes this issue, however as there is no Column Comment the description isn't pulled through.
Either the column comment should be added at the same time as the column, or the description should be pulled from the csv each time.

Maybe I'm missing it, but is there an option in the viewer to display Farenheight instead of Celsius?
Thanks

Hi, after last pull it now plots when you select the session but not when you select a Variables to Plot.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near '! FROM raw_logs WHERE sessio' at line 1

[Sun Aug 17 08:32:58.672510 2014] [:error] [pid 29811] [client 109.201.154.182:65521] PHP Notice: Undefined index: Plot! in /var/www/html/torque/web/plot.php on line 33, referer: http://www.ravilious.info/torque/web/session.php?id=1408204267154

thanks for all ya help

I need to work with raw data and analyze it on my PC. Can I download, by Torque, data in one of the common formats (csv, json, xml, etc.)?

Thank you in advance!

The torque.php script doesn't check whether a db connection is successful or not. Perhaps you could add a simple check?

Something like:
$link = mysql_connect($db_host, $db_user, $db_pass);
if (!$link) {
die("Database connection error: ".mysql_error());
}
$db = mysql_select_db($db_name);
if (!$db) {
die("Database error: ".mysql_error());
}