4.5.1 to 4.8 install HELP!!!!!

aluisi · November 30th, 2004, 06:47 PM

Okay so i downloaded the newest build. I put all the upgrade files up there. I ran the upgrade from 4.5 to 4.6 it said it worked then i went on to 4.6 to 4.6.7 and that one worked. Now when i do the 4.6.7 to 4.7 it tells me that everything it was updating failed. What am i doing worng. Even when i look in my photo post it still says i only have 4.5.1 please some one help

Chuck S · November 30th, 2004, 09:09 PM

What do you mean everything failed?

A Link?

An error anything for us to work with?

aluisi · November 30th, 2004, 10:13 PM

This is what I get

Preparing to reorganize admin options...
INSERT INTO admingroups VALUES (7,'Comments Options') failed with error: Duplicate entry '7' for key 1
INSERT INTO admingroups VALUES (8,'Registration Options') failed with error: Duplicate entry '8' for key 1
INSERT INTO admingroups VALUES (9,'Layout Options') failed with error: Duplicate entry '9' for key 1
INSERT INTO admingroups VALUES (10,'Watermark Options') failed with error: Duplicate entry '10' for key 1
ALTER TABLE comments ADD ipaddress VARCHAR(32) failed with error: Duplicate column name 'ipaddress'
ALTER TABLE photos ADD ipaddress VARCHAR(32) failed with error: Duplicate column name 'ipaddress'
INSERT INTO admingroups VALUES (11, 'Sidebar Settings') failed with error: Duplicate entry '11' for key 1
INSERT INTO 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 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 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 settings VALUES (147, 'Statistics PAL?', 'statspal', ' Display Statistics Pal?', 'yes', 6, 11) failed with error: Duplicate entry '147' for key 1
INSERT INTO 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 settings VALUES (149, 'Random Image PAL?', 'randompal', ' Display Random Image?', 'yes', 8, 11) failed with error: Duplicate entry '149' for key 1
INSERT INTO settings VALUES (150, 'Highest Ratings PAL?', 'ratingspal', ' Display Highest Ratings?', 'no', 9, 11) failed with error: Duplicate entry '150' for key 1
INSERT INTO settings VALUES (151, 'Show Sidebar on Index Page?', 'sidebar_index', '', 'no', 2, 11) failed with error: Duplicate entry '151' for key 1
INSERT INTO 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 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 settings VALUES (154, 'Show signatures?', 'showsigs', 'When available, display signatures?', 'yes', 27, 5) failed with error: Duplicate entry '154' for key 1
INSERT INTO settings VALUES (155, 'Show Avatars?', 'showavatar', 'When available, show avatars?', 'yes', 28, 5) failed with error: Duplicate entry '155' for key 1
INSERT INTO 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 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 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 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 settings VALUES (160, 'Number of Top Posters to display', 'numtoppal', '', '5', 14, 11) failed with error: Duplicate entry '160' for key 1
INSERT INTO settings VALUES (161, 'Number of Last Comments to display', 'numcompal', '', '5', 15, 11) failed with error: Duplicate entry '161' for key 1
INSERT INTO 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 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 settings VALUES (164, 'Use Whos Online PAL?', 'onlinepal', '', 'yes', 10, 11) failed with error: Duplicate entry '164' for key 1
ALTER TABLE usergroups ADD canassign INT(3) DEFAULT '0' NOT NULL failed with error: Duplicate column name 'canassign'
ALTER TABLE 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!

Chuck S · December 1st, 2004, 07:58 AM

Okay well all that means is you ran the upgrade already.

Link to your install?

aluisi · December 1st, 2004, 12:21 PM

Well this is what I dot the first time when upgrading from 4.7 to 4.8 i never ran that upgrade before and that is what I got. Also at the bottom of the page where is says its powered by photo post it still say 4.5.1

Chuck S · December 1st, 2004, 12:36 PM

okay and you did not answer my question. Mysql does not lie. You had to run the upgrade script before.

You did not provide a link to your install.

An upgrade is pretty simple. You upload all the new files EXCEPT THE CONFIG FILE and any modified stylesheet,header or footer and then run the upgrade scripts.

If your files still say 4.5.1 then did you upload all the new files?

aluisi · December 1st, 2004, 01:32 PM

I uploaded all the files. I didnt overwrite any of the folders jsut the files in the main directory. it says it upgrades fin from 4.5 up to 4.6 then fromt 4.6.7 i get some errors sating its a duplicate directore then from 4.6.7 to 4.7 i get what I posted up top. and I cant even move on to the 4.7 to 4.8 it sasy its done and updated but it still shows that i have 4.5.1 that was the first time. Now i restored everything to the origanl and tried again and did all the upgradeds with the same errors and now I get this when i go to my page

http://www.trevorjames.biz/gallery/index.php

Chuck S · December 1st, 2004, 02:32 PM

You have not followed the upgrade instructions in the upgrade folder.

You need to upload ALL FILES except your config file, any modified stylesheet if you modified one and of course the header.htm footer.htm

So in essense do this

Unzip the files to your computer.

Delete the following files

install.php
config-inc.php
header.htm
footer.htm
/stylesheets/default.css --SINCE YOU MODIFIED THIS ONE

UPLOAD EVERYTHING ELSE OVER YOUR CURRENT INSTALL ON THE WEB.

aluisi · December 1st, 2004, 04:55 PM

What about the Data folder that contains all my pictures for our gallery? Should I keep that current one on my server?

Chuck S · December 1st, 2004, 04:58 PM

Yes keep it

I said overwrite. I said nothing about deleting anything on the server. You do not want to delete anything on your server.You can upload the uploads and data folders from the distribution to your install as it wont harm whats already there

The point here is to make sure your uploading all the 4.8.2 files as you have no done that and this is the issue at hand

aluisi · December 1st, 2004, 05:05 PM

also do I have to redo the upgrade process?

aluisi · December 1st, 2004, 05:15 PM

okay it worked. Thanks for your help upgreading. But now I am getitng two issues one with the thumb nails when there rebuilt all the thumbnails look faded or back and white there are all just ruined. Also i am trying to close the gallery so that I can do matinace and I am getting a error stating this

Warning: fopen(config-inc.php): failed to open stream: Permission denied in /home/virtual/site1/fst/var/www/html/gallery/adm-editcfg.php on line 26

Warning: fwrite(): supplied argument is not a valid stream resource in /home/virtual/site1/fst/var/www/html/gallery/adm-editcfg.php on line 27

Warning: fclose(): supplied argument is not a valid stream resource in /home/virtual/site1/fst/var/www/html/gallery/adm-editcfg.php on line 28

I looked at the scripts and it is not in safe mode but it is not alowing me to close the gallery

aluisi · December 1st, 2004, 05:47 PM

okay I know this is in the wrong posting area so i will post in the error section

Chuck S · December 1st, 2004, 07:00 PM

chmod the files per the installation instructions. that file needs to be 666