Support » Plugin: Exports and Reports » How do I add capability to a role?

  • Resolved jsafire

    (@jsafire)


    Sorry, this may be an obvious question.
    How do I add the exports_reports_full_access capability to a role? I currently have only one group (WordPress) defined with Administrator selected in the select list for WP Roles with Access. (I am using a plugin called “Access” from the Toolset plugin platform – previously known as Types/Views.)

    I am currently getting a 1-byte file downloaded for any export I try – even the sample reports.

    Thanks,
    Jeff

    https://wordpress.org/plugins/exports-and-reports/

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    What do the file contents look like in the export? Try turning WP_DEBUG on in your wp-config.php and see if you can see any errors. Administrators get full access, they don’t need that capability.

    Thread Starter jsafire

    (@jsafire)

    The export file has only a newline character. Nothing else. Also, beneath Export: CSV tab, it says “No items found”.

    Anyway, there’s obviously a problem with my db here.

    From the plugin Reports screen…

    WordPress database error: [Table ‘db9368134344.wp_posts’ doesn’t exist]
    SELECT SQL_CALC_FOUND_ROWS ID,post_title,post_name,post_date,post_content FROM wp_posts WHERE post_type=’post’ LIMIT 0,25

    WordPress database error: [Table ‘db9368134344.wp_posts’ doesn’t exist]
    SELECT ID,post_title,post_name,post_date,post_content FROM wp_posts WHERE post_type=’post’

    Success: Your export is ready, the download should begin in a few moments. If it doesn’t, click here to access your CSV export file.

    When you are done with your export, click here to remove it, otherwise the export will be deleted within 24 hours of generation.

    Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    Please paste your full report SQL query here, use back ticks to surround your SQL query when posting it. `

    Thread Starter jsafire

    (@jsafire)

    SELECT ID,post_title,post_name,post_date,post_content FROM wp_posts WHERE post_type='post'

    This is from the Example Posts Report, unchanged from plugin download. (Simple blog posts report.)
    I am still getting the same Table Not Found db error for wp_posts.

    Any idea what’s causing that?
    The site is otherwise running fine of course.
    Note that this is a new installation of E & R.

    jeff

    Thread Starter jsafire

    (@jsafire)

    Scott –

    I think I may have a conflicting plugin, although E & R seems pretty straightforward. I will investigate my other plugins.
    Also, I have the same db table doesn’t exist problem with the same website running on a different site. (This site is not quite live yet and I just switched to a new webhost.

    Thx,
    Jeff

    Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    Is this a multisite installation? Do you have a different $table_prefix value in your wp-config.php file?

    Thread Starter jsafire

    (@jsafire)

    Scott –

    I’m glad this week is almost over. Total brain-fart on my part. Yes, of course I changed the table prefix! Dangit.
    Okay, basically working now.

    My apologies.
    This is a great plugin and nearly exactly what I need.
    Your Paypal account I can donate to?

    Jeff

    Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    Donations always accepted 🙂

    You can donate to my main project http://podsfoundation.org/donate/ and that’d be super useful.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘How do I add capability to a role?’ is closed to new replies.