Error when updating SQL DB table using cell edit in a Power Table

Ignition
6

That is the solution, it is a bug in 7.9 when using prepUpdate in extension or custom methods.
Try running this else where

id = 115
if id != 1:
		query = "UPDATE tblingredientname SET %s = ? WHERE tblingredientname.id = ?" % (colName)
		args = ['test001',id]
		system.db.runPrepUpdate(query,args)

In action performed from a button for example, I bet you won’t see the error.

If you still see the error, I would take @pturmel recommendation as priority.