Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Cannot create a row of size 8079 which is greater than the allowable maximum row size of 8060.
|
|
The error occurred in C:/home/eastcoastleisure.com/config/triggers.cfm: line 913
Called from C:/home/eastcoastleisure.com/config/triggers.cfm: line 1
Called from C:/home/eastcoastleisure.com/config/footer1.cfm: line 28
Called from C:/home/eastcoastleisure.com/custom/HotTubCover/index.cfm: line 226
Called from C:/home/eastcoastleisure.com/config/triggers.cfm: line 913
Called from C:/home/eastcoastleisure.com/config/triggers.cfm: line 1
Called from C:/home/eastcoastleisure.com/config/footer1.cfm: line 28
Called from C:/home/eastcoastleisure.com/custom/HotTubCover/index.cfm: line 226
|
911 : update EM_SR_Bookings
912 : set ccn = 'xxxx xxxx xxxx xxxx'
913 : where (DATEDIFF(day, bookingdate, <CFQUERYPARAM Value="#CreateODBCDateTime(now())#" cfsqltype="CF_SQL_TIMESTAMP">) > 5)
914 : </cfquery>
915 : <cfquery datasource="#dbdatasource#" username="#dbusername#" password="#dbpassword#">
|
|
SQLSTATE |
HY000 |
EXCEPTIONS |
<small><i>not set</i></small> |
DATASOURCE |
eastcoastleisurecom08 |
VENDORERRORCODE |
511 |
SQL |
update EM_SR_Bookings
set ccn = 'xxxx xxxx xxxx xxxx'
where (DATEDIFF(day, bookingdate, (param 1) ) > 5) |
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
18.189.193.134 |
Referrer |
|
Date/Time |
27-Jul-24 11:30 AM |
|