0 Replies Latest reply on Apr 12, 2015 10:57 AM by stevew13532487

    I am having a problem with our shopping cart data base.  Can anyone identify the problem and a solution???  Thank you!!!

    stevew13532487

      The web site you are accessing has experienced an unexpected error.
      Please contact the website administrator.

       

      The following information is meant for the website developer for debugging purposes.
      Error Occurred While Processing Request

      String index out of range: -2

      The error occurred in D:\Webs\worleybuggerflyco.com\worleybuggerflyco\cart\checkout2.cfm: line 9
      7 : </cfquery> 8 : 9 : <cfinsert datasource="#GetSoftwareID.DbName#" tablename="Orders" formfields="CompName, FirstName, LastName, BillAddress, BillCity, BillState, BillZip,  10 :                               Phone, Fax, ShipAddress, ShipCity, ShipState, ShipZip, Email, TotalPrice"> 11 : 

      Resources:
      Browser  Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.118 Safari/537.36
      Remote Address  71.85.17.67
      Referrer  https://omega3.securenetsystems.net/WORLEYBUGGERFLYCO/cart/checkout.cfm
      Date/Time  12-Apr-15 01:51 PM
      Stack Trace
      at cfcheckout22ecfm1422516024.runPage(D:\Webs\worleybuggerflyco.com\worleybuggerflyco\cart\c heckout2.cfm:9)

      java.lang.StringIndexOutOfBoundsException: String index out of range: -2 at java.lang.String.substring(String.java:1938) at coldfusion.tagext.sql.InsertTag.stripInvalidStringFrFormfields(InsertTag.java:328) at coldfusion.tagext.sql.InsertTag.setColumnList(InsertTag.java:407) at coldfusion.tagext.sql.InsertTag.doStartTag(InsertTag.java:621) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661) at cfcheckout22ecfm1422516024.runPage(D:\Webs\worleybuggerflyco.com\worleybuggerflyco\cart\checkout2.cfm:9) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:483) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:288) 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.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:126) at coldfusion.CfmServlet.service(CfmServlet.java:198) 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$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)