1 Reply Latest reply on Sep 9, 2008 10:06 AM by FreedomNet

    Help finding "...attempted to use an undefined value" error

    FreedomNet
      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.cf m: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.cf m: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:2 8)
      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)