Announcement

Collapse
No announcement yet.

Error when attempting to upgrade forums

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

  • Error when attempting to upgrade forums

    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 />
    Last edited by cptbogo; Sun 16th Sep '12, 11:52am.

  • #2
    Originally posted by cptbogo View Post
    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

    Comment


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

      Please don't PM or VM me for support - I only help out in the threads.
      vBulletin Manual & vBulletin 4.0 Code Documentation (API)
      Want help modifying your vbulletin forum? Head on over to vbulletin.org
      If I post CSS and you don't know where it goes, throw it into the additional.css template.

      W3Schools &lt;- awesome site for html/css help

      Comment


      • #4
        Originally posted by Lynne View Post
        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

        Comment


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

          Please don't PM or VM me for support - I only help out in the threads.
          vBulletin Manual & vBulletin 4.0 Code Documentation (API)
          Want help modifying your vbulletin forum? Head on over to vbulletin.org
          If I post CSS and you don't know where it goes, throw it into the additional.css template.

          W3Schools &lt;- awesome site for html/css help

          Comment


          • #6
            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.

            Comment


            • #7
              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.

              Please don't PM or VM me for support - I only help out in the threads.
              vBulletin Manual & vBulletin 4.0 Code Documentation (API)
              Want help modifying your vbulletin forum? Head on over to vbulletin.org
              If I post CSS and you don't know where it goes, throw it into the additional.css template.

              W3Schools &lt;- awesome site for html/css help

              Comment

              Related Topics

              Collapse

              Working...
              X