View Issue Details

IDProjectCategoryView StatusLast Update
0004889SOGoBackend Generalpublic2020-01-06 15:22
ReporterJacek Assigned Tofrancis  
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Platform[Server] LinuxOSRHEL/CentOSOS Version7
Product Version4.1.1 
Fixed in Version4.3.0 
Summary0004889: sql-update-3.0.0-to-combined-mysql.sh - possibly incorrect/missing table used
Description

Most of the time sql-update-3.0.0-to-combined-mysql.sh correctly uses table name defined in OCSFolderInfoURL to fetch or update data, but in one place this name is hardcoded to sogo_folder_info:

echo "UPDATE sogo_folder_info SET c_location = NULL, c_quick_location = NULL, c_acl_location = NULL WHERE c_folder_id = $FOLDERID;" >> $SQLFILE

This line should read:

echo "UPDATE $TABLE SET c_location = NULL, c_quick_location = NULL, c_acl_location = NULL WHERE c_folder_id = $FOLDERID;" >> $SQLFILE

Same goes for PostgreSQL version of the script.

TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

sogo: master 4216f9e7

2020-01-06 15:10:43

francis

Details Diff
chore: use TABLE variable in 9-table migration scripts

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

Issue History

Date Modified Username Field Change
2019-11-21 10:43 Jacek New Issue
2020-01-06 15:12 francis Changeset attached => sogo master 4216f9e7
2020-01-06 15:12 francis Assigned To => francis
2020-01-06 15:12 francis Resolution open => fixed
2020-01-06 15:22 francis Status new => resolved
2020-01-06 15:22 francis Fixed in Version => 4.3.0