cant upgrade?

[sanddancer]

Hi wne we try to upgrade version 5.5 to the new version we get

Error performing MySQL command: ALTER TABLE gallery_users ADD lastphoto INT( 12 ) NOT NULL DEFAULT '0', ADD lastdate INT( 15 ) NOT NULL DEFAULT '0'
Error: Duplicate column name 'lastphoto'

Error performing MySQL command: CREATE TABLE gallery_search ( searchid INT( 12 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , userid INT( 12 ) NOT NULL DEFAULT '0', searchtype VARCHAR( 1 ) NULL , searchterms VARCHAR( 250 ) NULL , searchdate VARCHAR( 5 ) NULL , cats MEDIUMTEXT NULL , name VARCHAR( 64 ) NULL , preview SMALLINT( 1 ) NOT NULL DEFAULT '1', idlist MEDIUMTEXT NULL , numresults INT( 5 ) NOT NULL DEFAULT '0', ipaddress VARCHAR( 15 ) NULL , searchtime FLOAT( 3, 6 ) NOT NULL DEFAULT '0', date INT( 15 ) NOT NULL DEFAULT '0' )
Error: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 'searchtime').

Error performing MySQL command: INSERT INTO gallery_settings VALUES (221,'Require users to be registered to use search?','searchreg','','no',1,14)
Error: Duplicate entry '221' for key 1

Error performing MySQL command: INSERT INTO gallery_settings VALUES (222,'Maximium number of search results to return?','searchmax','On larger sites, the less the better.','500',2,14)
Error: Duplicate entry '222' for key 1

Error performing MySQL command: INSERT INTO gallery_settings VALUES (223,'Number of seconds between searches?','searchto','The number of seconds a user must wait between searches.','30',3,14)
Error: Duplicate entry '223' for key 1

Error performing MySQL command: INSERT INTO gallery_settings VALUES (224,'Number of days to hold search results?','searchhold','','7',5,14)
Error: Duplicate entry '224' for key 1

Error performing MySQL command: INSERT INTO gallery_settings VALUES (225,'Display who is viewing a category?','catonline','This option adds a query to the Show Gallery page.','yes',5,4)
Error: Duplicate entry '225' for key 1

Thanks

[Chuck S]

Looks like you already ran your upgrade.

[sanddancer]

umm it doesnt create gallery_search
cant find that anywhere?

[sanddancer]

we are running mysql 5.0.22 if thats any help!

Thanks

[Chuck S]

Well try changing the query in upgrade.php to ( 6, 6 ) for the float.

Content visible to verified customers only.

[sanddancer]

hi

that seems to fix it it has created the search table fine?

Thanks!!

[Chuck S]

No problem must be another mysql 5 strict mode thing