MSSQL and RoundCube trunk giving DB error on user creation

[mikel]

I am using Roundcube trunk as of a few days ago.

When you install and log in as a new user, you get the following error:

DB Error in ...rcube_db.inc (521): DB Error: null value violates not-null constraint Query:

INSERT INTO users (created, last_login, username, mail_host, alias, language)
VALUES (getdate(), getdate(), 'myname@mydomain', '127.0.0.1', '', 'en_US')

[nativecode=515 - The statement has been terminated.]

The handling was to allow NULLS in the preferences column of the users database, but I think this is a hack.

Any advice?

Is there a "not set the preferences yet" default that we could change rcube_db.inc to include in the INSERT statement so that this error does not come up? Or should we just make the users table allow a null preference?

Note, in my case, allowing a NULL preference then allowed me to create the user and then as soon as logged in the preference field got set by roundcube anyway to a non null "default" value...

Regards

Mikel