OS info
- Operating System : Mac OSX 24.6.0
- Wappler Version : 7.6.0
- Platform: Nodejs
- Database: MySQL
Problem description
I have an insert that is returning an error, ER_WRONG_VALUE_COUNT_ON_ROW. I have tracked it down to an extra ‘‘, in the values section, but I am unable to identify why that is.
The database insert in Wappler has 36 fields in it. I have counted the fields and values several times to ensure that the error is not in the database insert.
Every field in the database insert has a default of NULL if no entry is received.
From looking at the Web Server log in Wappler, I have narrowed the error down to an extra ‘‘, in it after the field national_id and before the field phone. This is the only value that is not showing (every value should be filled in or show as NULL).
This is resulting in 36 insert fields and 37 value fields. I re-created the database insert and alphabetized it to help track down the error.
I have opened the file in code view and counted what is included in the MySQL insert step and count 36 actions, so I do not think it is with the database insert step in Wappler.
When viewing the table in Navicat, I count 37 fields, but that includes the ID field, which should not need to be added for a table insert.
So I am at a loss as to where this extra value in the middle of the insert showing in the Web Server logs and Google Chrome Developer is coming from.