I managed to fix the install script, made all the code hacks and got this error on the initial run:
Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT DISTINCT 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 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 1
ORDER BY lastedit desc
LIMIT 0, 20
mysql error: Unknown table 'user' in field list
mysql error number: 1109
The code appears to not handle tables with a prefix very well. The code really needs to be gone through well before another release.
|