MySQL Error during upgrade from 5.5 to 5.5

[Illuvatar123]

Got this error when attempting to upgrade from 5.3 to 5.5

Error performing MySQL command: ALTER TABLE photopostphotos ADD allowrate INT(1) DEFAULT '1' NOT NULL, ADD allowcoms INT(1) DEFAULT '1' NOT NULL;
Error: Duplicate column name 'allowrate'

Error performing MySQL command: INSERT INTO photopostsettings VALUES (220,'Number of minutes a user is allowed to edit a comment?','comtimeout','0 to disable. 86400 is one day.','0',2,7)
Error: Duplicate entry '220' for key 1

Please advise....thanks

PHP version 4.4.4
MySQL version 4.1.21-standard

[Chuck S]

That just means you ran the upgrade twice and they already exist

[Illuvatar123]

Thanks Chuck....well.....I never did get the "Upgrade Complete" message so my assumption was that it did not complete. the only message I got was that one along with "The system has experianced a critical error". Now I get this:

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script: index

Query: SELECT id,ugnoupload,ugnoanno,ugnoview,ugnopost,ugnovote,password,watermark,cattype,ismember,catname,parent,children,thumbs,canzip,moderators,header,footer,headtags,subalbum FROM photopostcategories

Result: Unknown column 'subalbum' in 'field list'

Database handle: Resource id #7

that just from attempting to access them.

[Chuck S]

Hello

Yes you need to run your 5.2 5.3 upgrade scripts

[Illuvatar123]

Thanks Chuck...worked with only one small error over a table that it couldn't find..but the upgrade did complete this time and so did the 5.3 -> 5.5

Very odd as I know we were at 5.3 but no matter.....boards came up and everything's accessable.

Thanks again.