|
I re-ran the upgrade script and have all default files in right now.
The search function still does not work.
I got this message when I ran the upgrade script:
Preparing to update database...
Error performing MySQL command: ALTER TABLE plusers 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 plsearchids ( 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( 6, 6 ) NOT NULL DEFAULT '0', date INT( 15 ) NOT NULL DEFAULT '0' )
Error: Table 'plsearchids' already exists
Error performing MySQL command: INSERT INTO plsettings 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 plsettings 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 plsettings 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 plsettings 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 plsettings 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
Upgrade complete! You should continue to next step
|