Title: Query for exporting data
Last modified: August 21, 2016

---

# Query for exporting data

 *  Resolved [jwbowers](https://wordpress.org/support/users/jwbowers/)
 * (@jwbowers)
 * [11 years, 12 months ago](https://wordpress.org/support/topic/query-for-exporting-data/)
 * After testing this plugin a bit today, I couldn’t get the export function to 
   work. Not a deal-breaker for me, because I’ll probably just write a report that
   reads directly from the WordPress tables. But I was still curious as to why it
   didn’t work.
 * I traced the issue back to the wp_posts table that is referenced in your query.
   In my WordPress installation, my table names do not use the default “wp_” prefix,
   so the query was failing and returning the message “there are no records to export”.
   I changed the two instances of “wp_posts” on line 414 of class_wp_rnu.php to 
   reflect my actual table name and ~voila!~ it works like a charm now.
 * Thanks again for this great plugin.
 * [https://wordpress.org/plugins/read-and-understood/](https://wordpress.org/plugins/read-and-understood/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [petermantos](https://wordpress.org/support/users/petermantos/)
 * (@petermantos)
 * [11 years, 11 months ago](https://wordpress.org/support/topic/query-for-exporting-data/#post-4984191)
 * Thanks for your find. I have updated the software to respect your WPDB prefix
   when referencing the posts table.
 * I appreciate your taking the time to rate the plugin and to report this issue,
   which surely someone must have also run into, but failed to report.

Viewing 1 replies (of 1 total)

The topic ‘Query for exporting data’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/read-and-understood_000000.svg)
 * [Read and Understood](https://wordpress.org/plugins/read-and-understood/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/read-and-understood/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/read-and-understood/)
 * [Active Topics](https://wordpress.org/support/plugin/read-and-understood/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/read-and-understood/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/read-and-understood/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [petermantos](https://wordpress.org/support/users/petermantos/)
 * Last activity: [11 years, 11 months ago](https://wordpress.org/support/topic/query-for-exporting-data/#post-4984191)
 * Status: resolved