1. In MySQL 4 you could pass an empty field ("") to a primary key column that is auto insert, in MySQL 5 you can not. Simply take that out of your insert query completely.

2. MySQL 4 was much more relaxed and forgiving about fields not checked to allow null. If a field did not allow null and you passed in nothing on insert for that field, or did not include that column on insert, it would still work. However, for MySQL 5, if a field is not nullable, you must pass in something on insert. Simply allow null for that field or give that field a default value.

I will update this if I find any other issues.