恢复备份数据库出错2.61版本的
2016-07-07 15:51 来源:www.chinab4c.com 作者:ecshop专家
恢复备份数据提示如下错误。MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => CREATE TABLE `fsa_account_log` ( `log_id` mediumint(8) unsigned NOT NULL auto_increment, `user_id` mediumint(8) unsigned NOT NULL, `user_money` decimal(10,2) NOT NULL, `frozen_money` decimal(10,2) NOT NULL, `rank_points` mediumint(9) NOT NULL, `pay_points` mediumint(9) NOT NULL, `change_time` int(10) unsigned NOT NULL, `change_desc` varchar(255) NOT NULL, `change_type` tinyint(3) unsigned NOT NULL, PRIMARY KEY (`log_id`), KEY `user_id` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk DEFAULT CHARSET=utf8 ) [2] => Array ( [error] => Conflicting declarations: 'CHARACTER SET gbk' and 'CHARACTER SET utf8' ) [3] => Array ( [errno] => 1302 ) ) |
回答:
错误:Conflicting declarations: 'CHARACTER SET gbk' and 'CHARACTER SET utf8' 原因:您的数据库中有GBK和UTF-8两种编码的数据 解决方法:统一编码 共享里有转换编码的工具 见此贴: http://bbs.ecshop.com/viewthread ... 26amp%3Btypeid%3D16 |
万分感谢 |
最近更新
常用插件
- ecshop注册推荐送现金插件
ecshop中的促销售功能还不是很完善,随着电子商务系统的发展和进步,...
- ecshop二次开发商品购买备
ecshop销售统计 插件介绍:ecshop二次开发订单销售统计和商品购买备注服...
- ecshop二次商品订购人信息
ecshop二次商品订购人信息填写插件,有时候给朋友送花,或者是送礼品的...
- ecshop2.7.2退换货申请插件
ecshop2.7.2退换货申请插件,主要是在 ecshop 现在的基础上,对ecshop的订单处...
- ecshop会员中心订单excel倒出
ecshop会员中心订单excel倒出...
ecshop热门问答
ecshop热门资料
ecshopoccurred
ecshopconversion
ecshop商家
ecshop搜索范围
ecshopemoi
ecshop好汉
ecshop淘宝商城
ecshop空白处
ecshopSTMP
ecshop广告统计
ecshop毛边
ecshop工作
ecshop忙活
ecshopNBA
ecshop站长统计
ecshop留言显示IP
ecshop广州
ecshop淘宝数据
ecshop返修
ecshop信息流
ecshopSEM
ecshop收藏文章
ecshop家常
ecshop商品筛选
ecshop短信发送
ecshop视听
ecshop都会
ecshop心得
批量扩展
ecshop三级分类树