[SloppyJoe]

Whats version of tf2stats do you use?
9.1.0 Downloaded it from the first page.

How was the player table created?
The player table was created by the plugin. I ran the scripts to create the first 6 tables. Only when I started the game where the other tables created.

Also the sql account you use for the website has it permission to the tables?
Yes, I gave the user full permissions.


MySQL Version 5.5.48-37.8
PHP Version 5.4.45

[Cloman]

Originally Posted by SloppyJoe Whats version of tf2stats do you use? 9.1.0 Downloaded it from the first page. How was the player table created? The player table was created by the plugin. I ran the scripts to create the first 6 tables. Only when I started the game where the other tables created. Also the sql account you use for the website has it permission to the tables? Yes, I gave the user full permissions. MySQL Version 5.5.48-37.8 PHP Version 5.4.45

Ok try following.
Remove every table from the database regarding the tf2 stats so you will have a empty database.
then try latest version of tf2_stats plugin thats created by everyone here in the forum "https://forums.alliedmods.net/showpost.php?p=2344608&postcount=2615" (version 9.3.1)
Step 1: create empty database
Step 2: start tf2 server so all tables will be auto created.
Step 3: add missing tables for the website.
Step 4: Edit permissions of the user accounts of the sql so it can query and stuff of the tables.(just to be sure as sometimes permission inheritance doesnt work.)

[DeathMaster]

This plugin spams my logs with the following:

L 07/03/2016 - 11:49:24: [TF2_Stats.smx] TF2_Stats connected to SQLite Database!
L 07/03/2016 - 11:49:29: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied
L 07/03/2016 - 11:49:29: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied
L 07/03/2016 - 11:49:29: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied
L 07/03/2016 - 11:49:29: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied
L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied
L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied
L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied
L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied
L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied
L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied
L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied
L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied
L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied
L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied
L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied
L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied
L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied
L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied
L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied
L 07/03/2016 - 11:497: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied

Any ideas? I though it was supposed to be plug and play with sqlite

[Cloman]

Originally Posted by DeathMaster This plugin spams my logs with the following: L 07/03/2016 - 11:49:24: [TF2_Stats.smx] TF2_Stats connected to SQLite Database! L 07/03/2016 - 11:49:29: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied L 07/03/2016 - 11:49:29: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied L 07/03/2016 - 11:49:29: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied L 07/03/2016 - 11:49:29: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied L 07/03/2016 - 11:490: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied L 07/03/2016 - 11:497: [TF2_Stats.smx] SQL Error: table Player has 261 columns but 230 values were supplied Any ideas? I though it was supposed to be plug and play with sqlite

Found possible the problem will post shortly new version.
But can you post the version of the plugin you use?
After that i will post a update.

[DeathMaster]

Originally Posted by Cloman Found possible the problem will post shortly new version. But can you post the version of the plugin you use? After that i will post a update.

I used the one from this post: https://forums.alliedmods.net/showpo...postcount=2615

[Cloman]

Hi,
Created a updated version.

Version 9.3.2:
- Bug Fix Sqllite.
- Added missing Fields: tide_turner, K_jar, rtd_toxic, rtd_timebomb, rtd_instant_kills, back_scatter (was already in mysql or other databases but missing in sqllite)

To make this bug fix work you need to delete the sqllite version if you generated the database with newer then 9.1.0.
you can find it in "tf\addons\sourcemod\data\sqlite\" and delete file "tf2stats.sq3"

other databases are not affected so updating is no probs and will only bump the version number.

[DeathMaster]

I am still not having any luck with this:

L 07/05/2016 - 16:18:57: [TF2_Stats.smx] Query failed! Table 'tf2stats.Player' doesn't exist
L 07/05/2016 - 16:19:02: [TF2_Stats.smx] Query failed! Table 'tf2stats.Player' doesn't exist
L 07/05/2016 - 16:19:07: [TF2_Stats.smx] Query failed! Table 'tf2stats.Player' doesn't exist

I can see the database structure and that table was created and exists!

[Cloman]

Originally Posted by DeathMaster I am still not having any luck with this: L 07/05/2016 - 16:18:57: [TF2_Stats.smx] Query failed! Table 'tf2stats.Player' doesn't exist L 07/05/2016 - 16:19:02: [TF2_Stats.smx] Query failed! Table 'tf2stats.Player' doesn't exist L 07/05/2016 - 16:19:07: [TF2_Stats.smx] Query failed! Table 'tf2stats.Player' doesn't exist I can see the database structure and that table was created and exists!

Have you tryed to restart the server ?

[DeathMaster]

Originally Posted by Cloman Have you tryed to restart the server ?

Multiple times.
Even tried with sql and the database creates but I get the same error.

[Cloman]

Originally Posted by DeathMaster Multiple times. Even tried with sql and the database creates but I get the same error.

Ok lets see if we can rule out more.

- Your using the sqlite right ?
- What version of sourcemod do you use ?
- if you join your server is a record created for your stats in table player ?

Can you maybe attach the tf2stats.sq3 database and maybe the full log from startup to shutdown ?