Thanks all - checking the weblogs was the key - it was a server from another section doing link "checking" ie following every link on every page, and therefore hitting the delete link for each record.
A robots file has been implemented.
What would I do without a brains trust like this group!
regards Susan
At 01:02 PM 26/02/2004, you wrote:
just read the question again... maybe its an internal search engine? isys or something? G ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, February 26, 2004 12:56 PM Subject: [cfaussie] RE: tracking down unusual record deletions
> might be a stupid question, but could it be a search engine that's trawling > the site and just going to the page > > www.mysite.com/deletestaff.cfm?id=20 ??? > > Maybe add this file to the robot.txt file so it is not trawled, and make it > a form rather than a url variable. > > http://www.robotstxt.org/wc/norobots.html > > > > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "CFAussie Mailing List" <[EMAIL PROTECTED]> > Sent: Thursday, February 26, 2004 12:38 PM > Subject: [cfaussie] RE: tracking down unusual record deletions > > > > The query statements are: > > > > <CFQUERY DATASOURCE="Libmag"> > > UPDATE tblMeetings > > SET Active = no > > WHERE tblMeetings.Meet_ID=#URL.id# > > </CFQUERY> > > > > The URL.id comes from the previous page = its a basic display > > a list and select a single item to edit or delete. Thats why its hard > > to think why 20+ records would be deleted this way. > > > > I am trying to track down the server logs to see if there is > > any file activity that will point me in the right direction. Thanks > > for tips! > > > > regards > > susan > > > > > > At 12:23 PM 26/02/2004, you wrote: > > >How exactly is the delete occurring? Did you change a cfquery DELETE to a > > >cfquery UPDATE? If so then clearly this query is being run, right? What > does > > >the WHERE clause look like? > > > > > > > Its possible from within the web pages for staff to delete records > from > > > > these > > > > 2 tables, so I changed this function from being a real delete to > marking > > > > the records inactive. When I did this, the problem changed from the > > > > records being deleted to being marked inactive. > > > > > > > > > > > >--- > > >You are currently subscribed to cfaussie as: > > >[EMAIL PROTECTED] > > >To unsubscribe send a blank email to > [EMAIL PROTECTED] > > > > > >MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > > >http://www.mxdu.com/ + 24-25 February, 2004 > > > > Susan Murray-Smith, Web Services Coordinator > > University of Sydney Library F03 > > University of Sydney NSW 2006 AUSTRALIA > > Ph: (612) 9351 3804 > > Fax: (612) 9351 2890 > > Email: [EMAIL PROTECTED] > > > > > > --- > > You are currently subscribed to cfaussie as: > [EMAIL PROTECTED] > > To unsubscribe send a blank email to > [EMAIL PROTECTED] > > > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > > http://www.mxdu.com/ + 24-25 February, 2004 > > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 >
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
Susan Murray-Smith, Web Services Coordinator University of Sydney Library F03 University of Sydney NSW 2006 AUSTRALIA Ph: (612) 9351 3804 Fax: (612) 9351 2890 Email: [EMAIL PROTECTED]
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
