PhotoPost Community - View Single Post

mwaite49 · October 23rd, 2006, 05:18 PM

Thanks Chuck. I repaired the two tables as you suggested and ran upgrade.php again. I have my gallery back.

I had this show up at the install:

Error performing MySQL command: ALTER TABLE pp_photos 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 pp_settings 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

Upgrade complete!

I don't know what it means. Do I need to do something to clean up those two errors?

I really appreciate your assistance.

Mike

October 23rd, 2006, 05:18 PM	#13 (permalink)
mwaite49 Junior Member Verified Customer Join Date: Sep 2005 Location: Southwest Mississipp Posts: 18	Back in business Thanks Chuck. I repaired the two tables as you suggested and ran upgrade.php again. I have my gallery back. I had this show up at the install: Error performing MySQL command: ALTER TABLE pp_photos 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 pp_settings 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 Upgrade complete! I don't know what it means. Do I need to do something to clean up those two errors? I really appreciate your assistance. Mike