Upgrade Problems

larryd · January 19th, 2007, 10:57 PM

I'm upgrading my photopost from 4.66 to 5.62.

I have copied all of the files to the server except the config-inc.php and I have attempted to run the upgrade.php from 4.6 to the current version. I received multiple errors on most of the steps but kept getting the proceed option so I'd follow it ahead until I got to

http://www.newcelica.org/photopost/u...ade=485&step=1

At this step it gives me the error

Warning: require(/data/www/newcelica.org/html/photopost/forums/.php) [function.require]: failed to open stream: No such file or directory in /data/www/newcelica.org/html/photopost/pp-inc.php on line 4807

Fatal error: require() [function.require]: Failed opening required '/data/www/newcelica.org/html/photopost/forums/.php' (include_path='.:/usr/share/php5:/usr/share/php') in /data/www/newcelica.org/html/photopost/pp-inc.php on line 4807

I have a feeling I'm going to have to just do a fresh install but is there a way I can do a fresh install and keep all of the data or add the data back after the install?

larryd · January 19th, 2007, 11:05 PM

On another note I am able to run a fresh install on a different database and it was succesful.

larryd · January 20th, 2007, 01:19 PM

Here is my upgrade path step by step..

Preparing to update 4.6 database...

Performing MySQL command: ALTER TABLE photos ADD storecat INT(12) DEFAULT '0' NOT NULL AFTER `cat` ... Error: Duplicate column name 'storecat'
Performing MySQL command: ALTER TABLE photos ADD storeid INT(12) DEFAULT '0' NOT NULL AFTER `storecat` ... Error: Duplicate column name 'storeid'
Performing MySQL command: REPLACE INTO settings VALUES (136, 'Allow users to choose additional categories during upload?', 'optcats', '', 'no', 19, 6) ... Successful!

Upgrade complete! You should continue to next step
__________________________________________________________________

Preparing to update 4.6.7 database...

Performing MySQL command: REPLACE INTO settings VALUES (137, 'Enable slideshows?', 'slideshow', '', 'yes', 19, 6) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (138, 'Enable next and previous photo previews?', 'nextbox', '', 'yes', 20, 6) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (139, 'How many days after an eCard has been read do you want to keep it?', 'cardage', '', '7', 99, 5) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (140, 'Expire eCards after how many days (even if not read)?', 'cardexpire', '', '90', 100, 5) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (141, 'Acceptable multimedia file types?', 'acceptmm', 'Seperate file types by a comma and include the . (example: .mpg,.wma,.asf,.mp3)', '.mpeg,.mpg,.avi,.asf,.wmv,.mov', 89, 3) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (142, 'Acceptable image file types?', 'acceptimg', 'Seperate file types by a comma and include the . (example: .jpg,.gif,.png)', '.jpg,.jpeg,.png,.gif', 89, 3) ... Successful!
Performing MySQL command: ALTER TABLE usergroups ADD reqmod INT(3) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'reqmod'
Performing MySQL command: ALTER TABLE ecards ADD returnr INT(15) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'returnr'
Performing MySQL command: ALTER TABLE notify ADD type INT(2) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'type'
Performing MySQL command: ALTER TABLE ecards ADD readdate INT(15) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'readdate'
Performing MySQL command: DELETE FROM settings WHERE id = 22 ... Successful!
Performing MySQL command: DELETE FROM settings WHERE id = 57 ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (143,'Select a border for your thumbnails','thumbborder','Choose from the available borders for your thumbnails','thumbnail',62,2); ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (84,'PhotoPost Version','pversion','','4.7',53,0) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (37,'cright','cright','','Powered by: PhotoPost --replaceme--
Copyright 2007 All Enthusiast, Inc.',300,'0') ... Successful!

Upgrade complete! You should continue to next step
__________________________________________________________________

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 should continue to next step
__________________________________________________________________

Preparing to update 4.8.2 database...

Performing MySQL command: INSERT INTO settings VALUES (166,'BotBuster Integration', 'botbuster', 'Set to yes if you have BotBuster on your system (this includes the necessary tag)', 'no', 22, 1) ... Error: Duplicate entry '166' for key 1
Performing MySQL command: INSERT INTO settings VALUES (167,'Enable ZLIB page compression', 'compression', 'Set to on if you want to enable Zlib page compression (and it is supported)', 'yes', 23, 1) ... Error: Duplicate entry '167' for key 1
Performing MySQL command: INSERT INTO settings VALUES (168,'Date format', 'ppdateformat', 'Keywords: dow, month, mm, dd, yyyy', 'dow month dd, yyyy', 24, 1) ... Error: Duplicate entry '168' for key 1
Performing MySQL command: INSERT INTO settings VALUES (169,'GMT Offset', 'gmtoffset', 'If you are running VB and want the server to display the time as an offset of GMT (for example, to the timezone where your server is located), enter the offset here.', '-5', 25, 1) ... Error: Duplicate entry '169' for key 1
Performing MySQL command: INSERT INTO settings VALUES (170,'Enable IP Cache Timeout', 'ipcache', 'This variable is used to track IP addresses and userids for voting and viewing purposes. This is set in HOURS. 0 disables this setting', '0', 26, 1) ... Error: Duplicate entry '170' for key 1
Performing MySQL command: INSERT INTO settings VALUES (171,'PhotoPost Cookie Path', 'cookie_path', 'This should be set to match the path/domain for your cookies. Setting to / enables entire site.', '/', 1, 12) ... Error: Duplicate entry '171' for key 1
Performing MySQL command: INSERT INTO settings VALUES (172,'Forum Cookie Prefix', 'cookieprefix', 'Some Default values vB3: bb, phpBB2: phpbb2mysql, Threads: w3t_', '', 2, 12) ... Error: Duplicate entry '172' for key 1
Performing MySQL command: INSERT INTO settings VALUES (173,'PhotoPost Cookie Domain', 'domain_path', '.yourdomain.com; sets the cookie to be usable across the domain', 'newcelica.org', 3, 12) ... Error: Duplicate entry '173' for key 1
Performing MySQL command: INSERT INTO settings VALUES (174,'Debug Setting', 'debug', 'How do you want PhotoPost to handle errors?', '2', 27, 1) ... Error: Duplicate entry '174' for key 1
Performing MySQL command: INSERT INTO settings VALUES (175,'Enable On-The-Fly Watermarks', 'onthefly', 'Requires GD2 and you must edit the file watermark.php', 'no', 29, 5) ... Error: Duplicate entry '175' for key 1
Performing MySQL command: INSERT INTO settings VALUES (176,'Imaging Integration (IM or GD)', 'usegd', 'Select ImageMagick or GD1/GD2 for image processing', '0', 28, 1) ... Error: Duplicate entry '176' for key 1
Performing MySQL command: INSERT INTO settings VALUES (177,'Directory for backups?', 'backupdir', 'The full path to the directory to store backups', '/data/www/newcelica.org/html/photopost/backups', 29, 1) ... Error: Duplicate entry '177' for key 1
Performing MySQL command: INSERT INTO settings VALUES (178,'Path to mysqldump', 'mysqldumppath', 'The full path to your mysqldump executable', '/usr/local/bin/mysqldump', 30, 1) ... Error: Duplicate entry '178' for key 1
Performing MySQL command: INSERT INTO settings VALUES (179,'Path to jpegtran (if used)', 'jpegtran', 'If you would like to clean any JPG image uploaded before being processed; enter the path to your jpegtran executable.', '/usr/local/bin/jpgtran', 18, 1) ... Error: Duplicate entry '179' for key 1
Performing MySQL command: INSERT INTO settings VALUES (180,'Path to jhead (if used)', 'jhead_command', 'This only needs to be set if you are extracting EXIF information from images. Full server path.', '/usr/local/bin/jhead', 19, 1) ... Error: Duplicate entry '180' for key 1
Performing MySQL command: INSERT INTO settings VALUES (181,'Gallery Open?', 'ppboards', '', 'open', 20, 1) ... Error: Duplicate entry '181' for key 1
Performing MySQL command: INSERT INTO settings VALUES (182,'Message displayed when closed', 'closedmsg', '', 'The boards are temporarily down for maintainence.', 21, 1) ... Error: Duplicate entry '182' for key 1
Performing MySQL command: REPLACE INTO settings VALUES (165,'Your SMF Cookie Name', 'smfcookie', 'Only needed for users of SMF forums', '', 5, 13) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (183,'Show Peronsal Albums Index link under Members Gallery?', 'showalbum', 'Adds a text link to the Albums index into the Members Gallery description', 'yes', 10, 3) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (184,'Allow users to move their own images?','usermove', '', 'no', 16, 2) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (84,'PhotoPost Version','pversion','','4.85',53,0) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (37,'cright','cright','','Powered by: PhotoPost --replaceme--
Copyright 2007 All Enthusiast, Inc.',300,'0') ... Successful!
Performing MySQL command: REPLACE INTO admingroups VALUES (12,'Cookie Settings') ... Successful!
Performing MySQL command: REPLACE INTO admingroups VALUES (13,'Forum Settings') ... Successful!
Performing MySQL command: ALTER TABLE usergroups ADD uplimit INT(5) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'uplimit'
Performing MySQL command: ALTER TABLE categories ADD ugnovote VARCHAR(255) NULL AFTER ugnopost ... Error: Duplicate column name 'ugnovote'
Performing MySQL command: UPDATE settings SET title='Allow users to delete their own images?',optionorder=17 WHERE id=91 ... Successful!
Performing MySQL command: ALTER TABLE categories CHANGE catorder catorder MEDIUMINT(4) DEFAULT '9999' NOT NULL ... Successful!
Performing MySQL command: UPDATE categories SET catorder=9999 WHERE catorder=0 AND cattype='a' ... Successful!
Performing MySQL command: UPDATE settings SET section=13,optionorder=1 WHERE id=7 ... Successful!
Performing MySQL command: UPDATE settings SET section=13,optionorder=2 WHERE id=41 ... Successful!
Performing MySQL command: UPDATE settings SET section=13,optionorder=3 WHERE id=83 ... Successful!
Performing MySQL command: UPDATE settings SET section=13,optionorder=4 WHERE id=163 ... Successful!
Performing MySQL command: UPDATE settings SET section=13,optionorder=5 WHERE id=153 ... Successful!

Upgrade complete! You should continue to next step
__________________________________________________________________

Finally on -> This install script will upgrade your 4.8.5 or 4.8.6 release. Only run this upgrade if you have the 4.8.5 or 4.8.6 version of the database in place (either by previous upgrades or if upgrading in order to the latest).

I get this: includes/config.php does not exist. Cannot continue.

larryd · January 22nd, 2007, 01:19 PM

Anyone?

Chuck S · January 22nd, 2007, 02:33 PM

Looks to me like your not running all the requires upgrades.

Now I see things look fine on your site except viewing a photo you have deleted in vbulletin the user location so try adding this back in the vb sql box making sure to add any prefix to your vb tables in this query

ALTER TABLE userfield ADD field2 VARCHAR(75) DEFAULT NULL;

larryd · January 22nd, 2007, 07:03 PM

Things look fine on my site because I ran a new install. I've been uploading photos for 2 days straight and I'm only back to about 20% of what was in the old database not including any of the comments, ratings, or views.

Is there an easier way to import the data from my old database to the new database?

Chuck S · January 22nd, 2007, 07:46 PM

Nope there is not you must properly upgrade the old database so it can be used.

larryd · January 22nd, 2007, 10:06 PM

So what do you believe I was doing wrong? The version I was running before according to the config file was 4.66. I ran the upgrades starting at 4.6 one time and 4.6x another time. Regardless of which I start on I always get the errors listed above and then ultimately I get the includes/config.php does not exist. Cannot continue.

I'd really prefer to upgrade rather then keep the fresh install.

Chuck S · January 22nd, 2007, 10:37 PM

I can not say. You need to restore a 4.6 database and then upgrade and post back here with any error.

larryd · January 23rd, 2007, 01:51 AM

Thats what the error message above is from. Before I started the upgrade I backed up the database. I've replaced the database time and time again with the backup and I keep trying to run the upgrade script and I keep getting all the errors I describe above.

Chuck S · January 23rd, 2007, 09:21 AM

// Now lets include the forum integration
require "{$Globals['PP_PATH']}/forums/{$Globals['vbversion']}.php";

Lets look at your error why would you ever have that error unless the forum integration your using was empty and this is not something normal. Using phpmyadmin you can view your photopost settings table and setting 41 should say vb3.

You can then upgrade the old database and should not have that error.

larryd · January 23rd, 2007, 12:26 PM

OK that worked. I changed the setting and ran all of the upgrade scripts. I had a few errors but I did not document them as it allowed me to continue all the way through.

Now everything is looking good except I can not view pictures. When you click on any thumbnail you get an error stating

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script: showphoto

Query: SELECT u.username,u.homepage,u.usertitle,u.posts,u.joindate,uf.field2,s.host,t.signature FROM user u LEFT JOIN userfield uf ON uf.userid=u.userid LEFT JOIN session s ON s.userid=u.userid LEFT JOIN usertextfield t ON t.userid=u.userid WHERE u.userid=26369 LIMIT 1

Result: Unknown column 'uf.field2' in 'field list'

Database handle: Resource id #10

Chuck S · January 23rd, 2007, 02:40 PM

See post 5 of mine above that I already noted. You have deleted an important vb database field for user location and I posted a query above for you to add it back.

larryd · January 23rd, 2007, 03:14 PM

This is what you noted to do

ALTER TABLE userfield ADD field2 VARCHAR(75) DEFAULT NULL;

There is no table userfield in the photopost database. Not in mine anyhow.

larryd · January 23rd, 2007, 03:20 PM

larryd · January 23rd, 2007, 03:21 PM

Also for whatever reason my gallery now is not showing any images as thumnails either. Before it showed all the thumbnails and even though I changed nothing I've come back a few hours later and it says no thumbnail on each picture.

Chuck S · January 23rd, 2007, 03:26 PM

The query I noted is for your vb admin not Photopost as noted in my post

You dont have any thumbnails since you ran your 4.85 upgrade twice. You need to restore a backup of the photos table and rerun upgrades ONCE.

larryd · January 23rd, 2007, 04:24 PM

OK, I ran the query on the VB Database and I reran the upgrades after restoring the original PhotoPost database. Everything went smooth except the following errors.

-----------------------------------

Warning: unlink(/data/www/newcelica.org/html/photopost/adm-userg.php) [function.unlink]: No such file or directory in /data/www/newcelica.org/html/photopost/upgrade.php on line 2109

Warning: unlink(/data/www/newcelica.org/html/photopost/adm-approve.php) [function.unlink]: No such file or directory in /data/www/newcelica.org/html/photopost/upgrade.php on line 2110

Warning: unlink(/data/www/newcelica.org/html/photopost/adm-db.php) [function.unlink]: No such file or directory in /data/www/newcelica.org/html/photopost/upgrade.php on line 2111

Warning: unlink(/data/www/newcelica.org/html/photopost/adm-menu.php) [function.unlink]: No such file or directory in /data/www/newcelica.org/html/photopost/upgrade.php on line 2112

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /data/www/newcelica.org/html/photopost/pp-inc.php on line 2809

-----------------------------------

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /data/www/newcelica.org/html/photopost/pp-inc.php on line 3921

-----------------------------------

Everything appears to be working great and I owe you a huge thank you. Are the errors above anything I need to address?

Chuck S · January 23rd, 2007, 05:03 PM

The file unlink errors are no big deal and your site looks fine

larryd · January 23rd, 2007, 05:19 PM

Great, THANK YOU VERY MUCH