开源版本16.5升级到21.2遇到的问题汇总已解决悬赏5积分

1.升级后权限没有完全复制过来，比如右下角的搜索框不可见，需要重新给角色分配全文检索的权限。且搜索完成后，不会自动清空本次输入的数据，下次使用前需要手动点X号。

2.复制bug的时候会带附件一起复制，实际附件复用的可能性不大，建议去除。

3.我的地盘、指派给我的bug搜索的时候，不管搜啥都是一堆报错。

17:05:26 #0 lib/base/dao/dao.class.php(1698): baseRouter->triggerError('SQLSTATE[42S22]...', '/opt/zbox/app/z...', 1698, true)#1 lib/base/dao/dao.class.php(617): baseDAO->sqlError(Object(PDOException))#2 lib/dao/dao.class.php(342): baseDAO->count('')#3 module/bug/model.php(877): dao->page(Object(pager))#4 module/my/control.php(491): bugModel->getUserBugs('admin', 'bySearch', 'id_desc', 0, Object(pager), 0, 0)#5 framework/base/control.class.php(923): my->bug('bySearch', 'myQueryID', 'id_desc', '0', '20', '1')#6 framework/control.class.php(415): baseControl->fetch('my', 'bug', Array, '')#7 module/my/control.php(94): control->fetch('my', 'bug', 'type=bySearch&p...')#8 framework/base/router.class.php(2535): my->work('bug', 'bySearch', 'myQueryID', 'id_desc', '0', '20', '1')#9 framework/router.class.php(772): baseRouter->loadModule()#10 www/index.php(88): router->loadModule()#11 {main}ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't1.status' in 'where clause' ,the sql is: 'SELECT COUNT(*) AS recTotal FROM zt_bug WHERE deleted = '0' AND (( 1 AND t1.`status` = 'resolved' ) AND ( 1 )) AND assignedTo = 'admin' '

The sql is: SELECT *, IF(`pri` = 0, 256, pri) AS priOrder, IF(`severity` = 0, 256, severity) AS severityOrder FROM zt_bug wHeRe deleted = '0' AND (( 1 AND t1.`status` = 'resolved' ) AND ( 1 )) AND assignedTo = 'admin' oRdEr bY id desc

in lib/base/dao/dao.class.php on line 1698, last called by lib/base/dao/dao.class.php on line 617 through function sqlError.in/opt/zbox/app/zentao/framework/base/router.class.php on line3276 when visitingmy-work-bug-bySearch-myQueryID

4.已有bug编辑的时候，不分bug格式整个乱了，需手动挨个换行解决。

5.bug导出后顺序并没保持原筛选顺序，而是按照id大小排序。

6.编辑bug保存时偶发无法保存问题。

7.火狐浏览器无法在指派的时候添加备注。

8.多次点击跳转到多个页面，点击←箭头想回到之前页面时，报错，乱码。

9.升级到21.7.4时报错，当时按照这个设置的innodb_large_prefix=1

innodb_file_format=Barracuda

innodb_file_per_table=1，不好使，测试了几个其他方式也不行，无奈就只升级到了21.2版本。

#0 lib/base/dao/dao.class.php(1918): baseRouter->triggerError('SQLSTATE[42000]...', '/opt/zbox/app/z...', 1918, true) #1 lib/base/dao/dao.class.php(1066): baseDAO->sqlError(Object(PDOException)) #2 module/upgrade/model.php(10856): baseDAO->query('ALTER TABLE zt...') #3 module/upgrade/model.php(237): upgradeModel->convertCharset() #4 module/upgrade/model.php(207): upgradeModel->executeUpgradeMethod('convertCharset', Array) #5 module/upgrade/model.php(146): upgradeModel->executeByConfig('21_7_1') #6 module/upgrade/control.php(175): upgradeModel->execute('18_13') #7 framework/base/router.class.php(2504): upgrade->execute('18_13') #8 framework/router.class.php(752): baseRouter->loadModule() #9 www/upgrade.php(95): router->loadModule() #10 {main}ERROR: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes ,the sql is: 'ALTER TABLE zt_autocache` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci' <p>The sql is: ALTER TABLE zt_autocache CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci</p> in lib/base/dao/dao.class.php on line 1918, last called by lib/base/dao/dao.class.php on line 1066 through function sqlError.