[titusc]

Hello,

I had a version 4 photopost before and had run the upgrade script unsucessfully. So now I'm not sure which version do I have. What should I do?

I encountered errors during the upgrade as follow:

Preparing to update 4.8.5 database...
Error performing MySQL command: ALTER TABLE photopostphotos ADD numcom INT(8) DEFAULT '0' NOT NULL , ADD lastposter VARCHAR(255), ADD lastpid INT(8) DEFAULT '0' NOT NULL
Error: Duplicate column name 'numcom'

Error performing MySQL command: ALTER TABLE photopostcategories ADD maximages INT(12) default '0' NOT NULL, ADD canzip VARCHAR(3) DEFAULT 'no' NOT NULL, ADD frames VARCHAR(32) NULL
Error: Duplicate column name 'maximages'

Error performing MySQL command: ALTER TABLE photopostcategories ADD numextra INT(3) default '0' NOT NULL
Error: Duplicate column name 'numextra'

Error performing MySQL command: ALTER TABLE photopostcategories ADD intro VARCHAR(3) default 'no' NOT NULL, ADD introtitle VARCHAR(128) DEFAULT NULL, ADD introcopy TEXT DEFAULT NULL, ADD moderators TEXT DEFAULT NULL
Error: Duplicate column name 'intro'

Error performing MySQL command: ALTER TABLE photopostcategories ADD ratingtype INT(1) DEFAULT '0' NOT NULL, ADD takevotes INT(1) DEFAULT '0' NOT NULL
Error: Duplicate column name 'ratingtype'

Error performing MySQL command: CREATE TABLE photopostphotoviews (photoid mediumint(9) NOT NULL default '0') TYPE=HEAP
Error: Table 'photopostphotoviews' already exists

Error performing MySQL command: CREATE TABLE photopostextrafields (id INT(12) NOT NULL AUTO_INCREMENT, cat INT(12), fieldname VARCHAR(255), fieldtype VARCHAR(2), fieldoptions TEXT, PRIMARY KEY (id) )
Error: Table 'photopostextrafields' already exists

Error performing MySQL command: CREATE TABLE photopostphotoextras (id INT(12) NOT NULL AUTO_INCREMENT, photo INT(12), extraid INT(12), selection TEXT, PRIMARY KEY (id) )
Error: Table 'photopostphotoextras' already exists

Error performing MySQL command: ALTER TABLE photopostusers ADD cellphone VARCHAR( 255 )
Error: Duplicate column name 'cellphone'



Move DATA directory files (you only do this only once successfully) --> or quit here.
Moving data files can take some time depending on your installation; 10,000 files could take 5 minutes or more. Please be patient.