Upgrade issues 6.02 to 6.1

nvader07 · May 6th, 2008, 11:26 PM

I am going from 6.02 to 6.1. Uploaded all files edited config-inc.php then ran script. Get this error when script is run: I realize the dups are from running the script over but the bottom error seems to have been the prevalent issue.

Preparing to update database...

Error performing MySQL command: INSERT INTO pp_settings VALUES (236,'Enable Email a Friend feature?','findfriend','','yes',7,4)
Error: Duplicate entry '236' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (238,'Use images for user menu options on showphoto?','imgmenu','','yes',35,5)
Error: Duplicate entry '238' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (239,'Enable zoom javascript?','zoom','Enable the TJP zoom javascript feature on showphoto?','no',36,5)
Error: Duplicate entry '239' for key 1

Error performing MySQL command: ALTER TABLE pp_messages ADD fromuserid INT( 12 ) DEFAULT '0' NOT NULL AFTER userid
Error: Duplicate column name 'fromuserid'

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/virtuat4/public_html/photopost/upgrade.php on line 2765

In the gallery I get this when clicking on a user:

Parse error: syntax error, unexpected $end in /home/virtuat4/public_html/photopost/templates/vb3enhanced/profile.tmpl on line 650

nvader07 · May 6th, 2008, 11:34 PM

Checked all the files I uploaded and they show to be updated from the 6.1 zip.

skidpics · May 6th, 2008, 11:39 PM

Quote:

Originally Posted by nvader07

In the gallery I get this when clicking on a user:

Parse error: syntax error, unexpected $end in /home/virtuat4/public_html/photopost/templates/vb3enhanced/profile.tmpl on line 650

I am getting a similar error when view internal messages..

nvader07 · May 6th, 2008, 11:53 PM

I am getting the error on messages too. I can view albums but get the error when viewing an individual user gallery or my messages. I dunno.

Nobody · May 7th, 2008, 04:18 AM

Also got errors with the upgrade here...was upgrading from 5.6.2 to 6.1. Photopost integrated with Vbulletin on separate db's.

warning message

Code:

Content visible to verified customers only.

Appeared at step..

Code:

Content visible to verified customers only.

Now I am getting the same errors as the people above when viewing member profiles, plus non of my categories are accessible, they are showing on the index as headers (collapsed sections) but don't open if clicked. Also in the search, the categories themselves are not listed.

Chuck S · May 7th, 2008, 11:02 AM

Duplicate errors means you already ran the upgrade script. The mysql query could be that there are no categories that do not have empty catavatars but should not affect any operation of the code.

The profile thing go to admin and edit your profile template and make template this

Code:

Content visible to verified customers only.

Nobody · May 7th, 2008, 11:15 AM

After the edit I get the following error...

Quote:

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/mydomain/public_html/gallery/templates/vb3enhanced/profile.tmpl on line 23

Also relating to my earlier post, I have some other issues existing, currently the gallery is non functional. I'll start a new thread regarding that though.

Chuck S · May 7th, 2008, 11:18 AM

If the profile template is what I posted here their is no issue

http://www.photopost.com/photopost/member.php?uid=2359

I took that template code right off our site here

http://www.photopost.com/photopost/t...d/profile.tmpl

Nobody · May 7th, 2008, 11:35 AM

Sorry Chuck, my mistake. I re-uploaded the original file instead of the edited one

All is well with the user profiles now

Chuck S · May 7th, 2008, 11:55 AM

Not a problem enjoy your day my friend.

nvader07 · May 7th, 2008, 01:27 PM

I now have this error on messages and profile views after the edit you posted Chuck.

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/virtuat4/public_html/photopost/templates/vb3enhanced/profile.tmpl on line 23

nvader07 · May 7th, 2008, 01:31 PM

OK Chuck, I wasn't in the vbenhanced folder. DOH! All is well, thanks for the help!!

Chuck S · May 7th, 2008, 02:54 PM

Not a problem have a good day!

sherpa · May 8th, 2008, 07:03 PM

@ nvader07
Sorry for out focusing your topic

@ Chuck
Do we need to run upgrade.php to go 6.1 from 6.02?

Chuck S · May 8th, 2008, 09:04 PM

Yes you need to run the upgrade as the announcement states.

sherpa · May 11th, 2008, 07:41 PM

Thanks Chuck

During the upgrade I encountered error below

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sherpa/public_html/photo/upgrade.php on line 2765

Chuck S · May 11th, 2008, 09:18 PM

That will not cause any issues it just scans and updates the last photo cat avatar field but it causes no issues. I have reported the issue and Michael should be fixing the build.

sherpa · May 15th, 2008, 10:41 PM

Ok
Now I found one parse error in profile.tmpl
If I click on some ones profile error comes saying
Parse error: syntax error, unexpected $end in /home/sherpa/public_html/photo/templates/profile.tmpl on line 665

Chuck S · May 15th, 2008, 10:55 PM

I am pretty sure all issues have been found. the template above is valid

Peter · May 25th, 2008, 09:52 AM

Hi, I am getting the same problem:

Parse error: syntax error, unexpected $end in /home/site/www/gallery/templates/profile.tmpl on line 665

Any idea how to fix it ?

Its not the vbenhanced one, I have no integration there.

If I replace with the code mentioned above, I get this:

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/site/www/gallery/templates/profile.tmpl on line 23

Thanks.