Bug: Error creating subgrouping table

[Nobody/Anonymous]

Install in progress....

Attempting to check mysql compatability [4.1.2 or greater required]... 5.0.41-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

[Dan]

I'll look into this.

[apease11]

I am having the same problem.  I think it might be my php.ini, I am hosting an Apache 2.2.4 server from my computer with PHP 5.2.5 and MySQL server version 5.0.45.  I tried to install ZenCart, an online store, and after two pages of the instalation it said that the page was there but it could not be displayed.  Also I tried to install PHPBTTracker+ 2.2 and ZenCart on Host Monster (an official website host) and it went through fine.  Please email me at aldenpease963@peaseenterprises.com if you find the solution.  Thank you.

[Dan]

It isn't your PHP settings.

It appears newer versions of mysql have changed some rules about creating tables (or, rather, just started enforcing existing rules...)

There are a couple other bugs that I've located, so hopefully version 2.3 will be out in a couple weeks.