customer address issue losing my mind!!! SOLVED

I am having a issue which is driving me crazy

it is very weird

when a customer registers their account the address changes to a existing customers address

for example all of my customers now show that one customer

however if i delete that one customer then all of the customers will show the second customer in line

this in turn does not let any of the customers to be able to use their own address

this problem does not occur on guest checkout

what is going on Version 1.5.6.4

What do you use on Custom Themes and/or Extensions?
Ernie

hi i use the journal theme but even with the default theme and all the modules deactivated and vqmod deactivated i get the same problem


but i found the exact problem

well its two problems one is when customer details a put in and the continue button is pressed the customer is not taken to the next step but if you refresh it is taken to the next step but gets a warning message saying you must select address but an address is selected

and the main cause is that when ever a new registration is placed the address id is set as the value 0

even if i have 50 different addresses the value is set to 0

so opencast is confused as to what address is what because none of the addresses are unique


can anyone help me figure this out

well, it does no happen by default. And the Journal Extension add's a lot of THINGS to the default Software,
also some other Extensions may change/replace default system files.
So, the only way, to find out, would be, to install a second Default OC, and try again, step by step, until you
find out, wich Extension may be in charge of this.
Good Luck
Ernie

but none of my extensions till this day has replaced any system files i always make sure of this so a second default OC would still be a dead end someone must of had a similar problem or knows what it is

may be so, but during the past 33+ Months, I 've never heard about anything like this, and I have been reading thousands of postings, related to v.1.5.x already! I have been building more then 100 v.1.5.6.x Test Shops, during that time, but have never seen something like this before either.
Ernie

Hi Ernie

I understand and agree with you %100 but i have disabled all the extensions and mods transferred all the stock files still have the same problem surely someones out there who could think of a solution or even the part which manages the address registration

Hey guys i have found the solution

it was fairly easy but the last thing we would think of

just so if anyone out there has the same problem they can first check my solution out

the problem was that the address_id within the oc_address table which is the primary key never incremented and was always 0 at every new entry this in turn confused open cart and open cart could not find the relevant address thus making all customers had the same address which was the first in the list with a 0 address_id

before you do anything please backup your database

firstly change the name of the column address_id to anything you want to as we do not want open cart to use this field

next apply this query via SQL to create a new column with auto increment on



ALTER TABLE `oc_address` ADD `addresss_id` INT PRIMARY KEY AUTO_INCREMENT;

and that is all guys

now your database will give a unique id for each address inputted

thus problem solved