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:




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']]>
Database error in vBulletin 4.1.2</p>

Invalid SQL:


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



MySQL Error : Unknown column 'type' in 'where clause'

Error Number : 1054

Request Date : Friday, September 14th 2012 @ 04:37:16 PM

Error Date : Friday, September 14th 2012 @ 04:37:17 PM

Script : http://example.com/install/upgrade.php

Referrer : http://example.coml/upgrade.php

Classname : vB_Database

MySQL Version : 5.1.54




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

qubed