Solved

osCommerce mixing customer and billing addresses

Posted on 2010-09-16
9
374 Views
Last Modified: 2013-12-12
We have a osCommerse webshop which has gone crazy.
Nothing has really changed, but lately it has started to mix customer adresses with billing addresses.
The billing and delivery addresses are correct.
Is this a known bug in osCommerce?
I am sometimes wondering if there is some kind of cache problem which mixup a portion of data.
0
Comment
Question by:johanselin
  • 6
  • 3
9 Comments
 
LVL 4

Expert Comment

by:trippy1976
ID: 33695567
Did you install any add-ons?
0
 

Author Comment

by:johanselin
ID: 33698718
Only a payment module which connects to a local payment service.
The application is standard and I think that problem occurs while registering user information.
0
 
LVL 4

Expert Comment

by:trippy1976
ID: 33703627
First it did not happen.
Now it does.

Does it happen for every user?  If yes, then I don't think it is affecting registering user information only (as your old users are already registered).  If old user data is still correct and new user data is not correct, then you may be right about the registration data being the root cause.

Do you have a test site?  Can you remove the payment module and/or roll back to prior to adding it to see if the problem still presents itself?  If not, then you know it's the payment module.

Where exactly is it mixing addresses?  On the packing slip or in the order view itself?  Everywhere?
0
 

Author Comment

by:johanselin
ID: 33714998
This error occurs for about 50% of all our orders, and the problem is that we can not re-create the failure.
The customer picks the products, create the account and then complet the payment.
When we receive the "order process" notification via email we can see that the Billing and the delivery address is correct, but the customer address in the table [orders] missmatch.
Could osCommerce temporarily store old data from one client used by another client?
Sometimes osCommerce also store wrong data in the table  [customers]
Are there any table which needs to be cleaned up?
The table [customers_info] is empty. This table also gives me an error message as I browse with a db-explorer. "Invalid field name of customers_info_date_of_last_log"
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:johanselin
ID: 33732080
This might give you a hint.
One thing which crossed my mind is that a friend of mine went to the web-shop and as "already logged in" as another user.
He could view customers data.
Can osCommerce share a login session?
0
 

Author Comment

by:johanselin
ID: 33732093
This might give you a hint.
One thing which crossed my mind is that a friend of mine went to the web-shop and as "already logged in" as another user.
He could view customers data.
Can osCommerce share a login session?
0
 
LVL 4

Expert Comment

by:trippy1976
ID: 33735118
Wow.  Not that I'm aware of.  I'd be really concerned about that.  You probably aren't storing CC info on your site, but having users see the address of other users is not good, eh?

So back to the problem at hand.

What payment modules do you have installed?  Do you notice this happening only on one vs. the other.  

How old is your osCommerce install?
0
 

Author Comment

by:johanselin
ID: 33737721
Ok,
1. The payment modules installed are PayPal and DIBS.
2. The installation is about 10 months old.

What is a CC?

Are there any session properties to be set.
Session Directory        = /tmp         
Force Cookie Use       = False       
Check SSL Session ID       = True  (was false yesterday)      
Check User Agent       = True  (was false yesterday)       
Check IP Address       = False       
Prevent Spider Sessions = True       
Recreate Session = True (was false yesterday)

I have desperately change some session settings do solve this.
0
 

Accepted Solution

by:
johanselin earned 0 total points
ID: 33838482
Thanks for the information.
I guess i found the problem.
When i turned on the session properties as above it all seems to work.
I also deleted all data in the session table.

0

Featured Post

Easy Project Management (No User Manual Required)

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now