How to clean up all testing data at once?

This topic contains 5 replies, has 2 voices, and was last updated by  Kor 5 years, 10 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • November 3, 2018 at 4:29 am #452345

    Kai Liu
    Expired Member
    Post count: 368

    Is there a fast way to clean up all testing data, maybe by category all at once?

    I loaded several thousands of testing data. Now wanting to clean them all and start loading actual data. however, each page only 20 records, It will take me ages to delete them page by page. I have tried to do it in phpAdmin by deleting gd_place_detail table, however, even I delete them all, WP admin still showing all the listing, even after refreshing.

    Please advise

    November 3, 2018 at 5:05 am #452353

    Kor
    Moderator
    Post count: 16516

    Hi Kai Liu,

    Thanks for your post. Unfortunately, there isn’t an option in GD that allows you to do that. You’ll have to clear it manually or through the database.

    Thanks

    November 3, 2018 at 5:14 am #452355

    Kai Liu
    Expired Member
    Post count: 368

    Hi Kor,

    I already delete them in DB via phpAdmin, but in GD admin panel, they are still showing.

    Is there a place to store listing title apart from gd_place_detail table?

    November 3, 2018 at 5:21 am #452358

    Kor
    Moderator
    Post count: 16516

    Hi Kai Liu,

    Maybe you did not remove it correctly. Could you please share your database access so that I could forward this to a developer. Remember to backup everything.

    Thanks

    November 7, 2018 at 11:01 am #452848

    Kai Liu
    Expired Member
    Post count: 368

    Hi Kor,

    I found out the issue and fixed.

    Apart from storing data in CTP data table, I found that they also stored in wp_post table which is not visible in phpAdmin panel. I have to search an item in the whole DB to locate where the residual data is. then delete all posts associated with the post_type to clear the records.

    Sam

    November 7, 2018 at 11:18 am #452850

    Kor
    Moderator
    Post count: 16516

    Hi Sam,

    Thanks for your reply and I’m glad that you sorted it out yourself. Let us know if you need anything else.

    Thanks!

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount