Status
Not open for further replies.

Trekkan

Customer
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 :
 
Confirmed. For a quick fix make the following edit:

Open: ./dbtech/vbactivity/includes/class_profileblock.php
Find:
Code:
$sorttype = 'username';
Add beneath:
Code:
$sqlsort = 'username';
Save/upload the file, should all be good then. I'll let Bel apply the patch when he's awake :)
 
Last edited by a moderator:
Status
Not open for further replies.

Legacy vBActivity & Awards

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
1,730
Customer rating
0.00 star(s) 0 ratings
Back
Top