
|
If you were logged in you would be able to see more operations.
|
|
|
|
File Attachments:
|
1.
reattachnodes.cfm (4 kb)
|
|
Environment:
|
MySQL 5.x (Fedora), CFMX8 (windows XP)
|
|
|
There is a problem with reading table dmNavigation on MySQL case sensitive installations. Basically the ntmorphans query is written in lowercase for dmNavigation which casued the error on my system. Fix code below.
<!--- orphan nodes and exist in dmnavigation --->
<cfquery datasource="#application.dsn#" name="ntmorphans">
SELECT ntm.parentid, n.objectid, n.label, n.status, n.lnavidalias, n.datetimelastupdated
FROM nested_tree_objects ntm, dmNavigation n
WHERE ntm.objectid = n.objectid
AND ntm.parentid not in
(select objectid from nested_tree_objects)
AND NOT (ntm.parentid is NULL OR ntm.parentid = '') -- ie. not ROOT
</cfquery>
|
|
Description
|
There is a problem with reading table dmNavigation on MySQL case sensitive installations. Basically the ntmorphans query is written in lowercase for dmNavigation which casued the error on my system. Fix code below.
<!--- orphan nodes and exist in dmnavigation --->
<cfquery datasource="#application.dsn#" name="ntmorphans">
SELECT ntm.parentid, n.objectid, n.label, n.status, n.lnavidalias, n.datetimelastupdated
FROM nested_tree_objects ntm, dmNavigation n
WHERE ntm.objectid = n.objectid
AND ntm.parentid not in
(select objectid from nested_tree_objects)
AND NOT (ntm.parentid is NULL OR ntm.parentid = '') -- ie. not ROOT
</cfquery> |
Show » |
|