[cybersquare420]

they are not, as near as i can tell, it is not correctly resolving my dynamic ip address from my url... i have been focused on another webserver issue for last couple days and have not had much time to look at this... ill get to it more later... in your setup r u using direct ip address or r u using a url?
if it is resolving a url correctly then it must be something in my setup...

[anon666]

I'm using it on my home server. Previously, I used the dynamic IP option (from dyndns.org). But after I changed my router, it doesnt work anymore and I have to use the LAN IP in order for the script to work properly even though all ports are forwarded correctly. I'm also not that familiar with networking and I just discovered it via trial and error.

The requirement is PHP5. If you can get the original script working, maybe there is something wrong with my modification

[fugitif]

Hello,

I can not install this plugin.
This is the error message

[chatlogex.smx] ChatLogEx: Cannot log message, handle hdatabase is not set!

addons/sourcemod/configs/databases.cfg

"Databases" 
{ 
    "driver_default"        "mysql" 
     
    "default"
    {
        "driver"            "default" 
        "host"                "127.0.0.1" 
        "database"            "webadmin" 
        "user"                "my_user" 
        "pass"                "my_password" 
        "timeout"            "60" 
        "port"                "3306" 
    }
     
    "storage-local"
    {
        "driver"            "sqlite" 
        "database"            "sourcemod-local" 
    }
 
    "clientprefs"
    {
        "driver"            "sqlite" 
        "host"                "localhost" 
        "database"            "clientprefs-sqlite" 
        "user"                "root" 
        "pass"                "" 
        //"timeout"            "0" 
        //"port"            "0" 
    }
}

Otherwise there are no plugins that will save the chat log to a text file?

[Kage Musha]

Originally Posted by fugitif Hello, I can not install this plugin. This is the error message addons/sourcemod/configs/databases.cfg

Does that database user have the correct privileges to create a table etc?

[fugitif]

Originally Posted by Kage Musha Does that database user have the correct privileges to create a table etc?

Yes. I also try as root mysql user but it is not working.
This is another log

L 02/15/2010 - 04:07:26: [chatlogex.smx] ChatLogEx: Cannot log message, handle hdatabase is not set!
L 02/15/2010 - 04:09:05: [sql-admin-manager.smx] Query failed: Table 'sm_admins' already exists
L 02/15/2010 - 04:09:05: [sql-admin-manager.smx] Query dump: CREATE TABLE sm_admins (id int(10) unsigned NOT NULL auto_increment, authtype enum('steam','name','ip') NOT NULL, identity varchar(65) NOT NULL, password varchar(65), flags varchar(30) NOT NULL, name varchar(65) NOT NULL, immunity int(10) unsigned NOT NULL, PRIMARY KEY (id))
L 02/15/2010 - 04:09:30: [sql-admin-manager.smx] Query failed: Table 'sm_groups' already exists
L 02/15/2010 - 04:09:30: [sql-admin-manager.smx] Query dump: CREATE TABLE sm_groups (id int(10) unsigned NOT NULL auto_increment, flags varchar(30) NOT NULL, name varchar(120) NOT NULL, immunity_level int(1) unsigned NOT NULL, PRIMARY KEY (id))
L 02/15/2010 - 04:09:54: [sql-admin-manager.smx] Query failed: Table 'sm_admins' already exists
L 02/15/2010 - 04:09:54: [sql-admin-manager.smx] Query dump: CREATE TABLE sm_admins (id int(10) unsigned NOT NULL auto_increment, authtype enum('steam','name','ip') NOT NULL, identity varchar(65) NOT NULL, password varchar(65), flags varchar(30) NOT NULL, name varchar(65) NOT NULL, immunity int(10) unsigned NOT NULL, PRIMARY KEY (id))
L 02/15/2010 - 04:10:08: [sql-admin-manager.smx] Query failed: Table 'sm_group_immunity' already exists
L 02/15/2010 - 04:10:08: [sql-admin-manager.smx] Query dump: CREATE TABLE sm_group_immunity (group_id int(10) unsigned NOT NULL, other_id int(10) unsigned NOT NULL,  PRIMARY KEY (group_id, other_id))
L 02/15/2010 - 04:11:57: SourceMod error session started
L 02/15/2010 - 04:11:57: Info (map "c1m1_hotel") (file "errors_20100215.log")
L 02/15/2010 - 04:11:57: [chatlogex.smx] ChatLogEx: Cannot log message, handle hdatabase is not set!

I install this plugin instead. http://forums.alliedmods.net/showthread.php?t=117116
Thank you for your help and sorry for my English, I am French.

[chikarkas36]

Help please have the following errors in my l4d server

PHP Code:

L 02/19/2010 - 05:53:07: [chatlogex.smx] ChatLogEx: Cannot log message, handle hdatabase is not set!
L 02/19/2010 - 05:53:07: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 02/19/2010 - 05:53:07: [SM] Displaying call stack trace for plugin "chatlogex.smx":
L 02/19/2010 - 05:53:07: [SM]   [0]  Line 778, /home/groups/alliedmodders/forums/files/5/2/0/8/2/47687.attach::SendQuery()
L 02/19/2010 - 05:53:07: [SM]   [1]  Line 386, /home/groups/alliedmodders/forums/files/5/2/0/8/2/47687.attach::CleanDB()
L 02/19/2010 - 05:53:07: [SM]   [2]  Line 370, /home/groups/alliedmodders/forums/files/5/2/0/8/2/47687.attach::OnMapEnd()
L 02/19/2010 - 05:53:07: Error log file session closed.
L 02/19/2010 - 05:53:11: SourceMod error session started
L 02/19/2010 - 05:53:11: Info (map "c1m1_hotel") (file "errors_20100219.log")
L 02/19/2010 - 05:53:11: [SM] Native "PrintToConsole" reported: Client index 12124345 is invalid
L 02/19/2010 - 05:53:11: [SM] Displaying call stack trace for plugin "l4d-stats.smx":
L 02/19/2010 - 05:53:11: [SM]   [0]  Line 5960, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::DoFastQuery()
L 02/19/2010 - 05:53:11: [SM]   [1]  Line 1354, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::ConnectDB()
L 02/19/2010 - 05:53:11: [SM]   [2]  Line 564, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::OnPluginStart() 


[Kage Musha]

Did you set up your database in databases.cfg?

Originally Posted by chikarkas36 Help please have the following errors in my l4d server PHP Code: L 02/19/2010 - 05:53:07: [chatlogex.smx] ChatLogEx: Cannot log message, handle hdatabase is not set! L 02/19/2010 - 05:53:07: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4) L 02/19/2010 - 05:53:07: [SM] Displaying call stack trace for plugin "chatlogex.smx": L 02/19/2010 - 05:53:07: [SM]   [0]  Line 778, /home/groups/alliedmodders/forums/files/5/2/0/8/2/47687.attach::SendQuery() L 02/19/2010 - 05:53:07: [SM]   [1]  Line 386, /home/groups/alliedmodders/forums/files/5/2/0/8/2/47687.attach::CleanDB() L 02/19/2010 - 05:53:07: [SM]   [2]  Line 370, /home/groups/alliedmodders/forums/files/5/2/0/8/2/47687.attach::OnMapEnd() L 02/19/2010 - 05:53:07: Error log file session closed. L 02/19/2010 - 05:53:11: SourceMod error session started L 02/19/2010 - 05:53:11: Info (map "c1m1_hotel") (file "errors_20100219.log") L 02/19/2010 - 05:53:11: [SM] Native "PrintToConsole" reported: Client index 12124345 is invalid L 02/19/2010 - 05:53:11: [SM] Displaying call stack trace for plugin "l4d-stats.smx": L 02/19/2010 - 05:53:11: [SM]   [0]  Line 5960, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::DoFastQuery() L 02/19/2010 - 05:53:11: [SM]   [1]  Line 1354, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::ConnectDB() L 02/19/2010 - 05:53:11: [SM]   [2]  Line 564, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::OnPluginStart()

[Kage Musha]

Originally Posted by Kage Musha Yes, I'm running 2 servers on the same file base. Yes, I tried to set it in the server.cfg files, but the plugin is not picking it up, it takes the one in sm_chatlogex.cfg only. Which is a shame, as I read somewhere that it was taken out? Can't it be added that the cvar set in server.cfg overrides the one in sm_chatlogex.cfg?

Muukis, are you willing to put this on your TO-DO list?

[Chaos Llama]

How many database connections does this use? 1 per player chat?

[Cliffhanger]

I'm getting a strange error since i updated sourcemod to the latest version

L 07/24/2010 - 02:58:27: [chatlogex.smx] ChatLogEx: Cannot log message, sm_chatlogex_id is not set! ChatLogEx creates a config file in <mod>/cfg/sourcemod. Edit the value in there.

weird thing is that i do have the id set and it hasn't changed since i first used it.