Announcement

Collapse
No announcement yet.

SQL Error in Forum Manager

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

  • SQL Error in Forum Manager

    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: '
                 Database error in vBulletin 5.0.0 Beta 28:
                  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 (19) 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 (19) AND node.contenttypeid  <> 23 /**moveNodes**/' at line 5
                 Error Number  : 1064
                 Request Date  : Thursday, February 7th 2013 @ 06:22:41 PM
                 Error Date    : Thursday, February 7th 2013 @ 06:22:42 PM
                 Script        : http:///admincp/forum.php?do=update
                 Referrer      :  http://www.xxxxx.de/admincp/forum.php?do=edit&n=19&
                  IP Address    : xxx.xxx.58.9
                 Username      : Maik Storck
                 Classname     : vB_Database_MySQL
                 MySQL Version : 5.1.66-0+squeeze1
             '
    Had this error with beta26 and now with beta28.

  • #2
    When you got the error in beta 26, did you enter it into Jira? And is it now marked as fixed in beta 28?

    What Server OS? What version of PHP?

    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


    • #3
      Originally posted by Lynne View Post
      When you got the error in beta 26, did you enter it into Jira? And is it now marked as fixed in beta 28?
      No, I did not. I will do it now.

      Originally posted by Lynne View Post
      What Server OS? What version of PHP?
      Linux, Tested PHP 5.4 and 5.3

      Comment


      • #4
        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