[sense1]

I'm getting an error message when I load the mod. This happens even though I set the user profile field to '7', as this seems to be the common cause for errors like this. Any ideas? The user.lastvisit entry looks a bit suspect but then, I know nothing about SQL...

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
`user` AS user
LEFT JOIN
`userfield` AS userfield ON (user.userid = userfield.userid)
LEFT JOIN
`gxboxlive` AS gxboxlive ON (userfield.userid = gxboxlive.userid)
WHERE
user.usergroupid NOT IN()

AND
field7 != ''
AND
user.posts >= '0'
AND
user.lastvisit >= '1170334536'
AND
gxboxlive.strikes = '0'
AND
gxboxlive.score >= '1';

MySQL Error : 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
field7 != ''
AND
user.posts >= '0'
AND
user.lastvisit' at line 13
Error Number : 1064
Date : Friday, February 1st 2008 @ 04:55:35 AM
Script : http://www.insensatez.com/forum/index.php
Referrer : http://www.insensatez.com/forum/admi...ex.php?do=head
IP Address : x.x.x.x
Username : xxx
Classname : vb_database

I've disabled the plugin for now until I can resolve this.