[galadril]

Originally Posted by DarthNinja Also the found items section only shows this at the moment:

The website only checking the ItemIndex column from the founditems.. So all these other items are old ones..
I've already posted a little sql script in multiple replies that can update all founditems to insert the correct ItemIndex:

SELECT DISTINCT  "UPDATE founditems SET ItemIndex = '", i.code, "' WHERE ITEM ='",  fi.item , "';"
FROM founditems as fi, items as i 
WHERE fi.item = i.ITEM
GROUP BY i.ITEM

This script results in a nice generated UPDATE script which you can run the update all the found items..

[markg]

my install has worked well since the beginning, but with one of the updates, started spamming the log file with this:

L 01/20/2012 - 00:54:03: [TF2_Stats.smx] SQL Error: table Player has 206 columns but 213 values were supplied
L 01/20/2012 - 00:54:10: [TF2_Stats.smx] SQL Error: table Player has 206 columns but 213 values were supplied
L 01/20/2012 - 01:02:24: [TF2_Stats.smx] SQL Error: table Player has 206 columns but 213 values were supplied
L 01/20/2012 - 01:03:57: [TF2_Stats.smx] SQL Error: table Player has 206 columns but 213 values were supplied
L 01/20/2012 - 01:04:15: [TF2_Stats.smx] SQL Error: table Player has 206 columns but 213 values were supplied
L

what should i do?

[DarthNinja]

galadril:
Just for the record, that script will cause the latest version of phpmyadmin to timeout so that it never outputs anything. You might want to throw together a simple php update script that people can just run from their /stats/ directory.

markg:
What database are you using, and what is the value of dbversion?
(Or do you know which columns are missing?)

[markg]

Originally Posted by DarthNinja . markg: What database are you using, and what is the value of dbversion? (Or do you know which columns are missing?)

im using whatever the default plugin uses, i did not install anything additional

[Leontar]

Guys, I need some help with this. Eventough I have the latest version I get 2 errors from database:

Query failed! Table 'tf2stats.Player' doesn't exist

and

Query failed: Table 'tf2stats.founditems' doesn't exist

I noticed these 2 tables do not excist in the sql files. Any help would be appreciated. Thanks.

[djmikrus]

Originally Posted by Leontar Guys, I need some help with this. Eventough I have the latest version I get 2 errors from database: Query failed! Table 'tf2stats.Player' doesn't exist and Query failed: Table 'tf2stats.founditems' doesn't exist I noticed these 2 tables do not excist in the sql files. Any help would be appreciated. Thanks.

i have the same problem

[Leontar]

Seems someone forgot to include these.

[DarthNinja]

The plugin creates those tables. Run the plugin.

Reading is hard:

Install Instructions: Simple: Upload the .smx file to your /sourcemod/plugins/ folder Set point settings in tf2-stats.cfg and upload to your /tf/cfg/ folder. Advanced + Web Interface: Edit your game server's database.cfg file located in /addons/sourcemod/configs and add the values shown below. Install plugin as above. Restart your game server. Edit settings.php (in the "inc" folder). Run the SQL files located in the website zip in your destination database. Upload web interface to desired location.

[Leontar]

Well, it seems it doesn't. I have run all the sql files and these tables are still not there...

[DarthNinja]

Originally Posted by Leontar Well, it seems it doesn't. I have run all the sql files and these tables are still not there...

Did you run the Plugin? Is the plugin connecting to the Correct Database?