Tried to to a fresh upgrade and got this error:
I did a backup of my prod 4.2.2 db via ssh and restored to test via ssh. I didn't drop the old database, would that have caused the issue? I assumed that the restore would have overwritten the old db.
Action Required
Unexpected Text:
<?xml version="1.0" encoding="windows-1252"?> Database error in vBulletin 5.0.0 Alpha 27: Invalid SQL: INSERT INTO text(nodeid, rawtext) SELECT node.nodeid, pmtext.message FROM pmtext AS pmtext INNER JOIN node AS node ON node.oldid = pmtext.pmtextid AND oldcontenttypeid = 9981 WHERE node.oldid > 0 AND node.oldid < (0 + 2000 + 1) /**importPMText**/; MySQL Error : Duplicate entry '133925' for key 'PRIMARY' Error Number : 1062 Request Date : Tuesday, April 8th 2014 @ 10:51:42 PM Error Date : Tuesday, April 8th 2014 @ 10:51:43 PM Script : http:///forum/core/install/upgrade.php Referrer : http://dev.shrimpkeepersforum.com/fo...ll/upgrade.php IP Address : 147.209.216.245 Username : Classname : vB_Database_MySQL MySQL Version : 5.1.73-cll
<?xml version="1.0" encoding="windows-1252"?> Database error in vBulletin 5.0.0 Alpha 27: Invalid SQL: INSERT INTO text(nodeid, rawtext) SELECT node.nodeid, pmtext.message FROM pmtext AS pmtext INNER JOIN node AS node ON node.oldid = pmtext.pmtextid AND oldcontenttypeid = 9981 WHERE node.oldid > 0 AND node.oldid < (0 + 2000 + 1) /**importPMText**/; MySQL Error : Duplicate entry '133925' for key 'PRIMARY' Error Number : 1062 Request Date : Tuesday, April 8th 2014 @ 10:51:42 PM Error Date : Tuesday, April 8th 2014 @ 10:51:43 PM Script : http:///forum/core/install/upgrade.php Referrer : http://dev.shrimpkeepersforum.com/fo...ll/upgrade.php IP Address : 147.209.216.245 Username : Classname : vB_Database_MySQL MySQL Version : 5.1.73-cll
I did a backup of my prod 4.2.2 db via ssh and restored to test via ssh. I didn't drop the old database, would that have caused the issue? I assumed that the restore would have overwritten the old db.
Comment