dumped containerdata and got out an empty struct
Btw: the tab Archive is also not working for dmHTML object containing rules in containers. Error message is
Element ARCHIVEPREVIEW is undefined in a CFML structure referenced as part of an expression.
The error occurred in C:\_webs_\applications\farcry_core\admin\edittabArchive.cfm: line 85
83 : <td>#lastupdatedby#</td>
84 : <td><a href="edittabArchiveDetail.cfm?archiveid=#objectid#">#application.adminBundle[session.dmProfile.locale].moreDetail#</a></td>
85 : <td><a href="#application.url.conjurer#?archiveid=#objectid#" target="_blank">#application.adminBundle[session.dmProfile.locale].archivePreview#</a></td>
86 : <td>
87 : <a href="edittabArchive.cfm?objectid=#url.objectid#&archiveid=#objectid#">Rollback</a>
Below are all the queries run before my CFDUMP
Silvio
SQL Queries
qgetType (Datasource=MUNICHITSERVICES, Time=10ms, Records=1) in C:\_webs_\applications\fourq\fourq.cfc @ 20:30:22.022
select typename from refObjects
where objectID = 'BEF6BC2F-F3F0-3583-9A360C1F3EB36E8F'
qgetData (Datasource=MUNICHITSERVICES, Time=0ms, Records=1) in C:\_webs_\applications\fourq\_fourq\getData.cfm @ 20:30:22.022
SELECT teaserImage,displayMethod,extendedmetadata,status,versionID,Teaser,Body,Title,metaKeywords,commentlog,createdby,locked,datetimelastupdated,label,datetimecreated,ObjectID,lastupdatedby,lockedBy
FROM dmHTML
WHERE ObjectID = 'BEF6BC2F-F3F0-3583-9A360C1F3EB36E8F'
qArrayData (Datasource=MUNICHITSERVICES, Time=0ms, Records=0) in C:\_webs_\applications\fourq\_fourq\getData.cfm @ 20:30:22.022
select * from dmHTML_aObjectIDs
where objectid = 'BEF6BC2F-F3F0-3583-9A360C1F3EB36E8F'
order by seq
qArrayData (Datasource=MUNICHITSERVICES, Time=10ms, Records=0) in C:\_webs_\applications\fourq\_fourq\getData.cfm @ 20:30:22.022
select * from dmHTML_aRelatedIDs
where objectid = 'BEF6BC2F-F3F0-3583-9A360C1F3EB36E8F'
order by seq
qgetType (Datasource=MUNICHITSERVICES, Time=10ms, Records=1) in C:\_webs_\applications\fourq\fourq.cfc @ 20:30:22.022
select typename from refObjects
where objectID = 'BEF6BC2F-F3F0-3583-9A360C1F3EB36E8F'
qgetType (Datasource=MUNICHITSERVICES, Time=0ms, Records=1) in C:\_webs_\applications\fourq\fourq.cfc @ 20:30:22.022
select typename from refObjects
where objectID = 'BEF6BC2F-F3F0-3583-9A360C1F3EB36E8F'
qGetParent (Datasource=MUNICHITSERVICES, Time=10ms, Records=1) in C:\_webs_\applications\farcry_core\packages\types\dmNavigation.cfc @ 20:30:22.022
SELECT objectid FROM dmNavigation_aObjectIDs
WHERE data = '557DAF4E-AF31-0EF8-7B94FBF7F5278387'
qgetData (Datasource=MUNICHITSERVICES, Time=10ms, Records=1) in C:\_webs_\applications\fourq\_fourq\getData.cfm @ 20:30:22.022
SELECT status,ExternalLink,options,lNavIDAlias,title,createdby,locked,datetimelastupdated,label,datetimecreated,ObjectID,lastupdatedby,lockedBy
FROM dmNavigation
WHERE ObjectID = '557DB104-EBB1-0EF9-8D6E08F5A181FAED'
qArrayData (Datasource=MUNICHITSERVICES, Time=10ms, Records=1) in C:\_webs_\applications\fourq\_fourq\getData.cfm @ 20:30:22.022
select * from dmNavigation_aObjectIDs
where objectid = '557DB104-EBB1-0EF9-8D6E08F5A181FAED'
order by seq
qgetType (Datasource=MUNICHITSERVICES, Time=0ms, Records=1) in C:\_webs_\applications\fourq\fourq.cfc @ 20:30:22.022
select typename from refObjects
where objectID = 'BEF6BC2F-F3F0-3583-9A360C1F3EB36E8F'
qProfile (Datasource=MUNICHITSERVICES, Time=10ms, Records=1) in C:\_webs_\applications\farcry_core\packages\types\_dmProfile\getProfile.cfm @ 20:30:22.022
SELECT objectID FROM dmProfile WHERE UPPER(userName) = 'FARCRY'
qgetData (Datasource=MUNICHITSERVICES, Time=0ms, Records=1) in C:\_webs_\applications\fourq\_fourq\getData.cfm @ 20:30:22.022
SELECT bReceiveEmail,notes,phone,userDirectory,department,position,lastName,locale,fax,emailAddress,userName,firstName,bActive,createdby,locked,datetimelastupdated,label,datetimecreated,ObjectID,lastupdatedby,lockedBy
FROM dmProfile
WHERE ObjectID = '557E9691-BDA0-4C14-1269F070DBCE5185'
q (Datasource=MUNICHITSERVICES, Time=10ms, Records=1) in C:\_webs_\applications\farcry_core\packages\farcry\tree.cfc @ 20:30:22.022
SELECT * from nested_tree_objects where objectid = '557DB104-EBB1-0EF9-8D6E08F5A181FAED'
q (Datasource=MUNICHITSERVICES, Time=0ms, Records=1) in C:\_webs_\applications\farcry_core\admin\includes\cfFunctionWrappers.cfm @ 20:30:22.022
select parentid from nested_tree_objects where objectid = '557DB0F4-E1C1-1E89-EDD34CABF4F6ACD6'
q (Datasource=MUNICHITSERVICES, Time=10ms, Records=1) in C:\_webs_\applications\farcry_core\admin\includes\cfFunctionWrappers.cfm @ 20:30:22.022
select objectid, objectname, nlevel from nested_tree_objects where objectID IN ('557DB0F4-E1C1-1E89-EDD34CABF4F6ACD6','')
q (Datasource=, Time=0ms, Records=1) in C:\_webs_\applications\farcry_core\packages\farcry\_tree\getAncestors.cfm @ 20:30:22.022
SELECT * FROM ancestors ORDER BY nlevel
q (Datasource=MUNICHITSERVICES, Time=0ms, Records=1) in C:\_webs_\applications\farcry_core\admin\includes\cfFunctionWrappers.cfm @ 20:30:22.022
SELECT * FROM dmPermission WHERE upper(permissionName) = 'APPROVE' AND upper(permissiontype) = 'DMNAVIGATION'
qgetType (Datasource=MUNICHITSERVICES, Time=10ms, Records=1) in C:\_webs_\applications\fourq\fourq.cfc @ 20:30:22.022
select typename from refObjects
where objectID = 'BEF6BC2F-F3F0-3583-9A360C1F3EB36E8F'
qgetType (Datasource=MUNICHITSERVICES, Time=0ms, Records=1) in C:\_webs_\applications\fourq\fourq.cfc @ 20:30:22.022
select typename from refObjects
where objectID = 'BEF6BC2F-F3F0-3583-9A360C1F3EB36E8F'
qHasDraft (Datasource=MUNICHITSERVICES, Time=0ms, Records=0) in C:\_webs_\applications\farcry_core\packages\farcry\_versioning\versioningRules.cfm @ 20:30:22.022
SELECT objectID,status from dmHTML where versionID = 'BEF6BC2F-F3F0-3583-9A360C1F3EB36E8F'
qgetType (Datasource=MUNICHITSERVICES, Time=10ms, Records=1) in C:\_webs_\applications\fourq\fourq.cfc @ 20:30:22.022
select typename from refObjects
where objectID = 'BEF6BC2F-F3F0-3583-9A360C1F3EB36E8F'
qgetData (Datasource=MUNICHITSERVICES, Time=0ms, Records=1) in C:\_webs_\applications\fourq\_fourq\getData.cfm @ 20:30:22.022
SELECT teaserImage,displayMethod,extendedmetadata,status,versionID,Teaser,Body,Title,metaKeywords,commentlog,createdby,locked,datetimelastupdated,label,datetimecreated,ObjectID,lastupdatedby,lockedBy
FROM dmHTML
WHERE ObjectID = '557DAF4E-AF31-0EF8-7B94FBF7F5278387'
qArrayData (Datasource=MUNICHITSERVICES, Time=0ms, Records=0) in C:\_webs_\applications\fourq\_fourq\getData.cfm @ 20:30:22.022
select * from dmHTML_aObjectIDs
where objectid = '557DAF4E-AF31-0EF8-7B94FBF7F5278387'
order by seq
qArrayData (Datasource=MUNICHITSERVICES, Time=0ms, Records=0) in C:\_webs_\applications\fourq\_fourq\getData.cfm @ 20:30:22.022
select * from dmHTML_aRelatedIDs
where objectid = '557DAF4E-AF31-0EF8-7B94FBF7F5278387'
order by seq
q (Datasource=MUNICHITSERVICES, Time=0ms, Records=91) in C:\_webs_\applications\farcry_core\packages\rules\container.cfc @ 20:30:22.022
SELECT *
FROM refContainers r
WHERE objectid = '557DAF4E-AF31-0EF8-7B94FBF7F5278387'
Tom Cornilliac wrote:
Yeah, I agree. I'm confused....Why isn't LABEL in CONTAINERDATA? It should as LABEL is a CORE property of the Container type. That said, any calls to getData() with a valid Container ID should produce a recordset with a LABEL column.
At this point I'm reluctant to add a conditional that checks for the existance of Label because I fear we would be treating the symptom and not the problem.
Can you do me a favor and wrap the offending code in a try/catch block. In the catch can you dump ContainerData. I'm curious to see what's in ContainerData when it throws the exception.
Thanks,
~tom
However I think the problem is within in this code snipped of cffunction copyContainers in container.cfc:
if(arguments.bDeleteDestData) { for(index = 1;index LTE qDestCon.recordcount;index=index+1) { //get the data on the container I might delete containerData = super.getData(qDestCon.containerid[index]);
if(find(qDestCon.objectid[index],containerData.label)) { //delete all rule data from this container deleteContainerRules(containerid=qDestCon.containerid[index]); //delete the container super.deleteData(qDestCon.containerid[index]); //delete the refContainers entry for this container
deleteRefContainerData(containerid=qDestCon.containerid[index],dsn=arguments.dsn); } } }
especially this IF
if(find(qDestCon.objectid[index],containerData.label))
is producing the error message "Element LABEL is undefined in CONTAINERDATA" if label does not exist
When commenting out the snipped above it is possible to send an dmHTML object live. Maybe an additional IF which checks for existence of containerData.label will be an workaround here. I will investigate this.
Best regards,
Silvio
Tom Cornilliac wrote:
Well....Try as I might I cannot seem to recreate your scenario Silvio. Have you made any progress on your end? Has anyone else seen this or something like it in 2.3?
~tom
On Fri, 28 Jan 2005 10:02:49 -0800, Tom Cornilliac <[EMAIL PROTECTED]> wrote:
Hi Silvio,
I'm looking into this right now. I'll let you know what I come up with.
~tom
On Fri, 28 Jan 2005 17:01:02 +0100, Silvio Resch <[EMAIL PROTECTED]> wrote:
Hi,
Got some trouble after updating 2.2 sites to b2.3. When aproving dmHTML objects containing referencing containers on it I get this error message.
Element LABEL is undefined in CONTAINERDATA.
The error occurred in C:\_webs_\applications\farcry_core\packages\rules\container.cfc: line 138 Called from C:\_webs_\applications\farcry_core\packages\farcry\_versioning\sendObjectLive.cfm: line 72 Called from C:\_webs_\applications\farcry_core\packages\farcry\versioning.cfc: line 44 Called from C:\_webs_\applications\farcry_core\tags\navajo\objectStatus.cfm: line 300 Called from C:\_webs_\applications\farcry_core\tags\navajo\objectStatus.cfm: line 122 Called from C:\_webs_\applications\farcry_core\tags\navajo\objectStatus.cfm: line 120 Called from C:\_webs_\applications\farcry_core\tags\navajo\objectStatus.cfm: line 1 Called from C:\_webs_\applications\farcry_core\admin\navajo\approve.cfm: line 7
136 : should not be removed because it *was not copied* to begin with. 137 : */ 138 : if(find(qDestCon.objectid[index],containerData.label)) 139 : { 140 : //delete all rule data from this container ***************************************************************************************
DB is MS SQL 2K
Got some trouble within the update script also. Had to add the DB fields dmProfile.locale and Categories. Alias manually. Any idea what's went wrong?
Best regards,
Silvio
--- 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/
--- 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/
--- 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/
