Error Upgrading From 4.2.4 to 4.2.5

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tempagain
    Member
    • Mar 2014
    • 57
    • 4.2.X

    Error Upgrading From 4.2.4 to 4.2.5

    I got a similar "Unexpected Text" error as another poster when upgrading from 4.2.4 to 4.2.5. I'm running with PHP Version 5.6.40

    Originally posted by Wayne Luke
    You need to run at least PHP 5.6.30 to run 4.2.5. We recommend PHP 7.1.
    Any ideas? Thanks.

    Here's the error.

    Unexpected Text:
    <?xml version="1.0" encoding="windows-1252"?>
    <br />
    <b>Warning</b>: mysqli_query(): (23000/1062): Duplicate entry 'block_activitystream--10-template' for key 'title' in <b>/var/www/sites/www.mysite.com/includes/class_core.php</b> on line <b>1386</b><br />
    <?xml version="1.0" encoding="windows-1252"?>
    <errors>
    <error><![CDATA[<p>Database Error</p>

    Invalid SQL:

    UPDATE vb_template
    SET styleid = -10 WHERE styleid = -1 AND (product = 'vbulletin' OR product = '');

    Duplicate entry 'block_activitystream--10-template' for key 'title']]></error>
    <error_html><![CDATA[<p>Database error in vBulletin 4.2.5</p>
    <p>Invalid SQL:

    UPDATE vb_template
    SET styleid = -10 WHERE styleid = -1 AND (product = 'vbulletin' OR product = '');<p>
    <p>
    <strong>MySQL Error</strong> : Duplicate entry 'block_activitystream--10-template' for key 'title'<br />
    <strong>Error Number</strong> : 1062<br />
    <strong>Request Date</strong> : Saturday, May 11th 2019 @ 04:46:28 PM<br />
    <strong>Error Date</strong> : Saturday, May 11th 2019 @ 04:46:29 PM<br />
    <strong>Script</strong> : http://www.mysite.com/install/upgrade.php<br />
    <strong>Referrer</strong> : https://www.mysite.com/install/upgrade.php<br />
    <strong>Classname</strong> : vB_Database_MySQLi<br />
    <strong>MySQL Version</strong> : 5.6.43-84.3-log<br />
    </p>]]></error_html>
    </errors>

    Click image for larger version  Name:	051119b.gif Views:	0 Size:	16.6 KB ID:	4414997

    Click image for larger version  Name:	051119a.gif Views:	1 Size:	5.0 KB ID:	4414996

    Status: Aborted
    93%

    Upgrade Progress
    • Upgrading to 4.2.5 Alpha 1
    • Upgrading to 4.2.5 Alpha 2
    • Upgrading to 4.2.5 Alpha 3
    • Upgrading to 4.2.5 Beta 1
    • Upgrading to 4.2.5 Beta 2
    • Step 1 - Altering session Table (1 of 1)
    • Step 2 - Altering threadrate Table (1 of 1)
    • Step 3 - Altering apiclient Table (1 of 1)
    • Step 4 - Altering apilog Table (1 of 1)
    • Step 5 - Altering searchlog Table (1 of 1)
    • Step 6 - Updating contenttype table (1 of 1)
    • Step 7 - Updating vb_userchangelog table
    • Step 8 - Altering ipdata Table (1 of 2)
    • Altering ipdata Table (2 of 2)
    • Step 9 - Updating postlog table
    • Altering postlog table
    • Altering postlog table
    • Step 10 - Altering searchcore Table (1 of 2)
    • Altering searchcore Table (2 of 2)
    • Step 11 - Updating vb_adminmessage table
    • Step 12 - Skipping step, not needed
    • Step 13 - Updating vb_groupmessage table
    • Step 14 - Updating vb_picturecomment table
    • Step 15 - Updating vb_visitormessage table
    • Step 16 - Skipping step, not needed
    • Upgrading to 4.2.5 Beta 3
    • Upgrading to 4.2.5 Beta 4
    • Upgrading to 4.2.5 Release Candidate 1
    • Upgrading to 4.2.5 Release Candidate 2
    • Upgrading to 4.2.5
    • Processing Blog
    • Step 1 - Skipping step, not needed
    • Step 2 - Skipping step, not needed
    • Step 3 - Skipping step, not needed
    • Step 4 - Skipping step, not needed
    • Step 5 - Skipping step, not needed
    • Step 6 - Skipping step, not needed
    • Step 7 - Skipping step, not needed
    • Step 8 - Skipping step, not needed
    • Step 9 - Skipping step, not needed
    • Step 10 - Skipping step, not needed
    • Step 11 - Skipping step, not needed
    • Step 12 - Skipping step, not needed
    • Step 13 - Skipping step, not needed
    • Step 14 - Skipping step, not needed
    • Step 15 - Skipping step, not needed
    • Step 16 - Skipping step, not needed
    • Step 17 - Skipping step, not needed
    • Step 18 - Updating vb_blog_text table
    • Step 19 - Product upgrade completed
    • Step 20 - Importing vbulletin-mobile-style-blog.xml
    • Template Group: Blog
    • Template Group: Search
    • Step 20 - Import Done
    • Processing CMS
    • Step 1 - Skipping step, not needed
    • Step 2 - Skipping step, not needed
    • Step 3 - Skipping step, not needed
    • Step 4 - Skipping step, not needed
    • Step 5 - Skipping step, not needed
    • Step 6 - Skipping step, not needed
    • Step 7 - Skipping step, not needed
    • Step 8 - Skipping step, not needed
    • Step 9 - Skipping step, not needed
    • Step 10 - Skipping step, not needed
    • Step 11 - Skipping step, not needed
    • Step 12 - Skipping step, not needed
    • Step 13 - Skipping step, not needed
    • Step 14 - Skipping step, not needed
    • Step 15 - Skipping step, not needed
    • Step 16 - Skipping step, not needed
    • Step 17 - Skipping step, not needed
    • Step 18 - Skipping step, not needed
    • Step 19 - Skipping step, not needed
    • Step 20 - Skipping step, not needed
    • Step 21 - Skipping step, not needed
    • Step 22 - Skipping step, not needed
    • Step 23 - Skipping step, not needed
    • Step 24 - Skipping step, not needed
    • Step 25 - Skipping step, not needed
    • Step 26 - Skipping step, not needed
    • Step 27 - Skipping step, not needed
    • Step 28 - Skipping step, not needed
    • Step 29 - Skipping step, not needed
    • Step 30 - Skipping step, not needed
    • Step 31 - Product upgrade completed
    • Step 32 - Skipping step, not needed
    • Step 33 - Importing vbulletin-mobile-style-cms.xml
    • Template Group: vBulletin CMS
    • Step 33 - Import Done
    • Processing Skimlinks
    • Step 1 - Skipping step, not needed
    • Step 2 - Skipping step, not needed
    • Step 3 - Product upgrade completed
    • Processing Forum Runner
    • Step 1 - Skipping step, not needed
    • Step 2 - Skipping step, not needed
    • Step 3 - Skipping step, not needed
    • Step 4 - Product upgrade completed
    • Processing XML
    • Step 1 - Import latest options
    • Importing vbulletin-settings.xml
    • Import Done
    • Step 2 - Import latest admin help
    • Importing vbulletin-adminhelp.xml
    • Import Done
    • Step 3 - Import latest language
    • Importing vbulletin-language.xml
    • Import Done
    Last edited by tempagain; Sat 11 May '19, 1:25pm.
  • tempagain
    Member
    • Mar 2014
    • 57
    • 4.2.X

    #2
    Never mind. Got past it.

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...