Ticket #1484230 (closed Bugs: worksforme)

Opened 22 months ago

Last modified 9 months ago

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

Changed 9 months ago by seansan

  • milestone set to 0.1.1

review in 0.1.1 - is this still the case?

Changed 9 months ago by lancey

New users are added just fine using SVN v1107, fresh install, with the supplied mysql5.inital.sql

Changed 9 months ago by yllar

  • status changed from new to closed
  • resolution set to worksforme
  • milestone changed from 0.1.1 to 0.1-stable
Note: See TracTickets for help on using tickets.