Author Topic: Deleteing category doesnt actually remove it from the DB  (Read 830 times)

rayge

  • Jr. Member
  • **
  • Posts: 189
Deleteing category doesnt actually remove it from the DB
« on: June 04, 2013, 05:22:50 am »
When i delete a category It still shows up in the database.
Can someone validate this?
After i remove a category it is still SHowing in the following tables
jos_virtuemart_category_medias, jos_virtuemart_categories, jos_virtuemart_categories_en_gb, jos_virtuemart_category_categories
So even AFTER delteing the category from the admin i have to run the following to actually remove it.

DELETE FROM jos_virtuemart_category_medias WHERE virtuemart_category_id IN (146,162,163,16,6);
DELETE FROM jos_virtuemart_categories WHERE virtuemart_category_id IN (146,162,163,16,6);
DELETE FROM jos_virtuemart_categories_en_gb  WHERE virtuemart_category_id IN (146,162,163,16,6);
DELETE FROM jos_virtuemart_category_categories WHERE category_child_id IN (146,162,163,16,6);
I Use: Joomla 3.4.1 & VM 3.0.9

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10017
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Deleteing category doesnt actually remove it from the DB
« Reply #1 on: June 04, 2013, 13:23:11 pm »
Heavens that was some old code, yeh. I changed it, will be in the next version, you may try this model

[attachment cleanup by admin]
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

rayge

  • Jr. Member
  • **
  • Posts: 189
Re: Deleteing category doesnt actually remove it from the DB
« Reply #2 on: June 04, 2013, 19:49:23 pm »
THanks
I Use: Joomla 3.4.1 & VM 3.0.9

rayge

  • Jr. Member
  • **
  • Posts: 189
Re: Deleteing category doesnt actually remove it from the DB
« Reply #3 on: June 04, 2013, 21:11:29 pm »
I tried your modified field and I still see the categoy in the tables after removing from the admin.
I Use: Joomla 3.4.1 & VM 3.0.9

rayge

  • Jr. Member
  • **
  • Posts: 189
Re: Deleteing category doesnt actually remove it from the DB
« Reply #4 on: July 24, 2013, 17:12:35 pm »
This still hasnt been fixed in 2.0.21G
I deleted a category from the admin and the record in virtuemart_categories_en_gb STILL REMAINS
this needs fixed ASAP
I Use: Joomla 3.4.1 & VM 3.0.9