Stewart Gilray Posted August 31, 2006 Share Posted August 31, 2006 I run two stores for different clients, both sites are setup in pretty much the exact same way, however on one of them, we get an interesting problem... Thing is it doesn't happen 99.9% of the time. In a year when we've had around 5000 orders it's happened no more than 10 times. Basically... The SHOWN customer details are wrong and do not match the order, however... 1. The Shipping Address is Correct 2. The Billing Address is Correct 3. The Card details are Correct 4. When searching for the customer in the customer list, the name IS that used in the shipping and billing details. 5. If I use the name listed in the Customer details as seen in the below image, there is NO customer of that name. 6. In the order list, it's under that of the details listed in the Customer info (as seen below). 7. The order confirm email is sent to the person listed in the Customer info as below. 8. No email is sent to the REAL customer. It's driving me crackers, as I've NO idea how or why it happens... Any ideas please. Link to comment Share on other sites More sharing options...
Gazonice Posted August 31, 2006 Share Posted August 31, 2006 Hello, Did you resolve this issue? because I have a client who has experienced the exact same problems. Thanks, Garry Garry Link to comment Share on other sites More sharing options...
Stewart Gilray Posted August 31, 2006 Author Share Posted August 31, 2006 Not resolved it yet... I'm literally comparing and merging OSCommerce codebase... Link to comment Share on other sites More sharing options...
Stewart Gilray Posted September 1, 2006 Author Share Posted September 1, 2006 BUMPING Sorry about doing this, but I need help with this issue. someone else must know what the problem is? Link to comment Share on other sites More sharing options...
MSP Posted September 1, 2006 Share Posted September 1, 2006 had this exact same problem today for the first time Link to comment Share on other sites More sharing options...
Stewart Gilray Posted September 1, 2006 Author Share Posted September 1, 2006 Ok, so I'm hoping it's a system wide error and stuff... I think it's related to sessions and that sort of thing. Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted September 1, 2006 Share Posted September 1, 2006 check if session storage has been set to database, if not, do that your spiders are set to false for session allowed? is it always the same person reused or random clients (maybe one that has just bought something rright before?) probably a good idea to turn caching off also, if it still happens with sessions in the database. :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... Link to comment Share on other sites More sharing options...
msrichard Posted September 14, 2006 Share Posted September 14, 2006 check if session storage has been set to database, if not, do that your spiders are set to false for session allowed? is it always the same person reused or random clients (maybe one that has just bought something rright before?) probably a good idea to turn caching off also, if it still happens with sessions in the database. I am having the same problem all of a sudden. The only difference is I'm getting a lot of traffic now due to a new product. Forgive my ignorance, but I'm not sure where to change the things you suggested. The following is what I have set in sessions session directory /tmp force cookie use false check ssl session id false check user agent false check IP address false prevent spider sessions true recreate session false Is one or more of these wrong or am I looking totally in the wrong place? Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted September 14, 2006 Share Posted September 14, 2006 Marla, this spot is done correctly. Noch check cache and you catalog config file for the mysql entry for sessions. Have you by chance added a hardcoded link to your new product somewhere? If it had the session ID, that would cause issues :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... Link to comment Share on other sites More sharing options...
Stewart Gilray Posted September 15, 2006 Author Share Posted September 15, 2006 That sessionid appears to be the cause at my end. It seems some over sealous sales person at the clients, has been pasting a FULL URL with sessionID as well... Thanks for the heads up. Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted September 15, 2006 Share Posted September 15, 2006 good to hear. if your cookie settings are done correctly in the config file, your session id should disappear from the url after a few clicks on your site --- makes for less copying mistakes ;-) :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... Link to comment Share on other sites More sharing options...
Stewart Gilray Posted September 15, 2006 Author Share Posted September 15, 2006 You mentioned above about database and session storage. I can't actually find an option for this in admin, is that where it is located? Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted September 15, 2006 Share Posted September 15, 2006 the information is set in your configure.php files (includes folders) - called session storage, needs to be set to "mysql" :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... Link to comment Share on other sites More sharing options...
msrichard Posted September 18, 2006 Share Posted September 18, 2006 Marla, this spot is done correctly. Noch check cache and you catalog config file for the mysql entry for sessions. Have you by chance added a hardcoded link to your new product somewhere? If it had the session ID, that would cause issues Monika, I changed 'store session' to mysql in both config files and I thought that solved the problem but it happened again today. I also made sure that cache was set to false under admin. It was already set that way. I do not have a hardcoded link to my product. Somebody out there has been telling alot of people about my site and posted a link to it from their site. I just checked and the link has a oscid on it. Could this be the problem and how would it I fix it other than telling every one that has a link to remove that from the link. Thanks, Marla Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted September 18, 2006 Share Posted September 18, 2006 Marla, yes that could cause it. All external links with session ids are a problem. Did you apply the latest patches so the tell a friend email does not have the oscID? :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... Link to comment Share on other sites More sharing options...
msrichard Posted September 18, 2006 Share Posted September 18, 2006 Marla, yes that could cause it. All external links with session ids are a problem. Did you apply the latest patches so the tell a friend email does not have the oscID? No, I didn't do the patches yet. Will that also fix it so that if the user just clicks to make it a favorite it won't keep the id in the link? I will install the patches in the mean time. Thanks, Marla Link to comment Share on other sites More sharing options...
exbabylon Posted September 18, 2006 Share Posted September 18, 2006 I have a client that's experiencing the same problem. After doing extensive research I've found that the orders/clients that are getting "mixed up" are orders places right next to each other i.e. 418 and 419 - The user_id's get mixed up. That's why the correct billing/address information shows up, but the customer information is wrong. This is also the reason why the right customer receives an email with an order they did not make, and the right customer doesn't. I have examples and proof of this situation, and it has nothing to do with links containing session ids... this happened on two customers who live a world apart, and shop at the store all the time. Does ANYONE know what's causing this to happen?? Link to comment Share on other sites More sharing options...
msrichard Posted September 19, 2006 Share Posted September 19, 2006 good to hear. if your cookie settings are done correctly in the config file, your session id should disappear from the url after a few clicks on your site --- makes for less copying mistakes ;-) Monika, How should my cookie settings be set in my config file so the session id disappears? Marla Link to comment Share on other sites More sharing options...
exbabylon Posted September 19, 2006 Share Posted September 19, 2006 I was just wondering something... the only client I have who is having this problem is on a PHP5 server. I would be interested to hear if those of you who are experiencing this problem are also on PHP5. Thanks! Link to comment Share on other sites More sharing options...
Gazonice Posted September 19, 2006 Share Posted September 19, 2006 I was just wondering something... the only client I have who is having this problem is on a PHP5 server. I would be interested to hear if those of you who are experiencing this problem are also on PHP5. Hi, My client who has had this almost identical problem is on PHP 4.4.4 with MySQL 4.2.21. In fact all my clients are on the same server (same versions) but only one has had this problem. I guess we can eliminate that, maybe? Garry Garry Link to comment Share on other sites More sharing options...
exbabylon Posted September 19, 2006 Share Posted September 19, 2006 Hopefully... The client that's having the problem, are the orders that are getting mixed up very close to each other in #? Link to comment Share on other sites More sharing options...
exbabylon Posted September 19, 2006 Share Posted September 19, 2006 Near as I can tell, the global session data for customer_id is getting mixed up somewhere along the line.... most likely in order.php. The more I research this the more confusing it is... Link to comment Share on other sites More sharing options...
Gazonice Posted September 19, 2006 Share Posted September 19, 2006 Hi, My clients orders were seven numbers apart from each other. Just like with your client, one customer placed the order but another, already existing customer, got the delivery address and emails. Garry Garry Link to comment Share on other sites More sharing options...
MSP Posted September 19, 2006 Share Posted September 19, 2006 I'm on PHP 4.4.2 and MySQL version 4.1.21-standard I saw a problem once on another forum where 2 people tried to post at the exact same time and their usernames and messages got mixed up, I always wondered if that might have something to do with this problem Link to comment Share on other sites More sharing options...
baronmunchowsen Posted September 20, 2006 Share Posted September 20, 2006 I've had this problem today too. Customer A has a customer profile, but did not buy anything. Customer B does not have a customer profile, somehow managed to buy something, and customer A received the confirmation email. Under 'orders' SOLD TO / CUSTOMER is customer A, SHIP TO AND BILLING ADDRESS is customer B. It looks as if customer A placed the order, and set the billing address to customer B. (They have never met!!!) I can see no way that they would have recieved a link to the store with a sessionID in it. 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.