Need Advanced Help/Opinions

[rotaour]

I have a problem that has occurred on 3-4 orders out of approx. 10,660 orders total. On two occassions credit card info(cc_name, cc_number, cc_cvv, cc_expire) was partial or missing from the database altogether.

 

On one other occasion the ot_shipping info was written partially into the orders_total table, it wrote;

 

"u:"

 

instead of

 

"United Parcel Service (1 pkg x 1 lbs total) (UPS Ground):" and the 'value' field was 0.000 which is the field default which tells me the data was empty altogether.

 

The fourth occasion, if it actually did happen, we dont remember what was screwed up. We cant find a record of it, but I think there was a fourth order with partial info written to the DB.

 

I do not believe this is a code error, because there would be many more messed up orders out of over 10,660 than the 3-4 we have had problems with. In addtition I know that the field validation would have caught any credit card fields improperly filled out. The ot_shipping is generated by an object so its a bit different, but its only happened once.

 

I talked to our LAMP admin upon the last instance of this problem and asked to check the mysql error log, he said there was nothing there to indicate a problem. He said "Normally if the MySQL server encounters an error it will log it to the servers MySQL .err log." Does that mean that in an abnormal situation an error will occur and not write it to the mysql.err log?

 

I'd guess that this is caused by a memory error or customers simply letting an order sit long enough for some of the $_POST variables or other info in memory to get destroyed before confirming the order.

 

Anyone have any insight or suggestion on how to figure this out? I know its not a huge problem, 3-4 orders out of over 10,660, but its driving me nuts and our admin is copping out and blaming the software, I say BS! What do you say?

 

TIA

Matt

[rotaour]

I should have explored this a little more before I posted and our fullfillment dept. should have kept me better informed.

 

It turns out that we have 63 orders with the credit card info cc_type, cc_owner, cc_number, cc_cvv and cc_expires missing or NULL. One order has a partial cc_num and no other cc info.

 

Thats a bit more than 3 to 4, but not a huge amount at 64 out of our current 10,731 orders.

 

The problem with the ot_shipping field in the orders_total table has occured only once.

 

Anyone have any ideas?

 

TIA

[jdvb]

is your server local? (i.e. same as apache server)

I wonder what happens when the mysql server gives a timeout on inserting data... is that handled properly?

I have not had any of such occurences, but then have not yet reached that amount of orders yet, (only just started getting more serious).

[rotaour]

is your server local? (i.e. same as apache server)

 

Yes, we have a dedicated server handling only our online stores.

 

I wonder what happens when the mysql server gives a timeout on inserting data... is that handled properly?

 

I dont know how that works, I'd guess it would be logged but dont know where.

 

I have not had any of such occurences, but then have not yet reached that amount of orders yet, (only just started getting more serious).

 

This problem has occurred every since our stores went live around 15 months ago. It seems to be happening less over the last several months than it did earlier though.

 

We take care of production and distribution for several NGO's which is why we have that volume of orders. When I started working here we had a custom cart scripted in Coldfusion which cost them probably $13K over the 2 1/2 years it was deployed. What a rip especially knowing CF is headed nowhere. It didnt work very well so I decided to go open source and Osc was it.

[rotaour]

We've had two orders since I originally posted this topic that were missing credit card info and I've finally gotten our fullfillment dept. to ask questions when calling these customers.

 

The first one said the confirmation process timed out 4 or 5 times before it went through. They didnt ask what service the user was using, but hopefully I've got them trained to ask that too now.

 

The second customer said everything went smooth, no timeouts and he did not let the order sit before confirming. He was using Earthlink.

 

Anyone? Is this a server memory issue?