UseBB Community

The official board for UseBB help and discussion

• UseBB Community » Bug Reports » [FIXED] BLOB/TEXT column [...] can't have a default value.

[FIXED] BLOB/TEXT column [...] can't have a default value.

Page: 1

Author Post
mark999
#1 Tue Feb 20, 2007 4:54 pm
Member
Registered: Feb 2007
Posts: 10
Location: London, England
Installing UseBB 1.0.4 got this error...

In file db_mysql.php on line 117:

SQL_ERROR - BLOB/TEXT column 'descr' can't have a default value

Enable debug mode level 2 to see the error and erroneous SQL query.


MySQL v5.0.27
PHP 5.2.1
Server is Abyss
OS Windows XP


Any suggestions appreciated...

Mark.
« Last edit by Dietrich on Tue Feb 20, 2007 6:26 pm. »
Dietrich
#2 Tue Feb 20, 2007 6:30 pm
Developer
Registered: Apr 2004
Posts: 2243
Location: Belgium
Fixed in CVS. Thanks for reporting.

You can download the adjusted file install/schemas/mysql.sql using the download link here (in Links to HEAD).
mark999
#3 Tue Feb 20, 2007 8:55 pm
Member
Registered: Feb 2007
Posts: 10
Location: London, England
Many thanks for the quickest fix in history :) . I now have another problem with error (HTTP) 302 occuring frequently but I'll post more about it in Support when I've investigated further.

Mark.

Page: 1

• UseBB Community » Bug Reports » [FIXED] BLOB/TEXT column [...] can't have a default value.

UseBB Community is powered by UseBB 1 Forum Software