help! Null Pointers

[Duke_Snyder1]

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>

[Adam Cameron.]

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

[Duke_Snyder1]

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