Raised This Month: $12 Target: $400
 3% 

ChatLog v1.3.7 (Extended)


Post New Thread Reply   
 
Thread Tools Display Modes
Wolfseye
Senior Member
Join Date: Apr 2014
Location: Germany
Old 01-21-2018 , 06:28   Re: ChatLog v1.3.7 (Extended)
Reply With Quote #191

Quote:
Originally Posted by arne1288 View Post
First: Surround your error logs and other "code" into [CODE] tags on the forum to keep the readability!

Next, your issue appears to have be explained in the first post of this thread if you care to read that..
No, it doesnt really.

I got the same issue, and the only thing I found in the original topic was...

Code:
PLUGIN VERSION HISTORY
1.3.6 - Hopefully fixed the database handle error. Implemented a cleaning mechanism for older messages. Thanks naris!
and that doesn't really help, but implies that it simply dont work properly. My Database seems to be correct, and the settings as well as far as I can tell. But still, that error i cant get rid of.

I just noticed, I had the same issue back then. Guess it wont work without spamming the error log.

Last edited by Wolfseye; 01-21-2018 at 06:31.
Wolfseye is offline
Send a message via Skype™ to Wolfseye
Wolfseye
Senior Member
Join Date: Apr 2014
Location: Germany
Old 01-21-2018 , 06:43   Re: ChatLog v1.3.7 (Extended)
Reply With Quote #192

Ok, the version attached to this post fixed the issue for some reason. ;)

Code:
https://forums.alliedmods.net/showpost.php?p=1675610&postcount=136
No more error logs at least.
Wolfseye is offline
Send a message via Skype™ to Wolfseye
Wolfseye
Senior Member
Join Date: Apr 2014
Location: Germany
Old 01-21-2018 , 06:58   Re: ChatLog v1.3.7 (Extended)
Reply With Quote #193

Does anyone know what in the PHP file to change, to have a different font type ? Its a terrible font. ;)

Something else i noticed is kinda strange. I was playing on one of my servers for an hour, in that time quite some chat activities have happened. When I checked the weblog for the chat, only the last 20 minutes was still in there. In the DB i got much more of that missing comments. But why don't they show up in the chat on the webscript ?

From what I notice over the last hour checking on things, its that the displayed chat in the webscript seems to be always max 15 minutes, after that what was first displayed is remove from the webscript and starts again with the next 15 minutes. Why would it do that ?

Using PHP 5.5 btw for that, just in case its important. Thats the lowest version I can use with my hoster. Otherwise more PHP 7.x and so on.

I guess this topic is dead.

Last edited by Wolfseye; 01-21-2018 at 10:41.
Wolfseye is offline
Send a message via Skype™ to Wolfseye
nguyenbaodanh
AlliedModders Donor
Join Date: Jun 2007
Location: HCMC, Vietnam
Old 01-22-2018 , 00:26   Re: ChatLog v1.3.7 (Extended)
Reply With Quote #194

how to config the database ?
I want to use like this
PHP Code:
"chatlog"
    
{
        
"driver" "default"
        "host" "127.0.0.1"
        "database" "chat"
        "user"        ""
    "pass"        ""
        
// "timeout" "0"
        // "port" "0"
    
}

__________________
nguyenbaodanh is offline
DarkDeviL
SourceMod Moderator
Join Date: Apr 2012
Old 01-22-2018 , 04:48   Re: ChatLog v1.3.7 (Extended)
Reply With Quote #195

Quote:
Originally Posted by nguyenbaodanh View Post
how to config the database ?
I want to use like this
PHP Code:
"chatlog"
    
{
        
"driver" "default"
        "host" "127.0.0.1"
        "database" "chat"
        "user"        ""
    "pass"        ""
        
// "timeout" "0"
        // "port" "0"
    
}

If you read #1, you'll see the cvar "sm_chatlogex_db", set it to:

Code:
sm_chatlogex_db "chatlog"
__________________
Mostly known as "DarkDeviL".

Dropbox FastDL: Public folder will no longer work after March 15, 2017!
For more info, see the [SRCDS Thread], or the [HLDS Thread].

Last edited by DarkDeviL; 01-22-2018 at 04:49.
DarkDeviL is offline
nguyenbaodanh
AlliedModders Donor
Join Date: Jun 2007
Location: HCMC, Vietnam
Old 01-22-2018 , 20:49   Re: ChatLog v1.3.7 (Extended)
Reply With Quote #196

Quote:
Originally Posted by arne1288 View Post
If you read #1, you'll see the cvar "sm_chatlogex_db", set it to:

Code:
sm_chatlogex_db "chatlog"
Ah Thanks now I understand, though that it is table name
__________________
nguyenbaodanh is offline
deville
AlliedModders Donor
Join Date: Oct 2016
Old 04-14-2018 , 10:30   Re: ChatLog v1.3.7 (Extended)
Reply With Quote #197

Can't run this on PHP7 which I'm afraid I'm forced to use with my current host. With PHP5 support expiring this year, it would be fantastic to see this feature viable by freshening up the php script. I am no PHP guru myself, hopefully someone can take on the task.
deville is offline
GM127
AlliedModders Donor
Join Date: Feb 2016
Location: HONG KONG
Old 08-29-2018 , 08:08   Re: ChatLog v1.3.7 (Extended)
Reply With Quote #198

Quote:
Originally Posted by deville View Post
Can't run this on PHP7 which I'm afraid I'm forced to use with my current host. With PHP5 support expiring this year, it would be fantastic to see this feature viable by freshening up the php script. I am no PHP guru myself, hopefully someone can take on the task.
I have changed it to use PDO to connect to database. It should be work on PHP7.
Attached Files
File Type: zip chatlogex_PDO.zip (3.1 KB, 217 views)
GM127 is offline
sixten_8_9@
Senior Member
Join Date: Jun 2009
Location: Sweden
Old 11-13-2018 , 16:22   Re: ChatLog v1.3.7 (Extended)
Reply With Quote #199

join message dont work on csgo need help to fix that, (it works on css.)
everything else work like disconnect message.
__________________
My Nick name is Nouton^
i have played cs for around 12years+
have build servers for about 12years
my website and my servers are: http://Nouton.se

i host at home did build my own server station for around 1300$.

Last edited by sixten_8_9@; 11-13-2018 at 17:42.
sixten_8_9@ is offline
jevgienij
Junior Member
Join Date: Nov 2018
Old 01-09-2019 , 05:24   Re: ChatLog v1.3.7 (Extended)
Reply With Quote #200

Code:
L 01/08/2019 - 19:49:36: SourceMod error session started
L 01/08/2019 - 19:49:36: Info (map "siege_coop") (file "errors_20190108.log")
L 01/08/2019 - 19:49:36: [chatlogex.smx] Query Failed! Incorrect string value: '\xF0\x9D\x94\xBE\xF0\x9D...' for column 'text' at row 1
L 01/08/2019 - 19:49:36: [chatlogex.smx] Query: INSERT INTO chatlogs (name, steamid, text, team, srvid, type) VALUES ('', '', 'Player 𝔾𝕌ℕ connected', -1, '2', -1)
L 01/08/2019 - 19:50:26: [player_analytics.smx] Unable to insert row for client 𝔾𝕌ℕ<453><STEAM_1:1:83062392><>. Incorrect string value: '\xF0\x9D\x94\xBE\xF0\x9D...' for column 'name' at row 1
L 01/08/2019 - 19:54:24: [chatlogex.smx] Query Failed! Incorrect string value: '\xF0\x9D\x94\xBE\xF0\x9D...' for column 'text' at row 1
L 01/08/2019 - 19:54:24: [chatlogex.smx] Query: INSERT INTO chatlogs (name, steamid, text, team, srvid, type) VALUES ('', 'STEAM_1:1:83062392', 'Player 𝔾𝕌ℕ was killed by player 𝔾𝕌ℕ', -1, '2', -2)
L 01/08/2019 - 19:55:22: [chatlogex.smx] Query Failed! Incorrect string value: '\xF0\x9D\x94\xBE\xF0\x9D...' for column 'text' at row 1
L 01/08/2019 - 19:55:22: [chatlogex.smx] Query: INSERT INTO chatlogs (name, steamid, text, team, srvid, type) VALUES ('', 'STEAM_1:1:83062392', 'Player 𝔾𝕌ℕ was killed by a bot (BOT Jonny)', -1, '2', -2)
L 01/08/2019 - 19:58:27: [chatlogex.smx] Query Failed! Incorrect string value: '\xF0\x9D\x94\xBE\xF0\x9D...' for column 'text' at row 1
L 01/08/2019 - 19:58:27: [chatlogex.smx] Query: INSERT INTO chatlogs (name, steamid, text, team, srvid, type) VALUES ('', 'STEAM_1:1:83062392', 'Player 𝔾𝕌ℕ was killed by a bot (BOT Vuk)', -1, '2', -2)
L 01/08/2019 - 20:01:11: [chatlogex.smx] Query Failed! Incorrect string value: '\xF0\x9D\x94\xBE\xF0\x9D...' for column 'text' at row 1
L 01/08/2019 - 20:01:11: [chatlogex.smx] Query: INSERT INTO chatlogs (name, steamid, text, team, srvid, type) VALUES ('', 'STEAM_1:1:83062392', 'Player 𝔾𝕌ℕ was killed by a bot (BOT Mike)', -1, '2', -2)
L 01/08/2019 - 20:02:47: [chatlogex.smx] Query Failed! Incorrect string value: '\xF0\x9D\x94\xBE\xF0\x9D...' for column 'text' at row 1
L 01/08/2019 - 20:02:47: [chatlogex.smx] Query: INSERT INTO chatlogs (name, steamid, text, team, srvid, type) VALUES ('', 'STEAM_1:1:83062392', 'Player 𝔾𝕌ℕ was killed by a bot (BOT Rich)', -1, '2', -2)
L 01/08/2019 - 20:04:31: [chatlogex.smx] Query Failed! Incorrect string value: '\xF0\x9D\x94\xBE\xF0\x9D...' for column 'text' at row 1
L 01/08/2019 - 20:04:31: [chatlogex.smx] Query: INSERT INTO chatlogs (name, steamid, text, team, srvid, type) VALUES ('', 'STEAM_1:1:83062392', 'Player 𝔾𝕌ℕ was killed by a bot (BOT Valdis)', -1, '2', -2)
L 01/08/2019 - 20:06:55: [chatlogex.smx] Query Failed! Incorrect string value: '\xF0\x9D\x94\xBE\xF0\x9D...' for column 'text' at row 1
L 01/08/2019 - 20:06:55: [chatlogex.smx] Query: INSERT INTO chatlogs (name, steamid, text, team, srvid, type) VALUES ('', 'STEAM_1:1:83062392', 'Player 𝔾𝕌ℕ disconnected (Disconnected.)', -1, '2', -1)
L 01/08/2019 - 20:07:19: Error log file session closed.
I have a lot more like this. Whenever it's happening, it involves players with special characters in their names. Like some kind of encoding problem. How can I fix it?

I have also this kinds of errors:
Code:
L 01/07/2019 - 01:09:29: SourceMod error session started
L 01/07/2019 - 01:09:29: Info (map "cs_italy_coop") (file "errors_20190107.log")
L 01/07/2019 - 01:09:29: [SM] Exception reported: Invalid game event handle c300bd (error 2)
L 01/07/2019 - 01:09:29: [SM] Blaming: chatlogex.smx
L 01/07/2019 - 01:09:29: [SM] Call stack trace:
L 01/07/2019 - 01:09:29: [SM]   [0] GetEventString
L 01/07/2019 - 01:09:29: [SM]   [1] Line 499, /home/forums/content/files/5/2/0/8/2/47687.attach::LogPlayerConnect
L 01/07/2019 - 01:10:45: Error log file session closed.
L 01/07/2019 - 20:12:04: SourceMod error session started
L 01/07/2019 - 20:12:04: Info (map "cs_italy_coop") (file "errors_20190107.log")
L 01/07/2019 - 20:12:04: [SM] Exception reported: Invalid game event handle c300bd (error 2)
L 01/07/2019 - 20:12:04: [SM] Blaming: chatlogex.smx
L 01/07/2019 - 20:12:04: [SM] Call stack trace:
L 01/07/2019 - 20:12:04: [SM]   [0] GetEventString
L 01/07/2019 - 20:12:04: [SM]   [1] Line 499, /home/forums/content/files/5/2/0/8/2/47687.attach::LogPlayerConnect
L 01/07/2019 - 20:51:30: Error log file session closed.

L 01/03/2019 - 02:56:36: [SM] Exception reported: Invalid game event handle f400e4 (error 2)
L 01/03/2019 - 02:56:36: [SM] Blaming: chatlogex.smx
L 01/03/2019 - 02:56:36: [SM] Call stack trace:
L 01/03/2019 - 02:56:36: [SM]   [0] GetEventString
L 01/03/2019 - 02:56:36: [SM]   [1] Line 499, /home/forums/content/files/5/2/0/8/2/47687.attach::LogPlayerConnect
L 01/03/2019 - 03:12:11: Error log file session closed.
L 01/03/2019 - 06:02:38: [SM] Exception reported: Invalid game event handle f400e4 (error 2)
L 01/03/2019 - 06:02:38: [SM] Blaming: chatlogex.smx
L 01/03/2019 - 06:02:38: [SM] Call stack trace:
L 01/03/2019 - 06:02:38: [SM]   [0] GetEventString
L 01/03/2019 - 06:02:38: [SM]   [1] Line 499, /home/forums/content/files/5/2/0/8/2/47687.attach::LogPlayerConnect
L 01/03/2019 - 09:02:55: Error log file session closed.
Quite a few of them too.

Game is Insurgency 2014.
jevgienij is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 17:11.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode