Announcement

Collapse
No announcement yet.

vb4 to vb5 upgrade. Altering poll Table (1 of 1) Step 152 - Unexpected Text

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

  • vb4 to vb5 upgrade. Altering poll Table (1 of 1) Step 152 - Unexpected Text

    Hi

    Any idea why I got this when upgrading from vb4 to vb5?
    Altering poll Table (1 of 1) Step 152 - Unexpected Text

    <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
    <html><head>
    <title>500 Internal Server Error</title>
    </head><body>
    <h1>Internal Server Error</h1>
    <p>The server encountered an internal error or
    misconfiguration and was unable to complete
    your request.</p>
    <p>Please contact the server administrator,
    [email protected] and inform them of the time the error occurred,
    and anything you might have done that may have
    caused the error.</p>
    <p>More information about this error may be available
    in the server error log.</p>
    </body></html>
    Script: 500a1
    Step: 152

    I tried running the upgrade script again and it continued OK, but just wondered if I should worry.
    Note: I do have a bigish board (1.6m posts), but thought I'd try the browser script first on a test clone before trying the command line option.
    Last edited by charlesr; Sun 7th Jul '19, 11:48pm.
    http://www.bordersdown.net - 10 years of videogame reviews and chat

  • #2
    From the log (although it's possible this is unrelated, but unlikely since it's a test server with only me with access):

    Invalid SQL:
    INSERT IGNORE INTO session (`sessionhash`,`userid`,`host`,`idhash`,`lastactivity`,`location`,`styleid`,`languageid`,` loggedin`,`inforum`,`inthread`,`incalendar`,`badlocation`,`useragent`,`bypass`,`profileupd ate`,`apiclientid`,`apiaccesstoken`,`emailstamp`)
    VALUES('30aaefaf7a1b54daa7a972552671e976',0,'90.240.250.5','0c21ec26503b70f5f4a773251315dd a4',1562566368,'',118,1,0,0,0,0,0,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36',0,0,0,'',0)
    /**session**/;

    MySQL Error : Unknown column 'emailstamp' in 'field list'
    Error Number : 1054
    Request Date : Monday, July 8th 2019 @ 06:12:48 AM
    Error Date : Monday, July 8th 2019 @ 06:12:49 AM
    Script : removed by me
    Referrer :
    IP Address : 90.240.250.5
    Username : Guest
    Classname : vB_Database_MySQLi
    MySQL Version :


    Stack Trace:
    #0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1203
    #1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 201
    #2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 557
    #3 vB_Database->query_write() called in [path]/vb/db/query/insertignore.php on line 88
    #4 vB_dB_Query_InsertIgnore->doInserts() called in [path]/vb/db/query/insert.php on line 98
    #5 vB_dB_Query_Insert->execSQL() called in [path]/vb/db/assertor.php on line 301
    #6 vB_dB_Assertor->assertQuery() called in [path]/vb/db/assertor.php on line 473
    #7 vB_dB_Assertor->insertIgnore() called in [path]/vb/session.php on line 593
    #8 vB_Session->save() called in [path]/vb/shutdown.php on line 86
    #9 vB_Shutdown->shutdown() called in [path]/vb/vb.php on line 483
    #10 vB::shutdown() called in on line
    Last edited by charlesr; Mon 8th Jul '19, 12:04am.
    http://www.bordersdown.net - 10 years of videogame reviews and chat

    Comment


    • #3
      The script information is important. This is the 5.0.0 Alpha 1 script?

      The emailstamp field isn't added until 5.0.4. The poll table is converted in 5.0.0. Alpha 1. The most likely cause of the Poll issue is duplicate votes in the table. There wasn't an index on this table to prevent duplicate votes in the 3.X era.

      For a board your size, the command line script is the better option to upgrade.
      Last edited by Wayne Luke; Mon 8th Jul '19, 8:09am.
      Translations provided by Google.

      Wayne Luke
      The Rabid Badger - a vBulletin Cloud customization and demonstration site.
      vBulletin 5 Documentation - Updated every Friday. Report issues here.
      vBulletin 5 API - Full / Mobile
      I am not currently available for vB Messenger Chats.

      Comment


      • #4
        Ah yeah, sorry should have looked at the script. I believe it was that 5.0Alpha1 yes. Cheers. Should be ok if that's all it was then. Rest all was smooth.

        And yeah, it took "some time" using the browser upgrage I'll try the whole thing again with the command line one too.
        http://www.bordersdown.net - 10 years of videogame reviews and chat

        Comment

        Related Topics

        Collapse

        Working...
        X