When setting up the database with the createtables.php, I get the following:
Code:
Maps table created successfully!
Players table created successfully!
Specified key was too long; max key length is 1000 bytes
Maps data for L4D2 inserted successfully!
All tables created successfully!
Everything still seemed to work, so I created some stats by playing. We also had some fun and spawned a bunch of extra things just to play around, then were going to reset the stats.
So, I tried the command to clear the stats: sm_rank_clear
This is what I got back:
Code:
20:47:35 [RANK] Clear Stats: Started clearing the database!
[RANK] Clear Stats: Fast query failed! (Error = "Table 'l4d2stat.timedmaps' doesn't exist") Query = "DELETE FROM timedmaps"
20:47:35 L 01/24/2010 - 11:56:25: [l4d_stats.smx] Fast query failed! (Error = "Table 'l4d2stat.timedmaps' doesn't exist") Query = "DELETE FROM timedmaps"
20:47:35 [RANK] Clear Stats: Clearing timedmaps table failed. Executing rollback...
[RANK] Clear Stats: Failure!
So, it looks like all the tables weren't created. What tables are supposed to be created (I suppose I could look in the php file that creates them and hunt it down, but thought I'd ask here first).
Any help is appriciated. I'm dropped the tables and started fresh, but still got that first error.
Thanks! ;)