This SQL Query has not been allowed by an Administrator.

  • Resolved bradcoleman60

    (@bradcoleman60)


    3 years, 2 months ago

    Hi there – thanks for this plug in. Trying to use the [sqlgetvar] short cut with a query to the wp_post data table.

    SELECT
    DATE_FORMAT (MAX(post_date), ‘%b %e %Y at %I:%i %p’) as last_updated
    FROM
    wp_posts
    WHERE
    post_title = ‘PETE’S BRASS RAIL AND CAR WASH’ AND
    comment_status =’closed’

    I get the error = This SQL Query has not been allowed by an Administrator.

    I have copied this query exactly from the SQL Reports that I also saved per the instructions.

    I also tested the sample “user count” query that you have in the documenation that queries the wp_users table and that worked fine.

    Thanks for any help.

    Regards,
    Brad

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

    (@scheeeli)

    This security warning indicates that there must be a saved report with exactly the same query saved in your report list. Every symbol, including SPACE characters must match exactly. To help avoid unseen difference that might be causing this error try removing all the line-feed/returns in the query string so that the string is all on one line. Also make sure that there are no leading or trailing spaces. Save the query as a report with a unique name, making sure that it runs without errors and returns results, then try using the name of the report instead of the whole SQL Query in the sqlgetvar shortcode to call up this value on the page.

Viewing 1 replies (of 1 total)
  • The topic ‘This SQL Query has not been allowed by an Administrator.’ is closed to new replies.