Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

osCommerce mixing customer and billing addresses

Posted on 2010-09-16
9
Medium Priority
?
391 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 

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
 

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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Original post  on Monitis Blog. Web performance monitoring is broken into two camps: passive and active. Passive monitoring is defined as looking at real-world historical performance by monitoring actual log-ins, site hits, clicks, requests for …
The online market is growing at an unprecedented rate and retail eCommerce sales are expected to reach $4 trillion by 2020. Yet, the profit is not just there for the taking because you have to set yourself apart from the competition.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

661 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