The Jedi Punts - Need IE testers

I've been working with a Lighthouse Pro user today who has discovered a very odd issue. When generating reports (the flash charts version), he got a null pointer error from ColdFusion at the end of the first chart.

I opened up Firefox, gave it a whirl, and couldn't reproduce the error.

We then found that the error only occurred in IE (I tried 7, not 6).

So this is what bugs me. It's a CF error - not a client side error. I debugged the FORM scope after posting from the page where you select what to chart and it was the exact same. I debugged the Data variable which all the charts use and it was the exact same in both browsers (as expected), yet somehow only IE is throwing the server side issue.

It seems impossible - but we are both seeing the same thing. Soooo.... consider this my official call for help. If anyone out there wants to try to duplicate this, and actually can duplicate it, post here. FYI - the database the user was running was SQL Server, not that I think it should matter, but there ya go.

I hope we can figure this out - because it certainly is interesting (and frustrating).

Comments

I may have an IE 6 machine at the office I may be able to play with. Which version of LHP was the error occuring on? I have not yet updated to the latest version.

Always willing to give you a hand.
# Posted By Shane Zehnder | 4/2/08 9:23 PM
HI Ray. I use IE 6 on my development machine. I'll be happy to help.
# Posted By Gary Funk | 4/2/08 9:31 PM
The version of LHP is the most recent.
Gary - thanks.

In case it wasn't clear - anyone can test this - just download LHP, install it, and try to reproduce the NPE with IE.
# Posted By Raymond Camden | 4/2/08 10:00 PM
The version of LHP is the most recent.
# Posted By gooki | 4/2/08 11:23 PM
@Ray. I can't find any problem. I installed with MySQL. I will try it with MSSQL 2005. I am also thinkging it might me something with the data. Maybe have the user build a new database and try it with fresh data. I'll keep trying but so far all is well.
# Posted By Gary Funk | 4/2/08 11:23 PM
For anybody wanting to test multiple versions of IE without having to run a virtual machine, can I recommend:

For Windows XP: http://tredosoft.com/Multiple_IE
For XP/Vista: http://www.my-debugbar.com/wiki/IETester/HomePage
BTW - Debug bar also comes pre-installed with IE8 beta.

Sorry Ray but I think these apps are both Windows only.

All the best
Martin
# Posted By Martin | 4/3/08 2:56 AM
@Martin

Wow, what cool programs! Brilliant.

I've been running IE6 via Virtual PC on my laptop for testing, but this looks much easier - spot on.
# Posted By James Allen | 4/3/08 4:42 AM
It reminds me a similar problem on another application (no chart)... in fact one of my form fields names seemed to be an IE7 reserved word, I was digging and digging in my code and finally tried to change the names (desperate measures) of my fields and it worked both in Firefox and IE7

Hope it could a solution
# Posted By Jean-Michel Rottiers | 4/3/08 5:54 AM
I know it is strange that a browser reserved words cause a server side error, I never found why and I had other priorities at that time.
# Posted By Jean-Michel Rottiers | 4/3/08 5:57 AM
Using IE7 and IE8, no problems to report.
# Posted By Steve Walker | 4/3/08 6:08 AM
What version of CF is the user running?

LHP 2.4.001 is running fine on CF7. No errors to report using IE6.
# Posted By Jeff | 4/3/08 7:00 AM
@Jeff - he is on 7. I found out when I tried to do a fileWriteLine() call. ;)
# Posted By Raymond Camden | 4/3/08 7:32 AM
Hey Everyone,

I'm the user that Ray referred to having this issue. Here is a quick run down of my software.

Windows Server 2003 R2
IIS 6.0
SQL Server 2000
ColdFusion 7,0,2,137072 (Enterprise Edition)
Java JDK 1.4.2_13
Lighthouse Pro 2.4.3

I get the error to pop up in IE6 and IE7, but not FF 2.0.0.12. I'm running IE6, IE7 and FF on Windows XP Pro and IE7 and FF on Windows Vista Home Premium.

If anyone needs more information post here and I will respond.

Thanks!
# Posted By Chuck Weidler | 4/3/08 8:48 AM
Worked fine for me - running:

Latest IE7
CF 8
SQL Server 2000
# Posted By Charles Sherman | 4/3/08 8:05 PM
I thought IE only made life hard for web designers...guess I underestimated how terrible it is :)
# Posted By Joel Watson | 4/3/08 8:47 PM
I did more testing tonight. I dropped the database and recreated it on the server with no luck. I still get the error in IE6 and IE7 and no error in FF.

On my local machine, the same one I'm testing my server with, I created the database with the same script. The machine I created it on locally is Windows XP Pro, CF 8 using the built-in webserver and SQL Server 2005. Everything ran perfectly.

I have not a clue all the debuggin I put in tells me everything is running fine, except the for the error I keep receiving.

Anyhow, still testing and trying to think of other ways to debug.

Where is the Force when you need it?!
# Posted By Chuck Weidler | 4/3/08 11:10 PM
Guess what? I got it working.

I had to apply CF 7 Hotfix 3 and restart my ColdFusion Services and WALA it works. I had tried restarting the service before with no luck, but it was the addition of Hotfix 3 that did the trick.

Thanks to everyone for helping look in to the issue.
# Posted By Chuck Weidler | 4/4/08 12:00 AM
Wow, normally I try to always recommend patching your CF if it isn't completely updated, but with this being IE only, I didn't think that was the case.

Holy smokes.

Well, glad it's working. And thank you to everyone here who tried it as well.

Now we can move on to important matters like - how am I going to download the new episode of Battlestar Galatica tonight since I'm at a hotel...
# Posted By Raymond Camden | 4/4/08 7:31 AM
I've been having problems with random null pointer errors in CF8 / MySQL, and found that unchchecking "maintain connections across users" - or whatever that setting reads in CF admin - will fix the issue. Apparently it's a MySQL bug. Worth looking at, I suppose.
# Posted By Eric Hynds | 4/4/08 4:56 PM
Wow, apparently Chuck thought this was his issue (and apparently he replicated what I found!!). Anyway, I'm glad I found this post as I was the one who posted the error on RIAForge. I'll try the patch Monday and see if I still get the same errors. Thanks all for checking and testing their environment. BTW, the environment that this failed in is WinXP SP2, IE7 (fully patched) & Firefox 2.0.0.13, CF7.0.2 & MSSQL 2000 (not sure which SP).
# Posted By Brandon Moser | 4/4/08 11:41 PM
So, after applying the patch, it appears that the problem is fixed for our office, too. Thanks all for the suggestions.
# Posted By Brandon Moser | 4/7/08 10:40 AM