Joomla 2.5 Tutorial – Delete not allowed for category Sample Data-Banners

by Elaine on July 30, 2012

Joomla 2.5 Tutorial – I was in the process of deleting all my banners and emptying out the trash when I encountered this error while trying to empty the trash in the Banner Categories.  See screenshot below:

joomla 2 5 delete not allowed for category items are assigned to category 1 Joomla 2.5 Tutorial   Delete not allowed for category Sample Data Banners Joomla 2.5 – Delete not allowed for Banner Category items

Delete not allowed for category Sample Data-Banners. 3 items are assigned to this category.

There are no banners assigned to the category because I already deleted them all.  I could not find the source of the problem so I decided to delete it from the database directly using the phpMyAdmin.   Below are the steps that I used to fix this problem.

Overall:

 1.  Login to Joomla 2.5 phpMyAdmin

  • Go to your web hosting and login to your Joomla 2.5 phpMyAdmin
  • Through your phpMyadmin you can access the backend tables of your Joomla 2.5 website.
  • Please note that you must follow these directions exactly otherwise will cause severe problems to your website which may result in bringing down your whole site.
  • Recommended:  Take a backup of your database.

2.  Find the _banners table, Select & Delete all Categories in the _banners table

As mentioned above, please take a backup of your database before you make any changes in the phpMyadmin.  Any errors made in the backend tables may result in bringing down your whole site.  Here you will find the _banners table, select all the banners and delete them.  See screenshot below:

joomla 2 5 delete not allowed for category items are assigned to category 2 Joomla 2.5 Tutorial   Delete not allowed for category Sample Data Banners Joomla 2.5 – Use phpMyAdmin to find _banners table and delete all banners
  • Scroll down on the left side to find the table _banners
  • Click on ‘Check All’
  • Click on the ‘x’ to delete all categories selected

4.  Click on ‘GO’ to confirm deletion in phpMyAdmin

phpMyadmin provides a security check to make sure you want to delete the values from the table.  Click yes to confirm deletion of the banner categories.

joomla 2 5 delete not allowed for category items are assigned to category 3 Joomla 2.5 Tutorial   Delete not allowed for category Sample Data Banners Joomla 2.5 – phpMyAdmin – Confirm deletion of Banner Categories
  • Under “Do you really want to:”
  • Click on ‘Yes

5.  Go to Joomla 2.5 backend and Empty Trash in Category Manager

Log back into your Joomla 2.5 backend administrator panel and access your Banner Category Manager. If you try to empty the Banner Category trash you will see no errors.

joomla 2 5 delete not allowed for category items are assigned to category 4 Joomla 2.5 Tutorial   Delete not allowed for category Sample Data Banners

Joomla 2.5 – Delete Banner Categories successful
  • Login to your Joomla 2.5 Admnistrator backend
  • Click on ‘Components’, ‘Banners‘, ‘Categories
  • Use the checkbox to select all categories and click on ‘Empty Trash’
  • Will see a message that says:
 2 categories successfully deleted

That’s it.  You successfully deleted your banner categories.

Thanks,

Elaine

 Joomla 2.5 Tutorial   Delete not allowed for category Sample Data Banners

Elaine

Elaine is the founder of CmsMind, an online blog providing Joomla and Wordpress tutorials. Elaine lives in Toronto and when she is not online, she is either Marathon and Triathlon training or travelling and racing somewhere in the world. Find her also at: Save Money, Premium Themes and Templates, and at Webhosting Tips.

More Posts - Website

Leave a Comment

Captcha Captcha Reload

Older Post:

Newer Post: