ExecuteSQLit sql=
update set translated='1' where ref='Joh 3:16'

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'set translated='1' where ref='Joh 3:16'' at line 1