Q002:升级UCenter 1.7.0报错(Warning: fopen(../data/logs/X3.5_upgrade_ucenter.php): failed to open stream: No such file or directory in uc_server/update_ucenter_adult.phpon line990)
A002:需要给UC目录(通常为/uc_server/)的升级日志目录(/data/logs/)赋予写权限。
Q007:升级过程中提示Specified key was too long; max key length is 767 bytes
A007:这是由于X3.5将升级数据库为InnoDb引擎,索引字段长度和Myisam不同,需要看报错中的具体表,进行索引字段长度变更,一般255的,建议变更为190
Q008:升级过程中提示(1061) Duplicate key name 'gpmid'ALTER TABLE common_member_grouppm ADD INDEX gpmid(gpmid);
A008:应该是升级出错后又直接再次执行升级文件导致的,升级出错后建议回滚数据后再重新操作。同时,针对该问题,回滚数据后可以进入“pre_common_member_grouppm”数据表检查索引gpmid是否存在,如存在,可以先予以删除再操作升级
Q009:升级过程中提示(1062) Duplicate entry '***' for key 'username'ALTER TABLE common_member CONVERT TO CHARACTER SET utf8mb4COLLATE utf8mb4_unicode_ci;(common_member也可能是common_member_archive)
A009:首先,这一般是UC升级1.7.0后UC里应用通信失败导致改名通知未被全部执行就进行了X程序升级引起的,解决方法有多种。
select uid from pre_ucenter_members where username in (select username from pre_ucenter_members group by convert(username using utf8mb4) collate utf8mb4_unicode_ci having count(1) > 1)
Fatal error: Uncaught Error: Call to undefined function getglobal() in /www/wwwroot/*/source/class/discuz/discuz_error.php:336 Stack trace: #0 /www/wwwroot/*/source/class/discuz/discuz_error.php(183): discuz_error::write_error_log('<b>Call to unde...') #1 /www/wwwroot/*/source/class/class_core.php(121): discuz_error::exception_error(Object(Error)) #2 [internal function]: core::handleException(Object(Error)) #3 {main} thrown in /www/wwwroot/*/source/class/discuz/discuz_error.php on line 336