Well, brother, we still arn't out of the woods yet. If you add a bug, either through the AdminCP or in the forums, everything seems to work fine until you click on it to read it. Then a HUGE big db error occurs:
Quote:
Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT vbug_severity.severityname, vbug_type.typename, vbug_version.versionname, vbug_status.statusname ,vbugs.*, admin.username AS adminname, user.username, user.usertitle, lastreply.username AS lastreplyname
FROM vbugs
LEFT JOIN vbug_status ON (vbugs.vbug_statusid = vbug_status.vbug_statusid)
LEFT JOIN vb3_user AS admin ON (vbugs.adminid = admin.userid)
LEFT JOIN vb3_user AS user ON (vbugs.userid = user.userid
LEFT JOIN vb3_user AS lastreply ON (vbugs.lastreplyuid = lastreply.userid)
LEFT JOIN vbug_type ON (vbugs.vbug_typeid = vbug_type.vbug_typeid)
LEFT JOIN vbug_version ON (vbugs.vbug_versionid = vbug_version.vbug_versionid)
LEFT JOIN vbug_severity ON (vbugs.vbug_severityid = vbug_severity.vbug_severityid)
WHERE vbugs_id = 2
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 'LEFT JOIN vb3_user AS lastreply ON (vbugs.lastreplyuid = lastre
mysql error number: 1064
|