Upgrading to 9.5 disables categories

[aaronpais]

Hi,

I just attempted an upgrade to 9.5

It seems to have disabled my categories. All my categories have disappeared and I cannot create new categories. Here was the sequence of steps that I followed -


1. download the latest build

2. Rename settings.php.default to settings.php. Rename /libs/dbconnect.php.default to /libs/dbconnect.php.

3. change values in settings.php and /libs/dbconnect.php for your site

4. Upload the files to the web root directory on your server; overwrite existing files.

5. http://localhost/install/upgrade.php

6. Delete your /install folder.


I had a prior issue in the past where I was trying to create a development and had Pligg 9.1 rev 9xxx running and I downloaded Pligg 9.1 rev7xxx, and tried to connect to the DB and I experienced the same issue; the categories disappeared. This made sense because the DB was associated with an older version.

At that time, I resolved the issue by downloading a more recent build of Pligg than the one that I had, and did the upgrade from the install folder. It fixed the categories.

However, it is not working now; anyone have any suggestions?

Thx
-A

[kbeeveer46]

You don't have to do step 2. You should technically just back up your files but let Pligg use the new config and settings files. The new dbconnect file has a .default extension on it so it won't overwrite your existing one.

Also, we need a link to your site if you have one. There's not much we can do without it.

[aaronpais]

I performed the upgrade in the devel environment. I backup up my DB from my production env (proddb) and restored to a dev DB (devdb).


Main URL: http://www.uratestuff.com (Uses proddb, Pligg v9.1 build 9xx)

[kbeeveer46]

I'm not sure why this would break it but in templates/yget/sidebar_modules/categories.tpl try removing this code

start=1

If that fixes the sidebar then also remove the same code in templates/yget/admin_templates/category_manager.tpl

[aaronpais]

Didn't work.

In the past, I was able to upgrade my version (I think it is Pligg 9.1 maybe rev 900) to Pligg 9.1 rev974

I will attempt an upgrade to 9.1 rev974 and then to 9.5

Will report back with my results when complete...

[doctorgirlfriend]

This seems to have happened to me, too. I get errors like this everywhere a page looks for categories:

Warning: Invalid argument supplied for foreach() in /home/myhost/public_html/mysite/news/libs/html1.php on line 14

Warning: Invalid argument supplied for foreach() in /home/myhost/public_html/mysite/news/libs/html1.php on line 164

Those line numbers refer to line like this:
html1.php line# 14: foreach($the_cats as $cat){

Also, during the upgrade process, it was looking for the cache folder like this:
/home/myhost/public_html/mysite/newscache
(my site is in /home/myhost/public_html/mysite/news )
and giving an error because it couldn't find that file. I tried changing settings.php from $my_pligg_base = '/news'; to $my_pligg_base = '/news/'; but it kept reverting as if the upgrade.php was overwriting it back to $my_pligg_base = '/news'; (without the trailing slash). My only way to fix this was to actually create a folder at mysite.com/newscache and CHMOD it to 777 and then run upgrade.php

[envieme]

aaronpais ,

do the following

mysql> INSERT INTO pligg_categories VALUES (0, 'en', 0, 0, 'all', 'all', 0, 0, 2, 0, '000000');

mysql> UPDATE pligg_categories SET category__auto_id = 0 WHERE category_name = 'all' LIMIT 1;

mysql> commit;

Easier still if you use phpMyAdmin. Browse to your categories table and change the attributes of 'All' category. If you don't find it, add it and give the following values. 0, 'en', 0, 0, 'all', 'all', 0, 0, 2, 0, '000000'

I guess everything should work fine after this.

[doctorgirlfriend]

I've been talking about this in another thread, too, it's strange because while trying to fix it I dropped the whole categories table and redid the sql query with the 'all' category set to zero, but it inserted it as 9 because that was the Next Autoindex value.
Editing the value manually to zero still didn't work for some reason. I had to drop the table again, and do this:
ALTER TABLE pligg2_categories AUTO_INCREMENT = 0
and THEN run my SQL queries to recreate my categories from a backed up sql dump I had, and it inserted everything correctly and now I can revert to Pligg 9.1 at least.
Pligg 9.5 upgrade still doesn't work, it throws all those errors all over the page everywhere it looks for a category value. I wonder if it has something to do with the part in html1.php where the comments say that $the_cats is defined in smartyvariables.php, but there's no mention of $the_cats in my smartyvariables.php file.

[painperdu]

I experienced problems upgrading also.

Categories and comments weren't being pulled from the db. I reverted back to 9.1 and now it's screwed up as well.

This upgrade doesn't seem too solid.

[kbeeveer46]

We always test the upgrade before a new release and I never ran into a single problem myself. You guys can look in upgrade.php and see what's actually going on. It;s nothing that will damage your site to where you can't use it.

The Pligg 9.5 code was freely available on source forge for anyone to test before the official release. As open source code, there's just as much responsibility for the entire community to make sure the code will work as it is the devs. Just because someone doesn't have the title "dev" doesn't mean they can't participate.