Error when attempting to upgrade forums

[cptbogo]

An error has occurred with your database. Please contact vBulletin Support for assistance.
Module: 500a23, Step 2 Database Error:1064
Query:

UPDATE setting SET value = value | WHERE varname = 'defaultregoptions'



Does anyone know how to get around this issue? Edit: I hit refresh as some people said to do on another topic and got this error.


<?xml version="1.0" encoding="windows-1252"?>
<br />
<b>Fatal error</b>: Uncaught
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 &gt; 0 AND node.oldid &lt; (0 + 2000 -1)
/**importPMText**/;
MySQL Error : Duplicate entry '55904' for key 'PRIMARY'
Error Number : 1062
Request Date : Sunday, September 16th 2012 @ 01:47:40 PM
Error Date : Sunday, September 16th 2012 @ 01:47:40 PM
Script : http:///forums/core/install/upgrade.php
Referrer : http://feverclan.com/forums/core/install/upgrade.php
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.1.63-cll
thrown in <b>/home/feverc5/public_html/forums/core/vb/database.php</b> on line <b>1073</b><br />

[simonhind]

An error has occurred with your database. Please contact vBulletin Support for assistance.
Module: 500a23, Step 2 Database Error:1064
Query:

UPDATE setting SET value = value | WHERE varname = 'defaultregoptions'



Does anyone know how to get around this issue? Edit: I hit refresh as some people said to do on another topic and got this error.


<?xml version="1.0" encoding="windows-1252"?>
<br />
<b>Fatal error</b>: Uncaught
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 &gt; 0 AND node.oldid &lt; (0 + 2000 -1)
/**importPMText**/;
MySQL Error : Duplicate entry '55904' for key 'PRIMARY'
Error Number : 1062
Request Date : Sunday, September 16th 2012 @ 01:47:40 PM
Error Date : Sunday, September 16th 2012 @ 01:47:40 PM
Script : http:///forums/core/install/upgrade.php
Referrer : http://feverclan.com/forums/core/install/upgrade.php
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.1.63-cll
thrown in <b>/home/feverc5/public_html/forums/core/vb/database.php</b> on line <b>1073</b><br />

vb5 beta is not designed on a live production site, they suggest you use it for beta testing at the moment, ou need to do a fresh install, and transfer users / posts
it takes tie

[Lynne]

Try doing a repair/optimize on the test table. (Is this the first time trying to do this upgrade? )

[simonhind]

Try doing a repair/optimize on the test table. (Is this the first time trying to do this upgrade? )

i tried the same for 4.2.0 - vb5 and got the the same message, it broke my forum after, i reran the upgrade and it got to final stage, but only allowed admincp access
the forum index page was blank, nothing loaded

[Lynne]

Here is a page from the manual about troubleshooting blank or 'white' pages: https://www.vbulletin.com/docs/html/blank_pages

[cptbogo]

The upgrade doesn't go any farther after it gives the second error. Also my forums turn white as well, but it hasn't finished the install either.

[Lynne]

Take a look at your error_logs (if you don't know where they are, ask your host) and see if anything is in there.