Create Table Block == BLOB/TEXT column 'pages' can't have a default value [#93123]

I installed Drupal 5 beta 1 on Apache 2.2x using PHP 5.2x and MySQL 5.0x

No errors were show in the installation, but once I clicked to go to my site an error about the "blocks" table being unexistant occurred.

I redid the install, and ran the create table {block} i found in system.install

MySQL gave me the error: ERROR 1101 (42000): BLOB/TEXT column 'pages' can't have a default value

I simply changed line 151:
"pages text DEFAULT '' NOT NULL,"

to:
"pages text NOT NULL,"

and ran the MySQL directly again, and it worked. Error disappeared.

***Please note, I'm new to Drupal issue's, though have been using Drupal since 4.6, please tell me if Im reporting bug wrongs, what I should be doing instead..etc***

Comments

Comment #1

Tom-E CreditAttribution: Tom-E commented 6 November 2006 at 05:57

I have gotten no errors up until now, when node_revisions table didn't exit...

Sooo the problem occurs with all BLOB/TEXT fields...

Comment #2

mudanoman CreditAttribution: mudanoman commented 6 November 2006 at 21:35

I hate to budge in, but I could not contact you directly via pm/email. I was wondering if you have found any resolution to: http://drupal.org/node/81012 . I have replied to some of your post seeking help as we are facing the same problem on a high traffic site.

Thanks,

ivan at flixya.com

Comment #3

svemir CreditAttribution: svemir commented 8 November 2006 at 18:05

This is a result of MySQL running in "strict" mode. See http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html for details. Basically, you need to remove STRICT_TRANS_TABLES from sql_mode variable. You can do that in your overall configuration file, when you start mysql, or per session by executing SET SQL_MODE = '' (you may add any attributes you actually need, see above link.)