MyBB MySQL Error on Install

[gOOvER]

When i try to install ForumRunner on MyBB i get following Error:


MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1064 - 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=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci' at line 9
Query:
CREATE TABLE mybb_forumrunner_push_data ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, userid INT UNSIGNED NOT NULL DEFAULT '0', pmid INT UNSIGNED NOT NULL DEFAULT '0', threadid INT NOT NULL DEFAULT '0', threadread INT NOT NULL DEFAULT '0', subsent TINYINT UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (id) ) TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci


MyBB Version: 1.6.4
MySQL: MySQLi 5.5.17
PhP: 5.3.8-1~dotdeb.2

[ClemsonJeeper]

Very odd. That is exactly how myBB says to do it.

You can try editing inc/plugins/forumrunner.php

and changing


$db->write_query("
CREATE TABLE " . TABLE_PREFIX . "forumrunner_push_data (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
userid INT UNSIGNED NOT NULL DEFAULT '0',
pmid INT UNSIGNED NOT NULL DEFAULT '0',
threadid INT NOT NULL DEFAULT '0',
threadread INT NOT NULL DEFAULT '0',
subsent TINYINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (id)
) TYPE=MyISAM{$charset}
");

$db->write_query("
CREATE TABLE " . TABLE_PREFIX . "forumrunner_push_users (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
userid INT UNSIGNED NOT NULL,
fr_username VARCHAR(45) NOT NULL,
last_login DATETIME DEFAULT NULL,
b TINYINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (id)
) TYPE=MyISAM{$charset}
");


to


$db->write_query("
CREATE TABLE " . TABLE_PREFIX . "forumrunner_push_data (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
userid INT UNSIGNED NOT NULL DEFAULT '0',
pmid INT UNSIGNED NOT NULL DEFAULT '0',
threadid INT NOT NULL DEFAULT '0',
threadread INT NOT NULL DEFAULT '0',
subsent TINYINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (id)
) {$charset}
");

$db->write_query("
CREATE TABLE " . TABLE_PREFIX . "forumrunner_push_users (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
userid INT UNSIGNED NOT NULL,
fr_username VARCHAR(45) NOT NULL,
last_login DATETIME DEFAULT NULL,
b TINYINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (id)
) {$charset}
");

[rmkilc]

Ah thank you. This worked for me!

Sent from my Motorola Atrix using Forum Runner