已解决 14.1升级到11.5出错

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'system-common-xuanxuan-https' for key 'unique'

The sql is: UPDATE `zt_config` SET `key` = 'https' WHERE `owner` = 'system' AND `module` = 'common' AND `section` = 'xuanxuan' AND `key` = 'isHttps'



SQLSTATE[42S22]: Column not found: 1054 Unknown column 'readme' in 'zt_im_client'

The sql is: 

ALTER TABLE `zt_im_client` CHANGE `readme` `changeLog` text NOT NULL


禅道版本 11.4.1 源码包
操作系统 Windows Server 2008
客户端浏览器 IE11

提问者: 59471032 悬赏: 5 日期: 2019-05-10 08:12:41 答案:1 点击:250
设置备注
答案列表
2019/05/10

还原下备份,重新在官网下载源码包,升级下,看下结果呢?

2019/05/10
哎,忘记备份了。以前都很顺利。这次就是不行
2019/05/10
现在访问,可以正常访问吗?
2019/05/10
早上重新下载覆盖过,一样的问题
2019/05/10
联系下官网顶部的商务QQ,邀请加入技术交流群,群里截图看下现在的提示。
2019/06/26
11.3 11.4.1升级都存在相同问题
该SQL直接在数据库中执行报错
UPDATE `zt_config`
SET `key` = 'https'
WHERE
`owner` = 'system'
AND `module` = 'common'
AND `section` = 'xuanxuan'
AND `key` = 'isHttps'


[SQL]UPDATE `zt_config`
SET `key` = 'https'
WHERE
`owner` = 'system'
AND `module` = 'common'
AND `section` = 'xuanxuan'
AND `key` = 'isHttps'

[Err] 1062 - Duplicate entry 'system-common-xuanxuan-https' for key 'unique'
2019/06/26
表索引 uniqueowner, module, section, keyUnique0A000
2019/06/26
联系下官网顶部的商务QQ,邀请加入技术交流群,群里截图看下