Running 4-0-6 using an Oracle database and I am getting duplicate
refObject records for all content types - standard and custom.

"Fix RefObjects Table" appears to fix the problem - removing the
duplicates. But each new content item creation creates duplicates.

It appears that the problem is that the Oracle installer does not set
a primary key on the refObject objectID This primary key is set for MS
SQL db installer.

Adding the primary key constraint fixes the problem.

The duplicates were being created in packages/fourq/gateway/
DBGateway.cfc in function createData

I have not reviewed other tables to see if there are any other missing
constraints.

I have raised a bug report for this.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"farcry-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/farcry-dev?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to