I would really appreaciate some help. We are running CF
Enterprise 8.01 (8,0,1,195765) on a Linux Red hat Enterprise 4
server - Database is MySQL 5 running on second server.
The following sequnece of steps works under CF 6.1 but
intermittantly fails on CF 8.01:
<CFIF IsDefined('search_string') AND search_string NEQ ''
AND Len(search_string) GT 0 AND IsDefined('source_URI') AND
source_URI NEQ '' AND Len(source_URI) GT 0 >
<CFSET insert_search_string = Left(search_string, 126)>
<CFSET insert_source_URI = Left(source_URI, 126)>
<cfquery name="Set_calling_string"
DATASOURCE="#database_name#">
INSERT INTO browser_source_info (seq_num, source_URI,
source_search_string, date_updated ) VALUES (0,
"#insert_search_string#", "#insert_source_URI#",
"#DateFormat(Now(), 'MM/DD/YYYY')#")
</cfquery>
...
</CFIF>
The acutal line referenced in the error is the insert
statement above.
Here is the error screen:
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/cgdirect/public_html/save_referer.cfm: line 42
Called from /home/cgdirect/public_html/_initial.cfm: line 2
Called from /home/cgdirect/public_html/cat_disp_new_col2.cfm:
line 6
Called from /home/cgdirect/public_html/cat_disp_new_col2.cfm:
line 1
40 : <CFSET insert_source_URI = Left(source_URI, 126)>
41 : <cfquery name="Set_calling_string"
DATASOURCE="#database_name#">
42 : INSERT INTO browser_source_info (seq_num, source_URI,
source_search_string, date_updated ) VALUES (0,
"#insert_search_string#", "#insert_source_URI#",
"#DateFormat(Now(), 'MM/DD/YYYY')#")
43 : </cfquery>
44 : <cfquery name="get_rec_id"
DATASOURCE="#rodatabase_name#">
--------------------------------------------------------------------------------
Resources:
Check the ColdFusion documentation to verify that you are
using the correct syntax.
Search the Knowledge Base to find a solution to your problem.
Browser Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0;
WOW64; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506; Media Center
PC 5.0; .NET CLR 1.1.4322)
Remote Address 76.24.68.83
Referrer
http://174.132.34.28/
Date/Time 09-Sep-08 09:07 AM
Stack Trace (click to expand)
at
cfsave_referer2ecfm2064506072.runPage(/home/cgdirect/public_html/save_referer.cfm:42)
at
cf_initial2ecfm1039435966.runPage(/home/cgdirect/public_html/_initial.cfm:2)
at
cfcat_disp_new_col22ecfm895304899._factor10(/home/cgdirect/public_html/cat_disp_new_col2.cfm:6)
at
cfcat_disp_new_col22ecfm895304899.runPage(/home/cgdirect/public_html/cat_disp_new_col2.cfm:1)
java.lang.NullPointerException
at com.mysql.jdbc.Statement.setMaxRows(Statement.java:2178)
at
coldfusion.server.j2ee.sql.JRunStatement.setMaxRows(JRunStatement.java:214)
at
coldfusion.sql.Executive.executeQuery(Executive.java:1276)
at
coldfusion.sql.Executive.executeQuery(Executive.java:1008)
at coldfusion.sql.Executive.executeQuery(Executive.java:939)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325)
at
coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831)
at
coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521)
at
cfsave_referer2ecfm2064506072.runPage(/home/cgdirect/public_html/save_referer.cfm:42)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
at
coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
at
coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661)
at
cf_initial2ecfm1039435966.runPage(/home/cgdirect/public_html/_initial.cfm:2)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
at
coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
at
coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661)
at
cfcat_disp_new_col22ecfm895304899._factor10(/home/cgdirect/public_html/cat_disp_new_col2.cfm:6)
at
cfcat_disp_new_col22ecfm895304899.runPage(/home/cgdirect/public_html/cat_disp_new_col2.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
at
coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
at
coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279)
at
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at
coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at
coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at
coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at
coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
at
coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at
coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:175)
at
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
at
coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at
coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at
jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)