Skip to main content
October 14, 2009
Question

help! Null Pointers

  • October 14, 2009
  • 2 replies
  • 696 views

I have a brand new install of coldfusion 8 (8,0,1,195765)  on a linux server running Linux 2.6.18-128.7.1.el5 on i686.I am also running MySQL version 5.0.45 as a db.

Every once in a while I get this strange error (see below): Now if I refresh the page it goes away. I can find no pattern of this error.

It happens on all my sites on this server and on different pages and every time I refresh the page it runs fine. As you can see the query is simple.

The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code.

Null Pointers are another name for undefined values. 

The error occurred in /home/atlantic/atlantic_fm/index.cfm: line 19

17 : }

18 : </style>

19 :   <cfquery name="get_t" datasource="atlantic">

20 :   SELECT * FROM testimonials where status = 1 ORDER BY id DESC

21 :   </cfquery>

This topic has been closed for replies.

2 replies

October 15, 2009

I found the answer to the problem. It appears this is specific to Coldfusion 8 and MySQL. The fix was going into the advance setting on the "Data Source"  setup and un-checking the "Maintain connections across client requests" option. It has been 1 day and I have not seen this error again. I do not know why this happens or how the un-checking that option fixed it but it did. I am guessing it's a bug with the drivers CF uses to connect to MySQL 5. I am guessing they fixed it in 9.  Thanks anyhow Cameron

Inspiring
October 14, 2009

Is there any commonality between the code that's erroring on the different pages?  Does it always occur with <cfquery> tags, for example?

Do the JRun logs (or the CF logs, for that matter) log anything around the same time this error crops up?

--

Adam