View Issue Details

IDProjectCategoryView StatusLast Update
0000554WackoWikiinstallerpublic2022-01-11 16:47
Reporterascrnet Assigned Toadministrator  
Status resolvedResolutionno change required 
PlatformLinuxOSDebianOS Version10
Product Version6.0.0 
Target Version6.0.27Fixed in Version6.0.27 
Summary0000554: upgrade from 6.0.0 to 6.0.1
Descriptionwhen I do the update I get this error in a database table

Wacko 6.0.0 a 6.0.1

    Inserting Record into user table Problema
        Error Inserting Record into user table
        Duplicate entry 'Deleted' for key 'idx_user_name'

attached image
TagsNo tags attached.
Attached Files
update.png (3,984 bytes)   
update.png (3,984 bytes)   



2020-01-04 19:54

reporter   ~0001080

table_user.png (85,070 bytes)   
table_user.png (85,070 bytes)   


2020-01-05 08:19

administrator   ~0001081

That is OK. The routine for adding the new system user 'Deleted' was missing in the upgrade procedure. If you made a fresh install previously then the user 'Deleted' is already there. That's all.

The system user 'Deleted' currently has no use, but should be assigned to the records for deleted users (user_id + owner_id) in the future.
I already wrote a procedure for the user to delete his account, but it also raises questions if this is the right way to do that in a wiki. You see it is work in progress. (read: $) -> General Data Protection Regulation

Issue History

Date Modified Username Field Change
2020-01-04 16:12 ascrnet New Issue
2020-01-04 16:12 ascrnet File Added: update.png
2020-01-04 19:54 ascrnet Note Added: 0001080
2020-01-04 19:54 ascrnet File Added: table_user.png
2020-01-05 08:19 administrator Note Added: 0001081
2020-01-05 08:21 administrator Assigned To => administrator
2020-01-05 08:21 administrator Severity minor => tweak
2020-01-05 08:21 administrator Status new => resolved
2020-01-05 08:21 administrator Resolution open => no change required
2020-01-05 08:21 administrator Fixed in Version => 6.0.x
2020-01-05 08:21 administrator Target Version => 6.0.x
2022-01-11 16:45 administrator Fixed in Version 6.0.x => 6.0.27
2022-01-11 16:47 administrator Target Version 6.0.x => 6.0.27