5.62 to 6.11 upgrade breaks Category.

yonglvnv · July 5th, 2008, 07:54 AM

I've tried several times to upgrade my Photopost 5.62 to 6.11 with same results. Basically, upgrading breaks Category listing, see below attachments. I've traced the problem to pp-inc.php file, and as soon as this file is copied over, it breaks the category listing. I've reverted back to 5.62 until I can find solution for this. Any help is appreciated.

Chuck S · July 5th, 2008, 09:09 AM

Turn off your category cache in admin perform your upgrade you will be fine.

yonglvnv · July 7th, 2008, 02:51 AM

Thanks, that worked. Now, do I turn the category cache back on? Or turning it back on cause same problem?

Chuck S · July 7th, 2008, 10:28 AM

You can turn the cache on thats fine. Have a good day.

yonglvnv · July 19th, 2008, 05:28 AM

turning the cache on breaks the category listing again.

With cache off, category listing is not showing for unregistered users. Any way to fix this?

Chuck S · July 19th, 2008, 12:58 PM

We would have to see a link and login to your site because if everything is correct you should not have an issue. I can run cache on or off it does not matter.

vigape · July 19th, 2008, 08:06 PM

I have the same problem, I truncate the table pp_cache and now all works fine.

Chuck S · July 19th, 2008, 08:41 PM

Not a problem most likely your cache table entry would not update

vigape · July 20th, 2008, 03:42 AM

and is posible regenerate de cache table?

Chuck S · July 20th, 2008, 01:18 PM

Truncating or getting rid of the entry and allowing the program to regenerate it should work

yonglvnv · July 20th, 2008, 02:50 PM

how would I go about truncating and regenerating the pp_cache table. Are you talking about physically deleting the table?

Chuck S · July 20th, 2008, 03:20 PM

in phpmyadmin try running this

DELETE FROM pp_cache;

vigape · July 20th, 2008, 07:23 PM

And how allowing the program to regenerate it ?
I do not see the option on the admin panel

Chuck S · July 20th, 2008, 07:52 PM

If you turn on the category cache we should place an entry in the cache table.

vigape · July 21st, 2008, 09:14 AM

I try turn off the cache, delete from pp_cache and turn on the cache.
But 5 hours later the cache table is empty.

The value for 'Minutes to cache index page...' is 10 minutes.

Are some script to rebuild the cache table?

Chuck S · July 21st, 2008, 11:40 AM

It should be built within the script sure there are conditionals in the script. Is anyone actually viewing the gallery to rebuild it? The cache has to be on for it to be rebuilt and if you cleared the entry and it is on it will be rebuilt. If you turn it on and things display fine just leave it on.

vigape · July 21st, 2008, 01:59 PM

We have over 30 users viewing the gallerys.
I turn on the cache and you can see not working well now. I send you the link by mp.

vigape · July 21st, 2008, 02:00 PM

I can't message you, the link is *********

You can see the title of all gallerys publics and private users.

Chuck S · July 21st, 2008, 02:01 PM

That definately does not look like its upgraded correctly you can email support at photopost dot com

vigape · July 21st, 2008, 02:15 PM

Ok.
The finally solution.
the system is not capable of creating new cache if this is eliminated.
But if you can re-fill the table.
I restore the table with the data backup and runnig this:
UPDATE `pp_cache` SET `statscache` = NULL ,
`recentcache` = NULL ,
`popularcache` = NULL ,
`randomcache` = NULL ,
`calcache` = NULL ,
`catcache` = NULL ,
`catprops` = NULL WHERE `id` =1 LIMIT 1 ;
This sql flush the table, is the same that create a new row with id 1 and a timestamp and all others null if table is empty.

Now the system works fine, and re-fill the table with correct data.

yonglvnv, try it and tell us if works for you