easysoft / zentaopms

Zentao is an agile(scrum) project management system/tool, Free Upgrade Forever!​
http://www.zentao.pm
Other
1.29k stars 322 forks source link

【Bug】禅道17.7安装时与mariadb-server-5.5.68 存在兼容性问题。 #101

Closed fuchanghao closed 2 months ago

fuchanghao commented 1 year ago

系统:CentOS 7.9 php:5.4.16-48 mariadb-server:5.5.68-1 httpd:2.4.6-97

我下载的是php5.4_5.6的RPM包。

按照文档进行一步一步安装。

屏幕截图 2022-10-27 173645

在安装到这一步时。

屏幕截图 2022-10-27 173939

报错“您当前的数据库不支持使用InnoDB数据表引擎,请修改为MyISAM后重试。”。

屏幕截图 2022-10-27 174230

我这里查询了数据表引擎,默认是InnoDB。

show engines\g;
+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                                          | Transactions | XA   | Savepoints |
+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
| CSV                | YES     | Stores tables as CSV files                                                       | NO           | NO   | NO         |
| MRG_MYISAM         | YES     | Collection of identical MyISAM tables                                            | NO           | NO   | NO         |
| MyISAM             | DEFAULT | Non-transactional engine with good performance and small data footprint          | NO           | NO   | NO         |
| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears)                   | NO           | NO   | NO         |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                                               | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                        | NO           | NO   | NO         |
| ARCHIVE            | YES     | gzip-compresses tables for a low storage footprint                               | NO           | NO   | NO         |
| InnoDB             | YES     | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys       | YES          | YES  | YES        |
| FEDERATED          | YES     | Allows to access tables on other MariaDB servers, supports transactions and more | YES          | NO   | YES        |
| Aria               | YES     | Crash-safe tables with MyISAM heritage                                           | NO           | NO   | NO         |
+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+

而且我将数据表引擎修改为默认为MyISAM后问题依旧。

fuchanghao commented 1 year ago

是17.5系统之后将最低的mysql/mariadb的依赖提升到5.6以上了吗?

这里测试了一下Mysql 8.0和MariaDB 10.9均工作正常。