export listings csv fail

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

Open Support Ticket

Tagged: download, export, snippet

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