mac64 Posted February 11, 2003 Share Posted February 11, 2003 Hi All, I'm having a problem with a live store. The credit card number and credit card owner are not being saved into the database for only some of the orders. I would say 1 out of 10 are missing credit card info. The Credit card type, and Expiration Date are saved, but not the CC Number or CC name. I can't seem to figure out where the problem is. The store is using a 2.2 Snapshot from June 2002. I thought it was maybe just 1 or 2 peoples computers, but it seems to be happening more latly. Anyone else experience this type of thing? Any help on this is much appreciated. Thanks! Link to comment Share on other sites More sharing options...
Gisele Posted February 11, 2003 Share Posted February 11, 2003 It's happending to me as well. out of 50 orders, 4 didn't capture the credit card number, yet the customer insists that they entered it. any ideas? Link to comment Share on other sites More sharing options...
mac64 Posted February 12, 2003 Author Share Posted February 12, 2003 I have had this occur 2 different times. The first was if Javascript was turned off, it would not save the CC Number. I added some code to the checkup process so that it kept the credit card info regardless of Javascript. However, I do not think that is the main problem, since it is occuring again. I can't find anything in the code that is making it mess up. Link to comment Share on other sites More sharing options...
Synjen Posted April 22, 2003 Share Posted April 22, 2003 Anyone have any luck solving this? I am encountering the same issue. Quite a strange bug. Link to comment Share on other sites More sharing options...
alonsoac Posted April 26, 2003 Share Posted April 26, 2003 I have the same problem. I told the customer to enter the order again. He did and once again there are no credit card details. So this is something on the client side. ---------------- Alonso Acu�a Founder and Lead Programmer Link to comment Share on other sites More sharing options...
mbiddlecombe Posted May 29, 2003 Share Posted May 29, 2003 Any progress on this yet. I am finding the same problem as well, although it is more like 99% of transactions failing to store cc data. I am hoping to go live soon as well, and cannot with this bug still there. Link to comment Share on other sites More sharing options...
obi Posted December 10, 2003 Share Posted December 10, 2003 Hi Having the same problem. I'm stiill searching for a solution. Any word yet? Thanks. Link to comment Share on other sites More sharing options...
mhart Posted June 11, 2005 Share Posted June 11, 2005 Hi, I was having EXACTLY this problem, and let me tell you how it started... My store was running just fine on a shared server, when a friend offered free use and admin rights over a pretty-much totally unused server in a London datacentre. Naturally, I snatched at my friends offer, and migrated my site, and it was THEN that this problem - exactly as others have described here - started to show itself! I was losing the CC info for about one order in ten, and remember that NONE of the code had been changed in the migration, so this would explain why people can't find a way for the code to cause this. OK, you've read so far, so what was it? Answer - It was the server memory that was causing the problem. Most webservers have service monitors with restart facilities working in the background, so often a problem will not be noticed. In my case, everything else on the site, and other small sites on the same server, were working fine, including one other that was using MySQL. Hardware was swapped out - no more problem! - Mike Hart Link to comment Share on other sites More sharing options...
Guest Posted June 23, 2005 Share Posted June 23, 2005 Better i should not start anything with credit cards, looks like ppl having problems :( :( Link to comment Share on other sites More sharing options...
mhart Posted June 27, 2005 Share Posted June 27, 2005 Hardware was swapped out - no more problem! - Mike Hart <{POST_SNAPBACK}> Well, it looks like I spoke too soon! A hundred and fifty orders went through just fine, and then a couple of glitches! I've now rebuilt Apache, and am waiting to see if that has made any improvement. 25 orders and counting OK - I'll let you know the results. Regards, - Mike Link to comment Share on other sites More sharing options...
mhart Posted June 27, 2005 Share Posted June 27, 2005 The 'Edit' button seems to have disappeared, so I'll simply post my edited version! Hardware was swapped out - no more problem! - Mike Hart <{POST_SNAPBACK}> Well, it looks like I spoke too soon! A hundred and fifty orders went through just fine, and then a couple of glitches! I've now rebuilt Apache, and am waiting to see if that has made any improvement. 25 orders and counting OK - I'll let you know the results. If I could just make a couple more comments on this... Firstly, a previous poster has said that this looks like client-side. I'm not so sure about this, and think it is server side. There are many people who simply do not get this problem, and all our installs are being accessed from the same worldwide 'pool' of browsers. If some sites get this problem, and some sites don't, then it must be server side. Next, whilst it is clear that no-one has a solution/fix to this, does anyone have a workaround? One possible workaround is to journal/append all the details to a file as soon as they are input. Not ideal I know, but it would quickly show if the problem was being caused by a MySQL glitch, as [stating th obvious] writing out to a file does not involve MySQL. Regards, - Mike Link to comment Share on other sites More sharing options...
mhart Posted June 27, 2005 Share Posted June 27, 2005 A bit more information for anyone in a position to help... I had another order fail today - AFTER Apache has been recompiled, so i don't think that fault lies there. It certainly not server load, as my server is pretty much twiddling its thumbs most of the time. Perhaps i sould mention that I'm using the CRE Loaded version of OSC - but I don't see how this could make a difference. I do desperately need a solution or workaround to this problem, as I'm having to email customers asking them to re-input their orders, and i just KNOW I'm going to lose sales! Regards,- Mike Link to comment Share on other sites More sharing options...
danalamas Posted July 5, 2005 Share Posted July 5, 2005 Hello All: OK, from what I have seen, my database does not save any cc info at all, but all transactions are going through - meaning cards are authorized and I am paid. Now for the strange part, my database used to hold cc info for the first few orders, but now it holds nothing for any orders. I.E. Older orders cc info was wiped out. No idea why this happened, but I think it could be caused by one of two things - using the database backup function or adding a contribution. I have added about 6 contributions to my site - all work properly - but maybe one is defective in some way. I have also used the database backup function on the admin side, but I only save the two most recent backups which don't go back far enough to see if cc info got wiped out from the backup process or not. Does anyone out there have an old backup that might show some orders with cc info that have since been wiped out? Thanks Dana Link to comment Share on other sites More sharing options...
montytx Posted September 9, 2005 Share Posted September 9, 2005 So has anyone come across a solution for this. I have 3 stores running and none of them retain CC data. Link to comment Share on other sites More sharing options...
KHagar Posted March 13, 2006 Share Posted March 13, 2006 I've been using the same barely-modified version of OSComm for 2 years now with little to no problems... and just started having this problem of no credit card info being stored in database. I deleted the customer/info and had them resubmit their order. STILL no CC info stored on this particular customer. All other orders have been fine. Just this customer is having a problem. She actually submitted a succesful order a few months ago, but couldn't log back in to her account so she created a new account. Could it be that the database won't accept duplicate credit card numbers? Has anyone had any revelations? Link to comment Share on other sites More sharing options...
bigdeals Posted March 15, 2006 Share Posted March 15, 2006 Where would the CC numbers be stored? Link to comment Share on other sites More sharing options...
Guest Posted September 8, 2006 Share Posted September 8, 2006 The probelem may be due to this IE bug: http://support.microsoft.com/?kbid=831167 There is a discussion on this topic here: http://www.oscommerce.com/forums/index.php?sho...=75316&st=0 There is no consensus, but the best advice seems to be adding the following to your server httpd.conf file. Some people who are on shared servers found their hosting companies to be receptive to making this change for them: SetEnvIf User-Agent ".*MSIE.*" nokeepalive ssl-unclean-shutdown downgrade-1.0 force-response-1.0 If you can't get anyone to edit the httpd.conf file, it might also work to add the following to your .htaccess file: <IfModule mod_setenvif.c> <IfDefine SSL> SetEnvIf User-Agent ".*MSIE.*" nokeepalive ssl-unclean-shutdown downgrade-1.0 force-response-1.0 </IfDefine> </IfModule> I am having this problem myself and I'll write back if the httpd.conf solution helps me. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.