View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0001924SOGosogo-toolpublic2012-08-09 11:182012-11-14 15:59
Reporterrims Assigned Tojraby 
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Product Version1.3.16 
Summary0001924: Incorrect MySQL UPDATE command syntax when using rename-user
Description

I am using SOGo (version 1.3.17) configured with MySQL. After issuing command:

sogo-tool rename-user test1 test2

this error is reported:

SQL: UPDATE sogo_folder_info SET c_path = '/'||c_path1||'/'||c_path2||
'/'||c_path3||'/'||c_path4 WHERE c_path2 = 'test2';
ERROR: Duplicate entry '0' for key 'PRIMARY'
SQL: ROLLBACK;

Additional Information

I think this error is reported because there is incorrect MySQL UPDATE command syntax. The correct syntax is:

UPDATE sogo_folder_info SET c_path = CONCAT('/',c_path1,'/',c_path2,
'/',c_path3,'/',c_path4) WHERE c_path2 = 'test2';

Tagsmysql, sogo-tool

Activities

jraby

jraby

2012-11-13 22:30

viewer   ~0004843

Fixed: https://github.com/inverse-inc/sogo/commit/378eef408236051f5bcb44011f20a51ed1fe3fe8

Issue History

Date Modified Username Field Change
2012-08-09 11:18 rims New Issue
2012-08-09 11:49 rims Tag Attached: sogo-tool
2012-08-09 11:49 rims Tag Attached: mysql
2012-09-20 20:17 ludovic Status new => assigned
2012-09-20 20:17 ludovic Assigned To => jraby
2012-11-13 22:30 jraby Note Added: 0004843
2012-11-14 15:59 jraby Status assigned => resolved
2012-11-14 15:59 jraby Resolution open => fixed