The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
What's wrong....
What's wrong with the following SQL query?
Code:
SELECT forum.*, forumpermission.canpost, forumpermission.canview FROM forum LEFT JOIN forum ON forum.forumid=forumpermission.forumid WHERE forum.displayorder<>0 AND forum.active=1 AND forum.isnews=1 AND forumpermission.usergroupid='$bbuserinfo[usergroupid]' ORDER BY forum.parentid,forum.displayorder Code:
Not unique table/alias: 'forum' |
#2
|
||||
|
||||
You are JOINing the forum table to itself without giving them an alias. That's the error, but in your code LEFT JOIN forum should be LEFT JOIN forumpermission.
|
#3
|
|||
|
|||
Quote:
Now I'm getting a parse error here.... Code:
$threads=DB_site->query("SELECT threadid,forumid,dateline FROM thread WHERE $forumids ORDER BY dateline DESC"); |
#4
|
||||
|
||||
$threads=$DB_site->
|
#5
|
|||
|
|||
Quote:
Thanks. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|