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 derfloh 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
Joined
Jan 10, 2006
Messages
240
Location
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