View Issue Details

IDProjectCategoryView StatusLast Update
0004833SOGoBackend Generalpublic2019-09-30 16:44
Reporterpstalder Assigned Tofrancis  
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Platform[Server] LinuxOSUbuntuOS VersionLTS 18.04
Product Version4.0.8 
Fixed in Version4.1.0 
Summary0004833: The mysql-utf8mb4.sql script does not contain all the changes from sql-update-3.2.10_to_4.0.0-mysql.sh script
Description

The table create script for MySQL database "mysql-utf8mb4.sql" creates the tables without the 3 field growings from "sql-update-3.2.10_to_4.0.0-mysql.sh" script.

The fields "c_defaults", "c_settings" should be LONGTEXT instead of TEXT and "c_mail" should be TEXT instead of VARCHAR(256)

Steps To Reproduce

Create database with "mysql-utf8mb4.sql" an look at the generated structure.

(As a workaround the update script "sql-update-3.2.10_to_4.0.0-mysql.sh" can be run and just fails for the field additions.

TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

sogo: master 4c7665d3

2019-09-30 16:27:51

francis

Details Diff
(sql) Update mysql-utf8mb4.sql for v4.x

Fixes 0004833
Affected Issues
0004833
mod - Scripts/mysql-utf8mb4.sql Diff File

Issue History

Date Modified Username Field Change
2019-09-29 11:36 pstalder New Issue
2019-09-30 16:43 francis Changeset attached => sogo master 4c7665d3
2019-09-30 16:43 francis Assigned To => francis
2019-09-30 16:43 francis Resolution open => fixed
2019-09-30 16:44 francis Status new => resolved
2019-09-30 16:44 francis Fixed in Version => 4.1.0