Unable to remove JEMH plugin storage tables

[Onkar Ahire]

Hi,

I had gone through the steps to remove JEMH configuration database tables but unable to drop 3 tables it gives error related to foriegn constraint , Please let me know how to remove these tables/dependencies. I am using MySQL.

Thanking You,

Regards

Onkar Ahire

[Satyendra Narwane · Accepted solution]

Hi Onkar you can Drop the table by following command

Drop table table_name CASCADE CONSTRAINTS;

[Andy Brook [Plugin People]]

It might help if you actually refer the error message given, for what tables?

[Onkar Ahire]

Thanks for reply Tiago,

I am not able to drop 3 tables rest all droped where I stuck exactly , finally I tried as you said above, I tried to delete table in premutation way (1,2,3), (1,3,2), (2,1,3), (2,3,1), (3,1,2), and (3,2,1) but still same.

Thanks in advance.

[Onkar Ahire]

Thanks for reply Tiago,

I am not able to drop 3 tables rest all droped where I stuck exactly , finally I tried as you said above, I tried to delete table in premutation way (1,2,3), (1,3,2), (2,1,3), (2,3,1), (3,1,2), and (3,2,1) but still same.

Thanks in advance.

[Tiago Comasseto]

Hi Onkar, it seems to me just a matter of dropping the tables in the right order. When you get the foriegn constraint error, try to drop the table it refer to first.

Cheers

[Onkar Ahire]

Thanks for reply Tiago,

I am not able to drop 3 tables rest all droped where I stuck exactly , finally I tried as you said above, I tried to delete table in premutation way (1,2,3), (1,3,2), (2,1,3), (2,3,1), (3,1,2), and (3,2,1) but still same.

Thanks in advance.