Scott Sanzenblogger
Erratic Mess

MySQL Database Dropping Records

June 10, 2008 09:21 by Scott
Here's another issue!  Ha ha.  So I have an app that's got a MySQL Database back-end.  There is a table that has certain categories that has records being periodically dropped.  I have a page for adding and removing these categories, which is the only place I see a delete statement regarding that table.  It's an old app, so I've built the add/remove logic into the querystring.  I'm thinking they may be going to a version of the page that's stored in their history rather than directly to the page, sans querystring.  This might be the issue.  However, I also don't think the categories have changed in the few years or so since they've had the app, so I can't see why this would be in the history of their web browser.  Can anybody at all see any reason records would just be dropped from the table without human intervention?  The only reasons I can think are the aforementioned querystring issue or someone coming in and manually deleting them.  Unfortunately, the latter sounds like a better possibility.

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Tags: , , ,
Categories:
Actions: E-mail | Permalink | Comments (2) | Comment RSSRSS comment feed

Related posts

Comments

June 10. 2008 10:00

Ryan

If it's a querystring, can you make it POST only to delete -- this would let you see which of the two options is causing it.

Ryan

June 10. 2008 18:18

Sarah

Is this post in French?

Sarah

Add comment


(Will show your Gravatar icon)  

  Country flag

[b][/b] - [i][/i] - [u][/u]- [quote][/quote]



Live preview

November 23. 2008 08:43