next »

[Courgette]

it looks like your chatlog table is missing a column in the MySQL database.
Drop the chatlog table and re-create it using the sql script 'chatlogger.sql' you will find with the chatlogger plugin

[Mariodu62]

No, i'm sorry but i think there is a mystake in the plugin @line 278

        self.info('purge of commands older than %s days ...'%self._max_age_in_days)
        q = "DELETE FROM %s WHERE msg_time < %i"%(self._db_table_cmdlog, self.console.time() - (self._max_age_in_days*24*60*60))
        self.debug(q)

it  should be "cmd_time" instead of "msg_time" bcause it's the chatlog table..

[Courgette]

You are right, sorry I overlooked it.

See https://github.com/courgette/b3-plugin-chatlogger/issues/2
fixed in chatlogger 1.1.3

[Mariodu62]

Works fine now..

Thx

[cyanide]

hi i get following error from the chatlogger plugin

Code:

120310 11:50:29 VERBOSE Parsing Event: Say: ChatloggerPlugin
120310 11:50:29 DEBUG ChatloggerPlugin: ALL, 357, [3z$*]SkunP, oui
120310 11:50:29 DEBUG ChatloggerPlugin: writing to file
120310 11:50:29 ERROR handler ChatloggerPlugin could not handle event Say: Exception: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%(time)s, %(type)s, %(client_id)s, %(client_name)s, %(client_team)s, %(msg)s, %(' at line 3") [('C:\\UserFiles\\xxxxxx\\GameServers\\TC14348801515003882578383\\b3\\parser.py', 921, 'handleEvents', 'hfunc.parseEvent(event)'), ('C:\\UserFiles\\xxxxxx\\GameServers\\TC14348801515003882578383\\b3\\plugin.py', 157, 'parseEvent', 'self.onEvent(event)'), ('C:\\UserFiles\\xxxxxx\\GameServers\\TC14348801515003882578383\\b3\\plugins\\chatlogger.py', 287, 'onEvent', 'chat.save()'), ('C:\\UserFiles\\xxxxxx\\GameServers\\TC14348801515003882578383\\b3\\plugins\\chatlogger.py', 427, 'save', 'self._save2db(data)'), ('C:\\UserFiles\\xxxxxx\\GameServers\\TC14348801515003882578383\\b3\\plugins\\chatlogger.py', 347, '_save2db', 'raise e')]

any idea why this is

[cyanide]

any one got any ideas?

[MordyT]

any one got any ideas?

I would drop and re-add the table...

[cyanide]

i'll give that a try

[tanka]

I am trying to get the log files to uplaod to an FTP but what I get is this:

120420 11:34:04   INFO   'ChatloggerPlugin: chat log messages are kept forever'
120420 11:34:04   INFO   'ChatloggerPlugin: Using file (ftp:\\*****:*****@41.185.60.73\\Pub2\\chat.log) to store log'
120420 11:34:04   INFO   "ChatloggerPlugin: Using value 'D' for the file rotation rate"
120420 11:34:04   ERROR   "ChatloggerPlugin: cannot setup file chat logger. disabling logging to file ([Errno 22] invalid mode ('ab') or filename: 'C:\\\\UserFiles\\\\Tanka\\\\GameServers\\\\TC02452261181601642448184\\\\ftp:\\\\*****:*****@41.185.60.73\\\\Pub2\\\\chat.log')"
120420 11:34:04   DEBUG   'Register Event: Stop Process: ChatloggerPlugin'
120420 11:34:04   DEBUG   'Register Event: Program Exit: ChatloggerPlugin

Any reason why it should be doing that?