Website problem after upgrade to CF 6

 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

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Renante EnteraSenior PHP DeveloperCommented:
Hello ciaranfarrell!

I would suggest to restart the following services : Coldfusion MX Application Server, Coldfusion MX ODBC Agent and Coldfusion MX ODBC Server.  After that, go to the CF Administrator page then recreate the Datasource that you are referring to and of course verify the connection.  Lastly, try running again your web application.

Hope this helps you.  Just try it.

eNTRANCE2002 :-)
ciaranfarrellAuthor Commented:
Thank you,

I don't have admin privileges as ColdFusion is running on our company intranet.

I had a closer look at the code (I didn't write it myself - which is why this is confusing).

CFTREE was used to construct the tree - which explains why a Java Applet is displayed. Is there any known issue with CFTREE and ColdFusion 6?
Renante EnteraSenior PHP DeveloperCommented:
So far, I haven't encountered any known issue with CFTREE and CF 6.

For a sort of tutorial on <cftree> tag, visit this site :

But I suspect, that is not the root cause of the problem.  Most cases in which CF is upgraded, it is adviceable to restart the services and then verify the connections of your Datasource/s.

eNTRANCE2002 :-)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Servers

From novice to tech pro — start learning today.