WordPress.org

Ready to get started?Download WordPress

Forums

Exports and Reports
[resolved] wrd_posts instead of wp_posts (4 posts)

  1. cjmusante
    Member
    Posted 1 year ago #

    I'm trying to query the WordPress DB for some user info, and I've downloaded the Exports and Reports plug-in.
    The standard two reports work great. When I try to create a new report, I find that the queries that drive your reports refer to a table named wrd_posts, but in my WordPress database, this table is called wp_posts.
    When I select from wp_posts or wp_users, I get empty reports, but if I modify the same query, replacing the wp_ with wrd_, the queries work.
    Can you tell me why the queries work in this manner? Is the string "wrd_" a defined variable that can be changed? If so, where is it maintained?
    For the record, I'm not a developer, and I'm not a SQL admin, but I've got a website to build, and could use some help.

    http://wordpress.org/extend/plugins/exports-and-reports/

  2. Scott Kingsley Clark
    Member
    Plugin Author

    Posted 1 year ago #

    wrd_ doesn't automatically get replaced, this plugin installs itself with those example reports using whatever your table prefix is set to in your wp-config.php

    Are you absolutely sure your table prefix is wp_?

  3. cjmusante
    Member
    Posted 1 year ago #

    Now I see the problem. I'm new to WordPress, and I've got a site installed behind our companie's firewall, which was/is based on a Bitnami VM image. I've also got a site that is on the Internet, in the public domain, where I installed the report writer/exporter.
    I wrongfully assumed that all installations would use the same table-names, and now that I've checked the wp-config.php, I have confirmed that you are correct, and the table prefix for this installation is in fact wrd_, not wp_.
    thanks for your help

  4. Scott Kingsley Clark
    Member
    Plugin Author

    Posted 1 year ago #

    No problem at all, enjoy the plugin!

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.