No posts found despite there being lots of posts there

Hi Ben

Thanks for your message and sorry it’s not working for you.

Usually this problem is caused by some sort of error. You could try turning on error logging and then paste any errors here.

Best wishes

Paul

Hi Paul,

Thanks for getting back to me.

I have enabled debug on wordpress and do not get any errors, I simply get:
You seem to have nothing to export. Add a post or page and try again.

however if I go to wordpress export tool and select bookings i get all of the bookings exported.

No other errors are showing up unless you can advise me anywhere else I may find an error?

Thanks
Ben

Hi Ben

Are you able to give me full access to your site (WordPress, FTP, DB, etc)? If so, then please contact me via my site and I’ll take a look for you.

Best wishes

Paul

No contact so resolving.

Hello ??
I had the same problem…
Apache error_log says:
[Thu Jan 22 22:08:11.518080 2015] [:error] [pid 3019] [client 127.0.0.1:49504] PHP Warning: mysqli_fetch_array() expects parameter 2 to be long, string given in /opt/www/programy.lh/wp-content/plugins/wp-csv/CPK_WPCSV_Posts_Model.php on line 37, referer: https://programy.lh/wp-admin/tools.php?page=wp-csv.php

I solved this by editing CPK_WPCSV_Posts_Model.php

Replaced MYSQL_ASSOC with MYSQLI_ASSOC.

Hope it helps

Thanks Napcok. Really appreciated. I’ll fix this in the next update of the plugin.

Best wishes

Paul

I had the same issue. In addition to the solution by napcok, I solved it by editing the CPK_WPCSV_Log_Model.php on line 75 and CPK_WPCSV_Posts_Model.php on line 35. The function mysqli_connect() needs an int-type for the port parameter. So I did a cast for $db_port. The line now looks like this: $link = mysqli_connect( $db_host, DB_USER, DB_PASSWORD, DB_NAME, (int) $db_port );

Hi napcok and mcdorf

I’ve made these updates. Thank you both for your contributions. Really appreciated.

Best wishes

Paul

Hi, I just tried to export the bookings, but no posts were found. Perhaps due to the recent update in WooCommerce Bookings creating problems? The changelog:

2015.02.11 – version 1.7.1
* Fix – get_bookings_in_date_range_query filtering.
* Fix – Calendar date query.

2015.02.02 – version 1.7.0
* Fix – Tweak cart expirey to ignore ‘unpaid’ bookings between checkout and payment.
* Fix – Block availability checking to hide 0 avail blocks.
* Fix – Set order ID before triggering status update on new booking.
* Fix – New booking email triggers.
* Fix – Special chars being sent to google cal.
* Refactor – Use custom queries to get bookings – improves performance.
* Refactor – Use transient caching to query bookings to save on resources.

Hi Coolav

I’m not familiar with that plugin. If it uses a custom post type for the bookings, then you ought to be able to export the booking information. Otherwise, you’d have to find another way to do it unfortunately.

If you suspect that the bookings plugin is interfering with WP CSV, then please deactivate it temporarily and then test my plugin again to see if helps.

Best wishes

Paul

Thanks Paul,

I’ll muck around in the code and server logs for a bit, and try to get it to work for me.

Best regards

Coolav

You’re welcome Coolav. If you find anything wrong with the plugin, please let me know. Even if it’s just an error message in the log.

Best wishes

Paul