Moved to Bugs
I was able to find a MySQL bug linked to this:
http://bugs.mysql.com/bug.php?id=19498
[4 Aug 5:53] Paul DuBois
Noted in 5.0.25 changelog.
TEXT and BLOB columns do not support DEFAULT values. However, when a
default of '' was specified, the specification was silently ignored.
This now results in a warning, or an error in strict mode.
So in newer versions of MySQL in strict mode, PunBB's install will fail. The fix is simply to do "message text," since having a default appears to do nothing anyway.
Orange: If you would like a fix, do this to install.php
FIND
$sql = 'CREATE TABLE '.$db_prefix."posts (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
poster VARCHAR(200) NOT NULL DEFAULT '',
poster_id INT(10) UNSIGNED NOT NULL DEFAULT 1,
poster_ip VARCHAR(15),
poster_email VARCHAR(50),
message TEXT NOT NULL DEFAULT '',
hide_smilies TINYINT(1) NOT NULL DEFAULT 0,
posted INT(10) UNSIGNED NOT NULL DEFAULT 0,
edited INT(10) UNSIGNED,
edited_by VARCHAR(200),
topic_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (id)
) TYPE=MyISAM;";
REPLACE WITH
$sql = 'CREATE TABLE '.$db_prefix."posts (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
poster VARCHAR(200) NOT NULL DEFAULT '',
poster_id INT(10) UNSIGNED NOT NULL DEFAULT 1,
poster_ip VARCHAR(15),
poster_email VARCHAR(50),
message TEXT,
hide_smilies TINYINT(1) NOT NULL DEFAULT 0,
posted INT(10) UNSIGNED NOT NULL DEFAULT 0,
edited INT(10) UNSIGNED,
edited_by VARCHAR(200),
topic_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (id)
) TYPE=MyISAM;";