2016-07-24, 11:39 AM
I'm hosting MyBB 1.8 on my localhost server and trying to install the Wiki plugin, yet it's giving me an error when installing. Any clue how I can fix this? I really need a Wiki plugin.
https://gyazo.com/ee162f55e0becfc38cd6e2a11041aa22
Plugin: http://community.mybb.com/thread-189024.html
Downloaded: v1.1.1 (https://github.com/Krytic/MyBBWiki/releases)
https://gyazo.com/ee162f55e0becfc38cd6e2a11041aa22
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1101 - BLOB, TEXT, GEOMETRY or JSON column 'lastauthor' can't have a default value
Query:
CREATE TABLE mybb_wiki( id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, authors TEXT(255) NOT
NULL, title TEXT(255), content TEXT, watching VARCHAR(65535), protected INT DEFAULT '0', lastauthor
TEXT(255) DEFAULT '', lastauthorid INT(8), notepad TEXT(255) DEFAULT '', category TEXT(255),
original TEXT ) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
Plugin: http://community.mybb.com/thread-189024.html
Downloaded: v1.1.1 (https://github.com/Krytic/MyBBWiki/releases)