Mysterious Loss of data

FatStratCat

I have a remote hosted MySQL database, using a php built order form on line, with customer protected access. Recently a customer inquired about an order, but we have no record of it in the database, and on the day they ordered it there is no sequential break in the order numbers, not even from the day before or after. However, the customer faxed over a copy of the order confirmation that shows it was ordered.

My questions.

With a username/password protected login PHP form, are logs kept that show access to the order form and is it possible to show a link between logins and orders actually placed (time stamped data entered into the database)?
Has anyone ever heard of something like this occurring with a MySQL database and an online php order form, and how could I best track down what actually happened? It was over a month ago.

In three years it never happened before.

bogu

Maybe there was an mysql insert error after the order come from payment process ...

What do u mean by:

With a username/password protected login PHP form, are logs kept that show access to the order form and is it possible to show a link between login and orders actually placed (time stamped data entered into the database)?

this is you authentication lib so u should know more about it, do u logged your access on the site?

Has anyone ever heard of something like this occurring with a MySQL database and an online php order form, and how could I best track down what actually happened? It was over a month ago.

How do u think that mysql and online php order form are linked together? u should ask your coder about that problem ...

In three years it never happened before.

I'll give u an idea about your problem and where to look for it:
1. check for payment responce to your script...
2. check your mysql insert after paymen ok, and check for field like address where it could be something like ex. My "Home" it's there (use of simple quote or double quote) that's where it could give you an error ...

FatStratCat

Maybe there was an mysql insert error after the order come from payment process ...

What do u mean by:

With a username/password protected login PHP form, are logs kept that show access to the order form and is it possible to show a link between login and orders actually placed (time stamped data entered into the database)?

I have a remote hosted DB server. Customers log in to the order form. Every customer has a unique usr/PWD. I am in contact with the provider to see if can provide me with an access log for that day, to see who logged in and when.

this is you authentication lib so u should know more about it, do u logged your access on the site?

All of that is handled by the remote host, and they've told me the logs are not generally accessible by users. I am trying to get to them.

Has anyone ever heard of something like this occurring with a MySQL database and an online php order form, and how could I best track down what actually happened? It was over a month ago.

How do u think that mysql and online php order form are linked together? u should ask your coder about that problem ...

The coder is no longer around, I can't find him, anyway. The mySQL and PHP order form are linked together, because the form the customers use to enter data is a php form, and the entered data goes into the Mysql database.

In three years it never happened before.

I'll give u an idea about your problem and where to look for it:
1. check for payment responce to your script...
2. check your mysql insert after paymen ok, and check for field like address where it could be something like ex. My "Home" it's there (use of simple quote or double quote) that's where it could give you an error ...

The payment portion of the order is not linked up. There is an "Order Confirm" Page that is generated when the submit button is hit.

The problem here is that the customer has faxed over to me a copy of the actual order they placed ( they can print out a copy for their records), however that data is NOT in the database. I was hoping to see in a log file what time they logged in, to see if there is some kind of trail I can follow and see if there was an error of some type that caused this to occur.