Tweet
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...
Along with a series of similar email reports.
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
Comment