I have a multi insert which does something strange in server connect. On the front end I have my form with the usual naming for a multi insert i.e.
name="record[{{$index}}][memberHolidayFund]"
And it displays the array in server connect:
I set up an repeat and set value action just to test the repeat as the values weren’t inserted in the database
When running the action there are 2 empty items in the array before any of my expected items appear:
I get the following error:
“status”: “500”,
“code”: “ER_WRONG_VALUE_COUNT_ON_ROW”,
“message”: “insert into transactions (memberHolidayFund) values (‘R130.40’, ‘R59.40’) - ER_WRONG_VALUE_COUNT_ON_ROW: Column count doesn’t match value count at row 1”,
“stack”: "Error: ER_WRONG_VALUE_COUNT_ON_ROW: Column count doesn’t match value count at row 1\n at Query.Sequence._packetToError
Does not seem like I am doing anything wrong since I have used the multi insert many times recently.
Last updated: