View Issue Details

IDProjectCategoryView StatusLast Update
0004888SOGoBackend Generalpublic2020-01-06 13:49
ReporterJacek Assigned Tofrancis  
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Platform[Server] LinuxOSRHEL/CentOSOS Version7
Product Version4.1.1 
Fixed in Version4.3.0 
Summary0004888: sql-update-3.0.0-to-combined-mysql.sh - Truncated incorrect INTEGER value
Description

sql-update-3.0.0-to-combined-mysql.sh does not work at all. The first command it tries to execute is:
ALTER TABLE $TABLE MODIFY COLUMN c_location integer NULL;
yet it is impossible to convert VARCHAR like "mysql://user:pass@host:port/database/table" to INT.

Script for Postgres drops the NOT NULL constraint instead:
ALTER TABLE $TABLE ALTER COLUMN c_location DROP NOT NULL;

So I assume it should be something like:
ALTER TABLE $TABLE MODIFY COLUMN c_location VARCHAR(2048) NULL;

Steps To Reproduce
  1. Install SOGo with classic layout (three tables per user).
  2. Execute sql-update-3.0.0-to-combined-mysql.sh
  3. It fails with error:
    ERROR 1292 (22007) at line 1: Truncated incorrect INTEGER value: 'mysql://...:...@...:3306/sogo/...'
    ERROR: mysql returned error 1
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

sogo: master ba1757fd

2020-01-06 13:43:40

francis

Details Diff
chore: fix MySQL migration script to 9-table schema

Fix datatype of sogo_folder_info.c_location.

Fixes 0004377
Fixes 0004888
Affected Issues
0004377, 0004888
mod - Scripts/sql-update-3.0.0-to-combined-mysql.sh Diff File

Issue History

Date Modified Username Field Change
2019-11-21 09:57 Jacek New Issue
2020-01-06 13:48 francis Changeset attached => sogo master ba1757fd
2020-01-06 13:48 francis Assigned To => francis
2020-01-06 13:48 francis Resolution open => fixed
2020-01-06 13:49 francis Status new => resolved
2020-01-06 13:49 francis Fixed in Version => 4.3.0