Quote from Jonathon.provost :

Right,
I have read threw the docs better this time. and when I try to use the db.sql file I get the following error.

"SQL query:

--
-- Table structure for table `data`
--
CREATE TABLE `data` (

`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`lfsworld` VARCHAR( 40 ) NOT NULL DEFAULT '',
`type` VARCHAR( 40 ) NOT NULL DEFAULT '',
`value` VARCHAR( 250 ) NOT NULL DEFAULT '',
`lap` INT( 11 ) NOT NULL DEFAULT '0', <----- there is a red icon here with a "!" in it
`race_id` INT( 11 ) NOT NULL DEFAULT '0',
`created_on` INT( 11 ) NOT NULL DEFAULT '0',
`time` INT( 11 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( `id` ) ,
KEY `lfsworld` ( `lfsworld` ) ,
KEY `type` ( `type` ) ,
KEY `race_id` ( `race_id` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci;

MySQL said:

#1046 - No database selected"

Please help ASAP!
Cheers,
J.Provost

It means that you did not set up and/or select a MySQL Database in the config.

Ok,
What config do you mean??
FIXED

_______________________________________________

Also I have put the files in the following URL but error
http://www.ident-racing.net/tracker/

_______________________________________________

Fixed the db.sql file error

_______________________________________________

Also get the attached error when trying to use local tracker

Small update, noticed I had introduced a bug with the trimming of pitstops, so it's now fixed.

Either download the web tracker from the OP or get the stats2array.php file from dropbox.

Great to see it finally going public!
Thanks a lot, boothy!


I've got it up running now, just a few things I can't figure out:

1. I get the error: "Notice: Use of undefined constant max_execution_time - assumed 'max_execution_time' in C:\xampp\htdocs\config.php on line 86" on all the pages. It doesn't seem to hurt, I just wonder why this is?
   
2. The "main logo" won't show. There is no error message or anything, it just doesn't appear. Doesn't help to type in the whole URL either. As suggested in the documentation, the image is smaller than 400x150
   
3. See Attachment.
   

EDIT:
Oh, and a feature request:
Would be nice if the tracker would automatically move all the "old" html-files in a seperate directory when a new session is starts.

Hmm that's a strange thing with the main image and empty position - any chance you could zip up your tracker folder and database, then PM/email them to me? Thanks

I had thought about that feature request, the problem is though the tracker doesn't really know when a new session has started. I could however make a page in the admin section which would delete/move the html files, I'll have a look into that.

Boothy fixed all the issues, everything works perfectly now.

Thanks a lot boothy!

No problem, for anyone else that has the same issues:

1. it should be $mainLogoSrc and $mainLogoLink in config.php
   
2. if you have not defined any classes in config.php or teams.yaml/.csv, then you need to change line 149 of stats.php to
   
<?php 
        if ($XMLRACE['numClasses'] > 1) {
?>


3. change max_execution_time to
   
<?php 
ini_set('max_execution_time', 90);
?>


   - i.e. with quotation marks
   

These will be included in the main zip when I next update the tracker with more stuff.

Just one more thing:

Is there an easy way to make the localtracker use a MySQL 4.1+ style password/authentication? On my local webserver, it works fine using a 4.0 style pw in the database, but I guess my website-admin would be happier not to use an outdated password-style.

If there is no easy way, well, he'll have to get over it.

The issue with MySQL 4.1+ authentication is that PHP 4 doesn't support it, therefore you can't run the local tracker. I did try the local tracker with PHP 5, however there were a few errors so I'd need to try and fix them - but I don't really know the differences well enough between the versions to do it quickly

Ok, I'll break it to him gently.

Hi,
I have read the info again and I cant find any explanation for the attached.
Please Help,
J.provost
P.S. I can't access the tracker home.
ident-racing.site88.net/tracker

Ignore the error if it works fine.

Ok, I get a error message when I go to ident-racing.site88.net/tracker, is that the htacces file?? or how do i sort it

I also get an error message when I go to ident-racing.site88.net/FGSFDS - have a look in the address bar and you'll see what error it is...

If you're having problems with your web hosting then either learn how to manage websites or contact your host - this thread is for issues with the tracker and not websites.

Ow beep sorry, i forgot to put stats.php on it. :S
how do I get the style for http://ident-racing.site88.net/tracker/stats.php
I have got the css for the admin but not the main page

I think I have found the problem thanks to deko.
It isn't creating the index.html file no idea why

Thought I'd finally get this released, includes qualifying session support, and other various fixes/additions. In terms of development, given most of the important features are completed then it's a case of doing it when I have time or can be arsed, unless there's bugs.

Once again, make sure you read the docs before asking simple questions, and use WinMerge to compare this to the previous version if you want to see what's changed.

Changelog to 27-03-2012

Web tracker

• Fixed a bug where team finished data from a previous race_id could affect the current one
  
• Teamstats filenames, and links to them now respect team number (i.e. with zeros, or even characters)
  
• Total driving time is now calculated for each driver (includes large laptimes from timeouts/rejoing the race however)
  
• Teamstats now calculates the total time for each driver’s stints
  
• Hour display in race start time now carries leading zeros
  
• H1, and track dt display now depend on there being data for those variables
  
• Proper case of 2 variables updated in config.php - $mainLogoSrc and $mainLogoLink
  
• 'max_execution_time, 90' updated to include quotation marks
  
• Fixed a bug where no classes defined would leave a strange positions column
  
• Fixed a bug with the DT/SG column
  
• DB server race table listing in admin section now correctly displays session lengths
  
• Fixed a bug where a UTF-8 character as the first character in a .csv file would not display
  
• Improved team status column on stats/teamstats
  
• Fixed a bug where a negative penalty time would only display one digit
  
• Added time behind class leader for last mutual lap
  
• Drivers’ data does not show on stats/teamstats if empty
  
• BETA feature: added Twitter support in conjunction with the hourly standings - the tracker can send the top 3 in each class to a twitter account each hour, useful for endurance race updates - you must get auth keys from dev.twitter.com after adding a new application.
  
  

Added qualifying/practice functionality, ensure you have set the local tracker to record qual/prac sessions, and then set the $trackerMode to qualifying or practice, in addition to the other qualifying settings.

Docs

• updated general, web and local tracker information
  

Hello,

first, congratulations for this great work.

And... a little question, what versions of PHP and MySQL are needed to work properly?

thank you!

Nice, was this the same version you sent me Saturday?

Quote from Dr3dD :

And... a little question, what versions of PHP and MySQL are needed to work properly?

The local tracker requires PHP4 as I mentioned to Highharti, which you can download in the OP. PHP5/MySQL5 is what I've been using for the web tracker so try that, as it's pretty much standard.

Quote from Mustangman759 :

Nice, was this the same version you sent me Saturday?

If the latest version was available I'd have given it to you back then...

Alright thanks,
Ill have to uPdate everything then

Hi,

stats.php on line 138 has

The correct URL should be:

It's not necessarily wrong - if a copy of the tracker is moved to another folder (e.g. /archive/) then you will not have to copy the images folder to make the expand.png work. Though perhaps I should add in $trackerRoot instead of the "/".

I installed on [url]http://domain/tracker/[/url] and the png was requested at [url]http://domain/images/expand.png[/url] instead of [url]http://domain/tracker/images/expand.png[/url]

It depends in individual setup. For me, version without / is more comfortable, because I don't archive anything.

One question, For a race how do I set it to display the driver name like in a qual session ??