BLOB/TEXT cannot have DEFAULT value

[somnatic]

Hi

I today installed Roundcubemail on a Windows Server 2k3. Before installing roundcubemail I installed the most recent version of mysql.

Well, when running the mysql5.initial.sql script, mysql complains that a BLOB/Text field must not have a default value (see mysql5.initial.sql -> table:user, the field mysql complains is "preferences")

Therefore I needed to remove the DEFAULT from that text. The script then ran fine. When logging in later, php (well, mysql) complained that it couldn't create a new user since "preferences" has no default value. I had to change the file main.inc to resolve this (around line 590)

$DB->query("INSERT INTO ".get_table_name('users')."

(created, last_login, username, mail_host, alias, language, preferences) VALUES (".$DB->now().", ".$DB->now().", ?, ?, ?, ?,?)", strip_newlines($user), strip_newlines($host), strip_newlines($user_email), $_SESSIONuser_lang?, );

Someone might want to recheck this.

[thomasb]

Fixed in r863 by setting the prefs field to NULL.