Field 'updateurl' doesn't have a default value

[uiouio]

A error occurred after add a new app.

A Database Error Occurred

Error Number: 1364

Field 'updateurl' doesn't have a default value

INSERT INTO razor_channel_product (product_id, description, date, user_id, productkey, channel_id) VALUES (2, '', '2012-12-13 03:52:15', '1', '551e7e078b9866d0774f52defe******', '7')

Filename: D:\razor\system\database\DB_driver.php

Line Number: 330

[uiouio]

It is cause by MySQL, to fix it,
1.open my.ini
update sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
to sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
2.restart MySQL.

[rockiee281]

这么改治标不治本吧？原因在于数据库里头把移动端没有采集的字段也设为不允许为NULL了，我在测试的时候，修改了数据库的schema，把那些字段改为default NULL的