upgrade from 482

saltyzoo · October 20th, 2007, 02:04 PM

I'm having the strangest problem. I'm trying to upgrade from 4.8 to 6 and when I try to do the 482 upgrade it just keeps coming back to the same screen over and over. Tossing in some debug shows that the $upgrade and $step variables are getting nulled out when config-inc.php is being included.

Any ideas what would cause this? I had no problem on my test server doing the upgrade (of course), and I've compared all my settings a dozen times especially the integration settings and they "seem" to be correct.

saltyzoo · October 21st, 2007, 09:51 AM

help?

iloco · October 21st, 2007, 10:08 AM

I am also having a problem.

I am getting a page full of errors that are referring to pp_settings doesn't exist.

Quote:

..

Performing MySQL command: INSERT INTO pp_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: Table 'ourexpre_forum.pp_settings' doesn't exist

Here is the SITE
User: test
Pass: test

Chuck S · October 21st, 2007, 10:53 AM

Is your Photopost tables in the forum database or some other database. We get the database settings from your photopost config file. What in that error tells you what your issue is?

Salty at the top of the upgrade.php file try adding this line and see if that helps.

Code:

Content visible to verified customers only.

iloco · October 21st, 2007, 11:11 AM

All the data base is in the forums data base. Only one data base.

Here are all the errors I get when I run the upgrade script.

Quote:

Preparing to update 4.8.2 database...

Performing MySQL command: INSERT INTO pp_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: Table 'ourexpre_forum.pp_settings' doesn't exist
Performing MySQL command: INSERT INTO pp_settings VALUES (167,'Enable ZLIB page compression', 'compression', 'Set to on if you want to enable Zlib page compression (and it is supported)', 'no', 23, 1) ... Error: Table 'ourexpre_forum.pp_settings' doesn't exist
Performing MySQL command: INSERT INTO pp_settings VALUES (168,'Date format', 'ppdateformat', 'Keywords: dow, month, mm, dd, yyyy', '', 24, 1) ... Error: Table 'ourexpre_forum.pp_settings' doesn't exist
Performing MySQL command: INSERT INTO pp_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.', '', 25, 1) ... Error: Table 'ourexpre_forum.pp_settings' doesn't exist
Performing MySQL command: INSERT INTO pp_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', '', 26, 1) ... Error: Table 'ourexpre_forum.pp_settings' doesn't exist
Performing MySQL command: INSERT INTO pp_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: Table 'ourexpre_forum.pp_settings' doesn't exist
Performing MySQL command: INSERT INTO pp_settings VALUES (172,'Forum Cookie Prefix', 'cookieprefix', 'Some Default values vB3: bb, phpBB2: phpbb2mysql, Threads: w3t_', '', 2, 12) ... Error: Table 'ourexpre_forum.pp_settings' doesn't exist
Performing MySQL command: INSERT INTO pp_settings VALUES (173,'PhotoPost Cookie Domain', 'domain_path', '.yourdomain.com; sets the cookie to be usable across the domain', '', 3, 12) ... Error: Table 'ourexpre_forum.pp_settings' doesn't exist
Performing MySQL command: INSERT INTO pp_settings VALUES (174,'Debug Setting', 'debug', 'How do you want PhotoPost to handle errors?', '', 27, 1) ... Error: Table 'ourexpre_forum.pp_settings' doesn't exist
Performing MySQL command: INSERT INTO pp_settings VALUES (175,'Enable On-The-Fly Watermarks', 'onthefly', 'Requires GD2 and you must edit the file watermark.php', 'no', 29, 5) ... Error: Table 'ourexpre_forum.pp_settings' doesn't exist
Performing MySQL command: INSERT INTO pp_settings VALUES (176,'Imaging Integration (IM or GD)', 'usegd', 'Select ImageMagick or GD1/GD2 for image processing', '', 28, 1) ... Error: Table 'ourexpre_forum.pp_settings' doesn't exist
Performing MySQL command: INSERT INTO pp_settings VALUES (177,'Directory for backups?', 'backupdir', 'The full path to the directory to store backups', '', 29, 1) ... Error: Table 'ourexpre_forum.pp_settings' doesn't exist
Performing MySQL command: INSERT INTO pp_settings VALUES (178,'Path to mysqldump', 'mysqldumppath', 'The full path to your mysqldump executable', '', 30, 1) ... Error: Table 'ourexpre_forum.pp_settings' doesn't exist
Performing MySQL command: INSERT INTO pp_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.', '', 18, 1) ... Error: Table 'ourexpre_forum.pp_settings' doesn't exist
Performing MySQL command: INSERT INTO pp_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.', '', 19, 1) ... Error: Table 'ourexpre_forum.pp_settings' doesn't exist
Performing MySQL command: INSERT INTO pp_settings VALUES (181,'Gallery Open?', 'ppboards', '', '', 20, 1) ... Error: Table 'ourexpre_forum.pp_settings' doesn't exist
Performing MySQL command: INSERT INTO pp_settings VALUES (182,'Message displayed when closed', 'closedmsg', '', '', 21, 1) ... Error: Table 'ourexpre_forum.pp_settings' doesn't exist

This is an older version ov VBB. 2.3.4. You said before in another thread that should not have any problem using an older version of VBB to upgrade PP to 6.0.

Chuck S · October 21st, 2007, 11:30 AM

I would suggest you verify nothing has changed in your database. There is no issues upgrading Photopost from 482 I have done a few this past week.

Looks at the error.

Code:

Content visible to verified customers only.

That tells me your pp_settings table does not exist in the ourexpre_forum database so can you confirm this why is it not there? where is photopost database?

saltyzoo · October 21st, 2007, 11:37 AM

Quote:

Originally Posted by Chuck S

Is your Photopost tables in the forum database or some other database. We get the database settings from your photopost config file. What in that error tells you what your issue is?

Salty at the top of the upgrade.php file try adding this line and see if that helps.

Code:

Content visible to verified customers only.

That worked, but now I have another problem. Before we go on to that problem can you explain why that worked?

saltyzoo · October 21st, 2007, 11:39 AM

Well, just ignoring the errors during upgrade and plowing on through it seemed to work ok anyway.

Chuck S · October 21st, 2007, 11:46 AM

Okay thats cool.

saltyzoo · October 21st, 2007, 12:18 PM

I'm still curious why that worked though. What did it do?

Chuck S · October 21st, 2007, 02:00 PM

well the error your showing me here I posted what I thought was wrong based on that error but other than that I can not say.

iloco · October 21st, 2007, 03:01 PM

Found the pp_ tht was causing the problem.
After updating with bunches of errors that I kelp on continuing withI got it updated but I have no thumbnails showing now.

You can use the link and pass word to see what it looks like.

Chuck S · October 21st, 2007, 06:12 PM

Okay if I am following here for one you had the wrong prefix in your config file so I am going to assume you replaced your config files and typed in what you thought was all the wrong info. The upgrade states never to overright the config files for this very reason.

Now next if your missing photos you more than likely ran your 485 upgrade more than once which will mess your photos up and you saw them not showing so you ran a scan database to try and get them back. That will just delete them because your filenames are wrong in the database. You need to restore a backup of your photos table and run through the upgrades you need to run ONLY ONCE.

If you do this you will be fine.

iloco · October 21st, 2007, 06:21 PM

Yes I did overwrite the config file with the one I edited with right info to get rid the error.

No I only ran the update one time.

What will happen if I rung update again now that I edited the config file.

I will get my host to put back the backup I made if cant get it fixed this way.
Thanks Chuck.

How do I restore the photo tables.

Chuck S · October 21st, 2007, 06:39 PM

You would use your hosting control panel to restore a backup of the photos table in your database. This would depend on the fact that you actually do backup your database.

After you restore that table just run the upgrades once and you will be okay.

iloco · October 21st, 2007, 06:53 PM

I did a complete back up from the cpanel and its stored on the home directory and I downloaded a copy as well.

I will open it and see if I can find a table for the photos. I am not very good with the techinal part of all this. Will give it a try and see. Cant mess up no more than what got now with no photos or thumbnails and also lost the categoreys. ?SP.

I have asked atomhost to restore the back up I had saved before the mess up with PP.
Chuck when it is back as before can I get you to run the upgrade script after I upload the files to the PP directory. I want to backup everything once more including the data base which I didnt do. Its in the full backp but I have no idea how to get into what I need.