Upgrade to 5.5 was not successful

[mwaite49]

Two days ago my gallery was just fine. Yesterday I went to it and nothing appeared. I looked at my files and no photos or comments had been made to it in over a week. The latest files that had changed were from my ISP changing their customer management system. I called them and they looked at the problem and returned an email. The email stated that the problem must be with Photopost. They did something so that my gallery page now showed these errors

"Notice: Undefined offset: 0 in /var/www/html/gallery/index.php on line 15

Fatal error: Call to undefined function: get_regcode() in /var/www/html/gallery/pp-inc.php on line 3037

I don't suspect Photopost since my site has run without problems for quite some time.

I decided that the best answer might be to upgrade, so I purchased Photopost 5.5. My upgrade to 5.5 failed and I get this message on the page the upgrade starts:

Preparing to update database...

Error performing MySQL command: ALTER TABLE pp_photos ADD allowrate INT(1) DEFAULT '1' NOT NULL, ADD allowcoms INT(1) DEFAULT '1' NOT NULL;
Error: Duplicate column name 'allowrate'

Error performing MySQL command: INSERT INTO pp_settings VALUES (220,'Number of minutes a user is allowed to edit a comment?','comtimeout','0 to disable. 86400 is one day.','0',2,7)
Error: Duplicate entry '220' for key 1

After that there are PhotoPost headers down the rest of the page.

I went into my photo database and I think that's alright.
I integrate with PHPBB2 and replaced those files when I upgraded.

What can I do to fix this? I have an article coming out soon where I refer people to my website.

Mike Waite

[mwaite49]

More on my previous message.

My gallery website is: http://mikewaite.com/gallery/

My website hosting service uses VDS hosting

They use PHP 4.4.4. on a Linux server Server version: 5.0.24

MySQL client version: 5.0.24

Hope this helps.

Mike Waite

[Chuck S]

You need to upload all the new photopost files. Your missing your forums subdirectory integration file under the gallery directory so reupload all your gallery files based off the Photopost 5.5 upgrade announcement

[mwaite49]

Chuck,

Thank for the quick reply.

I followed the instructions as they were in the Photopost 5.5 upgrade announcement. I just tried upgrading again with the same error. Both times I copied the phpbb2.php file from the forums directory to the forums directory.
I have only been copying the files listed in the 5.5 upgrade announcement.

What else may be going on?

[mwaite49]

I have followed the instructions each time I've tried to upgrade to 5.5 and still get the errors shown in my previous message. I double checked the forum files you suggested. Not only does my gallery not show but I can't access my site administration. I've upgraded several times since my initial purchase and have not had problems before.

I'm stuck and don't know how to proceed.

Mike Waite

[Chuck S]

Fatal error: Call to undefined function: get_regcode() in /var/www/html/gallery/pp-inc.php on line 3037

Thats an absolute error here that tells me your integration file does not exist

Try uploading the entire photopost distribution minus config files or header footer files

[mwaite49]

I did another upgrade and this time the upgrade stalled. Just a blank blue screen.

When you say integration file that doesn't exist do you mean the file phpbb2.php located in the forums directory? That file has definitely been updated and is sitting in the directory.

I can't access my gallery administration if there is something that can be set there.

Is there a way to reinstall and perhaps reset the integration? I don't even care if it integrates with the forum as long as I can get a working gallery with my photos and categories.

Mike

[Chuck S]

Fatal error: Call to undefined function: get_regcode() in /var/www/html/gallery/pp-inc.php on line 3037

The error above is absolute. get_regcode is defined in the integration file so yes phpbb2.php.

http://www.mikewaite.com/gallery/index.php

I dont really have any other answer for you here. I can only post what I have if I look at your site this is what I see and the function it says it can not find is in your phpbb2.php file which should be located under your gallery/forums subdirectory. With the error your site has this file is either corrupt or does not exist

Content visible to verified customers only.

[mwaite49]

Chuck,

You can look at my site.

Can I email you the information to login?

Mike

[mwaite49]

Chuck,

I'm at a point where I don't have the skills to fix my problem.

I'd be glad to give you a login to the site and my database so you could see if you can find something, but I need to know what to do. Can I email you this information or is there anything else involved?

Mike

[mwaite49]

Chuck,

I have a little more information.

I looked at my database and found this in the pp_cache table

#145 - Table './mikewaite/pp_cache' is marked as crashed and should be repaired

I also have the #145 - Table './mikewaite/pp_iponline' is marked as crashed and should be repaired

With my limited knowledge I'm guessing that these two tables are contributing to the problem.

How can they be repaired and what can be done?

Mike

[Chuck S]

You can use phpmyadmin to repair your tables thats probally the easiest thing to do. I take it this is how you saw they where corrupt just select them and hit repair in the dropdown

[mwaite49]

Thanks Chuck. I repaired the two tables as you suggested and ran upgrade.php again. I have my gallery back.

I had this show up at the install:

Error performing MySQL command: ALTER TABLE pp_photos ADD allowrate INT(1) DEFAULT '1' NOT NULL, ADD allowcoms INT(1) DEFAULT '1' NOT NULL;
Error: Duplicate column name 'allowrate'

Error performing MySQL command: INSERT INTO pp_settings VALUES (220,'Number of minutes a user is allowed to edit a comment?','comtimeout','0 to disable. 86400 is one day.','0',2,7)
Error: Duplicate entry '220' for key 1

Upgrade complete!

I don't know what it means. Do I need to do something to clean up those two errors?

I really appreciate your assistance.

Mike

[Chuck S]

That just means you ran the upgrade before and those columns exist