Website problem after upgrade to CF 6
Posted on 2004-11-15
Recently IT upgraded the ColdFusion server on our intranet from CF 5 to CF 6. Our department has a knowledge sharing application written in cfm with which users could insert information (including uploading files etc.) to a central MS Access database. As part of the navigation on the site, there is a hierarchical tree browser which pulls the categories from the MS Access database dynamically, meaning that when a user inserts a new comment, this is also featured in the tree. CFM is used to generate the queries. On the homepage, this is diplayed as a Java applet.
Fictional E.G. A user uploads a comment on ColdFusion. This would go into Subtopic Macromedia, which itself is a Subtopic of Web Development.
WebDevelopment > Macromedia > ColdFusion > UserComment
On the homepage, only the WebDevelopment folder would be shown. When you click on this, sub categories open up.
Whereas all this worked fine with CF 5, when the server was upgraded to CF 6, thing went wrong. The basic functionality is still there, but user inserts are starting to appear everywhere - not only where they are supposed to appear, but also in the start state of the tree - where only the main categories are supposed to be displayed in "closed" mode. No line of code was changed and nor was the database changed - it must be the upgrade to CFusion 6. Would appreciate any comment on this