problem appears to be the syntax...not the mod.
try this
in line -> SELECT DISTINCT user.username, session.useragent,user.userid
there sud be a space between "session.useragent," AND "user.userid"
like below:
SELECT DISTINCT user.username, session.useragent, user.userid
Quote:
Originally Posted by shadiguy1
this is what i get when i install it.
Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT DISTINCT user.username, session.useragent,user.userid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM session AS session
LEFT JOIN user AS user USING (userid)
WHERE session.lastactivity >
ORDER BY session.userid
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 'ORDER BY session.userid' at line 7
mysql error number: 1064
Date: Thursday 10th of February 2005 08:46:21 AM
Script: http://nextelelite.com/forums/index.php?
Referer: http://nextelelite.com/
Username: Shadiguy1
IP Address: 205.188.116.7
|