Lost pics on index after upgrade to 6.0.2

[Nito]

i have pp and VB on my site and after upgrade from pp 5.62 to 6.0.2 i lost all pics on indexcategories, they were still visible in most popular and resent pics?
i didnt upload the data folder and to my best knowledge followed the instructions and got no errors with upgrade, but after the upgrade i had all the categories intact, but no pics!
-i freaked as usual and reinstalled the 5.62 again and it wa all back to normal, so my Q is: what did i screw up this time?

[Chuck S]

I would need to know what you mean by photos disappear on index as you state they disappear but then say the blocks appear fine so I am a bit confused so I need to see what you mean to suggest what to do.

[Nito]

i could see my categories on index but they were empty, i could not click on a category, and all the icons, miniatures was gone, but the rest looked ok.

[Chuck S]

You would have to upgrade and give us a link but off hand try turning off your category cache and try upgrading.

[Nito]

closed category cache and upgraded, and it seems to work, but i got this message when done:

Preparing to update database...
Error performing MySQL command: CREATE TABLE pp_messages ( msgid int( 12 ) NOT NULL AUTO_INCREMENT , userid int( 12 ) NOT NULL default '0', datestamp int( 15 ) NOT NULL default '0', message mediumtext, status smallint( 1 ) NOT NULL default '0', type enum( 'c', 'f', 'i', 'm', 'r' ) default NULL , photo int( 12 ) NOT NULL default '0', PRIMARY KEY ( msgid ) ) TYPE=MYISAM
Error: Table 'pp_messages' already exists

Error performing MySQL command: CREATE TABLE pp_captcha ( id int( 12 ) NOT NULL auto_increment , code varchar( 12 ) default NULL , PRIMARY KEY ( id ) ) TYPE=MyISAM
Error: Table 'pp_captcha' already exists

Error performing MySQL command: CREATE TABLE pp_buddies ( id int( 12 ) NOT NULL auto_increment , userid int( 12 ) NOT NULL default '0', buddy int( 12 ) NOT NULL default '0', PRIMARY KEY ( id ) , KEY userid ( userid ) ) TYPE=MyISAM
Error: Table 'pp_buddies' already exists

Error performing MySQL command: CREATE TABLE pp_board ( msgid int(12) NOT NULL auto_increment, replyto int(12) NOT NULL default '0', userid int(12) NOT NULL default '0', category int(4) NOT NULL default '0', date int(15) NOT NULL default '0', subject varchar(250) default NULL, message mediumtext, replies int(6) NOT NULL default '0', views int(7) NOT NULL default '0', lastmsg int(12) NOT NULL default '0', lastdate int(15) NOT NULL default '0', lastuser int(12) NOT NULL default '0', lastusername varchar(32) default NULL, ipaddr varchar(15) default NULL, updated int(16) NOT NULL default '0', updateuser int(12) NOT NULL default '0', PRIMARY KEY (msgid), KEY date (date) ) TYPE=MyISAM
Error: Table 'pp_board' already exists

Error performing MySQL command: CREATE TABLE pp_invites ( id int( 12 ) NOT NULL AUTO_INCREMENT , code varchar( 32 ) default NULL , email varchar( 32 ) default NULL , name varchar( 64 ) default NULL , message mediumtext, datestamp int( 16 ) NOT NULL default '0', referer int( 10 ) NOT NULL default '0', status smallint( 1 ) NOT NULL default '0', uid int( 12 ) NOT NULL default '0', PRIMARY KEY ( id ) , UNIQUE KEY code ( code ) ) TYPE=MYISAM
Error: Table 'pp_invites' already exists

Error performing MySQL command: ALTER TABLE pp_users ADD realname varchar(80) default NULL, ADD title varchar(30) default NULL, ADD signature varchar(250) default NULL, ADD avatar varchar(120) default NULL, ADD mature tinyint(1) NOT NULL default '1', ADD invites int(6) NOT NULL default '0', ADD accepts int(6) NOT NULL default '0', ADD laston int(15) NOT NULL default '0'
Error: Duplicate column name 'realname'

Error performing MySQL command: ALTER TABLE pp_photos ADD votes tinyint(1) NOT NULL default '0'
Error: Duplicate column name 'votes'

Error performing MySQL command: ALTER TABLE pp_comments ADD votes tinyint(1) NOT NULL default '0'
Error: Duplicate column name 'votes'

Error performing MySQL command: ALTER TABLE pp_iponline ADD uid INT(12) NOT NULL default '0', ADD referer VARCHAR(255) default NULL, ADD agent VARCHAR(100) default NULL
Error: Duplicate column name 'uid'

Error performing MySQL command: ALTER TABLE pp_photos ADD tags INT(15) NOT NULL default '0', ADD ismature smallint(1) NOT NULL default '0', ADD exifinfo BINARY(1) NOT NULL DEFAULT '0'
Error: Duplicate column name 'tags'

Error performing MySQL command: INSERT INTO pp_settings VALUES (226,'Use lightbox integration?','lightbox','','no',32,5)
Error: Duplicate entry '226' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (227,'Width to trigger lightbox integration (if enabled)?','lbwidth','','900',33,5)
Error: Duplicate entry '227' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (228,'Height to trigger lightbox integration (if enabled)?','lbheight','','600',34,5)
Error: Duplicate entry '228' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (229,'Use mature content filter?','mature','Prevents photos marked from mature being shown without user electing to view them.','no',18,2)
Error: Duplicate entry '229' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (230,'Use uniform thumbnail feature?','uniform','','no',26,6)
Error: Duplicate entry '230' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (231,'Uniform thumbnail height?','uniheight','Can only be used when using IM for imaging.','78',27,6)
Error: Duplicate entry '231' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (232,'Uniform thumbnail width','uniwidth','Can only be used when using IM for imaging.','120',28,6)
Error: Duplicate entry '232' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (233,'Use Messaging System for PhotoPost alerts/notices?','usemsg','','yes',38,1)
Error: Duplicate entry '233' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (234,'Use CAPTCHA images when verifying registration?','usecaptcha','Requires GD2 support!','no',4,8)
Error: Duplicate entry '234' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (235,'Enable PhotoPost Message Board?','usebb','Used only for internal PhotoPost systems.','no',5,13)
Error: Duplicate entry '235' for key 1

updating photo tags...done.
scanning for exifs... done.
updating users table...done.
updating votes...done.

Upgrade complete! To prevent users from modifying your PhotoPost database settings, please be sure to delete the upgrade.php file from your PhotoPost directory before continuing.

[Chuck S]

Duplicate issues are no big deal that just means you ran the upgrade before so those tables and entries are already present. If your gallery works then your good to go.