error on upgrade

[hunterscentral]

running 4.86 with intergration with VB
here is the error I got
Error performing MySQL command: ALTER TABLE categories ADD numextra INT(3) default '0' NOT NULL
Error: Duplicate column name 'numextra'

Error performing MySQL command: ALTER TABLE categories 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 extrafields (id INT(12) NOT NULL AUTO_INCREMENT, cat INT(12), fieldname VARCHAR(255), fieldtype VARCHAR(2), fieldoptions TEXT, PRIMARY KEY (id) )
Error: Table 'extrafields' already exists

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

Error performing MySQL command: INSERT INTO settings VALUES (201,'Use photo view caching to reduce view update queries on high load sites?','viewcache', 'Set this to YES if you want to enable the view caching code which caches photo view updates', 'no', 33, 1)
Error: Duplicate entry '201' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (202,'Min allowable image width in pixels','minwidth','','0',21,6)
Error: Duplicate entry '202' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (203,'Min allowable image height in pixels','minheight','','0',22,6)
Error: Duplicate entry '203' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (204,'Mobile Phone Integration: EMail address for images','mobemail','EMail address users should send their images to','',23,6)
Error: Duplicate entry '204' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (205,'Show Last Comments column on Index?','showcoms','','yes',16,3)
Error: Duplicate entry '205' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (206,'Show Last Photo column on Index','showlast','','yes',17,3)
Error: Duplicate entry '206' for key 1

Error performing MySQL command: UPDATE categories SET frames=NULL WHERE frames='0'
Error: Unknown column 'frames' in 'where clause'

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

[hunterscentral]

it is FUBAR
got that error everything went to crap after that
I uploaded all backup files to make it back to 4.86 still have issues
no pics all pics are gone even tho there are still on the server

I need support

[hunterscentral]

the great thing is that the photo/(img) tags still show and work in VB threads
I have photopost shutdown right now until I hear something

[b6gm6n]

Was you trying to perfrom an upgrade to photopost 5? - i suggest you restore the photopost database and directories from your backup and run the upgrade again.

Remember to set permissions to 777 on your data dir and all under that dir, don't run 'step 3' of the upgrade twice, just the once

-T

[hunterscentral]

ok here is what I dont udnderstand how do you restore only photopost from a backup
VB and PP are in the same database and are .SQL backup

[Chuck S]

You would only need to restore the photos table not the whole backup