[fattony69]

Originally Posted by Gryphon

@harlita, there is a not about the field id change in the upgrade notice above. I also do not like to distribute readme's as they are too static and I can't make adjustments to them once they are out the door, not to mention another document to keep updated. The instructions above should get any new user through ok.

@fatony69, there shouldn't be anything that prevents you from accessing the admincp. However, in the event a plugin causes such an issue, you can add define('DISABLE_HOOKS', true); to your config.php to disable plugins while you troubleshoot the problem.

Actually upon reflection, there could be a problem with the script in this regard. I will double check this.

@doogie1775, Reputation 10 is about 2.5 stars. There is a max of 20 reputation, so 10 rep is half of 5 stars which is 2.5.

I have it disabled like you said and still recieve this. I like this addon, so I don't mind doing this extra work


Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT
COUNT(user.userid) AS `usercount`,
SUM(gxboxlive.score) AS `score`,
SUM(gxboxlive.reputation) AS `reputation`,
SUM(gxboxlive.gold) AS `gold`
FROM
`gpuser` AS user
LEFT JOIN
`gpuserfield` AS userfield ON (user.userid = userfield.userid)
LEFT JOIN
`gpgxboxlive` AS gxboxlive ON (userfield.userid = gxboxlive.userid)
WHERE
user.usergroupid NOT IN(8)

AND
field0 != ''
AND
user.posts >= '10'
AND
user.lastvisit >= '0'
AND
gxboxlive.strikes = '0'
AND
gxboxlive.score >= '1';

MySQL Error : Unknown column 'field0' in 'where clause'
Error Number : 1054
Date : Friday, January 25th 2008 @ 10:10:32 PM
Script : http://www.gamerspride.com/phpBB2/online.php
Referrer : http://www.gamerspride.com/phpBB2/online.php
IP Address : **********
Username : ********
Classname : vb_database