Tweet
Hello.
I am a user since vbulletin beta.
First time I have only one forum "test0"
Now version is 5.0.3, I added two forums on the same level.
The thing is test 0 forum list shows brother categories. But the other brother categories do not shows brothers.
I want, every forum is independent and do not show their brothers.
I guess, test 0 forum was defalut forum at beta version. that is why it shows brother categories.
I created new forum and moved children forums of test 0.
then error occured,
----------------------------------
An unexpected error was returned: ' Database error in vBulletin 5.0.3: Invalid SQL: UPDATE node AS node INNER JOIN closure AS cl ON (cl.parent = node.nodeid) INNER JOIN node AS child ON child.nodeid = cl.child SET child.starter = node.nodeid, child.routeid = WHERE node.nodeid in (42956) AND node.contenttypeid <> 23 /*moveNodes*/; 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 'WHERE node.nodeid in (42956) AND node.contenttypeid <> 23 /*moveNodes*/' at line 5 Error Number : 1064 Request Date : Friday, August 30th 2013 @ 04:45:08 PM Error Date : Friday, August 30th 2013 @ 04:45:09 PM Script : http:///admincp/forum.php?do=update Referrer : http://orumadmin.test.com/admincp/fo...o=edit&n=42956 IP Address : 000.00.00.000 Username : 00000 Classname : vB_Database_MySQLi MySQL Version : 5.5.32 '
----------------------------------
Anyway children forums moved.
The way that I used, is it OK?
I am a user since vbulletin beta.
First time I have only one forum "test0"
Now version is 5.0.3, I added two forums on the same level.
The thing is test 0 forum list shows brother categories. But the other brother categories do not shows brothers.
I want, every forum is independent and do not show their brothers.
I guess, test 0 forum was defalut forum at beta version. that is why it shows brother categories.
I created new forum and moved children forums of test 0.
then error occured,
----------------------------------
An unexpected error was returned: ' Database error in vBulletin 5.0.3: Invalid SQL: UPDATE node AS node INNER JOIN closure AS cl ON (cl.parent = node.nodeid) INNER JOIN node AS child ON child.nodeid = cl.child SET child.starter = node.nodeid, child.routeid = WHERE node.nodeid in (42956) AND node.contenttypeid <> 23 /*moveNodes*/; 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 'WHERE node.nodeid in (42956) AND node.contenttypeid <> 23 /*moveNodes*/' at line 5 Error Number : 1064 Request Date : Friday, August 30th 2013 @ 04:45:08 PM Error Date : Friday, August 30th 2013 @ 04:45:09 PM Script : http:///admincp/forum.php?do=update Referrer : http://orumadmin.test.com/admincp/fo...o=edit&n=42956 IP Address : 000.00.00.000 Username : 00000 Classname : vB_Database_MySQLi MySQL Version : 5.5.32 '
----------------------------------
Anyway children forums moved.
The way that I used, is it OK?
