Tweet
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 25: 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 (15) 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 (15) AND node.contenttypeid <> 23 /**moveNodes**/' at line 5 Error Number : 1064 Request Date : Wednesday, January 16th 2013 @ 06:36:21 AM Error Date : Wednesday, January 16th 2013 @ 06:36:21 AM Script : http:///forum/admincp/forum.php?do=update Referrer : http://www.myforum.com/forum/admincp...p?do=edit&n=15 IP Address : 108.108.108.108 Username : admin Classname : vB_Database_MySQL MySQL Version : 5.5.28-cll '
This is on beta 25
An unexpected error was returned: ' Database error in vBulletin 5.0.0 Beta 25: 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 (15) 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 (15) AND node.contenttypeid <> 23 /**moveNodes**/' at line 5 Error Number : 1064 Request Date : Wednesday, January 16th 2013 @ 06:36:21 AM Error Date : Wednesday, January 16th 2013 @ 06:36:21 AM Script : http:///forum/admincp/forum.php?do=update Referrer : http://www.myforum.com/forum/admincp...p?do=edit&n=15 IP Address : 108.108.108.108 Username : admin Classname : vB_Database_MySQL MySQL Version : 5.5.28-cll '
This is on beta 25
Comment