14.1升级到11.5出错已解决悬赏5积分

提问者59471032 答案数1 阅读数1048 发表时间2019-05-10 08:12:41

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

答案列表

禅道-李锡碧 2019-05-10 09:31:36

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

7条回复

🎄

59471032 2019/05/10

哎，忘记备份了。以前都很顺利。这次就是不行

禅道-李锡碧 2019/05/10

现在访问，可以正常访问吗？

🎄

59471032 2019/05/10

早上重新下载覆盖过，一样的问题

禅道-李锡碧 2019/05/10

联系下官网顶部的商务QQ，邀请加入技术交流群，群里截图看下现在的提示。

🐫

Silence 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'

🐫

Silence 2019/06/26

表索引 unique owner, module, section, key Unique 0 A 0 0 0

禅道-李锡碧 2019/06/26

联系下官网顶部的商务QQ，邀请加入技术交流群，群里截图看下

联系我们