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
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

I have imported the sql updates to the database about 5 times now, same error with xlrstats.

Share this post


Link to post
Share on other sites
Posted (edited)
2 hours ago, Rampage said:

I have imported the sql updates to the database about 5 times now, same error with xlrstats.

try using this but be aware its from version 1.9.2

recreate-xlrstats.sql

Edited by wkuzma

Share this post


Link to post
Share on other sites
22 hours ago, wkuzma said:

try using this but be aware its from version 1.9.2

recreate-xlrstats.sql 9.61 kB · 3 downloads

I imported the file to the database, and it took some of the previous errors away, but new errors appear and xlrstats doesn't load.

 

The new errors:

190821 21:59:39 ERROR    'Could not start plugin xlrstats'
Traceback (most recent call last):
  File "E:\cod4xservers\cod4xserver1b3\b3\parser.py", line 1096, in startPlugins
    start_plugin(self, plugin_name)
  File "E:\cod4xservers\cod4xserver1b3\b3\parser.py", line 1087, in start_plugin
    p.onStartup()
  File "E:\cod4xservers\cod4xserver1b3\b3\plugins\xlrstats\__init__.py", line 219, in onStartup
    self.save_Stat(player)
  File "E:\cod4xservers\cod4xserver1b3\b3\plugins\xlrstats\__init__.py", line 874, in save_Stat
    cursor = self.query(q)
  File "E:\cod4xservers\cod4xserver1b3\b3\storage\common.py", line 635, in query
    raise e
InternalError: (1054, u"Unknown column 'id_token' in 'field list'")

 

 

Share this post


Link to post
Share on other sites
1 hour ago, Rampage said:

I imported the file to the database, and it took some of the previous errors away, but new errors appear and xlrstats doesn't load.

 

The new errors:

190821 21:59:39 ERROR    'Could not start plugin xlrstats'
Traceback (most recent call last):
  File "E:\cod4xservers\cod4xserver1b3\b3\parser.py", line 1096, in startPlugins
    start_plugin(self, plugin_name)
  File "E:\cod4xservers\cod4xserver1b3\b3\parser.py", line 1087, in start_plugin
    p.onStartup()
  File "E:\cod4xservers\cod4xserver1b3\b3\plugins\xlrstats\__init__.py", line 219, in onStartup
    self.save_Stat(player)
  File "E:\cod4xservers\cod4xserver1b3\b3\plugins\xlrstats\__init__.py", line 874, in save_Stat
    cursor = self.query(q)
  File "E:\cod4xservers\cod4xserver1b3\b3\storage\common.py", line 635, in query
    raise e
InternalError: (1054, u"Unknown column 'id_token' in 'field list'")

 

 

check your b3 directories for sql files if you have them then use them.

Share this post


Link to post
Share on other sites
2 hours ago, Rampage said:

I got xlrstats working using b3 version 1.10.10 and trying a different parser.

 

Can you make a tutorial on that ? :)

Share this post


Link to post
Share on other sites

Nah, I don't do tutorials.

 

I did a few hours of "TBR". If you're wondering what that stands for, it stands for Test, Break, Repeat. 

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this