ATutor

Learning Management Tools


  1. Home



Pages:1 2 3 4 5 6 7 8 9 10 11 12 13 14 15


Error BLOBTEXT column cant have a default value



  • 2006-11-22 07:32:49

    Error BLOBTEXT column cant have a default value

    Hello,

    Sorry, my english is very poor.

    I have a problem installing ATutor 1.5.3.3 with MySQL 5.0.27, PHP 4.3.10 and Apache 2.0.52 in Windows XP.

    In step 2 (Database) i get several errors of type "Table AT_xxxx creation failed".

    I tried to run the sql scripts to create one of the tables with the client Mysql-Front and I get the error message "BLOB/TEXT column can't have a default value". Then, i realize that all tables with errors have a column with TEXT NOT NULL default ''. Tables with only TEXT NOT NULL are created without problems.

    What can i do? If i modify the script to use tables without default values in TEXT fields will works? May i use another version of mysql? ...?

    Thanks.


  • 2006-11-22 07:49:47

    Re: Error: BLOB/TEXT column can't have a default value

    Hi again,

    It seems to be a bug of MySql. Removing the value STRICT_TRANS_TABLES in the property sql_mode in my.ini works fine.


  • 2006-11-22 12:07:41

    Re: Error: BLOB/TEXT column can't have a default value

    Thanks. This issue will be available in the 1.5.3.3 release.