Problems with system.db.runPrepUpdate()

Ignition
1

I need to add information on a MySQL Database and this is the scribt:

script
script803×679 36 KB

When I use the project, l have this error:

Traceback (most recent call last):

_ File “event:actionPerformed”, line 9, in _

java.lang.Exception: java.lang.Exception: Error executing system.db.runPrepUpdate(INSERT INTO datos_generales (Formulador, LoteG, LoteL, Tanda, Tanque, Num) VALUES (?,?,?,?,?), [[System]Client/User/Username, 5, 6, 7, 8], , , false, false)

_ caused by Exception: Error executing system.db.runPrepUpdate(INSERT INTO datos_generales (Formulador, LoteG, LoteL, Tanda, Tanque, Num) VALUES (?,?,?,?,?), [[System]Client/User/Username, 5, 6, 7, 8], , , false, false)_
_ caused by GatewayException: SQL error for “INSERT INTO datos_generales (Formulador, LoteG, LoteL, Tanda, Tanque, Num) VALUES (?,?,?,?,?)”: Unknown column ‘Formulador’ in ‘field list’_
_ caused by SQLSyntaxErrorException: Unknown column ‘Formulador’ in ‘field list’_

Ignition v7.9.10 (b2018112821)
Java: Oracle Corporation 1.8.0_201

Error
Error916×474 20.8 KB

2

Offhand, it looks like your system.db.runPrepUpdate is missing the database parameter.
Documentation says it is optional but I always include it.
My preference is to store the name of the database in a tag so I can switch between Dev, Test and Production databases without editing code or changing project settings.
e.g.
database = system.tag.read( ‘Config/Database’ ).value
system.db.runPrepUpdate(query, args, database)

3

You either have the wrong table, or you’re typing the column name incorrectly, or your database is enforcing case-sensitivity on the column identifier (unlikely).