Upgrade from 4.7j to 4.8 errors! Help!

dealios · June 7th, 2004, 10:11 AM

Started the upgrade process, and the first screen after continue I got this error:

Preparing to reorganize admin options...
ALTER TABLE photop_categories DROP INDEX lastphoto failed with error: Can't DROP 'lastphoto'. Check that column/key exists
ALTER TABLE photop_categories DROP INDEX thumbnail failed with error: Can't DROP 'thumbnail'. Check that column/key exists
ALTER TABLE photop_iponline DROP INDEX userid failed with error: Can't DROP 'userid'. Check that column/key exists
ALTER TABLE photop_photos DROP INDEX approved failed with error: Can't DROP 'approved'. Check that column/key exists
ALTER TABLE photop_photos DROP INDEX date failed with error: Can't DROP 'date'. Check that column/key exists

Done! You can now remove this file and check out your new Admin Options layout!

I had 4.7j installed prior to this.....

Now when I goto my site, I see this...

Warning: main(/home/sites/yoursite/photopost/languages/english/pp-inc.php): failed to open stream: No such file or directory in /home/virtual/site10/fst/var/www/html/voice/gallery/pp-inc.php on line 63

Fatal error: main(): Failed opening required '/home/sites/yoursite/photopost/languages/english/pp-inc.php' (include_path='.:/usr/share/pear') in /home/virtual/site10/fst/var/www/html/voice/gallery/pp-inc.php on line 63

Any clues?

June 7th, 2004, 10:14 AM

http://www.photopost.com/members/for...60&postcount=2

dealios · June 7th, 2004, 10:30 AM

Ok, I changed the 4 lines, but their was only 1 WHERE in line 88... it read this..

$query[] = "DELETE FROM {$pp_db_prefix}settings WHERE id=33";

I ran upgrade47 again and now I get this..

Preparing to reorganize admin options...
INSERT INTO photop_admingroups VALUES (7,'Comments Options') failed with error: Duplicate entry '7' for key 1
INSERT INTO photop_admingroups VALUES (8,'Registration Options') failed with error: Duplicate entry '8' for key 1
INSERT INTO photop_admingroups VALUES (9,'Layout Options') failed with error: Duplicate entry '9' for key 1
INSERT INTO photop_admingroups VALUES (10,'Watermark Options') failed with error: Duplicate entry '10' for key 1
ALTER TABLE photop_comments ADD ipaddress VARCHAR(32) failed with error: Duplicate column name 'ipaddress'
ALTER TABLE photop_photos ADD ipaddress VARCHAR(32) failed with error: Duplicate column name 'ipaddress'
INSERT INTO photop_admingroups VALUES (11, 'Sidebar Settings') failed with error: Duplicate entry '11' for key 1
INSERT INTO photop_settings VALUES (144, 'Sidebar Placement?', 'sidebar', 'Set this to off for no sidebar or left or right depending on your tastes.', 'off', 1, 11) failed with error: Duplicate entry '144' for key 1
INSERT INTO photop_settings VALUES (145, 'Sidebar Width', 'sidebar_width', ' Choose the width for your sidebar', '20%', 4, 11) failed with error: Duplicate entry '145' for key 1
INSERT INTO photop_settings VALUES (146, 'Under Category PAL?', 'undercat', ' Display Recent Comments and Who\'s Online Pals', 'no', 5, 11) failed with error: Duplicate entry '146' for key 1
INSERT INTO photop_settings VALUES (147, 'Statistics PAL?', 'statspal', ' Display Statistics Pal?', 'yes', 6, 11) failed with error: Duplicate entry '147' for key 1
INSERT INTO photop_settings VALUES (148, 'Top Posters PAL?', 'topposterspal', ' Display Top Posters Pal?', 'no', 7, 11) failed with error: Duplicate entry '148' for key 1
INSERT INTO photop_settings VALUES (149, 'Random Image PAL?', 'randompal', ' Display Random Image?', 'yes', 8, 11) failed with error: Duplicate entry '149' for key 1
INSERT INTO photop_settings VALUES (150, 'Highest Ratings PAL?', 'ratingspal', ' Display Highest Ratings?', 'no', 9, 11) failed with error: Duplicate entry '150' for key 1
INSERT INTO photop_settings VALUES (151, 'Show Sidebar on Index Page?', 'sidebar_index', '', 'no', 2, 11) failed with error: Duplicate entry '151' for key 1
INSERT INTO photop_settings VALUES (152, 'Show Sidebar Globally?', 'sidebar_global', 'Showsidebar on showphoto,showmembers and showgallery pages?', 'no', 3, 11); failed with error: Duplicate entry '152' for key 1
INSERT INTO photop_settings VALUES (153, 'Default theme setting (UBBThreads users only)', 'threads', 'Threads Users: We need to know what the site default theme setting is.', 'infopop', 18, 1) failed with error: Duplicate entry '153' for key 1
INSERT INTO photop_settings VALUES (154, 'Show signatures?', 'showsigs', 'When available, display signatures?', 'yes', 27, 5) failed with error: Duplicate entry '154' for key 1
INSERT INTO photop_settings VALUES (155, 'Show Avatars?', 'showavatar', 'When available, show avatars?', 'yes', 28, 5) failed with error: Duplicate entry '155' for key 1
INSERT INTO photop_settings VALUES (156, 'Show Category Avatars?', 'indexavatars', 'Do you want to display the Index Avatars?', 'yes', 9, 3) failed with error: Duplicate entry '156' for key 1
INSERT INTO photop_settings VALUES (157, 'Display Custom PAL #1', 'custom1pal', ' If you modified the custom1pal.tmpl and want to include it set to yes', 'no', 11, 11) failed with error: Duplicate entry '157' for key 1
INSERT INTO photop_settings VALUES (158, 'Display Custom PAL #2', 'custom2pal', ' If you modified the custom2pal.tmpl and want to include it set to yes', 'no', 12, 11) failed with error: Duplicate entry '158' for key 1
INSERT INTO photop_settings VALUES (159, 'Display Custom PAL #3', 'custom3pal', ' If you modified the custom3pal.tmpl and want to include it set to yes', 'no', 13, 11) failed with error: Duplicate entry '159' for key 1
INSERT INTO photop_settings VALUES (160, 'Number of Top Posters to display', 'numtoppal', '', '5', 14, 11) failed with error: Duplicate entry '160' for key 1
INSERT INTO photop_settings VALUES (161, 'Number of Last Comments to display', 'numcompal', '', '5', 15, 11) failed with error: Duplicate entry '161' for key 1
INSERT INTO photop_settings VALUES (162, 'Number of Most Popular Photos to display', 'mostpoppal', '', '5', 16, 11) failed with error: Duplicate entry '162' for key 1
INSERT INTO photop_settings VALUES (163, 'Use Integrated forum stylesheets?', 'forumstyle', 'If you use a forum like vB3 or Threads and want to use the intergated stylesheet option, choose Yes', 'no', 19, 1) failed with error: Duplicate entry '163' for key 1
INSERT INTO photop_settings VALUES (164, 'Use Whos Online PAL?', 'onlinepal', '', 'yes', 10, 11) failed with error: Duplicate entry '164' for key 1
ALTER TABLE photop_usergroups ADD canassign INT(3) DEFAULT '0' NOT NULL failed with error: Duplicate column name 'canassign'
ALTER TABLE photop_categories ADD sortorder INT(2) DEFAULT '1' NOT NULL, ADD extra1 VARCHAR(250), ADD extra2 VARCHAR(250), ADD extra3 VARCHAR(250), ADD extra4 VARCHAR(250), ADD extra5 VARCHAR(250), ADD extra6 VARCHAR(250), ADD thumbnail INT(15) DEFAULT '0' NOT NULL failed with error: Duplicate column name 'sortorder'

Done! You can now remove this file and check out your new Admin Options layout!

MORE ERRORS! Help needed

dealios · June 7th, 2004, 11:01 AM

donny b in da house? help

June 7th, 2004, 11:38 AM

Duplicates are ok.

How's the gallery itself running?

dealios · June 7th, 2004, 12:52 PM

its not running at all...

Im still getting this error

Warning: main(/home/sites/yoursite/photopost/languages/english/pp-inc.php): failed to open stream: No such file or directory in /home/virtual/site10/fst/var/www/html/voice/gallery/pp-inc.php on line 63

Fatal error: main(): Failed opening required '/home/sites/yoursite/photopost/languages/english/pp-inc.php' (include_path='.:/usr/share/pear') in /home/virtual/site10/fst/var/www/html/voice/gallery/pp-inc.php on line 63

txbigguy · June 7th, 2004, 01:00 PM

I am getting the same error as well.....

June 7th, 2004, 01:00 PM

/home/sites/yoursite/photopost

Edit the path in the config-inc.php file. $pp_path

// Path to your PhotoPost installation - no end slashes
$PP_PATH = "/home/sites/yoursite/photopost";

It should read

$PP_PATH = "/home/virtual/site10/fst/var/www/html/voice/gallery";

dealios · June 7th, 2004, 01:02 PM

yep, just realized up i uploaded the 4.7 config instead of the fixed 4.8 config... ugh...

thanks

txbigguy · June 7th, 2004, 01:06 PM

Yea that did the trick for me...

dealios · June 7th, 2004, 01:19 PM

WOA, just fixed my gallery to look like my forums look!!

These 2 options need to be set:

Default theme setting (UBBThreads users only)
Threads Users: We need to know what the site default theme setting is.

make sure it is blank

Use Integrated forum stylesheets?

If you use a forum like vB3 or Threads and want to use the intergated stylesheet option, choose Yes

skj310 · June 10th, 2004, 07:37 PM

As well I've just upgraded to PP4.8c and i can no longer see my thumbnails.
All files in data directory still exist with correct permissions
PP_PATH in config-inc.php is pointed to the correct location
the admin options look to be correct as well
finally i reformed scan database to recreate the thumbnails and still no luck (i verified that all thumbnails in data directory have been changed to today (just after scan completed), so i know the rebuild of thumbnails was correct and occurred in correct location.

so why can't i see thumbnails on any of my gallery pages?

skj310 · June 10th, 2004, 07:49 PM

one more issue related to upgrade from 4.7j to 4.8c

"edit category" from administrator looks very weird!
each category is usually followed by hyperlinks within [] brackets ... the only link that shows up for me is [sort subcats]. what went wrong here?

rbl · June 10th, 2004, 08:24 PM

have you updated the language files?

skj310 · June 10th, 2004, 08:55 PM

figured out the problem with the above 2 posts by me ...

to do the upgrade i stuck the 4.8c files into a temp dir called /www/temp
the older version 4.7j was in /www/photopost

then i simply did some "mv <whatever ... dir or file.*>" to update to the newer release

ultimately while checking timestamps i learned that many of the php files in my main /www/photopost dir were still 4.7j ... -embarrassment-

repeated the move ... this time blowing away the 4.7j files and boom ... works (for the most part)!!

thanks for the quick reply!

Pasqualis · September 21st, 2004, 08:40 PM

Quote:

Originally Posted by dealios

Started the upgrade process, and the first screen after continue I got this error:

Preparing to reorganize admin options...
ALTER TABLE photop_categories DROP INDEX lastphoto failed with error: Can't DROP 'lastphoto'. Check that column/key exists
ALTER TABLE photop_categories DROP INDEX thumbnail failed with error: Can't DROP 'thumbnail'. Check that column/key exists
ALTER TABLE photop_iponline DROP INDEX userid failed with error: Can't DROP 'userid'. Check that column/key exists
ALTER TABLE photop_photos DROP INDEX approved failed with error: Can't DROP 'approved'. Check that column/key exists
ALTER TABLE photop_photos DROP INDEX date failed with error: Can't DROP 'date'. Check that column/key exists

I had this same error when I upgraded from 4.6.5 to 4.8.2 tonight.
I just continued my installation and all seems to be fine.... but is it ?!

Chuck S · September 21st, 2004, 09:31 PM

Your cant drop the index's

You can go in with phpmyadmin IF YOU KNOW WHAT YOUR DOING and drop those index's

Notice I capitalized the one part

We had one user here who actually went in and deleted the actual table structure equivilents not the index's

These are basically performance enhancing things to speed things up.

Pasqualis · September 22nd, 2004, 02:29 AM

Thanks for the quick reply!

So okay... what actions do I have to take from my phpmyadmin ?

Pasqualis · September 26th, 2004, 05:43 AM

bump...

Chuck S · September 26th, 2004, 10:05 AM

I already answered the question in my post. The mysql queries are self explanatory.

I dont know if I can be any clearer than drop those index's on the proper table.

If you do not know what an index is then you should not be attempting what I suggested one post up. As stated I had a customer delete their fields in their category table thinking I had told them to drop them. An index appears at the end of the table structure when viewing structure of the table.