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