export listings csv fail

This topic contains 12 replies, has 4 voices, and was last updated by  Mitch Canton 4 years, 7 months ago.

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

Open Support Ticket

Tagged: , ,

  • Author
    Posts
  • August 20, 2019 at 5:48 pm #504010

    Mitch Canton
    Expired Member
    Post count: 167

    This is going to sound stupid… but where does the file go when I click Export CSV? I checked downloads, desktop, media lib, it’s not there. The action (progress) runs in like ONE second (only 1000 listings in that file) but there is no file. No popup window to save. No confirmation of any kind. I’ve done this like 15 times. It’s like the export just isn’t happening.

    I’ve tried on both staging and live.

    I’ve tried in both Chrome and FF.

    I’ve tried with every other non-WPGD plugin deactivated.

    I talked to the host and they say they ‘made a change server-side to try and force a download’ to no avail.

    What am I missing?

    Thanks.

    August 20, 2019 at 5:53 pm #504012

    Mitch Canton
    Expired Member
    Post count: 167
    This reply has been marked as private.
    August 21, 2019 at 4:02 am #504077

    Alex Rollin
    Moderator
    Post count: 27815

    Try looking here

    /wp-content/uploads/cache/…

    If we nee to check more please make the user a full net/admin and share FTP for debugging

    Thanks

    August 21, 2019 at 3:45 pm #504184

    Mitch Canton
    Expired Member
    Post count: 167
    This reply has been marked as private.
    August 21, 2019 at 7:37 pm #504212

    Alex Rollin
    Moderator
    Post count: 27815

    I see some files in that folder, but not the one I just made.

    If this site is live, can you make a staging site on the same host where we can debug the issue with full WP Admin ability?

    August 21, 2019 at 7:40 pm #504214

    Mitch Canton
    Expired Member
    Post count: 167

    Yes, I had the same result. Files there, but not the exports. No exports anywhere.

    This is a staging site. Full admin credentials including SFTP that are in the private replies above are valid.

    Thank you for looking at this.

    August 22, 2019 at 8:01 am #504310

    Naveen Giri
    Moderator
    Post count: 1559
    This reply has been marked as private.
    August 22, 2019 at 2:15 pm #504376

    Mitch Canton
    Expired Member
    Post count: 167
    This reply has been marked as private.
    August 22, 2019 at 3:00 pm #504387

    Naveen Giri
    Moderator
    Post count: 1559

    Hi Mitch,

    I will need to check database, could you please send db access or cpanel details in private message.

    Thanks

    August 22, 2019 at 3:02 pm #504388

    Mitch Canton
    Expired Member
    Post count: 167
    This reply has been marked as private.
    August 27, 2019 at 12:30 am #504996

    Mitch Canton
    Expired Member
    Post count: 167
    This reply has been marked as private.
    August 27, 2019 at 9:16 am #505099

    Kiran
    Moderator
    Post count: 7069

    Hi Mitch,

    I have done some debugging and found following database error.

    WordPress database error Column 'post_category' in field list is ambiguous for query

    It looks like any plugin/theme has added database column ‘post_category’ to WordPress core xxx_posts table. It should avoid modifying structure of the WordPress core tables, otherwise it may create troubles like this.

    Try PHP snippet provided at here https://gist.github.com/kprajapatii/9de152dddeeb7bdb0d2f1cbc8711080c to prevent error during export by adding alias to ‘post_category’.

    Let us know.

    Thanks,
    Kiran

    August 27, 2019 at 8:46 pm #505213

    Mitch Canton
    Expired Member
    Post count: 167

    Hello Kiran,

    OK, so this works on tests in staging, thank you very much.

    I don’t know what could have “added database column ‘post_category’ to WordPress core xxx_posts table” – strange. I’ll see if I can figure it out.

    I’m at a loss for why when I deactivated ALL other plugins except WPGD, it didn’t work.

    I’ll try this on the ‘live’ site as well. Thank you again, much appreciated.

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

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

Open Support Ticket