Ntenze
06-06-2004, 03:43 PM
I received this email
Database error in vBulletin 3.0.1:
Invalid SQL:
SELECT count(threadid) AS articles,
SUM(IF(lastpost>=1086532361 AND open<>10,1,0)) AS newarticle
FROM vb3_thread
LEFT JOIN vb3_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE forumid IN (3)
AND visible = 1
AND open != 10
AND deletionlog.primaryid IS NULL
mysql error: Unknown table 'thread' in on clause
mysql error number: 1109
Date: Sunday 06th of June 2004 04:35:40 PM
Script: http://www.forthebayarea.com/
I can clear all cookies etc. and go back to site with no problems. Others seem to get DB error. Thanks in advance for any help
Database error in vBulletin 3.0.1:
Invalid SQL:
SELECT count(threadid) AS articles,
SUM(IF(lastpost>=1086532361 AND open<>10,1,0)) AS newarticle
FROM vb3_thread
LEFT JOIN vb3_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE forumid IN (3)
AND visible = 1
AND open != 10
AND deletionlog.primaryid IS NULL
mysql error: Unknown table 'thread' in on clause
mysql error number: 1109
Date: Sunday 06th of June 2004 04:35:40 PM
Script: http://www.forthebayarea.com/
I can clear all cookies etc. and go back to site with no problems. Others seem to get DB error. Thanks in advance for any help