已解決 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 點擊:369
設置備注
答案列表
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,邀請加入技術交流群,群里截圖看下
三肖中特期准黄大仙373745