It's a known issue.
http://tracker.vbulletin.com/browse/VBV-7057
-
SQL error when moving a forum
Moving a forum from one category to another results in the following error inside a "vBulletin Message":
Code:[COLOR=#262D35][FONT=Arial]An unexpected error was returned: ' Database error in vBulletin 5.0.0 Beta 26: 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 (30) 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 (30) AND node.contenttypeid <> 23 /**moveNodes**/' at line 5 Error Number : 1064 Request Date : Monday, January 28th 2013 @ 11:01:51 AM Error Date : Monday, January 28th 2013 @ 11:01:52 AM Script : http:///admincp/forum.php?do=update Referrer : http://new.ragga-jungle.com/admincp/forum.php?s=censored&do=edit&n=30 IP Address : 66.244.223.110 Username : rhygin Classname : vB_Database_MySQL MySQL Version : 5.1.66-0+squeeze1 ' [/FONT][/COLOR]
When I reload the Forum Manager the forum has been moved to the new category. When I visit the site the forum has also been moved to the new category, however the URL hasn't been updated. I.E. If the URL was /forum/general/test and I moved it to the category "Test Category" then I'd expect the URL to change to /forum/test-category/test, but it remains /forum/general/test.
vbulletin 5.0.0 beta 26
-
Hello,
When converting a forum to a category via Channel Management / Forum Manager it takes effect, but it gives this error first :
...PHP Code:An unexpected error was returned: ' Database error in vBulletin
Sun 3 Mar '13, 7:23am -
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...Fri 30 Aug '13, 12:21am -
Hi,
when I try to move a Forum from one category to another (admincp>Channel Management>Forum Manager) I get this error:
...Code:An unexpected error was returned: '
Thu 7 Feb '13, 8:32am -
When re-assigning a forum to a parent category I got the error message below. However, it still seemed to work.
An unexpected error was returned: ' Database error in vBulletin 5.0.0 Beta...Tue 15 Jan '13, 9:21pm -
When I want to move a forum from a category to another generates me this error:
...Code:[COLOR=#262D35][FONT=Arial][SIZE=12px]An unexpected error was returned: ' Database error in vBulletin 5.0.3: Invalid SQL: UPDATE node AS node INNER[/][/][/]
Thu 11 Jul '13, 4:49pm
Leave a comment: