Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MySQL Table Goes Read Only All Of a Sudden

Status
Not open for further replies.

3dColor

Programmer
Jan 10, 2006
240
US
Just one of my tables went read only about an hour ago and created problems.

I couldn't figure out what was wrong so I rebooted my server and then it started working again.

Here is the code that writes to the table Stats, do I need a CFLock around the query to prevent this?

Code:
<cfquery name="InsertStat" datasource="#DSN#">
  INSERT INTO Stats (listingFk,			ipAddress_stats)
VALUES 	(<cfqueryparam value=#URL.ad# cfsqltype="cf_sql_integer"/>,						<cfqueryparam value=#REMOTE_ADDR# cfsqltype="cf_sql_varchar"/>)
</cfquery>

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top