Mailing List Archive


Back to the month index Back to the list index
Jeff Ober (jro@protocorp.com)
Tue, 25 Nov 1997 08:13:49 -0500 

Message-ID: <01BCF97A.132BDFA0@dragon.protocorp.com>
From: Jeff Ober <jro@protocorp.com>
Subject: Data Inconsistencies
Date: Tue, 25 Nov 1997 08:13:49 -0500

I've been lurking on this list for a number of weeks, and I may be out of my league here, but I haven't seen anything related to my problem.

My web provider is running Linux OS, Apache HTTPD server, with Msql access. I'm using the Msql database through PHP/FI. (As an aside, I can no longer find any docs related to either PHP or mSQL -- all links I've followed before, including those I've seen here are dead ends).

I can use the database normally, or so it appears. However, at certain times, I cannot narrow down what is happening at the times, data disappears, reappears, or corrupts. For example, in a simple table with 3 fields, one record duplicates itself 10 or 12 times. Large chunks of data disappear: A table will have all records after a specific record suddenly delete. And deleted data reappears: A table that has 4 records, I delete record #3 today, and it will be back tomorrow. This has even happened with entire tables!

Is there something I'm missing on using these tables? Is there some process that I must do to REALLY delete a record from a table (other than DELETE FROM...)? Is there anything I can check on the server end (the ISP claims everything is OK there)? Does anyone have a hint of what I can do to use this database without random changes, losses, and re-creations?

Thanks in advance!