1
打开调试模式,即可新增数据成功,关闭调试,sql语句中,部分字段没值
解决办法
清除runtime(运行时)目录下的所有文件即可.
2
因为调试过程中,统一报错 404,对于想查看报错原因的,请查看
/data/runtime/Logs 报错日志
以下,简介
// $info = $wxusers_model->where(['openid'=>$da["openid"]])->save($post);
// $info = $wxusers_model->where($a)->save($post);
// $info = $wxusers_model->where('openid'.'='.$da['openid'])->save($post);
// $info = $wxusers_model->where('openid='.$da['openid'])->save($post); 不成
// $info = $wxusers_model->where(array('openid'=>$da['openid']))->save($post); 不成,
// 上面的都不成
$info = $wxusers_model->where('openid='."'".$da['openid']."'")->save($post);
// 这一句 sql 才执行正确
每一句sql 的报错日志
1
ERR: 1292:Truncated incorrect DOUBLE value: 'o1Zb_06f4hpWV5s7Q'
[ SQL语句 ] : UPDATE `red_wxusers` SET `username`='大师傅',`profession`='建筑 ',`company`='公司',`zhiwu`='大师傅',`portrait`='http://tmp/wx47059u90.jpg' WHERE `openid` = 0
对应
$info = $wxusers_model->where(array('openid'=>$da['openid']))->save($post);
2
ERR: 1054:Unknown column 'o1Zb_06f4hpWUuJW3' in 'where clause'
[ SQL语句 ] : UPDATE `red_wxusers` SET `username`='大师傅',`profession`='建筑',`company`='公司',`zhiwu`='大师傅',`portrait`='http://tmp/wx47db490.jpg' WHERE ( openid=o1Zb_06f4hpWUuJW3 )
对应
$info = $wxusers_model->where('openid='.$da['openid'])->save($post);
3
ERR: 1292:Truncated incorrect INTEGER value: 'o1Zb_06f4hpWUuJW3uCg'
[ SQL语句 ] : UPDATE `red_wxusers` SET `username`='大师傅',`profession`='建筑',`company`='公司',`zhiwu`='但是',`portrait`='http://tmp/wx4705490.jpg' WHERE ( openid )
对应
$info = $wxusers_model->where('openid','=',$da['openid'])->save($post);
4
ERR: 1054:Unknown column 'o1Zb_06f4hpWUuJW3u' in 'where clause'
[ SQL语句 ] : UPDATE `red_wxusers` SET `username`='大师傅',`profession`='建筑',`company`='公司',`zhiwu`='大师傅',`portrait`='http://tmp/wx470590.jpg' WHERE ( openid=o1Zb_06f4hpWUuJW3u )
对应
$info = $wxusers_model->where('openid'.'='.$da['openid'])->save($post);