Hi Guys, Looks like I'm coming into this a bit too late but I have also seem Silvio's problem (I send a msg late last year but I think it got lost in the Christmas email clutter). Tom, my query returned 1065 rogues.
I found that only some dmHTML objects gave this error when attempting to send live. My templates have a number of object specific containers on them like: <con:container label="#stobj.objectID#_bottom"> This results in a heap of entries in the container and refContainers tables. On the standard dmHTML template I have a two object specific containers (_top, _bottom). This results in 2 x the number of dmHTML objects records in containers; so I can understand how things could go a little wrong! On object specific containers, is there some doco on Container Reflection? Cheers David -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Cornilliac Sent: Wednesday, 2 February 2005 3:19 AM To: FarCry Developers Subject: [farcry-dev] Re: trouble with updated 2.3 sites That's what I thought you might get. Here's the deal. The referential integrity between your REFCONTAINERS table and your CONTAINER table is totally blown. That rowcount confirms that there are 2571 containers for which there is *no* data. This is a problem because a call to getData() using any of those container id's would result in a NULL return. That NULL is what's causing the error we've been fighting. Now that we've have the source of the error pinned down I'm confident to modify the container component to check that the getData() call actually returned a value. I'll patch the hole this AM my time and committ to CVS. So the question still remains. How did REFCONTAINERS get in it's current state? I don't know yet. I ran the same query on my REFCONTAINERS table here and I got back 19,000+ container id's that we're rogue :-( Obviously we have a problem in 2.2 or an earlier version of Farcry. The good news is that Geoff reworked most of the container code in 2.3 when he added Container Reflection (Which is sweet by the way) and I have not be able to recreate this scenario in the 2.3 release. You are safe to delete those references if you wish. I deleted mine without any problems. Although I highly recommend you backup your Db first. I'll patch that file right now. Have a look for it in CVS. ~tom --- You are currently subscribed to farcry-dev as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
