Announcement

Collapse
No announcement yet.

SQL error when moving a forum

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL error when moving a forum

    Moving a forum from one category to another results in the following error inside a "vBulletin Message":

    Code:
    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 '
    


    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

  • #2
    It's a known issue.

    http://tracker.vbulletin.com/browse/VBV-7057

    vBulletin QA - vBulletin Support French - Lead Project Tools developer

    Next release? Soon(tm)

    Comment

    Related Topics

    Collapse

    Working...
    X