jforum测试-环境搭建

来源：互联网发布：qq一键加好友软件编辑：程序博客网时间：2024/06/05 04:04

下载论坛框架jforum
下载Tomcat，将jforum解压后的文件放置在Tomcat%TOMCAT_HOME%webapps/目录，并启动Tomcat；
安装mysql并且新建数据库
输入http://127.0.0.1:8080/jforum-2.1.9/install.jsp 安装jforum
所有信息输入正确后点击确定有如下报错

报错信息：
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

原因:
根据报错是因为MySQL的版本不支持TYPE=InnoDB的语法，需要修改SQL语句改为：ENGINE=InnoDB

操作：
进入jforum-2.1.9\WEB-INF\config\database\mysql中修改mysql_db_struct，保存后再安装即可

0 0