Announcement

Collapse
No announcement yet.

Upgrading Questions / Issues from vb4.1.2 to 4.2

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

  • [Forum] Upgrading Questions / Issues from vb4.1.2 to 4.2

    Hi all,

    I am currently trying to upgrade my board from 4.1.2 to 4.2 patch 2 and I have backed up my site, files, database etc and I have just run the upgrade script and first ran into the issue with the vbblog.xml file and I have remedied that issue, however when re-running the script I have now encountered the following invalid SQL error:

    <?xml version="1.0" encoding="windows-1252"?>
    <?xml version="1.0" encoding="windows-1252"?>
    <errors>
    <error><![CDATA[<p>Database Error</p>


    Invalid SQL:


    SELECT styleid, title, parentlist, parentid, userselect
    FROM style
    WHERE type = 'standard'
    ORDER BY parentid;


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


    SELECT styleid, title, parentlist, parentid, userselect
    FROM style
    WHERE type = 'standard'
    ORDER BY parentid;<p>
    <p>
    <strong>MySQL Error</strong> : Unknown column 'type' in 'where clause'<br />
    <strong>Error Number</strong> : 1054<br />
    <strong>Request Date</strong> : Friday, September 14th 2012 @ 04:37:16 PM<br />
    <strong>Error Date</strong> : Friday, September 14th 2012 @ 04:37:17 PM<br />
    <strong>Script</strong> : http://example.com/install/upgrade.php<br />
    <strong>Referrer</strong> : http://example.coml/upgrade.php<br />
    <strong>Classname</strong> : vB_Database<br />
    <strong>MySQL Version</strong> : 5.1.54<br />



    Can anyone provide any helpful information to resolve this so I can proceed with the upgrade? Thank you in advance.

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