Page 1 of 1
Remove a Plugin Manually
Posted:
Fri Mar 09, 2018 2:31 pmby SBarnes
Hi Guys,
What SQL statements are needed to remove a plugin from the database under 7.1 I have a plugin that for some strange reason freezes Jiwa every time I try and delete it in plugin maintenance?
Re: Remove a Plugin Manually 
Posted:
Fri Mar 09, 2018 2:43 pmby Scott.Pearce
I believe that all the SY_Plugin and associated tables have foreign keys defined with ON DELETE CASCADE, so a delete from SY_Plugin should delete all rows from associated tables for that plugin.
Re: Remove a Plugin Manually
Posted:
Fri Mar 09, 2018 2:51 pmby Mike.Sheen
The following do not have delete cascade on FK constraints to SY_Plugin, and will require additional delete statements to remove them:
SY_PluginEmbeddedReference
SY_PluginSchedule
Re: Remove a Plugin Manually
Posted:
Fri Mar 09, 2018 3:03 pmby SBarnes
Hi Guys
Firstly thanks for the replies, I think the problem may possibly have be caused by that the plugin was still enabled or that I had been shelling out to visual studio as the debugger that might be the issue some how.
Fortunately this plugin has no embedded references and isn't scheduled, it was picking up the custom fields which was my may concern so hopefully Scott's original answer will do the trick.