Opened 6 years ago
Closed 5 years ago
#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: | git-master |
| 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 (3)
comment:1 Changed 5 years ago by seansan
- Milestone set to 0.1.1
comment:2 Changed 5 years ago by lancey
New users are added just fine using SVN v1107, fresh install, with the supplied mysql5.inital.sql
comment:3 Changed 5 years ago by yllar
- Milestone changed from 0.1.1 to 0.1-stable
- Resolution set to worksforme
- Status changed from new to closed
Note: See
TracTickets for help on using
tickets.

review in 0.1.1 - is this still the case?