[Bb-trac] [bbPress] #654: MySQL 5.1 errors

[bbPress]

#654: MySQL 5.1 errors
----------------------------------+-----------------------------------------
 Reporter:  darkfate              |       Owner:         
     Type:  defect                |      Status:  new    
 Priority:  highest               |   Milestone:  1.0    
Component:  Installation/Upgrade  |     Version:         
 Severity:  blocker               |    Keywords:  mysql51
----------------------------------+-----------------------------------------
 I'm getting these errors on install:

 {{{


 bbPress database error: [BLOB/TEXT column 'forum_slug' can't have a
 default value]
 CREATE TABLE bb_forums ( forum_id int(10) NOT NULL auto_increment,
 forum_name varchar(150) NOT NULL default '', forum_slug text NOT NULL
 default '', forum_desc text NOT NULL, forum_parent int(10) NOT NULL
 default '0', forum_order int(10) NOT NULL default '0', topics bigint(20)
 NOT NULL default '0', posts bigint(20) NOT NULL default '0', PRIMARY KEY
 (forum_id) )

 bbPress database error: [BLOB/TEXT column 'topic_slug' can't have a
 default value]
 CREATE TABLE bb_topics ( topic_id bigint(20) NOT NULL auto_increment,
 topic_title varchar(100) NOT NULL default '', topic_slug text NOT NULL
 default '', topic_poster bigint(20) NOT NULL default '0',
 topic_poster_name varchar(40) NOT NULL default 'Anonymous',
 topic_last_poster bigint(20) NOT NULL default '0', topic_last_poster_name
 varchar(40) NOT NULL default '', topic_start_time datetime NOT NULL
 default '0000-00-00 00:00:00', topic_time datetime NOT NULL default
 '0000-00-00 00:00:00', forum_id int(10) NOT NULL default '1', topic_status
 tinyint(1) NOT NULL default '0', topic_open tinyint(1) NOT NULL default
 '1', topic_last_post_id bigint(20) NOT NULL default '1', topic_sticky
 tinyint(1) NOT NULL default '0', topic_posts bigint(20) NOT NULL default
 '0', tag_count bigint(20) NOT NULL default '0', PRIMARY KEY (topic_id),
 KEY forum_id (forum_id), KEY topic_time (topic_time), KEY topic_start_time
 (topic_start_time) )

 }}}

 I assume this is because the table is InnoDB which doesn't allow default
 values. I think you can just take them out or switch to MyISAM, but that
 would mean losing fulltext support.

-- 
Ticket URL: <http://trac.bbpress.org/ticket/654>
bbPress <http://bbpress.org/>
Innovative forum development