View Full Version : PP Pro 6.0.1 -> 7.0.2 upgrade questions
October 5th, 2010, 10:15 AM
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?
October 5th, 2010, 10:35 AM
That sounds right although there is no need to replace your config files when upgrading you can use the same one thats there.
October 5th, 2010, 11:55 AM
Was a breeze. Thanks.
Asides from SEO urls, are there any other new settings that need to be reviewed?
October 5th, 2010, 01:05 PM
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: 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.
October 5th, 2010, 02:14 PM
I think this is your issue which is totally unrelated to your upgrade.
October 5th, 2010, 02:50 PM
October 5th, 2010, 03:26 PM
no problem glad to help
October 5th, 2010, 04:29 PM
I'm now encountering this error:
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?
October 5th, 2010, 06:18 PM
where are you getting this
October 6th, 2010, 05:57 AM
Im getting this in error emails sent from my Photopost installation. Subject 'MySQL Error Report'. One every few hours.
October 6th, 2010, 07:46 AM
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.
October 9th, 2010, 11:21 AM
I did reupload the files now. Just in case. But the error remains. Should I re-run the upgrade process?
October 9th, 2010, 11:24 AM
June 1st, 2011, 10:06 PM
How can i upgrade from 5.21 to 7.1? These doesn't seem to be a path in the upgrade
June 1st, 2011, 10:37 PM
Yes there is you upload the files and run the upgrade and select every upgrade once from 5.2 forward.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.