Someone using my blog has reported that posting a comment crashes his
MySQL server.
When you post a comment, you get the following error, which I'm unable
to duplicate myself, but it occurs every time on his setup, which is
Coldfusion MX 6.1 (I think) on Windows with MySQL 4.0.x (current)
running on the same box. Subsequent requests result in a "Mysql not
found.." error, because mysql crashed.
The error message is followed by the actual query....
----------------------------------------------------------------------
Error Message
----------------------------------------------------------------------
Communication link failure: java.net.SocketException
The error occurred in D:\home\sites\ctsix.org\wwwroot\cfcs\blogcfm.cfc:
line 967
Called from D:\home\sites\ctsix.org\wwwroot\entry.cfm: line 54
Called from D:\home\sites\ctsix.org\wwwroot\entry.cfm: line 9
Called from D:\home\sites\ctsix.org\wwwroot\entry.cfm: line 1
Called from D:\home\sites\ctsix.org\wwwroot\1\2005\05\A-Bug.cfm: line 2
Called from D:\home\sites\ctsix.org\wwwroot\cfcs\blogcfm.cfc: line 967
Called from D:\home\sites\ctsix.org\wwwroot\entry.cfm: line 54
Called from D:\home\sites\ctsix.org\wwwroot\entry.cfm: line 9
Called from D:\home\sites\ctsix.org\wwwroot\entry.cfm: line 1
Called from D:\home\sites\ctsix.org\wwwroot\1\2005\05\A-Bug.cfm: line 2
965 : #CreateODBCDateTime(Now())#,
966 : <cfqueryparam cfsqltype="cf_sql_char"
value="#arguments.details.IP#">,
967 : <cfqueryparam cfsqltype="cf_sql_longvarchar"
value="#arguments.details.COMMENT_TEXT#">
968 : )
969 : </cfquery>
--------------------------------------------------------------------------------
ERROR MESSAGE
--------------------------------------------------------------------------------
SQL INSERT INTO BLOG_COMMENTS ( BLOG_ID, ENTRY_ID, COMMENT_ID,
USER_ID, UNAME, EMAIL, WEBSITE, ENTRY_DATE, IP, COMMENT_TEXT ) VALUES (
(param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) ,
(param 7) , {ts '2005-06-01 14:40:38'}, (param 8) , (param 9) )
DATASOURCE ctsix_data
SQLSTATE 08S01
--------------------------------------------------------------------------------
ACTUAL QUERY CODE
--------------------------------------------------------------------------------
<cfquery name="qry" datasource="#this.primarydb#">
INSERT INTO BLOG_COMMENTS
(
BLOG_ID,
ENTRY_ID,
COMMENT_ID,
USER_ID,
UNAME,
EMAIL,
WEBSITE,
ENTRY_DATE,
IP,
COMMENT_TEXT
) VALUES (
<cfqueryparam cfsqltype="cf_sql_char" value="#arguments.BLOG_ID#">,
<cfqueryparam cfsqltype="cf_sql_char"
value="#arguments.details.ENTRY_ID#">,
<cfqueryparam cfsqltype="cf_sql_integer" value="#retVal.COMMENT_ID#">,
<cfqueryparam cfsqltype="cf_sql_char"
value="#arguments.details.USER_ID#">,
<cfqueryparam cfsqltype="cf_sql_varchar"
value="#arguments.details.UNAME#">,
<cfqueryparam cfsqltype="cf_sql_varchar"
value="#arguments.details.EMAIL#">,
<cfqueryparam cfsqltype="cf_sql_varchar"
value="#arguments.details.WEBSITE#">,
#CreateODBCDateTime(Now())#,
<cfqueryparam cfsqltype="cf_sql_char" value="#arguments.details.IP#">,
<cfqueryparam cfsqltype="cf_sql_longvarchar"
value="#arguments.details.COMMENT_TEXT#">
)
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208274
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
