Sign in to follow this  
ZOMBIE

B3 with XLRstats plugin

Recommended Posts

Hello everyone and happy new year 😘
Im running 3 "COD4" servers on COD4x client, the servers is up on master server.
But I have a problem with B3 1.12 (latest version), the XLRstats plugin won't to load up
.
Screenshot-1.png  

that's the error message from b3 logs: 
 

190103 02:14:04 ERROR    'Query failed [ALTER TABLE `xlr_playerstats` ADD `id_token` VARCHAR(10) NOT NULL DEFAULT \'\'] None: (1060, u"Duplicate column name \'id_token\'")'
190103 02:14:04 ERROR    'Query failed [SELECT MAX(xlr_playerstats.skill) AS max_skill, MIN(xlr_playerstats.skill) AS min_skill, SUM(xlr_playerstats.skill) AS sum_skill,\n               AVG(xlr_playerstats.skill) AS avg_skill , COUNT(xlr_playerstats.id) AS cnt\n               FROM xlr_playerstats, clients\n               WHERE clients.id = xlr_playerstats.client_id\n               AND xlr_playerstats.client_id <> None\n               AND (xlr_playerstats.kills + xlr_playerstats.deaths) > 50\n               AND 1546481644 - clients.time_edit <= 5184000] None: (1054, u"Unknown column \'None\' in \'where clause\'")'
190103 02:14:04 ERROR    'Could not start plugin xlrstats'
Traceback (most recent call last):
  File "C:\Users\almumarga23\Desktop\Cod4-bestcod4maps\b3\b3\parser.py", line 948, in startPlugins
    start_plugin(self, plugin_name)
  File "C:\Users\almumarga23\Desktop\Cod4-bestcod4maps\b3\b3\parser.py", line 939, in start_plugin
    p.onStartup()
  File "C:\Users\almumarga23\Desktop\Cod4-bestcod4maps\b3\b3\plugins\xlrstats\__init__.py", line 257, in onStartup
    self.correctStats()
  File "C:\Users\almumarga23\Desktop\Cod4-bestcod4maps\b3\b3\plugins\xlrstats\__init__.py", line 1558, in correctStats
    cursor = self.query(q)
  File "C:\Users\almumarga23\Desktop\Cod4-bestcod4maps\b3\b3\storage\common.py", line 635, in query
    raise e
InternalError: (1054, u"Unknown column 'None' in 'where clause'")


btw I'm using this parser Cod4X18 and latest cod4x version and latest patch + fresh b3 database.

thanks in advance 

 

Share this post


Link to post
Share on other sites

wrong forum. topic moved.

Share this post


Link to post
Share on other sites
xlr_playerstats.client_id <> None

None should be a string literal probably. i suppose your mysql database version is too new. 

Share this post


Link to post
Share on other sites
9 hours ago, dpj said:

xlr_playerstats.client_id <> None

None should be a string literal probably. i suppose your mysql database version is too new. 

I will try to use older versions

Share this post


Link to post
Share on other sites

now that i think about it again. it's probably an error generated in the python program as None is used as a null-value in python. probably not the mysql server version then.

Share this post


Link to post
Share on other sites
On 1/3/2019 at 8:00 PM, dpj said:

now that i think about it again. it's probably an error generated in the python program as None is used as a null-value in python. probably not the mysql server version then.

So its a normal error ?

Share this post


Link to post
Share on other sites

i suppose your database tables for xlrstats are set up incorrectly. i dont use b3 or xlrstats, i'm just guessing. this is the cod4x forum afterall 😛 

Share this post


Link to post
Share on other sites
6 hours ago, dpj said:

i suppose your database tables for xlrstats are set up incorrectly. i dont use b3 or xlrstats, i'm just guessing. this is the cod4x forum afterall 😛 

 

11 hours ago, ZOMBIE said:

So its a normal error ?

I would not say its a normal error  in your b3 setup there is a directory called sql  did you do all the updates in that directory for your data base even if some failed?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this