17.7升级18.2失败
启动包如下错误
# /opt/zbox/zbox restart
/opt/zbox/bin/php: relocation error: /opt/zbox/run/lib/libc.so.6: symbol _dl_exception_create, version GLIBC_PRIVATE not defined in file ld-linux-x86-64.so.2 with link time reference
升级出现问题，提示 权限不够。内容如下：
-----------------
SQLSTATEI420001: Syntax error or access violation: 1227 Access denied; you need (at least one of) the SUPER privilege(s) forthis operationep>The sql is: SET global log bin trust function creators = 1</p>SQLSTATE(42000): Syntax error or access violation: 1227 Access denied; you need (at least one of) the SUPER privilege(s) forthis operationep>The sol is.SET olobal sgl mode = "</p>
SQLSTATE23000: Integrity constraint violation: 1062 Duplicate entry 1-bug-exportTemplate' for key group'<p> The sql isUPDATE zt grouppriv' SET method'='exportTemplate' WHERE method' = 'exportTemplet'</p>
可以在zentao/db/updatefunctions.sql文件中注释下这两句，然后还原一下禅道的数据库，重新升级禅道看下。（注意：此方法只适用于开源版升级）
SET global log_bin_trust_function_creators = 1;
SET global sql_mode = '';
上面是升级时报的错
页面访问时生成配置文件最下面的清空现有数据是清的什么数据，是禅道里的项目吗
启动包如下错误
# /opt/zbox/zbox restart
/opt/zbox/bin/php: relocation error: /opt/zbox/run/lib/libc.so.6: symbol _dl_exception_create, version GLIBC_PRIVATE not defined in file ld-linux-x86-64.so.2 with link time reference
-----------------
SQLSTATEI420001: Syntax error or access violation: 1227 Access denied; you need (at least one of) the SUPER privilege(s) forthis operationep>The sql is: SET global log bin trust function creators = 1</p>SQLSTATE(42000): Syntax error or access violation: 1227 Access denied; you need (at least one of) the SUPER privilege(s) forthis operationep>The sol is.SET olobal sgl mode = "</p>
SQLSTATE23000: Integrity constraint violation: 1062 Duplicate entry 1-bug-exportTemplate' for key group'<p> The sql isUPDATE zt grouppriv' SET method'='exportTemplate' WHERE method' = 'exportTemplet'</p>
请问该怎么解决？网站是虚拟主机形式
E:/CD/ZenTao/bin/mysql/bin/mysql.exe --user=root --password=123456 --port=3306 -e "SET password for root@localhost=password('123456')";
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
最后更新于：02-09 10:57