vBulletin 4.2.0 Patch Level 2 to vBulletin 5.0.0 Beta 11 Upgrade Issue

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • NSK1
    New Member
    • Sep 2012
    • 4
    • 4.2.X

    vBulletin 4.2.0 Patch Level 2 to vBulletin 5.0.0 Beta 11 Upgrade Issue

    I was upgrading from vBulletin 4.2.0 Patch Level 2 to vBulletin 5.0.0 Beta 11 and I got this error, I refreshed and continued but I am worried that it will cause issues at a later time. What seems to be the issue?



    An error has occurred with your database. Please contact vBulletin Support for assistance.Module: 500a23, Step 2 Database Error:1064Query:
    UPDATE setting SET value = value | WHERE varname = 'defaultregoptions'

    - - - Updated - - -

    I also got another error just after the above one:

    Unexpected Text:
    <?xml version="1.0" encoding="windows-1252"?>
    <font color=ff0000>
    Fatal error: 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 > 0 AND node.oldid < (0 + 2000 -1)
    /**importPMText**/;


    MySQL Error : Duplicate entry '149881' for key 'PRIMARY'
    Error Number : 1062
    Request Date : Friday, September 28th 2012 @ 12:12:52 PM
    Error Date : Friday, September 28th 2012 @ 12:12:52 PM
    Script : http:///vb5/core/install/upgrade.php
    Referrer : http://www.mydomain.com/vb5/core/install/upgrade.php
    IP Address :
    Username :
    Classname : vB_Database
    MySQL Version : 5.1.63-cll



    thrown in /home/*******/public_html/vb5/core/vb/database.php on line 1099
    </font>

    - - - Updated - - -

    After my second error I posted above, I refreshed but I can't seem to get past it, what should I do?
  • JoshiUK
    New Member
    • May 2008
    • 2
    • 4.2.X

    #2
    I got the same errors. I just restarted the upgrade and it worked but... now I'm getting two errors and I can't get my head around them... I'm sure they are quite simple for some people to solve...


    Warning: session_start() [function.session-start]: Cannot send session
    cache limiter - headers already sent (output started at [path]/forum.php:1) in
    [path]/includes/facebook/facebook.php on line
    37

    Fatal error: Class 'vBulletinHook' not found
    in /home/asachdeo/public_html/beamin.net/forum.php on line 85


    Someone please help us!

    Comment

    • Veniamin
      Member
      • Apr 2007
      • 48
      • 3.8.x

      #3
      It might sound trivial, but try to re-upload all vb5 files in ascii mode. Also, as far as I am aware, forum.php shouldn't be in the forum root directory.

      Comment

      • Lynne
        Former vBulletin Support
        • Oct 2004
        • 26255

        #4
        As stated, forum.php should definitely NOT be in the forum root directory. You should have NO vb4 files in the directory at all or you will have issues.

        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

        • nsglazer
          Database Error
          by nsglazer
          I've received hundreds of emails since our upgrade to vBulletin 5.1.3 Patch Level 1 all pretty similar to these. Any idea what's going on?

          Database error in vBulletin 5.1.3:

          ...
          Sun 16 Nov '14, 1:27pm
        • aelalfey
          Database error in vBulletin 5.1.8
          by aelalfey
          I started getting this error about 6 days "about 10 emails everyday" ago with no certain reason.
          Code:
          [COLOR=#222222][FONT=arial]Database error in vBulletin 5.1.8:[/FONT][/COLOR]
          
          [COLOR=#222222][FONT=arial]                        Invalid SQL:[/FONT][/COLOR]
          [COLOR=#222222][FONT=arial]CREATE[/][/]
          ...
          Fri 25 Sep '15, 4:00am
        • marky
          Database error in vBulletin 5.1.0
          by marky
          Got an error today (everything is verbatim except the bolded part):

          Invalid SQL:
          /** saveDbCache */ DELETE FROM cacheevent WHERE (cacheid = 'node_10_lvl1data' AND event = 'nodeChg_10')...
          Tue 22 Apr '14, 1:29pm
        • jtech77
          failed upgrade
          by jtech77
          I have completed the mysql updates and also was able to get the forum updated
          > all the way to version 5.0.0 beta 23 (non working as upgrade has not
          > completed.)
          >
          ...
          Thu 31 Jan '13, 4:11pm
        Working...