Ticket #1484230 (closed Bugs: worksforme)
MySQL5 default tables NOT NULL prevents new user creation
| Reported by: | nuxlli | Owned by: | |
|---|---|---|---|
| Priority: | 5 | Milestone: | 0.1-stable |
| Component: | Database | Version: | svn-trunk |
| Severity: | normal | Keywords: | |
| Cc: |
Description
In the insert register of the user in table users and insert data about user in table identities, it occurs a error in the column:
users - preferences identities - organization - reply-to - bcc - signature
It's error it occurs because, it's columns is NOT NULL and value inserted for the code is NULL.
Resolution: Alter the code in file mysql5.initial.sql, substituting the following lines:
users: `preferences` text NOT NULL, => `preferences` text NULL, identities: `organization` varchar(128) NOT NULL, => `organization` varchar(128) NULL, `reply-to` varchar(128) NOT NULL, => `reply-to` varchar(128) NULL, `bcc` varchar(128) NOT NULL, => `bcc` varchar(128) NULL, `signature` text NOT NULL, => `signature` text NULL
Change History
Note: See
TracTickets for help on using
tickets.
