The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
MySQL Help Please?
I received this email
Code:
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/ |
#2
|
||||
|
||||
replace
Code:
FROM vb3_thread Code:
FROM vb3_thread AS thread |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|