PP Pro 6.0.1 -> 7.0.2 upgrade questions

[Alfa1]

I'm preparing to upgrade my PP Pro installation from 6..0.1 to 7.0.2
I have big board with PP Pro - vbulletin integration and do not use PP forum. I use http and https.

Since there have been a lot of versions inbetween and I vaguely remember reading that this upgrade may need some extra work than the usual upgrade, I'd like to double check before going ahead.

To upgrade, should I just do the following?

* backup DB
* edit the same variables into config-inc.php as are in my 6.0.1 version.
* upload files
* run upgrade.php
* remove upgrade.php

Or is there anything else I should do?

[Chuck S]

That sounds right although there is no need to replace your config files when upgrading you can use the same one thats there.

[Alfa1]

Was a breeze. Thanks.

Asides from SEO urls, are there any other new settings that need to be reviewed?

[Alfa1]

Im getting this error.

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in */photopost/forums/vb3.php on line 175

As I assume that something went wrong with the upgrade, I have run the upgrade script again. On the 6.0 > 6.1 upgrade I get this:

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'

Any help would be appreciated.

[Chuck S]

MSQL_Fetch Issue

I think this is your issue which is totally unrelated to your upgrade.

[Alfa1]

Thanks.

[Chuck S]

no problem glad to help

[Alfa1]

I'm now encountering this error:

SELECT
id,user,userid,cat,storecat,date,title,description,ismature,keywords,bigimage,width,height,filesize,views,medwidth,medheight,medsize,approved,rating,votes,allowprint,numcom,lastposter
FROM pp_photos WHERE userid= AND storecat=0 ORDER BY disporder,date DESC

The query returned with an errorcode of:

You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'AND storecat=0 ORDER BY
disporder,date DESC' at line 1

Any idea how I can fix this?

[Chuck S]

where are you getting this

[Alfa1]

Im getting this in error emails sent from my Photopost installation. Subject 'MySQL Error Report'. One every few hours.

[Chuck S]

did you replace all your files when upgrading?

This looks mysteriously like something I fixed for 7.02 now off to go search down that thread on here.

[Alfa1]

I did reupload the files now. Just in case. But the error remains. Should I re-run the upgrade process?

[Chuck S]

SQL error

[kisii]

How can i upgrade from 5.21 to 7.1? These doesn't seem to be a path in the upgrade

[Chuck S]

Yes there is you upload the files and run the upgrade and select every upgrade once from 5.2 forward.