View Single Post
Old January 23rd, 2005, 11:02 PM   #9 (permalink)
storm5956
Member
Verified Customer
 
Join Date: Nov 2003
Location: Somewhere above TX
Posts: 35
Here's my error. It's looking for a table that's not there. Any ideas? I know it's something simple but I must be tired.....

Invalid SQL:
SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM vb3_session AS session
LEFT JOIN vb3_user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1106541779
ORDER BY username ASC

mysql error: Table 'photopost.vb3_session' doesn't exist
storm5956 is offline   Reply With Quote