[TF2 Stats] With Web Ranking and Item Logger [v9.1.0] - Page 195

Sillium

Thx for the update of the plugin and the website

galadril

Quote:

Originally Posted by Sillium

Thx for the update of the plugin and the website

your welcome

cool_myll

Also some bugs with the graphs

http://stats.tf2.gr/player.php?steam...M_0:0:19802480

**DarthNinja**

Quote:

Originally Posted by cool_myll

Thanks. The only problem i have now is this. It happened cause i made the player table from sqlite. And mysql didnt incude this entry? Stats work fine on the web interface except the location. They all are shown that they are from africa.

L 09/21/2011 - 10:45:23: [TF2_Stats.smx] SQL Error: Unknown column 'IPAddress' in 'field list'

Quote:

Moving to MySQL from SQLite:

Grab your SQLite DB file located at /sourcemod/data/sqlite/tf2stats.sq3
Use this program to open the file export the data from it.
Setup the TF2 stats plugin with MySQL and let it create the table structures.
Import the data *only the data* from the SQLite database.

If you directly copy the SQLite database to MySQL you will be missing a few columns which will cause plugin errors.

cool_myll

Darth you i read that but couldnt really add the sqlite data to the mysql table. I got an error that the collumn count wasnt the same.

Is there anything i can do know? What about the ipaddress field should i rename it or delete it?

**DarthNinja**

Add a field called IPAddress varchar 50

GunSpeed

The web interface is working fine, only problem is when I click on any player name I get error.
"....player.php?steamid=STEAM"...etc

Can't seems to fetch steamid info.

Obsidian

You know, it doesn't help anyone figure out the exact problem if you don't actually include the full error details.

Specify:
whose interface
what version
the error
PHP version, any relevant apache setup details

GunSpeed · *Last edited by GunSpeed; 09-22-2011 at 21:58.*

Quote:

Originally Posted by Obsidian

You know, it doesn't help anyone figure out the exact problem if you don't actually include the full error details.

True, sorry!

Quote:

Originally Posted by Obsidian

Specify:
whose interface
what version
the error
PHP version, any relevant apache setup details

interface : Powered by Heinisblog Running TF2 Stats Webinterface
Version : 7.4.0
The error : Server error
The website encountered an error while retrieving http://xxx.xxx.xxx.xxx/tf2stats/play...AM_0:1:2641xxx. It may be down for maintenance or configured incorrectly.
Here are some suggestions:
Reload this webpage later.
HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while the server was attempting to fulfill the request.

PHP Version 5.3.2-1ubuntu4.9
Apache Version Apache/2.2.14 (Ubuntu)

If anything required from phpinfo.php, that's my source of general information.

**DarthNinja**

What do your apache log file(s) have to say?
It should tell you whats causing the 500 error.