MySQL Command Error on upgrade to 5.6

[optrex]

I just ran the upgrade to 5.6 and got this

Preparing to update database...
Error performing MySQL command: CREATE TABLE pp_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').


What do I need to do please?

[Chuck S]

try altering the query in the upgrade file this

FLOAT( 3, 6 )

to this

FLOAT( 6, 6 )

[optrex]

Thanks Chuck,

I've run the upgrade with the float modification. I now get this:

Error performing MySQL command: ALTER TABLE pp_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: INSERT INTO pp_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 pp_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 pp_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 pp_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 pp_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

[Michael P]

That are just telling you that those were already added; you can ignore them.

[optrex]

cheers michael