[Intellibs]

Hello!
I'm trying to update table which I created in admin profile. My query is - $query_update ="UPDATE PMT_SUPPLIERS SET NAME='$supplier' WHERE CODE='$code'". The result of executeQuery($query_update) = 0; I had run the same query in Workbench and got error "You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option .... ", when I 'm running "SET SQL_SAFE_UPDATES = 0;" in Workbench - the query is running successfully, but in trigger this doesn't help, I can't update row((

[amosbatto]

You should check your execute-query-blacklist.ini file to make sure that it allows updating tables:
See:
https://wiki.processmaker.com/3.0/Consu ... ore_Tables

Also in your env.ini file, add the following line:

Code: Select all

debug=1

Then run your case in debug mode to see if there is an error defined in the __ERROR__ system variable.