I have a form and supporting action page. Variables are passed successfully to the action page, but I have an error from the action page on trying to Insert the data into the mysql table.
(error is mysql.connector.errors.DataError: 1136 (21S01): Column count doesn't match value count at row 1)
I have triple checked that the Insert Function and the mysql columns match. So I'm a bit lost as to what the problem might be.
Below please find the
- The insert function
- Section of the action page which deploys the function
- Corresponding mysql table structure
- Error Message - note that line 81 referred to in message is the .format line of the insert function.