*

samsosclass

  • **
  • 29 posts
Unable to delete listings from the backend.
« on: March 02, 2022, 02:17:38 PM »
Hello,
When ever i select a listing to delete it doesn't actually delete the listing it just clears all of the inputted data such as title and description and so on but never actually deletes the listing off the website. Here is a screen shot of what is looks like once deleted...

Kind Regards

*

MB Themes

Re: Unable to delete listings from the backend.
« Reply #1 on: March 03, 2022, 05:02:36 PM »
@samsosclass
Go to your database, into table t_item, try to remvoe 1 record, you should get error that there is some foreign key blocking removal.
Update this key with clause ON DELETE CASCADE or remove it.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

samsosclass

  • **
  • 29 posts
Re: Unable to delete listings from the backend.
« Reply #2 on: March 03, 2022, 05:15:04 PM »
Hello,
Thank you for you response and i got that error you was talking about with the foreign key, but how do i go about changing it to ON DELETE CASCADE ?

*

samsosclass

  • **
  • 29 posts
Re: Unable to delete listings from the backend.
« Reply #3 on: March 03, 2022, 05:37:34 PM »
Hello,
Just found it and i changed al of them to cascade then saved but exact same error occured.

Kind Regards
Sam


*

MB Themes

Re: Unable to delete listings from the backend.
« Reply #4 on: March 03, 2022, 06:33:16 PM »
Then it is related to different foreign key
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

samsosclass

  • **
  • 29 posts
Re: Unable to delete listings from the backend.
« Reply #5 on: March 04, 2022, 04:38:42 PM »
Hello,
Here is the error I'm receiving what would i need to do to solve this?

Kind Regards

*

MB Themes

Re: Unable to delete listings from the backend.
« Reply #6 on: March 07, 2022, 11:10:23 AM »
You must update foreign keys as described above.
Anyway it is strange you are having such issue, maybe you use old database system or you've done corrupted upgrade.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

samsosclass

  • **
  • 29 posts
Re: Unable to delete listings from the backend.
« Reply #7 on: March 17, 2022, 04:07:14 PM »
Hello,
The osclass system hasn't been upgraded its the same from the start. Is there anyway else i can overcome this? because I'm currently completely unable to delete listings and its taking up huge amounts of space on the server.

Kind Regards

*

MB Themes

Re: Unable to delete listings from the backend.
« Reply #8 on: March 17, 2022, 08:21:32 PM »
Remove that key (and try to create it again)
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

samsosclass

  • **
  • 29 posts
Re: Unable to delete listings from the backend.
« Reply #9 on: March 17, 2022, 09:23:53 PM »
Is there some sort of tutorial that i can follow on how to do that? or is there any osclass developers that you can recommend to do it for me?

Kind regards


*

samsosclass

  • **
  • 29 posts
Re: Unable to delete listings from the backend.
« Reply #11 on: March 18, 2022, 02:00:44 PM »
Thank you i will try the Ghostbuster plugin and report back.

*

samsosclass

  • **
  • 29 posts
Re: Unable to delete listings from the backend.
« Reply #12 on: March 18, 2022, 02:09:05 PM »
I believe that has worked! Amazing stuff thank you for the plugin suggestion, when i want to delete them all i need to do is open up the plugin under tools and it gets rid of them for me. Perfect!

*

MB Themes

Re: Unable to delete listings from the backend.
« Reply #13 on: March 18, 2022, 03:21:19 PM »
@samsosclass
Glad to hear you got at least some solution ;)
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots