Unable to create an update sql query

Unable to create an update sql query

by Yvan Leduc -
Number of replies: 1

Hello everybody,

 i.m using the version 3.01 of the plugin with moodle 3.0.

 When i try to create a simple sql query

(  example:   SELECT username, lang FROM prefix_user

UPDATE prefix_user SET lang = 'en_us' WHERE lang = 'en' )

to update a table i receive the message "Not allowed word".  In the configuration page of the plugin, the sql security is disable.  I'm logged as an admin. 

SELECT queries work well. 

 Any  idea?

Thank you

Average of ratings: -
In reply to Yvan Leduc

Re: Unable to create an update sql query

by Emma Richardson -
Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Plugin developers

Configurable reports is a read only plugin.  With good reason!!  It is for reporting - you need to use Adminer for full database access.