[ADMIN] [Categories] Deleting a category does not delete items belonging to it

[emanwebdev]

Items are still here despite the message claiming items will be deleted

[emanwebdev]

but media(s) of that item are deleted

[conejoninja]

Are you using any plugin ?

[conejoninja]

It works fine on my setup.
This is probably caused by a plugin that extends item's fields but miss the delete_item hook, then, the foreign keys on the plugin's table could not delete the item.

[emanwebdev]

right, i tried many plug-ins (and they spoil the oc-admin interface btw.... )

• Admin's PM Box
• OSClass PM Settings
• Voting options
• QR Code
• More Edit Options
• Seller post
• Advertising
• Extra Feeds help
• Rich edit options
• Breadcrumbs

gonna uninstall'em and test again

sorry for your precious time

[conejoninja]

Don't worry, we want to help you and make OSClass better!

Since almost all of the plugins are "official" (done by the team), please, tell me if you find which one is causing the problem so we could fix it.

Sorry for all the trouble made ;)

[emanwebdev]

I just deleted ALL plugins and now everything's OK regarding this issue!

It was not OSC that was 'faulty' but one/some of the plug-in/s as you correctly guessed! You're a well deserved Ninja :)

And BIG SORRY for that non-issue and your precious time Conejo!

---

And now, have to find WHICH plug-in is the criminal :)

[emanwebdev]

Since almost all of the plugins are "official" (done by the team), please, tell me if you find which one is causing the problem so we could fix it.

ok, i'll do that after lunch,
and should I open another issue then? (as you closed this one)

[conejoninja]

No, feel free to comment here, since it's a plugin issue, it should be posted on their own github project https://github.com/osclass/osclass-plugins

but it's ok to post it here, and i will move it to the one which correspond (or contact the author if the plugin is not ours)

[emanwebdev]

https://github.com/osclass/osclass-plugins

it's where i got'em and install'em all

but it's ok to post it here, and i will move it to the one which correspond (or contact the author if the plugin is not ours)

ok

btw, how to turn OSClass in "verbose" mode? (like you "concurrent" Open Classified, displaying all requests and warnings in the footer)
is there a "debug mode" to set in any file?

[conejoninja]

PHP Errors :
http://doc.osclass.org/Debug_PHP_errors

MySQL queries (all, not only errors)
http://doc.osclass.org/Debug_SQL_queries

[emanwebdev]

Since almost all of the plugins are "official" (done by the team), please, tell me if you find which one is causing the problem so we could fix it.

Comes from the PayPal plugin.
Tried to deleted the remaining item in PhyMyAdmin, and the following error is raised:

Cannot delete or update a parent row: a foreign key constraint fails

(`oscdev_t_paypal_publish`, CONSTRAINT `oscdev_t_paypal_publish_ibfk_1` FOREIGN KEY (`fk_i_item_id`) REFERENCES `oscdev_t_item` (`pk_i_id`))

[emanwebdev]

but maybe it's because the PayPal plugin has not been uninstalled properly
It's been deleted by FTP not from oc-admin

[emanwebdev]

Others "faulty" plugins:

• ads4osc: remaining table in the DB after uninstall
• PM (personal messager from Jay): remaining tables in the DB after uninstall