XConvert info: MySQL Query Error
Time: 2008-10-9 2:08am
SQL: INSERT INTO discuz.cdb_threads (
`tid` , `fid` , `iconid` , `typeid`, `readperm`, `price`,`author` , `authorid` , `subject` , `dateline` , `lastpost` , `lastposter` , `views` , `replies` , `displayorder` , `highlight` , `digest` , `rate` , `blog` , `special` , `attachment` , `subscribed`, `moderated` , `closed`
) VALUES(
'62978', '2', '0', '0', '0', '0', 'smssms', '47924', '怎么样不采用函数做到,当B列某行出现有数字或文本时,下行将出现\"以下这空白\', '1095843234', '1095955124', '孔子', '100', '4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1095843234', '1095955124', '孔子', '100', '4', '0', '0', '0', '0', '0', '0', '0'' at line 4
Errormsg.: 可能原因:1.数据超长或类型不匹配;2.数据库记录重复
Errno.: 1064
在单独转换主题表时,这个错误频频发生,原因是主题的标题太长。
请问:难道转换程序不会对超长标题自动截取吗?需要我手工一条条来处理? |