[Solution] Categories Table Error CA:001

Register an Account
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old 01-17-2008, 12:34 AM
AshDigg's Avatar
Mayor of PliggVille/Coder
 
Join Date: Dec 2005
Posts: 1,515
This error occurs if the 'all' category has been renamed to something else AND the 'category__auto_id' has been changed. If just the 'category__auto_id' has been changed, Pligg Beta 9.8+ will try to resolve the issue itself. If it can't here is how to fix it.







You can see the 'all' category has been renamed to 'renamed!' and has a 'category__auto_id' of 7.



Last edited by AshDigg; 01-17-2008 at 12:38 AM.
Reply With Quote
  #2 (permalink)  
Old 01-17-2008, 12:34 AM
AshDigg's Avatar
Mayor of PliggVille/Coder
 
Join Date: Dec 2005
Posts: 1,515


Reply With Quote
  #3 (permalink)  
Old 01-17-2008, 12:34 AM
AshDigg's Avatar
Mayor of PliggVille/Coder
 
Join Date: Dec 2005
Posts: 1,515
If you still have this problem after following the above steps, please delete the contents of your /cache folder.

Last edited by AshDigg; 01-17-2008 at 12:38 AM.
Reply With Quote
  #4 (permalink)  
Old 01-17-2008, 08:21 AM
xiesi's Avatar
Constant Pligger
Pligg Version: 9.95
Pligg Template: yget + diy
 
Join Date: Jun 2007
Posts: 223
Send a message via MSN to xiesi
Thanks for your help.Ashdigg
Reply With Quote
  #5 (permalink)  
Old 01-17-2008, 08:26 AM
Banned
Pligg Version: 9.8.
Pligg Template: Custom
 
Join Date: Feb 2007
Location: Canada
Posts: 796
Great tutorial Ash.

Geoserv
Reply With Quote
  #6 (permalink)  
Old 01-18-2008, 10:48 AM
Constant Pligger
Pligg Version: 9.8
Pligg Template: garx mod
 
Join Date: Oct 2006
Location: Poland
Posts: 124
the same problem in fresh install..

Warning: Invalid argument supplied for foreach() in \libs\html1.php on line 14

Warning: Invalid argument supplied for foreach() in \libs\html1.php on line 171

Warning: Invalid argument supplied for foreach() in \libs\dbtree.php on line 76
There is a problem with the categories table. Error CA:001.



@latest svn code

Last edited by daone; 01-18-2008 at 11:16 AM.
Reply With Quote
  #7 (permalink)  
Old 01-18-2008, 01:40 PM
AshDigg's Avatar
Mayor of PliggVille/Coder
 
Join Date: Dec 2005
Posts: 1,515
Quote:
Originally Posted by daone View Post
the same problem in fresh install..

Warning: Invalid argument supplied for foreach() in \libs\html1.php on line 14

Warning: Invalid argument supplied for foreach() in \libs\html1.php on line 171

Warning: Invalid argument supplied for foreach() in \libs\dbtree.php on line 76
There is a problem with the categories table. Error CA:001.



@latest svn code
Did you see any errors when you ran the install? It looks like no categories were added when you installed.
Reply With Quote
  #8 (permalink)  
Old 01-18-2008, 02:21 PM
Constant Pligger
Pligg Version: 9.8
Pligg Template: garx mod
 
Join Date: Oct 2006
Location: Poland
Posts: 124
Quote:
Originally Posted by AshDigg View Post
Did you see any errors when you ran the install? It looks like no categories were added when you installed.
i saw somthing like "false false" in install progress log
installed on latest wamp server
Reply With Quote
  #9 (permalink)  
Old 01-20-2008, 01:42 AM
Constant Pligger
Pligg Version: 9.8
Pligg Template: garx mod
 
Join Date: Oct 2006
Location: Poland
Posts: 124
Step 4:

Creating database tables...
Creating table: 'categories'...
Creating table: 'comments'...
Creating table: 'friends'...
Creating table: 'links'...
Creating table: 'trackbacks'...
Creating table: 'users'...
Creating table: 'tags'...
Creating table: 'votes'...
Creating table: 'pageviews'....
Creating table: 'config'....
Creating table: 'messages'....
Creating table: 'modules'....
Creating table: 'formulas'....
Creating table: 'Saved Links'....
Creating table: 'Misc Data'....
Creating table: 'Totals'....
Creating 'god' user...
Inserting default categories...
Inserting default modules...
Inserting default formulas...
Inserting default 'totals' data...
Inserting default 'config' data...

Tables were created successfully!
falsefalse

Pligg appears to have installed successfully!
Reply With Quote
  #10 (permalink)  
Old 02-03-2008, 04:42 PM
New Pligger
Pligg Version: 9 beta
Pligg Template: no clue yet
 
Join Date: Jan 2008
Posts: 6
I'm sorry, i got this error today for 1st, and it was on the homepage of my website and everything worked fine for weeks before this.

all my settings were 100% as in the screenshots, and i could only fix it by restoring a dbase from yesterdays backup.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Table 'pligg.table_prefixconfig' doesn't exist guarriman Questions and Comments 5 01-27-2011 01:47 PM
Warning: Table 'tucknet_newqian_digg.pligg_groups' doesn't exist in seanli Questions and Comments 0 04-23-2009 03:35 AM
There is a problem with the categories table. Error CA:001. ideawagon Questions and Comments 6 08-24-2008 05:37 PM
installed successfully but one table is not exist oodbqpoo Questions and Comments 2 03-16-2007 03:22 PM
Upgrading problem GurillaNET Questions and Comments 4 01-19-2007 11:56 AM


Pligg Modules and Pligg Templates from Pligg Pro Find support on the Pligg CMS Forum - 24 hours a day! Make a donation to support Pligg CMS development