[已解决]求助，3.0升级4.0后发布招聘出现错误，

yangjie123

[ol]

MySQL Query:INSERT INTO destoon_job (title,level,style,catid,department,total,minsalary,maxsalary,areaid,type,gender,marriage,education,minage,maxage,experience,totime,username,company,truename,sex,telephone,email,mobile,address,qq,ali,msn,status,note,addtime,hits,fee,template,editor,adddate,edittime,editdate,introduce,ip) VALUES ('测试招聘','0','','1147','大部门','30','0','0','200','0','0','0','0','0','0','0','0','admin','','杨先生','1','027-85858585','afsfdf@163.com','','','','','','3','','1322194368','','0','','admin','2011-11-25','1322194505','2011-11-25','公司对刚刚喝喝酒哈哈哈','127.0.0.1')

MySQL Error:Unknown column 'sex' in 'field list' MySQL Errno:0

Message:MySQL Query Error[/ol]复制代码
[ 本帖最后由 yangjie123 于 2011-11-25 12:37 编辑 ]

yangjie123

已经解决
执行 ALTER TABLE `destoon_job` ADD `sex` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1' AFTER `skype` ;