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

review in 0.1.1 - is this still the case?

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.