ss's mysql 入库错误

defyasdf

1. 
   
2. INSERT INTO supe_spaceitems (itemid,catid,username,subject,dateline) VALUES('[自增ID]','92','[标签:作者]','[标签:标题]','[标签:时间]')
   
3. INSERT INTO supe_spacenews (itemid,message,relativetags,customfieldtext) VALUES('[自增ID]','[标签:内容]','a:1:{i:0;s:5:"[标签:SY_关键词]";}','a:0:{}')
   

复制代码

出现错误如下：

1. 
   
2. 出现错误 supe_spacenews表1-错误信息:#HY000Field 'customfieldtext' doesn't have a default value出现错误 supe_spaceitems表2-错误信息:#42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') VALUES('2','92','火车采集器','火车模块测试贴','2007-09-15 05:06:45')' at line 1
   

复制代码

怎么解决？

rq204

customfieldtext 这个没有值的,请给一个默认值.

懷念過去↑文

YES

defyasdf

我给了个值啊

vus520

给在哪里的？

luring

我推测是楼主的原始表字段创建时就有问题吧？