CSV Export link not working for events

This topic contains 6 replies, has 3 voices, and was last updated by  Kiran 4 years, 9 months ago.

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

Open Support Ticket
  • Author
    Posts
  • July 27, 2019 at 3:50 pm #499948

    Timothy Sullivan
    Buyer
    Post count: 63

    Hi,
    I’m trying to export my events listings. The export progress bar will appear and say “completed” but then no CSV download link appears. see attached screenshot.

    This issue seems to only happen with events and places. If I export categories, the download link appears correctly.

    July 27, 2019 at 3:51 pm #499950

    Timothy Sullivan
    Buyer
    Post count: 63
    This reply has been marked as private.
    July 28, 2019 at 12:05 am #499994

    Guust
    Moderator
    Post count: 29970

    Can you find the CSV file in /wp-content/uploads/cache ?

    Please post FTP details too and I will get a developer to have a look after the weekend.

    Thanks

    July 28, 2019 at 5:53 pm #500034

    Timothy Sullivan
    Buyer
    Post count: 63
    This reply has been marked as private.
    July 29, 2019 at 11:32 am #500112

    Kiran
    Moderator
    Post count: 7069

    Hi,

    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.

    I have added snippet (Snippets > GeoDirectory: Fix CSV export issue) to prevent error during export by adding alias to ‘post_category’.

    Let us know.

    Thanks,
    Kiran

    July 29, 2019 at 12:55 pm #500121

    Timothy Sullivan
    Buyer
    Post count: 63

    Thanks for the fix Kiran. It works now.

    when I have time, I’ll do some testing on my staging site to see if I can identify which plugin is modifying the structure of core WP database tables.

    thanks again

    July 29, 2019 at 12:56 pm #500122

    Kiran
    Moderator
    Post count: 7069

    Thanks for letting us know.

    Kiran

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

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

Open Support Ticket