Hello,
I upgraded yesterday to the 10.5 Enterprise version. Everything upgraded fine. Then, somehow, i managed to delete some files in the directory, including all those in /include - not good i know! After trying a few things and not getting anywhere i removed all the files in the dadabik directory, took the dadabik tables out of my test database, and tried to start again. I copied the program files from the enterprise folder, modified the config_custom file, and tried to re-install.
But am getting this error:
[08] Error: during query execution. INSERT INTO "dadabik_permissions" (subject_type_permission,id_subject,object_type_permission,object_permission,id_permission_type,value_permission) values (N'group', 1, N'field', N'TblAppointments.AppointmentID', 7, N'1')
The DBMS server said: SQLSTATE[23000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Violation of UNIQUE KEY constraint 'unique_permission'. Cannot insert duplicate key in object 'dbo.dadabik_permissions'. The duplicate key value is (1, field, TblAppointments.AppointmentID, 7).
i tried deleting the table in my database - i recognize it, and it has the correct name for the id field, but i have no idea where it is getting the duplicate from, i tried to install again, and it failed again at another table - not the next one, maybe three or four later.
I can't see any of the dadabik tables in the database, so can't see what is going on there. I thought there might be some hidden tables or something that were still somewhere so i have restored the database from an earlier version but the error is still occurring.
i am in enterprise version 10.5, but can't give you all the details as i can't get to that bit of the program.
Thanks for your help.
Anna
I upgraded yesterday to the 10.5 Enterprise version. Everything upgraded fine. Then, somehow, i managed to delete some files in the directory, including all those in /include - not good i know! After trying a few things and not getting anywhere i removed all the files in the dadabik directory, took the dadabik tables out of my test database, and tried to start again. I copied the program files from the enterprise folder, modified the config_custom file, and tried to re-install.
But am getting this error:
[08] Error: during query execution. INSERT INTO "dadabik_permissions" (subject_type_permission,id_subject,object_type_permission,object_permission,id_permission_type,value_permission) values (N'group', 1, N'field', N'TblAppointments.AppointmentID', 7, N'1')
The DBMS server said: SQLSTATE[23000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Violation of UNIQUE KEY constraint 'unique_permission'. Cannot insert duplicate key in object 'dbo.dadabik_permissions'. The duplicate key value is (1, field, TblAppointments.AppointmentID, 7).
i tried deleting the table in my database - i recognize it, and it has the correct name for the id field, but i have no idea where it is getting the duplicate from, i tried to install again, and it failed again at another table - not the next one, maybe three or four later.
I can't see any of the dadabik tables in the database, so can't see what is going on there. I thought there might be some hidden tables or something that were still somewhere so i have restored the database from an earlier version but the error is still occurring.
i am in enterprise version 10.5, but can't give you all the details as i can't get to that bit of the program.
Thanks for your help.
Anna