#6 Creating subgrouping table...FAILED

[apease11]

-------------
PHPBTTracker+ Installation
Install in progress....

Attempting to check mysql compatability [4.1.2 or greater required]... 5.0.27-community-nt detected... Pass.

Attempting to create database...done!
Attempting to create new user...done!

Starting to create tables...
Creating namemap table...done!
Creating torrent summary table...done!
Creating timestamps table...done!
Creating logins table...done!
Creating IP ban table...done!
Creating external torrents table...done!
Creating retired torrents table...done!
Creating user permissions table...done!
Creating torrents table...done!
Creating subgrouping table...FAILED

9 tables were created.

Problems creating required tables were detected. Please use the following error output to report a bug to http://sourceforge.net/tracker/?group_id=120663&atid=687790.

Error Creating subgrouping table...: BLOB/TEXT column 'heading' can't have a default value

Please copy the above information into a new bugreport.

config.php written.

Installation appears to have had errors. Please check and try again, if needed.
-------------
I am using MySQL Server 5.0.45 and MySQL Client 5.1.11. Also, I am using Apache httpd web server version 2.2.4 on Windows XP Home with PHP 5.2.5. How can I fix it? I tried it on a different computer and it did the same thing, but when I try it on an official server (Host Monster) it went through perfectly. Would you like to see my PHP or Apache configuration files?

[apease11]

This is a snapshot of the error.

[Nobody/Anonymous]

Try the table add manually and remove the "DEFAULT ''" part of statment.

CREATE TABLE `subgrouping` (`group_id` BIGINT (10) UNSIGNED AUTO_INCREMENT NOT NULL, `heading` TEXT NOT NULL DEFAULT '', `groupsort` INT (5) UNSIGNED NOT NULL DEFAULT 0, `category` VARCHAR (10) NOT NULL DEFAULT 'main', PRIMARY KEY(`group_id`))