WPIntell

Source evidence

This SQL Query has not been allowed by an Administrator

EZ SQL Reports Shortcode Widget and DB Backup · support · 2018-10-24T13:21:00+00:00

mixedsentiment
highseverity
0.94relevance
2replies
Evidence linked to opportunitycommercial context

Proof Health

Open evidence

Commercial opportunities need traceable source links before they are treated as build-worthy.

4 / 31 rows with source links

12.9% of this page's analysis has direct source links.

0 build-decision rows missing links

0 rows here require auditable proof before promotion.

27 rows with no attached evidence

0 rows have source counts but still need direct links.

Conversation

support
vitalclick resolved
I tried to run this query SELECT display_name FROM wp_users WHERE ID = '<?php $current_user->ID ?>' but it’s given this error: This SQL Query has not been allowed by an Administrator. Does anybody knows how to solve the problem? You put this query into a shortcode without defining it as a report yet. This is a security feature to prevent other non-admin users from creating potentially relieving queries on a page or post that have not been allowed by the site administrator. All you have to do is copy and paste that exact query into a new report and save that report with a name, then that SQL can be used in a shortcode successfully. Thank you! I have realized my mistake. WordPress is changing the formatting. I now insert the codes inside a Raw HTML Editor and it works

Comments

2 shown
Eli 2018-10-24T17:58:00+00:00

You put this query into a shortcode without defining it as a report yet. This is a security feature to prevent other non-admin users from creating potentially relieving queries on a page or post that have not been allowed by the site administrator. All you have to do is copy and paste that exact query into a new report and save that report with a name, then that SQL can be used in a shortcode successfully.

vitalclick 2018-10-25T16:07:00+00:00

Thank you! I have realized my mistake. WordPress is changing the formatting. I now insert the codes inside a Raw HTML Editor and it works