History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: FC-1061
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Blocker Blocker
Assignee: Matthew Bryant
Reporter: Ben Spencer
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
FarCry Core Framework

MySQL error in admin - reattachnodes

Created: 24/Jan/08 11:35 PM   Updated: 12/Oct/08 05:20 PM
Component/s: Webtop Admin UI
Affects Version/s: FarCry 4.0 (Gonzalas), 4.0.9
Fix Version/s: FarCry 5.1

Time Tracking:
Not Specified

File Attachments: 1. File reattachnodes.cfm (4 kb)

Environment: MySQL 5.x (Fedora), CFMX8 (windows XP)


 Description  « Hide
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>

 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
Ben Spencer - 24/Jan/08 11:36 PM
heres the fixed file

Matthew Bryant - 12/Oct/08 05:20 PM
Thanks Ben