Unable to create an update sql query

Unable to create an update sql query

Yvan Leduc -
Vastausten määrä: 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

Arviointien keskiarvo: -
Vastaus Yvan Leduc

Re: Unable to create an update sql query

Emma Richardson -
Kuva: Documentation writers Kuva: Particularly helpful Moodlers Kuva: 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.