部署JForum 2.1.9安装时遇到的问题：报数据库语法错误You have an error in your SQL syntax

一.数据库版本
mysql-5.6.11

二.tomcat版本
apache-tomcat-9.0.41

三.报错信息

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘TYPE=InnoDB’ at line 1
Query being executed when exception was thrown:
CREATE TABLE jforum_banlist ( banlist_id INT NOT NULL auto_increment, user_id INT, banlist_ip varchar(15), banlist_email varchar(255), PRIMARY KEY (banlist_id), INDEX idx_user (user_id), INDEX (banlist_ip), INDEX (banlist_email)) TYPE=InnoDB
CREATE TABLE jforum_banlist ( banlist_id INT NOT NULL auto_increment, user_id INT, banlist_ip varchar(15), banlist_email varchar(255), PRIMARY KEY (banlist_id), INDEX idx_user (user_id), INDEX (banlist_ip), INDEX (banlist_email)) TYPE=InnoDB

四.解决方案

1、找到mysql_db_struct.sql文件，用Notepad++打开

2、将TYPE=InnoDB 全部替换为 ENGINE=InnoDB，Notepad可以批量替换，步骤如下。

3、回到JForum安装网页，点击“修改状态”，继续安装步骤。
4、成功！