安装Discuz! x3.4的时候，使用的是腾讯的独立数据库，结果安装出错，用宝塔自带数据库则不会，应该是参数问题，找寻良久，终于找到修复方法，公布如下：
安装成功后发帖报错：
(1146) Table ‘discuz.forum_post’ doesn’t exist SELECT * FROM forum_post WHERE authorid=‘2’ AND invisible=’-3’ AND first=‘1’ LIMIT 20
后来一查原来是pre_forum_post 建表失败了
pre_forum_post 原表结构：
CREATE TABLE pre_forum_post ( pid int(10) unsigned NOT NULL, fid mediumint(8) unsigned NOT NULL DEFAULT '0', tid mediumint(8) unsigned NOT NULL DEFAULT '0', `first` tinyint(1) NOT NULL DEFAULT '0', author varchar(15) NOT NULL DEFAULT '', authorid mediumint(8) unsigned NOT NULL DEFAULT '0', `subject` varchar(80) NOT NULL DEFAULT '', dateline int(10) unsigned NOT NULL DEFAULT '0', message mediumtext NOT NULL, useip varchar(15) NOT NULL DEFAULT '', `port` smallint(6) unsigned NOT NULL DEFAULT '0', invisible tinyint(1) NOT NULL DEFAULT '0', anonymous tinyint(1) NOT NULL DEFAULT '0', usesig tinyint(1) NOT NULL DEFAULT '0', htmlon tinyint(1) NOT NULL DEFAULT '0', bbcodeoff tinyint(1) NOT NULL DEFAULT '0', smileyoff tinyint(1) NOT NULL DEFAULT '0', parseurloff tinyint(1) NOT NULL DEFAULT '0', attachment tinyint(1) NOT NULL DEFAULT '0', rate smallint(6) NOT NULL DEFAULT '0', ratetimes tinyint(3) unsigned NOT NULL DEFAULT '0', `status` int(10) NOT NULL DEFAULT '0', tags varchar(255) NOT NULL DEFAULT '0', `comment` tinyint(1) NOT NULL DEFAULT '0', replycredit int(10) NOT NULL DEFAULT '0', position int(8) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (tid,position), UNIQUE KEY pid (pid), KEY fid (fid), KEY authorid (authorid,invisible), KEY dateline (dateline), KEY invisible (invisible), KEY displayorder (tid,invisible,dateline), KEY `first` (tid,`first`) ) TYPE=MyISAM;
修改点：
PRIMARY KEY (tid,position), 修改为 PRIMARY KEY (position),
然后就是MySQL引擎的变化，TYPE=MyISAM; 修改为 ENGINE=InnoDB DEFAULT CHARSET=utf8;
更改后表结构：
CREATE TABLE `pre_forum_post` ( `pid` int(10) unsigned NOT NULL, `fid` mediumint(8) unsigned NOT NULL DEFAULT '0', `tid` mediumint(8) unsigned NOT NULL DEFAULT '0', `first` tinyint(1) NOT NULL DEFAULT '0', `author` varchar(15) NOT NULL DEFAULT '', `authorid` mediumint(8) unsigned NOT NULL DEFAULT '0', `subject` varchar(80) NOT NULL DEFAULT '', `dateline` int(10) unsigned NOT NULL DEFAULT '0', `message` mediumtext NOT NULL, `useip` varchar(15) NOT NULL DEFAULT '', `port` smallint(6) unsigned NOT NULL DEFAULT '0', `invisible` tinyint(1) NOT NULL DEFAULT '0', `anonymous` tinyint(1) NOT NULL DEFAULT '0', `usesig` tinyint(1) NOT NULL DEFAULT '0', `htmlon` tinyint(1) NOT NULL DEFAULT '0', `bbcodeoff` tinyint(1) NOT NULL DEFAULT '0', `smileyoff` tinyint(1) NOT NULL DEFAULT '0', `parseurloff` tinyint(1) NOT NULL DEFAULT '0', `attachment` tinyint(1) NOT NULL DEFAULT '0', `rate` smallint(6) NOT NULL DEFAULT '0', `ratetimes` tinyint(3) unsigned NOT NULL DEFAULT '0', `status` int(10) NOT NULL DEFAULT '0', `tags` varchar(255) NOT NULL DEFAULT '0', `comment` tinyint(1) NOT NULL DEFAULT '0', `replycredit` int(10) NOT NULL DEFAULT '0', `position` int(8) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`position`), UNIQUE KEY `pid` (`pid`), KEY `fid` (`fid`), KEY `authorid` (`authorid`,`invisible`), KEY `dateline` (`dateline`), KEY `invisible` (`invisible`), KEY `displayorder` (`tid`,`invisible`,`dateline`), KEY `first` (`tid`,`first`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
pre_common_member_grouppm消息建表失败，原表结构如下：
CREATE TABLE pre_common_member_grouppm ( uid MEDIUMINT (8) UNSIGNED NOT NULL DEFAULT '0', gpmid SMALLINT (6) UNSIGNED NOT NULL AUTO_INCREMENT, `status` TINYINT (1) NOT NULL DEFAULT '0', dateline INT (10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (uid, gpmid) ) ENGINE = MYISAM DEFAULT CHARSET = utf8;
更改后表结构：
CREATE TABLE pre_common_member_grouppm ( uid MEDIUMINT (8) UNSIGNED NOT NULL DEFAULT '0', gpmid SMALLINT (6) UNSIGNED NOT NULL AUTO_INCREMENT, `status` TINYINT (1) NOT NULL DEFAULT '0', dateline INT (10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (gpmid) ) ENGINE=InnoDB DEFAULT CHARSET = utf8;
