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
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