Announcement

Collapse
No announcement yet.

Changing forum to category gives error

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

  • Changing forum to category gives error

    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 5.0.0: Invalid SQL: UPDATE vb_node AS node INNER JOIN vb_closure AS cl ON (cl.parent = node.nodeid) INNER JOIN vb_node AS child ON child.nodeid = cl.child SET child.starter = node.nodeid, child.routeid = WHERE node.nodeid in (20) 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 (20) AND node.contenttypeid <> 23 /**moveNodes**/' at line 5 Error Number : 1064 Request Date : Sunday, March 3rd 2013 @ 10:20:14 AM Error Date : Sunday, March 3rd 2013 @ 10:20:15 AM Script : http:///admincp/forum.php?do=update Referrer : http://www.fishingbb.com/admincp/forum.php?do=edit&n=20&s=9e8ead376bde3965d48db8ee48a7baf0 IP Address : 62.241.123.22 Username : Mup Classname : vB_Database_MySQLi MySQL Version : 5.5.29-29.4 ' 

  • #2
    There is a bug report for this here - http://tracker.vbulletin.com/browse/VBV-7057

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools &lt;- awesome site for html/css help

    Comment

    Related Topics

    Collapse

    • mrwhitee
      error in forum manager
      by mrwhitee
      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, 10:21pm
    • Maik Storck
      SQL Error in Forum Manager
      by Maik Storck
      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, 9:32am
    • rhygin
      SQL error when moving a forum
      by rhygin
      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[/][/]
      ...
      Mon 28 Jan '13, 8:05am
    • sergiomc
      Error to move forums
      by sergiomc
      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, 5:49pm
    • z-at-ox
      Error after upded to 5.0.2
      by z-at-ox
      This is the error, when I use the page manager.

      Error: An unexpected error was returned: ' Database error in vBulletin 5.0.2: Invalid SQL: UPDATE node AS node INNER JOIN closure AS cl ON...
      Thu 9 May '13, 12:50pm
    Working...
    X