Forgot which version so how to upgrade?

titusc · May 23rd, 2006, 07:39 PM

Hello,

I had a version 4 photopost before and had run the upgrade script unsucessfully. So now I'm not sure which version do I have. What should I do?

I encountered errors during the upgrade as follow:

Quote:

Preparing to update 4.8.5 database...
Error performing MySQL command: ALTER TABLE photopostphotos ADD numcom INT(8) DEFAULT '0' NOT NULL , ADD lastposter VARCHAR(255), ADD lastpid INT(8) DEFAULT '0' NOT NULL
Error: Duplicate column name 'numcom'

Error performing MySQL command: ALTER TABLE photopostcategories ADD maximages INT(12) default '0' NOT NULL, ADD canzip VARCHAR(3) DEFAULT 'no' NOT NULL, ADD frames VARCHAR(32) NULL
Error: Duplicate column name 'maximages'

Error performing MySQL command: ALTER TABLE photopostcategories ADD numextra INT(3) default '0' NOT NULL
Error: Duplicate column name 'numextra'

Error performing MySQL command: ALTER TABLE photopostcategories ADD intro VARCHAR(3) default 'no' NOT NULL, ADD introtitle VARCHAR(128) DEFAULT NULL, ADD introcopy TEXT DEFAULT NULL, ADD moderators TEXT DEFAULT NULL
Error: Duplicate column name 'intro'

Error performing MySQL command: ALTER TABLE photopostcategories 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 photopostphotoviews (photoid mediumint(9) NOT NULL default '0') TYPE=HEAP
Error: Table 'photopostphotoviews' already exists

Error performing MySQL command: CREATE TABLE photopostextrafields (id INT(12) NOT NULL AUTO_INCREMENT, cat INT(12), fieldname VARCHAR(255), fieldtype VARCHAR(2), fieldoptions TEXT, PRIMARY KEY (id) )
Error: Table 'photopostextrafields' already exists

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

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

Move DATA directory files (you only do this only once successfully) --> or quit here.
Moving data files can take some time depending on your installation; 10,000 files could take 5 minutes or more. Please be patient.

Chuck S · May 23rd, 2006, 07:42 PM

Okay well it looks like you already ran that upgrade be careful cause you do not want to run step 3 of that upgrade more than once ever.

Look in your photos table with phpmyadmin and see if the user's userid's are prefixed to the bigimage field that contains the photo names. This will tell you if you ran that step already. You can safely run all the rest of the upgrades 5.0-5.3 double with no issues.

titusc · May 23rd, 2006, 08:20 PM

Hello,

Sorry which step is step 3?
And you mean to check if they are "bigimage_user193"?

Chuck S · May 23rd, 2006, 09:28 PM

Step 3 of the 485 upgrade is what you can not run more than once.

You can see if in the bigimage field the files are

imagename.jpg

or

useridimagename.jpg

this would tell whether you can that step

Chuck S · May 25th, 2006, 02:22 PM

why not just post a url to your install so we can see what version your on?

titusc · May 30th, 2006, 12:16 AM

Hello,

Quote:

Look in your photos table with phpmyadmin and see if the user's userid's are prefixed to the bigimage field that contains the photo names. This will tell you if you ran that step already. You can safely run all the rest of the upgrades 5.0-5.3 double with no issues.

Okay I went into phpMyAdmin and found the following tables but not sure which is the "photos" table that you want me to check.
photopostadmingroups
photopostadmlog
photopostcache
photopostcategories
photopostcomments
photopostecards
photopostexif
photopostextrafields
photopostfavorites
photopostipcache
photopostiponline
photopostlaston
photopostnotify
photopostphotoextras
photopostphotos
photopostphotoviews
photopostsettings
photopostsort
photopostsortmemb
photopostusergroups

Chuck S · May 30th, 2006, 09:19 AM

Please post your url to the install here for us to assist. What your posting just tells me lost likely you have ran all the upgrades.

titusc · May 30th, 2006, 12:34 PM

Hello,

It's at http://216.187.96.54/photopost or http://216.187.96.54/photopost/upgrade.php

Chuck S · May 30th, 2006, 12:48 PM

Okay well your issue has nothing to do with the upgrade scecifically.

You need to download the Photopost build and ftp the files to your server except the config files with the proper transfer protocol. It would appear looking at that page your files are correct possibly you are trying to transfer the php files as binary and not ascaii.

titusc · May 31st, 2006, 12:51 PM

CHUCK!

You are the man! I updated the values in the "photopostsettings" tables and the thing is now alive!! Alas. Without you I wouldn't even have thought about updating that table as I thought config.php would handle that. Afterall, I can't exactly login to the Admin panel to do that and have to do it in myPHPAdmin. Thanks!

Now, that comes to the next question. The Admin panel still shows that the new PhotoPost version is available even though I'm using the new version's files. And you mentioned to me that I have to check for these user_ids in this table. But what is this table's name? And which part of the upgrade process should I continue from?

titusc · June 2nd, 2006, 05:59 PM

Hello Chuck,

Okay this is what I found:
1) I check the "photos" table for the "userid" and "bigimage" fields. All of the "bigimage" fields have a number prefixed to the image file name. However, the number doesn't match the "userid" number on the same row. For example, I have "userid=579" but "bigimage=578newclam.jpg", or "userid=1619" but "bigimage=1735redmushroom.jpg".
2) Thinking that it is a userid anyway so I ran the 5.0x to 5.1 upgrade and got the following:

Code:

Content visible to verified customers only.

Chuck S · June 2nd, 2006, 07:57 PM

Did you switch integrations? The bigimage userid prefix is not a big deal if later you switched integrations. The userid being prefixed on the image just means you already ran 485 upgrade. So you where on a 5.0 version.

Just make sure you have all 5.3 files uploaded and run 5.0 thru 5.3

Duplicate mysql errors are not a problem

If your site runs fine your good to go dont worry about anything. The news thing is always going to report 5.3 is available and your current version is also shown on that stats screen in admin

titusc · June 2nd, 2006, 08:58 PM

Hello,

I switched from phpBB2 to vBulletin. I just ran the remaining part of the upgrade process and each steps shows duplication. And yeah it says version 5.3 in the admin panel.

I then ran the update databse part in the Admin panel and got the following:

Quote:

Processing may take a while... please be patient and wait the for FINISHED message...

Checking photo #4705: checking medium... creating...
Warning: copy(/var/www/virtual/canreef.com/webroot/htdocs/photopost/data/500/medium/DSC00351.JPG) [function.copy]: failed to open stream: Permission denied in /var/www/virtual/canreef.com/webroot/htdocs/photopost/adm-misc.php on line 1267
failed... - checking for exif - exif info added done.
Checking photo #4706: checking medium... creating...
Warning: copy(/var/www/virtual/canreef.com/webroot/htdocs/photopost/data/500/medium/DSC00240.JPG) [function.copy]: failed to open stream: Permission denied in /var/www/virtual/canreef.com/webroot/htdocs/photopost/adm-misc.php on line 1267
failed... - checking for exif - exif info added done.
Checking photo #4707: checking medium... not needed... - checking for exif - exif info added done.
Checking photo #4708: checking medium... creating...
Warning: copy(/var/www/virtual/canreef.com/webroot/htdocs/photopost/data/500/medium/230gApr11_06_006.jpg) [function.copy]: failed to open stream: Permission denied in /var/www/virtual/canreef.com/webroot/htdocs/photopost/adm-misc.php on line 1267
failed... - checking for exif - exif info added done.
Checking photo #4709: checking medium... creating...
Warning: copy(/var/www/virtual/canreef.com/webroot/htdocs/photopost/data/500/medium/IMG_1109_edited.jpg) [function.copy]: failed to open stream: Permission denied in /var/www/virtual/canreef.com/webroot/htdocs/photopost/adm-misc.php on line 1267
failed... - checking for exif - exif info added done.
Checking photo #4710: checking medium... not needed... - checking for exif - exif info added done.
Checking photo #4714: checking medium... creating...
Warning: copy(/var/www/virtual/canreef.com/webroot/htdocs/photopost/data/500/medium/reflector.jpg) [function.copy]: failed to open stream: Permission denied in /var/www/virtual/canreef.com/webroot/htdocs/photopost/adm-misc.php on line 1267
failed... - checking for exif - exif info added done.

Preparing to update categories with photo and posts information...

Preparing to update personal albums with photo and posts information...
Processing Personal Album Tank and corals ...
Processing Personal Album My Dogs ...

Thanks man.