Query for exporting data

  • Resolved jwbowers

    (@jwbowers)


    10 years, 9 months ago

    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://www.ads-software.com/plugins/read-and-understood/

Viewing 1 replies (of 1 total)
  • Plugin Author petermantos

    (@petermantos)

    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.