Support Forums - Classified Ads Script Osclass
Unread
New Replies
Osclass Market
Download Osclass
Documentation
Home
Help
Search
Login
Register
Unable to delete listings from the backend.
Support Forums - Classified Ads Script Osclass
Osclass theme support
Beta Osclass Theme
Unable to delete listings from the backend.
Match all words
Match any words
Most relevant results first
Largest topics first
Smallest topics first
Most recent topics first
Oldest topics first
Advanced
Unread posts
New replies
My topics
My posts
Print
Pages: [
1
]
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
Logged
MB Themes
Support team
17474 posts
Only quality matters
Download Osclass
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.
Logged
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 ?
Logged
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
Logged
MB Themes
Support team
17474 posts
Only quality matters
Download Osclass
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
Logged
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
Logged
MB Themes
Support team
17474 posts
Only quality matters
Download Osclass
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.
Logged
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
Logged
MB Themes
Support team
17474 posts
Only quality matters
Download Osclass
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)
Logged
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
Logged
cartagena68
71 posts
Re: Unable to delete listings from the backend.
«
Reply #10 on:
March 18, 2022, 04:27:00 AM »
https://forums.osclasspoint.com/osclass/ads-cant-delete-from-oc-admin/msg32482/#msg32482
Logged
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.
Logged
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!
Logged
MB Themes
Support team
17474 posts
Only quality matters
Download Osclass
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
Logged
To get fast support, we need following details:
Detail description, URL to reproduce problem, Screenshots
Print
Pages: [
1
]