Website problem after upgrade to CF 6

Posted on 2004-11-15
Last Modified: 2013-12-24
 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

Question by:ciaranfarrell
    LVL 14

    Expert Comment

    by:Renante Entera
    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 :-)
    LVL 1

    Author Comment

    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?
    LVL 14

    Accepted Solution

    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 :-)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Course: Create Mobile App Prototypes with Adobe XD

    This is a project-based course: we go through all the steps of creating a prototype from start to finish, using all the tools and features currently available in Adobe XD. You can complete the course in less than a day, plus all project files and fonts are included.

    One of the typical problems I have experienced is when you have to move a web server from one hosting site to another. You normally prepare all on the new host, transfer the site, change DNS and cross your fingers hoping all will be ok on new server…
    Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
    The purpose of this video is to demonstrate how to Import and export files in WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: : Click on Too…
    The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: : Go t…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now