next »

[tim967]

Hey all, just tried installing the follow suspicious players plugin, created the table and imported both follow.sql and addreason.sql and then added it to the config list. When i type !syncfollow ingame or any of the commands it says there was a problem processing the command and shows this error. Anyone got any ideas?

Code:

110328 11:42:48 DEBUG FollowPlugin: Syncing list
110328 11:42:48 DEBUG FollowPlugin: Lookup for UKGM | Tim967
110328 11:42:48 ERROR Query failed - <class '_mysql_exceptions.OperationalError'>: (1054, "Unknown column 'client_id' in 'field list'")
110328 11:42:48 ERROR STDERR Exception in thread Thread-13:
Traceback (most recent call last):
  File "/usr/lib/python2.6/threading.py", line 532, in __bootstrap_inner
    self.run()
  File "/usr/lib/python2.6/threading.py", line 736, in run
    self.function(*self.args, **self.kwargs)
  File "/usr/local/lib/python2.6/dist-packages/b3-1.4.1-py2.6.egg/b3/extplugins/follow.py", line 120, in sync_list
    self._add_list(c)
  File "/usr/local/lib/python2.6/dist-packages/b3-1.4.1-py2.6.egg/b3/extplugins/follow.py", line 185, in _add_list
    if cursor.rowcount > 0:
AttributeError: 'NoneType' object has no attribute 'rowcount'

[TmR]

Hey all, just tried installing the follow suspicious players plugin, created the table and imported both follow.sql and addreason.sql and then added it to the config list. When i type !syncfollow ingame or any of the commands it says there was a problem processing the command and shows this error. Anyone got any ideas?

Code:

110328 11:42:48 DEBUG FollowPlugin: Syncing list
110328 11:42:48 DEBUG FollowPlugin: Lookup for UKGM | Tim967
110328 11:42:48 ERROR Query failed - <class '_mysql_exceptions.OperationalError'>: (1054, "Unknown column 'client_id' in 'field list'")
110328 11:42:48 ERROR STDERR Exception in thread Thread-13:
Traceback (most recent call last):
  File "/usr/lib/python2.6/threading.py", line 532, in __bootstrap_inner
    self.run()
  File "/usr/lib/python2.6/threading.py", line 736, in run
    self.function(*self.args, **self.kwargs)
  File "/usr/local/lib/python2.6/dist-packages/b3-1.4.1-py2.6.egg/b3/extplugins/follow.py", line 120, in sync_list
    self._add_list(c)
  File "/usr/local/lib/python2.6/dist-packages/b3-1.4.1-py2.6.egg/b3/extplugins/follow.py", line 185, in _add_list
    if cursor.rowcount > 0:
AttributeError: 'NoneType' object has no attribute 'rowcount'

I ready this:
FollowPlugin: Lookup for UKGM | Tim967
ERROR   Query failed - <class '_mysql_exceptions.OperationalError'>: (1054, "Unknown column 'client_id' in 'field list'")
So it seems that there is no column client_id in the sql table it's trying to use.
Check your mysql DB

[tim967]

i've had a look and cant find it either. Surely when i import the following.sql and the reason sql file it should create them? any ideas where it needs creating/what table it goes in.

[TmR]

i've had a look and cant find it either. Surely when i import the following.sql and the reason sql file it should create them? any ideas where it needs creating/what table it goes in.

it should be there?!?

Code: plsql

CREATE TABLE IF NOT EXISTS `following` (
  `id` int(11) NOT NULL auto_increment,
  `client_id` int(11) NOT NULL,
  `admin_id` int(11) NOT NULL,
  `time_add` int(11) NOT NULL,
  `reason` varchar(100) default NULL,
  PRIMARY KEY  (`id`),
  KEY `following_client_id` (`client_id`),
  KEY `following_admin_id` (`admin_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

is the code from following.sql
check that table

[rubens116]

If I'm right and if I still can remember, there was only one file you had to import in : SQL > b3 > import.

[TmR]

If I'm right and if I still can remember, there was only one file you had to import in : SQL > b3 > import.

i believe so yes.

[Sona]

gotta import

xlrstats.sql
B3.sql
b3-db.sql
b3-update-v1.3.sql
xlrstats-update-to-v2.0.0.sql

u can always try to make a new database, change it in ur xml files, then import thse sql files, and see what it sez