Score
0
Watch 721 Star 2.1K Fork 1.1K

Discuz! / DiscuzXPHP

Discuz_X3.4 doesn't support 10.2.26-MariaDB

Open
shanewa  Opened this issue

Hi, There,

When I installed Discuz_X3.4 with MariaDB 10.2.26, all DB tables created failed!

The root cause:

The older TYPE option was synonymous with ENGINE. TYPE was deprecated in MySQL 4.0 and removed in MySQL 5.5. When upgrading to MySQL 5.5 or later, you must convert existing applications that rely on TYPE to use ENGINE instead.

One of the error log:

SQL:CREATE TABLE pre_ucenter_applications ( appid smallint(6) unsigned NOT NULL auto_increment, type varchar(16) NOT NULL default '', name varchar(20) NOT NULL default '', url varchar(255) NOT NULL default '', authkey varchar(255) NOT NULL default '', ip varchar(15) NOT NULL default '', viewprourl varchar(255) NOT NULL, apifilename varchar( 30 ) NOT NULL DEFAULT 'uc.php', charset varchar(8) NOT NULL default '', dbcharset varchar(8) NOT NULL default '', synlogin tinyint(1) NOT NULL default '0', recvnote tinyint(1) DEFAULT '0', extra text NOT NULL, tagtemplates text NOT NULL, allowips text NOT NULL, PRIMARY KEY (appid))
Error:You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MYISAM' at line 1

Thanks!

BR,
Shane

1773794_laozhoubuluo total 3 participants

Comments (2)

滴嗒 2019-08-06 21:12

you can use mysql

1773794_laozhoubuluo
老周部落 2019-08-07 22:35

It's already have a PR for fix this issue, You can try to solve the problem by using it.
PR: !159:Fix: MariaDB compatibility

Sign in to comment

Assignees
Labels
Not set
Projects
Milestones
Branches
Planed to start
Not set
Planed to end
Not set
Top level
Priority
PHP
1
https://gitee.com/ComsenzDiscuz/DiscuzX.git
git@gitee.com:ComsenzDiscuz/DiscuzX.git
ComsenzDiscuz
DiscuzX
DiscuzX

Help Search