[MasterS]

[l4d_stats.smx] Database.cfg missing 'l4dstats' entry!
here is my databases.cfg can you help me !

"Databases"
{
    "driver_default"        "mysql"
    
    "default"
    {
        "driver"            "default"
        "host"                "localhost"
        "database"            "sourcemod"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }
    
    "storage-local"
    {
        "driver"            "sqlite"
        "database"            "sourcemod-local"
    }

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

"l4dstats"
{
    "driver"              "mysql"
    "host"                "localhost"
    "database"            "l4d"
    "user"                "l4d"
    "pass"                "hide"

oh ! and when I run createtable.php got the follow results

Warning

:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /date/www/bfxhz/l4drank/common.php on line 134
Maps table created successfully!

Maps data inserted successfully!

Players table created successfully!

All tables created successfully!

[muukis]

Originally Posted by MasterS [l4d_stats.smx] Database.cfg missing 'l4dstats'

You have to place the "l4dstats" entry inside the "Databases" brackets. Also, in your example, you are missing a closing bracket for the "l4dstats" entry? Copy&paste error?

I had some problems with the MySQL, but don't remember if it was the same as yours. You can however try checking if your MySQL server is set to strict mode. That mode will cause problems due to some warnings the original queries will generate.

http://dev.mysql.com/doc/refman/5.0/...-sql-mode.html

[msleeper]

Originally Posted by galadril So whats the status>?????

You're extremely impatient. I already said that I was not going to include the changes to the webstats. I provide a very basic package for people, if someone wants to modify it then they are more than welcome to.

No, I haven't had a chance to totally complete things. Real life and work are important and I've had other obligations that require my attention. I will get these finished as soon as I can.

Originally Posted by muukis You have to place the "l4dstats" entry inside the "Databases" brackets. Also, in your example, you are missing a closing bracket for the "l4dstats" entry? Copy&paste error?

This. Fix your layout and you'll be fine.

As for your MySQL error, do what muukis suggested with the "strict" mode and you should be fine.

[MasterS]

Thank you I can run the Player Stats now !

And another problem I have search the problem about mysql strict mode and answer is add

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

to my.cnf

I have add this to my.cnf and restart mysql now do I need to reintall the database with createtable.php ?

[msleeper]

It probably wouldn't hurt. Just delete all of the tables and run the installer again.

[MasterS]

aways got the same problem
I have add

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

to my.cnf in the mysqld section and run

SET @@global.sql_mode= '';

with phpmyadmin but no effect
when i run createtable.php still get

Warning:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /date/www/l4drank/common.php on line 134

[rebbie23]

when a user types rank in the server this is the error I am getting in console and nothing shows up on the players screen.
can any one tell me what this means?

: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4) : [SM] Displaying call stack trace for plugin "l4d_stats.smx": : [SM] [0] Line 1549, /home/groups/alliedmodders/forums/files/3/7/5/2/1/41102.attach::cmd_ShowRank() : [SM] [1] Line 1520, /home/groups/alliedmodders/forums/files/3/7/5/2/1/41102.attach::cmd_Say()

and this is what my databases.cfg looks like (pretty positive this is right)

"Databases" { "driver_default" "mysql" "default" { "driver" "default" "host" "localhost" "database" "sourcemod" "user" "root" "pass" "" //"timeout" "0" //"port" "0" } "storage-local" { "driver" "sqlite" "database" "sourcemod-local" } "clientprefs" { "driver" "sqlite" "host" "localhost" "database" "clientprefs-sqlite" "user" "root" "pass" "" //"timeout" "0" //"port" "0" } "l4dstats" { "driver" "mysql" "host" "64.111.119.19" "database" "robertdcbrown_l4dstats" "user" "xxxxxx" "pass" "xxxxx" }

[msleeper]

You're forgetting your closing } at the end.

[rebbie23]

Originally Posted by msleeper You're forgetting your closing } at the end.

sorry, I forgot to copy and paste it. There is a final bracket in my config file.

still having same problem.

[msleeper]

Are you positive that your MySQL host allows external connections, or that you have configured your MySQL server properly?