Upgrade from 4.2.3 to 4.2.5 problems

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • gijsje
    New Member
    • Jul 2008
    • 6

    Upgrade from 4.2.3 to 4.2.5 problems

    I wanted to upgrade from 4.2.3 to 4.2.5 and am running into problems.
    When i run the upgrade procedure i do get a version mismatch between version 'empty' and 4.2.3 (see picture)
    Click image for larger version  Name:	mismatch.png Views:	2 Size:	12.8 KB ID:	4378899
    If i do run the 'empty' selection of the upgrade i find the this problem:
    <?xml version="1.0" encoding="windows-1252"?> <br />
    <b>Warning</b>: mysqli_query(): (42S22/1054): Unknown column 'text' in 'field list' in <b>/home/***/public_html/****.nl/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:
    SELECT text FROM adminutil WHERE title = 'master_style_import_vbulletin_-10';

    Unknown column 'text' in 'field list']]></error>
    <error_html><![CDATA[<p>Database error in vBulletin 4.2.3</p>
    <p>
    Invalid SQL:
    SELECT text FROM adminutil WHERE title = 'master_style_import_vbulletin_-10';<p>
    <p>
    <strong>MySQL Error</strong> : Unknown column 'text' in 'field list'<br />
    <strong>Error Number</strong> : 1054<br />
    <strong>Request Date</strong> : Wednesday, October 11th 2017 @ 11:21:49 PM<br />
    <strong>Error Date</strong> : Wednesday, October 11th 2017 @ 11:21:49 PM<br /> < strong>Script</strong> : http://www.****.nl/install/upgrade.php<br />
    <strong>Referrer</strong> : http://www.****.nl/install/upgrade.php<br />
    <strong>Classname</strong> : vB_Database_MySQLi<br />
    <strong>MySQL Version</strong> : 10.1.24-MariaDB<br />
    </p>]]>
    </error_html> </errors>


    If i select the upgrade from 4.2.3 i get this error message:

    <?xml version="1.0" encoding="windows-1252"?>
    <br />
    <b>Warning</b>: mysqli_query(): (42S22/1054): Unknown column 'title' in 'where clause' in <b>/home/***/public_html/****.nl/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:
    SELECT text
    FROM adminutil
    WHERE title = 'attach_fix';

    Unknown column 'title' in 'where clause']]></error>
    <error_html><![CDATA[<p>Database error in vBulletin 4.2.3</p>
    <p>Invalid SQL:

    SELECT text FROM
    adminutil WHERE title = 'attach_fix';<p>
    <p>
    <strong>MySQL Error</strong> : Unknown column 'title' in 'where clause'<br />
    <strong>Error Number</strong> : 1054<br />
    <strong>Request Date</strong> : Wednesday, October 11th 2017 @ 11:11:24 PM<br />
    <strong>Error Date</strong> : Wednesday, October 11th 2017 @ 11:11:25 PM<br />
    <strong>Script</strong> : http://www.****.nl/install/upgrade.php<br />
    <strong>Referrer</strong> : http://www.*****.nl/install/upgrade.php<br />
    <strong>Classname</strong> : vB_Database_MySQLi<br />
    <strong>MySQL Version</strong> : 10.1.24-MariaDB<br />
    </p>]]></error_html>
    </errors>




    if i look at the database i can see that adminutil is empty except for 1 line " t"
    Click image for larger version  Name:	adminutil.png Views:	1 Size:	79.8 KB ID:	4378898


    I have no clue how to solve this so please help me out
    Last edited by gijsje; Wed 11 Oct '17, 1:33pm.
  • Trevor Hannant
    vBulletin Support
    • Aug 2002
    • 24358
    • 5.7.X

    #2
    What's the highest numbered record in your upgradelog table?
    Vote for:

    - Admin Settable Paid Subscription Reminder Timeframe (vB6)
    - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

    Comment

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