Announcement

Collapse
No announcement yet.

Moving Channels within Channel Manager ACP = DB errors

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

  • Moving Channels within Channel Manager ACP = DB errors

    When attempting to move channels within the channel manager of ACP (i.e. not the site builder) I received a variety of d/b errors.

    I'll list them below for your inspection...

    Code:
    Database error in vBulletin 5.2.2:
    
                            Invalid SQL:
    
                                    INSERT INTO vbclosure (parent, child, depth, publishdate)
                                            SELECT cl2.parent, 163, cl2.depth + 1, node.publishdate
                                            FROM vbclosure AS cl2 INNER JOIN
                                                    vbnode AS node
                                            WHERE cl2.child = 23 AND node.nodeid = 163
    
    /**insertMovedNodeClosureRecords**/;
    
                            MySQL Error   : Duplicate entry '23-163' for key 'closure_uniq'
                            Error Number  : 1062
                            Request Date  : Sunday, July 17th 2016 @ 04:07:47 PM
                            Error Date    : Sunday, July 17th 2016 @ 04:07:58 PM
                            Script        : http:///admincp/forum.php?do=update
                            Referrer      : http://antimisandry.com/admincp/forum.php?do=edit&n=163
                            IP Address    : *removed*
                            Username      : *removed*
                            Classname     : vB_Database_MySQLi
                            MySQL Version : 5.5.50
    Code:
    Database error in vBulletin 5.2.2:
    
                            Invalid SQL:
    
                                    INSERT INTO vbclosure (parent, child, depth, publishdate)
                                            SELECT cl2.parent, 143, cl2.depth + 1, node.publishdate
                                            FROM vbclosure AS cl2 INNER JOIN
                                                    vbnode AS node
                                            WHERE cl2.child = 23 AND node.nodeid = 143
    
    /**insertMovedNodeClosureRecords**/;
    
                            MySQL Error   : Duplicate entry '23-143' for key 'closure_uniq'
                            Error Number  : 1062
                            Request Date  : Sunday, July 17th 2016 @ 03:54:57 PM
                            Error Date    : Sunday, July 17th 2016 @ 03:55:06 PM
                            Script        : http:///admincp/forum.php?do=update
                            Referrer      : http://antimisandry.com/admincp/foru...990eaa0be36b2b
                            IP Address    : *removed*
                            Username      : *removed*
                            Classname     : vB_Database_MySQLi
                            MySQL Version : 5.5.50
    Code:
    Database error in vBulletin 5.2.2:
    
                            Invalid SQL:
    
                                    INSERT INTO vbclosure (parent, child, depth, publishdate)
                                            SELECT cl2.parent, 158, cl2.depth + 1, node.publishdate
                                            FROM vbclosure AS cl2 INNER JOIN
                                                    vbnode AS node
                                            WHERE cl2.child = 23 AND node.nodeid = 158
    
    /**insertMovedNodeClosureRecords**/;
    
                            MySQL Error   : Duplicate entry '23-158' for key 'closure_uniq'
                            Error Number  : 1062
                            Request Date  : Sunday, July 17th 2016 @ 03:53:49 PM
                            Error Date    : Sunday, July 17th 2016 @ 03:54:01 PM
                            Script        : http:///admincp/forum.php?do=update
                            Referrer      : http://antimisandry.com/admincp/forum.php?do=edit&n=158
                            IP Address    : *removed*
                            Username      : *removed*
                            Classname     : vB_Database_MySQLi
                            MySQL Version : 5.5.50
    Code:
    Database error in vBulletin 5.2.2:
    
                            Invalid SQL:
    
                                    INSERT INTO vbclosure (parent, child, depth, publishdate)
                                            SELECT cl2.parent, 157, cl2.depth + 1, node.publishdate
                                            FROM vbclosure AS cl2 INNER JOIN
                                                    vbnode AS node
                                            WHERE cl2.child = 23 AND node.nodeid = 157
    
    /**insertMovedNodeClosureRecords**/;
    
                            MySQL Error   : Duplicate entry '23-157' for key 'closure_uniq'
                            Error Number  : 1062
                            Request Date  : Sunday, July 17th 2016 @ 03:53:08 PM
                            Error Date    : Sunday, July 17th 2016 @ 03:53:24 PM
                            Script        : http:///admincp/forum.php?do=update
                            Referrer      : http://antimisandry.com/admincp/forum.php?do=edit&n=157
                            IP Address    : *removed*
                            Username      : *removed*
                            Classname     : vB_Database_MySQLi
                            MySQL Version : 5.5.50
    Along with a series of similar email reports.
    VB 5.4.1 - PHP 7..2.4 - MySQL 5.5.56
    No Addons - none at all.

  • #2
    bump
    VB 5.4.1 - PHP 7..2.4 - MySQL 5.5.56
    No Addons - none at all.

    Comment


    • #3
      Which channel are you trying to move, and where to?
      MARK.B | vBULLETIN SUPPORT

      TalkNewsUK - My vBulletin 5.6.1 Demo
      AdminAmmo - My Cloud Demo

      Comment


      • #4
        Child forums to other parent forums

        So let's say I have something alike to...

        11111channel11111
        ----111child-forum-aaaa1111
        ----1111child-forum-bbbb1111
        2222channel2222
        --2222child-forum-aaa222
        --2222child-forum-bbb222

        When I attempt to move channel 2222child-forum-bbb222 over to 1111channel1111 it causes the aforementioned issues.
        VB 5.4.1 - PHP 7..2.4 - MySQL 5.5.56
        No Addons - none at all.

        Comment

        Related Topics

        Collapse

        Working...
        X