Ah!! - I think I added a "distinct" in one of the files to fix this Jake... You might check my notes. If the PK constraint fixes it that is much better....
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jake Churchill Sent: Wednesday, August 22, 2007 11:36 AM To: [email protected] Subject: [farcry-dev] Re: Duplicate refObject records - Oracle Nice catch. I'm working on a project with FC 3.0.2 and Oracle and it's been a huge pain to work with the DB. _____ Jake Churchill CF Webtools 11204 Davenport, Ste. 200b Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Kent Sent: Wednesday, August 22, 2007 11:13 AM To: farcry-dev Subject: [farcry-dev] Duplicate refObject records - Oracle 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. No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.484 / Virus Database: 269.12.1/965 - Release Date: 8/21/2007 4:02 PM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.484 / Virus Database: 269.12.1/965 - Release Date: 8/21/2007 4:02 PM --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
