webERP 添加客户->分公司信息 'vtiger_accountid' doesn't have a default value
来源:互联网 发布:雅迅网络线路图 编辑:程序博客网 时间:2024/05/21 11:06
webERP 添加客户->分公司信息的时候报SQL错误.
'vtiger_accountid' doesn't have a default value
解决办法是把sql-mode 设置成ANSI.
打开C:/Program Files/MySQL/MySQL Server 5.0/my.ini
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
改成
sql-mode="ANSI,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
重新启动mysql service 即可.
- webERP 添加客户->分公司信息 'vtiger_accountid' doesn't have a default value
- Field Doesn't Have a Default Value
- MySQL添加新用户 出现mysql]ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- mysql5.6添加用户出错 :Field 'ssl_cipher' doesn't have a default value
- 解决mysql添加用户Field 'ssl_cipher' doesn't have a default value的错误
- Field 'id' doesn't have a default value
- Field 'OPINION' doesn't have a default value
- Field 'id' doesn't have a default value
- Field 'id' doesn't have a default value
- Mysql Field * doesn't have a default value解决方法
- Field 'id' doesn't have a default value问题解决方法
- Field 'id' doesn't have a default value
- Field 'id' doesn't have a default value
- Field 'id' doesn't have a default value
- Mysql Field * doesn't have a default value解决方法hibernate
- hibernate的Field 'id' doesn't have a default value
- Field 'id' doesn't have a default value 原因
- hibernate异常 --- Field "id" doesn't have a default value
- 考研英语阅读理解七篇经典文章解析(7)
- BOL SIPPhone 第三方评价 - 北京邮电大学交换技术与通信网国家重点实验室(863计划实验室)
- 第六届中国国际高新技术成果交易会-时曦科技进会布展
- “易语言.飞扬”入围“首届中国优秀软件创新大赛”精英奖名单,即将角逐最高金奖
- AWT,SWING VS SWT(总结于一篇IBM网站的文章)
- webERP 添加客户->分公司信息 'vtiger_accountid' doesn't have a default value
- Effective Java(2nd Edition) Item 60 优先使用标准异常(译文)
- 开始读《走出软件作坊》
- my pretty girl
- SWT/JFace实践:为Composite添加滚动条效果(ScrolledComposite)使用心得
- 上传excel并存入数据库
- BOL 基本真实的产品发展记录
- 通过配置web.config发电子邮件详解
- 相册批量下载 前版本为v3.5 支持:雅虎相册、谷歌相册、网易相册、yupoo相册、百度相册、QQ相册