What a complete farce!!!
Perhaps a local media company may want to drop an e-mail to Ticket Zone explaining how they could have built a much more robust system for them???
On one occasion, they crashed but showed me the error message. If anyone is geeky enough to want to work out what they've done wrong...
__________________________________________________________________________________________________
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 54) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
The error occurred in C:\domains\ticketzonebooking.co.uk\wwwroot\shop\act_enterDetails.cfm: line 133
Called from C:\domains\ticketzonebooking.co.uk\wwwroot\shop\act_enterDetails.cfm: line 7
Called from C:\domains\ticketzonebooking.co.uk\wwwroot\shop\act_enterDetails.cfm: line 1
Called from C:\domains\ticketzonebooking.co.uk\wwwroot\shop\index.cfm: line 80
Called from C:\domains\ticketzonebooking.co.uk\wwwroot\index.cfm: line 15
Called from C:\domains\ticketzonebooking.co.uk\wwwroot\shop\act_enterDetails.cfm: line 133
Called from C:\domains\ticketzonebooking.co.uk\wwwroot\shop\act_enterDetails.cfm: line 7
Called from C:\domains\ticketzonebooking.co.uk\wwwroot\shop\act_enterDetails.cfm: line 1
Called from C:\domains\ticketzonebooking.co.uk\wwwroot\shop\index.cfm: line 80
Called from C:\domains\ticketzonebooking.co.uk\wwwroot\index.cfm: line 15
131 : FROM tbl_Bookings
132 : WHERE int_showID = #form.int_ShowID#
133 : AND str_Token = '#Request.Session.URLToken#'
134 : AND DATEDIFF(hh,dtm_DateBookingMade, GETDATE()) <= 4
135 : </cfquery>
SQLSTATE 40001
SQL SELECT MAX(int_BookingID) AS sessionBookingID FROM tbl_Bookings WHERE int_showID = 7259 AND str_Token = 'CFID=401916&CFTOKEN=a5841e2b1bd90a36-4867A008-1D09-6AAA-D6689429A24707CB&jsessionid=f0303a9fe3bb89d6b9d2720613b483851605' AND DATEDIFF(hh,dtm_DateBookingMade, GETDATE()) <= 4
VENDORERRORCODE 1205
DATASOURCE TicketZoneNew
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/5.0 (Macintosh; U; Intel Mac OS X 10.4; en-US; rv:1.9.0.10) Gecko/2009042315 Firefox/3.0.10Remote Address
87.***.***.** (that'll be me then?)Referrer
http://www.ticketzonebooking.co.uk/inde ... dsID=12683Date/Time 16-May-09 10:42 AM
Stack Trace
at cfact_enterDetails2ecfm2090089154._factor13(C:\domains\ticketzonebooking.co.uk\wwwroot\shop\act_enterDetails.cfm:133) at cfact_enterDetails2ecfm2090089154._factor15(C:\domains\ticketzonebooking.co.uk\wwwroot\shop\act_enterDetails.cfm:7) at cfact_enterDetails2ecfm2090089154.runPage(C:\domains\ticketzonebooking.co.uk\wwwroot\shop\act_enterDetails.cfm:1) at cfindex2ecfm437020543.runPage(C:\domains\ticketzonebooking.co.uk\wwwroot\shop\index.cfm:80) at cfindex2ecfm1689562905.runPage(C:\domains\ticketzonebooking.co.uk\wwwroot\index.cfm:15) at cfact_enterDetails2ecfm2090089154._factor13(C:\domains\ticketzonebooking.co.uk\wwwroot\shop\act_enterDetails.cfm:133) at cfact_enterDetails2ecfm2090089154._factor15(C:\domains\ticketzonebooking.co.uk\wwwroot\shop\act_enterDetails.cfm:7) at cfact_enterDetails2ecfm2090089154.runPage(C:\domains\ticketzonebooking.co.uk\wwwroot\shop\act_enterDetails.cfm:1) at cfindex2ecfm437020543.runPage(C:\domains\ticketzonebooking.co.uk\wwwroot\shop\index.cfm:80) at cfindex2ecfm1689562905.runPage(C:\domains\ticketzonebooking.co.uk\wwwroot\index.cfm:15)
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 54) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at macromedia.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at macromedia.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source)
at macromedia.jdbc.base.BaseStatement.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
at coldfusion.sql.Executive.executeQuery(Executive.java:1192)
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 cfact_enterDetails2ecfm2090089154._factor13(C:\domains\ticketzonebooking.co.uk\wwwroot\shop\act_enterDetails.cfm:133)
at cfact_enterDetails2ecfm2090089154._factor15(C:\domains\ticketzonebooking.co.uk\wwwroot\shop\act_enterDetails.cfm:7)
at cfact_enterDetails2ecfm2090089154.runPage(C:\domains\ticketzonebooking.co.uk\wwwroot\shop\act_enterDetails.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644)
at cfindex2ecfm437020543.runPage(C:\domains\ticketzonebooking.co.uk\wwwroot\shop\index.cfm:80)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644)
at cfindex2ecfm1689562905.runPage(C:\domains\ticketzonebooking.co.uk\wwwroot\index.cfm:15)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366)
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.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74)
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: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:284)
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)
________________________________________________________________________________________________