EC2.61版本，恢复备份数据库出错的解决方案

2016-07-07 15:31 来源：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 ) )

解决方案：
utf-8版本：
请下载此文件，重新上传覆盖到 EC目录/admin/database.php
database.php (22.13 KB)

gbk版本：
请下载此文件，重新上传覆盖到 EC目录/admin/database.php
database.php (21.7 KB)


回答：
Warning: require(D:/btwwwroot/..../shop/includes/init.phpincludes/lib_common.php) [function.require]: failed to open stream: No such file or directory in D:\.....\web\shop\includes\init.php on line 15

Fatal error: require() [function.require]: Failed opening required 'D:/btwwwroot/.../shop/includes/init.phpincludes/lib_common.php' (include_path='.;C:\php5\pear') in D:\btwwwroot\...\shop\includes\init.php on line 15

我这个应如何解决？


顶一下~~~~~

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => CREATE TABLE `e261_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=utf8DEFAULT CHARSET=utf8 ) [2] => Array ( [error] => Unknown character set: 'utf8DEFAULT' ) [3] => Array ( [errno] => 1115 ) )

下载文件覆盖后恢复的的时候显示以上错误。
原来的文件可以恢复成功，但是数据有问题，不能显示分类树。怎么办？

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => CREATE TABLE `ecs_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=utf8DEFAULT CHARSET=gbk ) [2] => Array ( [error] => Unknown character set: 'utf8DEFAULT' ) [3] => Array ( [errno] => 1115 ) )

看来这个问题不仅只有我中招啊。

好像还没有解决的帖子出来吧。。。有的话帮忙提醒一下。

我都用了几年的EC了，怎么升级到2.6.1会出现这个问题。

我的覆盖文件后恢复数据，但是有些产品图案打不开，而且打开商品栏目有如下出错提示：
Warning: include_once(D:/TOOLS/PHPnow/htdocs/fei8cn/ecshop/uc_client/client.php) [function.include-once]: failed to open stream: No such file or directory in D:\TOOLS\PHPnow\htdocs\fei8cn\ecshop\includes\lib_common.php on line 2027

Warning: include_once() [function.include]: Failed opening 'D:/TOOLS/PHPnow/htdocs/fei8cn/ecshop/uc_client/client.php' for inclusion (include_path='.;D:/TOOLS/PHPnow/htdocs/fei8cn/ecshop/') in D:\TOOLS\PHPnow\htdocs\fei8cn\ecshop\includes\lib_common.php on line 2027

Warning: call_user_func_array() [function.call-user-func-array]: First argument is expected to be a valid callback, 'uc_app_ls' was given in D:\TOOLS\PHPnow\htdocs\fei8cn\ecshop\includes\lib_common.php on line 2030

是会经常出现这问题 收藏了

搞定~

这个问题得到解决了

很急啊为什么覆盖了 还是一点效果都没有呢

你的ec是什么版本？

如果是恢复数据出现该错误你可以看
‘http://bbs.ecshop.com/viewthread ... mp;extra=#pid396795
76