Error in the Photo Manager Database

bob-gove wrote on 5/25/2017, 7:49 AM

Does MAGIX pay any attention to these forums? There seem to be a lot of questions that never get answered.

Recently downloaded and registered Photo Manager 16 Deluxe on a 6 month old Dell Laptop. Windows 10

I get this message when trying to identify a person in my pictures. The same person in all pictures. I'm allowed to identify others.Optimize database doesn't work. Do I just delete the data base and start over. How do I fix this?

Error code: 80000000

Statement::Execute( INSERT INTO T_CatAssign( C_RefCategoryID,C_RefFileID,C_RefCatAssignDescID) VALUES (40,6113,(SELECT RESULT FROM SP_INS_FACE_DESC2(0.35625,0.0666667,0.389062,0.125,90,2))) ) :
*** IBPP::Exception ***
Context: Statement::Execute( INSERT INTO T_CatAssign( C_RefCategoryID,C_RefFileID,C_RefCatAssignDescID) VALUES (40,6113,(SELECT RESULT FROM SP_INS_FACE_DESC2(0.35625,0.0666667,0.389062,0.125,90,2))) )
Message: isc_dsql_execute2 failed

SQL Message : -803
Invalid insert or update value(s): object columns are
constrained - no 2 table rows can have duplicate column values

Engine Code : 335544665
Engine Message :
violation of PRIMARY or UNIQUE KEY constraint "UK_TCATASSIGN" on table "T_CATASSIGN"
--------------------------------

Comments

emmrecs wrote on 5/25/2017, 8:22 AM

@bob-gove

Hi.

These forums are a user to user resource; Magix staff do not routinely read the posts, so a response to a question posted here is almost always dependent on another user being able to answer it.

However, your problem is clearly one which suggests a very specific difficulty with one part of a Magix program. I think you would be well-advised to raise a support ticket at http://support.magix.com to include all the information you have posted to this thread.

Jeff
Forum Moderator