Donate to the B3 fund!

"even a small donation helps!"
Donate with PayPal!
Most of the plugins here are made by B3 users and the authors may not visit frequently. If you need support for plugins or if questions remain unanswered, you will have to contact the author directly. Read the full Support Disclaimer here

NOTE: Do not attach plugins to your forumtopics! Attachements are periodically removed by maintenance tasks. Upload your plugins to our Downloads section instead!

Author Topic: i have problems with xlrstats Error: 1064  (Read 1963 times)

Offline dots

  • Jr. Member
  • **
  • Posts: 17
  • live your life...
i have problems with xlrstats Error: 1064
« on: February 02, 2012, 10:48:59 PM »
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!!
« Last Edit: February 02, 2012, 10:50:51 PM by dots »

Offline MordyT

  • Support Hero
  • Hero Member
  • *
  • Posts: 3644
  • Over $300 Donated to B3!
    • MordyT
Re: i have problems with xlrstats Error: 1064
« Reply #1 on: February 02, 2012, 11:42:41 PM »
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.
Help will be given to those with a b3.log

If drop off the map it is due to RL becoming busy :)

System: Python 2.7.3 - Deb 7 - B3 Source Code - 128MB RAM box (rented at $5 a year) - remote MySQL - Remote Web Services

 


Rate this page +1 at Google Search