Re: MYsql Error 1136

[Adhwaith S]

Hi Zach,

Thank you for the suggestions. The ID field is an AUTO INCREMENT value but i hadn't defined that while creating the table. I did triple check the DDL of the table to check for the structure of the table and the insert script is the correct.

I was able to resolve the issue. Seems like the issue was due to a trigger which was executing a procedure when a record is being inserted or updated . The trigger inserts into another table which was modified(add a new column) and so the insert statement inside the procedure had issue where only 3 column values where specified instead of 4.

Thanks a lot.

Regards,
Adhwaith S