I see you have a column named "status", but status is a reserved word in mysql. Try updating that column name or removing it from your insert.
If that isn't the issue I'd need to debug on the live site to figure it out. If you give me FTP access I can do that.
See a full list of reserved words here:https://dev.mysql.com/doc/refman/5.5/en/keywords.html