SQL Errors after upgrade

[robertorg]

Hi,

After update to the new version I'm reveiveing these SQL errors throught mail:

Database error in vBulletin 3.5.1:

Invalid SQL:

SELECT filedata, dateline, filename
FROM customprofilepic
WHERE userid = 148 AND visible = 1;

MySQL Error : Unknown column 'filedata' in 'field list'
Error Number : 1054

###################

Database error in vBulletin 3.5.1:

Invalid SQL:
SELECT * FROM subscription ORDER BY displayorder;

MySQL Error : Unknown column 'displayorder' in 'order clause'
Error Number : 1054

###################

Database error in vBulletin :

Link-ID == false, connect failed
mysql error:

mysql error number: 0

###################

What can I do?

Thanks for all.

[Steve Machol]

To troubleshoot this, remove any hacks and disable your plugins, then see if you still have this problem.

If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

Next, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?

[robertorg]

Hi Steve,

I thing that it isn't for hacks, It's because I had several problems with SQL Queries on the upgrade from the latest versions, I had to make manual changes to continue installing. (The only hacks I have are vbadvanced are a DC Rewrite (it shouldn't affect for queries).

I received another SQL error:

Invalid SQL:
SELECT * FROM subscription ORDER BY displayorder;

MySQL Error : Unknown column 'displayorder' in 'order clause'

It there any way to check the database structure and FIX it?

Thanks for all.

[Steve Machol]

You can't just change queries during the upgrade process and expect it to work. You can try running this query to create that missing field:

ALTER TABLE subscription ADD displayorder SMALLINT UNSIGNED NOT NULL DEFAULT '1';