next »

[dots]

hi agaim me, the b3 the last nigth run with any problem, today install diferent plugins and run with any problem. I install the b3 and the problems for me :-(


120202 16:08:20   BOT       'Starting Plugin xlrstats'
120202 16:08:20   DEBUG   'AdminPlugin: Command "xlrhide (None)" registered with cmd_xlrhide for level (60, 100)'
120202 16:08:20   DEBUG   'AdminPlugin: Command "xlrstats (None)" registered with cmd_xlrstats for level (1, 100)'
120202 16:08:20   DEBUG   'AdminPlugin: Command "xlrtopstats (None)" registered with cmd_xlrtopstats for level (2, 100)'
120202 16:08:20   DEBUG   'Register Event: Client Join Team: XlrstatsPlugin'
120202 16:08:20   DEBUG   'Register Event: Client Kill: XlrstatsPlugin'
120202 16:08:20   DEBUG   'Register Event: Client Team Kill: XlrstatsPlugin'
120202 16:08:20   DEBUG   'Register Event: Client Suicide: XlrstatsPlugin'
120202 16:08:20   DEBUG   'Register Event: Game Round Start: XlrstatsPlugin'
120202 16:08:20   DEBUG   'Register Event: Client Action: XlrstatsPlugin'
120202 16:08:20   DEBUG   'Register Event: Client Damage: XlrstatsPlugin'
120202 16:08:20   DEBUG   'XlrstatsPlugin: Got client id for B3: 1; World'
120202 16:08:20   DEBUG   'XlrstatsPlugin: No Webfront Url available, using defaults'
120202 16:08:20   DEBUG   'XlrstatsPlugin: Calculating kill_bonus'
120202 16:08:20   VERBOSE   'Added crontab <bound method XlrstatsPlugin.calculateKillBonus of <xlrstats.XlrstatsPlugin instance at 0x01C60C10>> (29901904) - 0s [0, 10, 20, 30, 40, 50]m -1h -1d -1M -1DOW'
120202 16:08:20   DEBUG   'Register Event: Stop Process: XlrstatscontrollerPlugin'
120202 16:08:20   DEBUG   'Register Event: Program Exit: XlrstatscontrollerPlugin'
120202 16:08:20   DEBUG   'Starting SubPlugin: XlrstatsControllerPlugin'
120202 16:08:20   DEBUG   'Register Event: Client Join Team: XlrstatscontrollerPlugin'
120202 16:08:20   DEBUG   'Register Event: Game Round Start: XlrstatscontrollerPlugin'
120202 16:08:20   BOT       'Starting Plugin awardsxlrstats'
120202 16:08:20   DEBUG   'Register Event: Client Authenticated: AwardsxlrstatsPlugin'
120202 16:08:20   INFO   'STDOUT \'Error: (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 \\\')) AND (xlr_playerstats.kills > 1000 OR xlr_playerstats.rounds > 50) AND xlr_pla\\\' at line 1")\\n  File "b3\\\\__init__.pyo", line 178, in start\\n  File "b3\\\\parser.pyo", line 460, in start\\n  File "b3\\\\parser.pyo", line 729, in startPlugins\\n  File "C:\\\\xampp\\\\FileZillaFTP\\\\BigBrotherBot\\\\extplugins\\\\awardsxlrstats.py", line 144, in onStartup\\n  File "C:\\\\xampp\\\\FileZillaFTP\\\\BigBrotherBot\\\\extplugins\\\\awardsxlrstats.py", line 283, in CalculAwards\\n  File "MySQLdb\\\\cursors.pyo", line 173, in execute\\n  File "MySQLdb\\\\connections.pyo", line 36, in defaulterrorhandler\\n\''
120202 16:08:20   INFO   "STDOUT '\\n'"
120202 16:08:34   BOT       'Shutting down...'
120202 16:08:34   VERBOSE   'AdvPlugin: Warning: No handle func for AdvPlugin'
120202 16:08:34   INFO   'StatusPlugin: B3 stop/exit.. updating status'
120202 16:08:34   DEBUG   'StatusPlugin: Writing XML status to C:\\xampp\\htdocs\\status\\status.xml'
120202 16:08:34   DEBUG   'XlrstatsPlugin: xlrstats.dumpEvent -- Type 2, Client None, Target None, Data '
120202 16:08:34   VERBOSE   'UrtbslapPlugin: Warning: No handle func for UrtbslapPlugin'
120202 16:08:34   VERBOSE   'HttpytailPlugin: Warning: No handle func for HttpytailPlugin'
120202 16:08:34   BOT       'Shutting down database connections...'


please help me!!

[MordyT]

Seems like you have a MySQL error for xlrstats tables.

I would dump the tables and reinsert them.
Easiest way to do this is execute the recreate-xlrstats.sql on the database.