[msleeper]

Originally Posted by Dodgy Bob Hi again, Done a bit of checking myself. Seems it's just a problem with the field playtime_nor (possibly others as this is just the first it hits). Trying to insert just a single entry gives the same error. Hope this helps. Bob.

Try changing line 45 in createtables from this:

$insert_maps = "INSERT INTO maps (name) VALUES ('l4d_airport01_greenhouse'),

To this:

$insert_maps = "INSERT IGNORE INTO maps (name) VALUES ('l4d_airport01_greenhouse'),

INSERT IGNORE may or may not solve your problem. Worst case scenario it says it works, and it actually does nothing. I am still curious your MySQL version.

[DevilsReject]

i cannot get this to work
what do i have to put in the server config?
this?
sm_l4dstats_announcemode
sm_l4dstats_medkitmode
sm_l4dstats_minhumans
sm_l4dstats_siteurl
sm_l4dstats_updaterate

[msleeper]

Originally Posted by DevilsReject i cannot get this to work what do i have to put in the server config? this? sm_l4dstats_announcemode sm_l4dstats_medkitmode sm_l4dstats_minhumans sm_l4dstats_siteurl sm_l4dstats_updaterate

You don't have to edit those cvars, but those are the ones you probably want to modify. You can put them in your server.cfg or in the config that the plugin creates, in /cfg/sourcemod/l4d_stats.cfg.

What exactly is the problem you are having?

[DevilsReject]

when i type rank or top10 in stats nothing happens
also
http://egamerz.net/stats/index.php
empty
should i leave those out of the config file

[msleeper]

Does your MySQL server allow external connections? Is there anything in the error log?

[DevilsReject]

yes it allows external connections and nothing inthe error log pertaining to this

[DevilsReject]

i never did find a database.cfg file where is it?

[msleeper]

You're not really giving me a lot of details so I don't really know what the issue might be. Did you restart the server after updating database.cfg?

EDIT

Yeah, if you didn't edit the database.cfg file then of course it won't connect. It is in the /addons/sourcemod/configs/ directory.

[DevilsReject]

yes i found it this time
what do i put here

"clientprefs"
{
"driver" "sqlite"
"host" "localhost"
"database" "clientprefs-sqlite"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}
}
what info

[msleeper]

Read the first post. All of the instructions on how to edit the file are there.