By Kabal-1 on

I get an error when importing my database schema

C:\Inetpub\wwwroot\drupal>mysql -u root -p drupal < database\database.4.1.mysql
Enter password: ********
ERROR 1101 (42000) at line 126: BLOB/TEXT column 'pages' can't have a default va
lue

I'm using Drupal 4.7.4 and MySQL 5.0.27-win32

Anyone have any ideas?

⋅ Categories: Drupal 4.7.x

Comments

rainaldijt’s picture

rainaldijt commented

I am also getting this error. Has anyone found a solution to this issue.

svemir’s picture

svemir commented

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.)