blank address gets added to database for user.

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
schoenbr
Ensign (ENS)
Ensign (ENS)
Posts: 3
Joined: Mon Jul 20, 2009 7:56 pm

blank address gets added to database for user.

Post by schoenbr » Mon Jul 20, 2009 8:26 pm

Hello all,

I have been testing site functionality and am running into some issues with users logging back into my development site to place an order and they see a blank shipping address along with there correct shipping address they entered when they created the account. This blank address has gotten into the system and is now the primary address for that user. I look in the ac_addresses table and there is now a record with all Nulls for that user id and the address id is now the primary address id on the user record in the ac_Users table.

I am running VERSION: 7.0.2, BUILD: 11659 on the asp.net platform.

I am new to able commerce and have not changed any code. The only changes that I have been making are to look and feel, mainly the css files in my new theme. I did make changes so that the one page check out is not used as we want to have a shopping cart with a check out progress bar. However I have tested this with both checkout options and both ways run into this same issue.

Any help would be great. Thanks.

Roy

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: blank address gets added to database for user.

Post by mazhar » Tue Jul 21, 2009 3:39 am

I am not clear, I haven't seen any thing like this on 7.0.2. Could you post some screen shot to clear your point?

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: blank address gets added to database for user.

Post by jmestep » Tue Jul 21, 2009 6:29 am

Do the users' names show? In demo mode, they say DEMO,DEMO
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

schoenbr
Ensign (ENS)
Ensign (ENS)
Posts: 3
Joined: Mon Jul 20, 2009 7:56 pm

Re: blank address gets added to database for user.

Post by schoenbr » Tue Jul 21, 2009 7:28 am

The site is running a development License. The only users in the database are the ones we have created for testing purposes.

So step by step.
1. Add product to the cart.
2. goto cart.
3 Select Checkout
4. This brings you to the login page. We login in with a user account that was setup with a default billing/shipping address created at an earlier time.
Image
5. Login with user account which brings edit shipping address page for this user.
Image

The address book page now has a blank address for the billing address and a blank entry for the shipping address.
Image

To fix the problem, I have to delete the bad address that somehow gets created with all Nulls from the ac_Addresses table. Everything starts working normal again but after some time this problem happens again.

Roy

User avatar
Logan Rhodehamel
Developer
Developer
Posts: 4116
Joined: Wed Dec 10, 2003 5:26 pm

Re: blank address gets added to database for user.

Post by Logan Rhodehamel » Tue Jul 21, 2009 8:34 am

schoenbr wrote:We login in with a user account that was setup with a default billing/shipping address created at an earlier time.
Give details on how the user account is created. This is where the problem is occurring, I am almost certain.

EDIT: I should say this is where the root cause of the problem is... but probably not where the blank address is created.
Cheers,
Logan
Image.com

If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.

schoenbr
Ensign (ENS)
Ensign (ENS)
Posts: 3
Joined: Mon Jul 20, 2009 7:56 pm

Re: blank address gets added to database for user.

Post by schoenbr » Tue Jul 21, 2009 8:59 am

The user account was created from the Checkout page (Checkout/Default.aspx) where you are given the returning customer & new customer option. When you click the new customer option you create an account along with supplying the billing address and have the option to select the billing address as the default shipping address. The problem has never occured for new users. The problem occurs only when we simulate a user returning to the site to make another purchase.

Post Reply