http://bbpress.org/forums/ bbPress support forums Topic: "column forum_slug can't have a default value" error with installation en Wed, 03 Dec 2008 03:21:43 +0000 http://bbpress.org/forums/topic/column-forum_slug-cant-have-a-default-value-error-with-installation#post-6868 Fri, 20 Apr 2007 06:09:24 +0000 sambauers 6868@http://bbpress.org/forums/ <p>Can you create a ticket for this <a href="http://trac.bbpress.org/newticket">here</a>. You can login with the same user/pass you use on this forum. </p> http://bbpress.org/forums/topic/column-forum_slug-cant-have-a-default-value-error-with-installation#post-6865 Thu, 19 Apr 2007 21:12:17 +0000 sjons 6865@http://bbpress.org/forums/ <p>Hope this is the right place. I just installed the latest svn version on my local pc, and got the forementioned error twice (also with topic_slug field). Running mysql 5.0.</p> <p>Patch:<br /> <pre><code>Index: upgrade-schema.php =================================================================== --- upgrade-schema.php (revision 805) +++ upgrade-schema.php (working copy) @@ -4,7 +4,7 @@ $bb_queries = &quot;CREATE TABLE $bbdb-&gt;forums ( forum_id int(10) NOT NULL auto_increment, forum_name varchar(150) NOT NULL default &#39;&#39;, - forum_slug text NOT NULL default &#39;&#39;, + forum_slug text NOT NULL, forum_desc text NOT NULL, forum_parent int(10) NOT NULL default &#39;0&#39;, forum_order int(10) NOT NULL default &#39;0&#39;, @@ -31,7 +31,7 @@ CREATE TABLE $bbdb-&gt;topics ( topic_id bigint(20) NOT NULL auto_increment, topic_title varchar(100) NOT NULL default &#39;&#39;, - topic_slug text NOT NULL default &#39;&#39;, + topic_slug text NOT NULL, topic_poster bigint(20) NOT NULL default &#39;0&#39;, topic_poster_name varchar(40) NOT NULL default &#39;Anonymous&#39;, topic_last_poster bigint(20) NOT NULL default &#39;0&#39;,</code></pre> <p>Regards, </p>