SQL Error

[Trekkan]

Just saw two of these pop up. Hope it's enough to help you find the problem.

Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT
dbtech_vbactivity_points AS points,
(
SELECT SUM(points) AS newpoints
FROM dhv_dbtech_vbactivity_pointslog AS pointslog
WHERE userid = user.userid
AND points > 0
) AS newpoints,
userid,
username,
user.usergroupid,
infractiongroupid,
displaygroupid
FROM dhv_user AS user
LEFT JOIN dhv_usergroup AS usergroup ON (usergroup.usergroupid = user.usergroupid)
WHERE (usergroup.genericoptions & 32)
ORDER BY asc
LIMIT 0, 20;

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 'asc
LIMIT 0, 20' at line 17
Error Number : 1064
Request Date : Wednesday, March 3rd 2010 @ 10:28:04 PM
Error Date : Wednesday, March 3rd 2010 @ 10:28:04 PM
Script : http://www.darkhandofvalor.com/vbac...=1&perpage=25&sorttype=username&sortorder=asc
Referrer : http://www.darkhandofvalor.com/vbactivity.php
IP Address : XXXXXXXXX
Username : Angryrabbit
Classname : vB_Database
MySQL Version :

 

[Deceptor]

Confirmed. For a quick fix make the following edit:

Open: ./dbtech/vbactivity/includes/class_profileblock.php
Find:

$sorttype = 'username';

Add beneath:

$sqlsort = 'username';

Save/upload the file, should all be good then. I'll let Bel apply the patch when he's awake

 

[Fillip H.]

Fixed for v1.1, thanks

 

[Trekkan]

Works good, thanks for the fix guys!

 

[Deceptor]

No problem Let us know if you have any further issues!