AnsweredAssumed Answered

ERROR 1062 (23000): Duplicate entry for table for key 'idx_alf_propd_val'

Question asked by asharma on Jul 31, 2018

Hi Everyone,


I made a backup of the alfresco database running on Mysql 5.1 for upgrade purpose. While restoring it on other machine I am getting a duplicate entry error for table alf_prop_double_value and key idx_alf_propd_val(ERROR 1062 (23000): Duplicate entry '0.000303030303030303' for key 'idx_alf_propd_val'). The corresponding column name is double_value. As checked there are other duplicate records in the table as well. Despite having a unique key in the table how it's been inserted into the table. A help will be much appreciated. Also, what's this table for and how is it going to impact the functionality.