The data clean-up tool can not delete several inactive, blocked, spam or expired listings. Most of such listings exist and have no description but only a price part with a title or price without title. I tried deleting them in phpmyadmin but they are also not allowed to delete. Whether this is a bug or not, it negatively impacts the site's SEO and must have a fix.
I hope the developers take this issue very seriously. Contributors are requested to share if anyone is having the same situation. Share your solutions also.

Means you have blocking index in your database. You should review it and set it to "on delete cascade on update cascade"

This means you have a blocking index in your database. You should review it and set it to "on delete cascade on update cascade"

I am not very familiar with databases. Would you be so kind as to show me the steps and screenshots?

Please note that in my case the tool is able to delete all records after I started using the Delta Theme but can not delete old records which are either very old or before the Delta theme installation almost a year old. I keep my listings for one year and then expire.
Thank you

There used to be old ghostbuster plugin that could handle it.

There used to be old ghostbuster plugin that could handle it.

WOW! Old is always Gold. It works. Thank you brother

Yes it removes listings, but does not really solve problematic foreign key

Yes it removes listings, but does not really solve problematic foreign key

Is there any solution to solve the problematic foreign key?

Quote from: MB Themes on September 28, 2023, 10:49:38 AM

Means you have blocking index in your database. You should review it and set it to "on delete cascade on update cascade"

yes, you are right but as said earlier, I am not so good at databases and don't want to mess up. Can you help please find me a step-by-step guide with screenshots in this regard? I am using Mariadb database and phpmyadmin tool to do this.

No, you can google how to work with mysql db and how to update foreign keys.