coppermine-gallery.com/forum

Support => Older/other versions => cpg1.3.x Support => Topic started by: keeva on August 24, 2004, 05:45:54 PM

Title: Can I Safely Delete "Cat=1" from MySQL?
Post by: keeva on August 24, 2004, 05:45:54 PM
My photo gallery is here: http://www.presidentsrock.com/media/photos/

Problem is that I have a categroy who id is 1 that I'd like to delete. Although I can't delete it from the CPG admin menus I see that I could easily delete the row in "cpg130_categories" within the SQL table in MyPHPAdmin. Can I safely delete it without screwing up the other categories and albums? Please advise as my client would freak if I screwed something up. I just want to get rid of this id 1 categpry.

thanks,

- Kevin
Title: Re: Can I Safely Delete "Cat=1" from MySQL?
Post by: Nibbler on August 24, 2004, 05:51:31 PM
Thats the user galleries cat. If you remove the albums that are in there then it will go away.
Title: Re: Can I Safely Delete "Cat=1" from MySQL?
Post by: keeva on August 24, 2004, 06:37:01 PM
Cat=1 does not show up in the Album Manager drop down, and thus there is no way to delete the album inside cat=1.

I don't care about saving the few photos in Cat=1. I just need to delete the entire category. Just to be clea, there is no option to delete Cat=1 in the category manager.

thanks,

- Kevin
Title: Re: Can I Safely Delete "Cat=1" from MySQL?
Post by: Casper on August 24, 2004, 07:18:06 PM
DO NOT delete cat 1 from your database. 
To delete the albums from cat 1, browse into the cat, and then the sub cat page, where you will see the edit/delete buttons.

Once all are deleted, this cat will then be invisible, and to prevent further albums being created there, turn off 'can have personal albums', for all groups including admin, in the groups manager.
Title: Re: Can I Safely Delete "Cat=1" from MySQL?
Post by: keeva on August 24, 2004, 07:23:57 PM
Thank you. That did the trick!