I deleted the queries and did a fresh install of the mod. Admin center works great, but when I try to go to my index page I get this:
Code:
Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity, session.location session.location,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM vb3session AS session
LEFT JOIN vb3user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1118714670
ORDER BY username 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 '.location,
IF(displaygroupid=0, user.usergroupid, displaygro
mysql error number: 1064
Date: Monday 13th of June 2005 09:19:30 PM
Script: http://gothicgaming.com/forum/index.php?
Referer: http://gothicgaming.com/forum/index.php?
Username: John
IP Address: xx.xx.xx.xx
I can get into the portal page and into the catagories and forums no problem, but when I try to go to the index.php I get the above.
Help!!!