There is a problem with the categories table. Error CA:001.

[ideawagon]

I keep getting this error when submitting a post. I have checked that the category table is present.

The site was working fine for a week. All of a sudden it started giving the error.

There is a problem with the categories table. Error CA:001.

[ideawagon]

I guess some specific URL's get this error up. For example the url below when i try to submit I get this error.

"http://uk.reuters.com/article/UK_CRICKET/idUKSP10813520071022"

Any idea why some URL's give the error.
"There is a problem with the categories table. Error CA:001."

[werushka]

when you delete tepmlete_c files it gets fixed but how to prevent it in the future?

[AshDigg]

Originally Posted by ideawagon

I guess some specific URL's get this error up. For example the url below when i try to submit I get this error.

"http://uk.reuters.com/article/UK_CRICKET/idUKSP10813520071022"

Any idea why some URL's give the error.
"There is a problem with the categories table. Error CA:001."

I'm sorry but I can't duplicate this problem.

[Geoserv]

Did you delete any categories? Looks like the error you get when the "all" category has been deleted from the database.

Geoserv.

[savpav]

I have pligg on my local PC and then I copy it to server.
Just copy all files and restore database using backup files made by Pligg.

Problem was that in config.php
$the_cats = $db->get_results("select category_id, category__auto_id, lft, rgt, category_name, category_safe_name, category_lang from ".table_categories." ORDER BY lft ASC;");
return array where
$the_cats[0]->category__auto_id was set to 6 !!!
and
$the_cats[0]->category_id was 0

Even more. In database category__auto_id was 0 two - no error.

So there is may be problem in PHP or db object. (php on server 4.4.8)

Problem was fixed when I just change order of fields in query and place category__auto_id on first place.

[ritesh]

Hi Guys,

Clearing the cache folder "pligg_directory/cache" might solve the problem.

Enjoy!