mySql errors with upgrade

[ChefTalk]

Hello,

I upgraded to version six and my photo gallery looks very strange now and I received several mySql errors:

An error was encountered during execution of the query:

SELECT id,user,userid,cat,storecat,ismature,title,bigimage,height,width FROM pp_photos WHERE approved=1 AND storecat=0 ORDER BY date DESC LIMIT 29

The query returned with an errorcode of:

Unknown column 'ismature' in 'field list'

An error was encountered during execution of the query:

SELECT id,user,userid,cat,storecat,title,ismature,bigimage,height,width, id*0+RAND() as rand_col FROM pp_photos WHERE approved=1 AND storecat=0 ORDER BY rand_col DESC LIMIT 29

The query returned with an errorcode of:

Unknown column 'ismature' in 'field list'

An error was encountered during execution of the query:

SELECT id,user,userid,cat,storecat,title,ismature,bigimage,height,width FROM pp_photos WHERE approved=1 AND storecat=0 AND cat IN (527,a) ORDER BY date DESC LIMIT 9

The query returned with an errorcode of:

Unknown column 'a' in 'where clause'

You can view my photo gallery here:

www.cheftalk.com/photopost/

[ChefTalk]

Well it looks like I ran the upgrade script when I was not supposed to for my version.

So what are my options to fix my photo gallery it looks totally messed up and I can view any categories.

Please help.

[Chuck S]

Hello well the errors your posting tell me you have not ran the upgrade script so you might want to reupload the upgrade.php file and run the upgrades that you need to run. Specifically the last one 5.61 to 6