2.71升级到2.72出现问题

2016-07-07 15:26 来源：www.chinab4c.com 作者：ecshop专家

2.71升级到2.72出现问题，升级卡在哪里，不动了。



初始化…………完成


正在从 v2.6.2 升级到 v2.7.0


备份数据…………完成
升级文件…………

回答：
MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT v.*, o.option_id, o.vote_id, o.option_name, o.option_count FROM `gzbuy`.`ecs_vote` AS v, `gzbuy`.`ecs_vote_option` AS o WHERE o.vote_id = v.vote_id AND o.vote_id = '1' ORDER BY o.option_order ASC, o.option_id DESC ) [2] => Array ( [error] => Unknown column 'o.option_order' in 'order clause' ) [3] => Array ( [errno] => 1054 ) )

你原来的版本是 2.71？

这里显示
正在从 v2.6.2 升级到 v2.7.0
备份数据…………完成
升级文件…………

恢复下数据重新升级试下

试过了恢复了。还是不行。

恢复后，程序也需要回复
如果恢复程序，那么需要再次升级~

试试来试去都不行，卡在

正在从 v2.6.2 升级到 v2.7.0
备份数据…………完成
升级文件…………

upgrade_v2.6.2.log文件提示

SQL Error:
ERROR NO: 1062
ERROR MSG: Duplicate entry '104' for key 1

Query String:
INSERT INTO `ecs_admin_action` (`action_id`, `parent_id`, `action_code`) VALUES (104, 7, 'package_manage')

File Path:
E:/shop/upgrade/packages/v2.6.2/data_zh_cn_utf-8.sql

请问数据库是否已经恢复了
还有看下ecs_admin_action 该表的的数据
action_id 是 104的数据是否存在，提示的重复了

你好，恢复了。我导出了ecs_admin action.sql这个表，分两段贴上，请帮忙检查一下，谢谢

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(1, 0, 'goods');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(2, 0, 'cms_manage');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(3, 0, 'users_manage');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(4, 0, 'priv_manage');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(5, 0, 'sys_manage');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(6, 0, 'order_manage');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(7, 0, 'promotion');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(8, 0, 'email');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(9, 0, 'templates_manage');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(10, 0, 'db_manage');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(21, 1, 'goods_manage');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(22, 1, 'remove_back');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(23, 1, 'cat_manage');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(24, 1, 'cat_drop');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(25, 1, 'attr_manage');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(26, 1, 'brand_manage');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(27, 1, 'comment_priv');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(84, 1, 'tag_manage');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(30, 2, 'article_cat');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(31, 2, 'article_manage');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(114, 9, 'library_manage');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(115, 9, 'lang_edit');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(116, 9, 'backup_setting');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(117, 9, 'mail_template');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(118, 10, 'db_backup');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(119, 10, 'db_renew');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(120, 10, 'db_optimize');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(121, 10, 'sql_query');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(122, 10, 'convert');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(128, 7, 'exchange_goods');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(129, 6, 'delivery_view');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(130, 6, 'back_view');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(131, 5, 'reg_fields');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(132, 5, 'shop_authorized');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(133, 5, 'webcollect_manage');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(134, 4, 'suppliers_manage');

INSERT INTO ecs_admin_action
(`action_id`, `parent_id`, `action_code`)
VALUES
(135, 4, 'role_manage');

SQL Error:
ERROR NO: 1062
ERROR MSG: Duplicate entry '105' for key 1

Query String:
INSERT INTO `ecs_admin_action` (`action_id`, `parent_id`, `action_code`) VALUES (105, 1, 'picture_batch')

File Path:
E:/shop/upgrade/packages/v2.6.2/data_zh_cn_utf-8.sql

刚才看你的ecs_admin action
这个数据应该是升级后的数据表。
里面已经有 id为104的数据，那么再插入，那么是会报错的。
要恢复的是 最初的数据，就是升级前的

13# 晓天


你好，不是升级后的数据，我重新下载过2.71版，发现里面还是有这个数据的。

明白怎么回事了

你修改过版本号了。

现在升级不是从2.7.1开始升，是从 2.6.2开始升级
http://bbs.ecshop.com/thread-95341-1-1.html
59
里面有查看版本号的方法，修改下版本号