Quote:
Originally Posted by hornstar1337
not sure why people will want to buy the pro version if you cant even get the lite version working for all. I am still getting the database error after installing the new version today.
Code:
Database error in vBulletin 3.8.1:
Invalid SQL:
SELECT usergroup.usergroupid, usergroup.title, usergroup.isstaff
COUNT(user.userid) AS membercount
FROM vb3_usergroup AS usergroup
LEFT JOIN vb3_user AS user ON (user.usergroupid = usergroup.usergroupid OR FIND_IN_SET(usergroup.usergroupid, user.membergroupids))
WHERE usergroup.isstaff = '1'
GROUP BY usergroup.usergroupid
ORDER BY usergroup.title ASC;
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 'COUNT(user.userid) AS membercount
FROM vb3_usergroup AS usergroup
LEFT JOIN vb' at line 2
Error Number : 1064
Request Date : Saturday, February 28th 2009 @ 06:04:30 PM
Error Date : Saturday, February 28th 2009 @ 06:04:30 PM
Script : http://www..net/forums/staff.php
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.67-community
|
I Got that Same Error Too.
I thin is Important for Hasann to Get this Last Version 3.2 Working to Successfully Lauch His Pro Version; this is the FrontPage for Users to Motivate to Acquire the Pro One.
My Best Regards.