[Skip to main content](#vessel-content) # Problem With Address Table Record linking to Wrong ## - **[dselby](/forum/user/32169-dselby "View dselby's Profile")** - [![dselby's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32169-dselby "View dselby's Profile") Topic Author - [ Offline](/forum/user/32169-dselby) Less More - Posts: 5 - Thank you received: 0 - - 12 years 3 months ago [\#166889](#166889) by [dselby](/forum/user/32169-dselby "View dselby's Profile") *[Problem With Address Table Record linking to Wrong](/forum/33-customers/870261-problem-with-address-table-record-linking-to-wrong#166889 "-- HikaShop version -- : 2.3.1 business -- Joomla version -- : 3.3.1 -- Browser(s) name and version -- : all I have had 3 instances of customers logging on and finding that there billing_address is set up to be another customers name and address. I can see in the hikashop_address table that the original correct address record is set to not be published, the new address record is set up correctly for new customer, but there is another address record set up linking to wrong customer id. Do you have any idea why/how this would be happening? I have attached a file showing the data of the latest instance. The customer_ids are consecutive and the address_ids are consecutive in this example.")* was created by *[dselby](/forum/user/32169-dselby "View dselby's Profile")* -- HikaShop version -- : 2.3.1 business -- Joomla version -- : 3.3.1 -- Browser(s) name and version -- : all I have had 3 instances of customers logging on and finding that there billing_address is set up to be another customers name and address. I can see in the hikashop_address table that the original correct address record is set to not be published, the new address record is set up correctly for new customer, but there is another address record set up linking to wrong customer id. Do you have any idea why/how this would be happening? I have attached a file showing the data of the latest instance. The customer_ids are consecutive and the address_ids are consecutive in this example. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMzLWN1c3RvbWVycy84NzAyNjEtcHJvYmxlbS13aXRoLWFkZHJlc3MtdGFibGUtcmVjb3JkLWxpbmtpbmctdG8td3Jvbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86358 - Thank you received: 14293 - - 12 years 2 months ago [\#166894](#166894) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Problem With Address Table Record linking to Wrong](/forum/33-customers/870261-problem-with-address-table-record-linking-to-wrong#166894 "-- HikaShop version -- : 2.3.1 business -- Joomla version -- : 3.3.1 -- Browser(s) name and version -- : all I have had 3 instances of customers logging on and finding that there billing_address is set up to be another customers name and address. I can see in the hikashop_address table that the original correct address record is set to not be published, the new address record is set up correctly for new customer, but there is another address record set up linking to wrong customer id. Do you have any idea why/how this would be happening? I have attached a file showing the data of the latest instance. The customer_ids are consecutive and the address_ids are consecutive in this example.")* Hi, That can happen when you migrate your website for example from an old version of Joomla to a new one and that the id of the users change, or that you clean the users you had for your tests before going live but don't delete first their addresses or something like that. Basically, it's not a bug, but data that has not been handled properly in the database. It cannot happen in the normal functioning of the shop. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMzLWN1c3RvbWVycy84NzAyNjEtcHJvYmxlbS13aXRoLWFkZHJlc3MtdGFibGUtcmVjb3JkLWxpbmtpbmctdG8td3Jvbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dselby](/forum/user/32169-dselby "View dselby's Profile")** - [![dselby's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32169-dselby "View dselby's Profile") Topic Author - [ Offline](/forum/user/32169-dselby) Less More - Posts: 5 - Thank you received: 0 - - 12 years 2 months ago [\#166943](#166943) by [dselby](/forum/user/32169-dselby "View dselby's Profile") Replied by *[dselby](/forum/user/32169-dselby "View dselby's Profile")* on topic *[Problem With Address Table Record linking to Wrong](/forum/33-customers/870261-problem-with-address-table-record-linking-to-wrong#166943 "-- HikaShop version -- : 2.3.1 business -- Joomla version -- : 3.3.1 -- Browser(s) name and version -- : all I have had 3 instances of customers logging on and finding that there billing_address is set up to be another customers name and address. I can see in the hikashop_address table that the original correct address record is set to not be published, the new address record is set up correctly for new customer, but there is another address record set up linking to wrong customer id. Do you have any idea why/how this would be happening? I have attached a file showing the data of the latest instance. The customer_ids are consecutive and the address_ids are consecutive in this example.")* Hi Nicholas Thanks for your reply. I have migrated the website, but these records are all brand new records and did not exist previously. I have the backup of the old data and these records were not there. I do agree that it is weird and my first thought was that I had made an error in migrating data from virtuemart, but this has only happened 3 times, and it is a brand new user who registers (and the address never existed previously) .. there ends up being one address linked correctly to the new user, and the same address is created and linked wrongly to another existing user. Did you see the example that I sent? The IDs are all consecutive, and these were both brand new customers who registered one after the other - none of this data existed prior to last week. When two users are both registering at the same time, how does the system recognise which user is which? Does it do it with IP address? The one thing I am wondering about is that I am operating behind a sucuri.net firewall, so the IP address is the same for each user, and maybe the session id is the same? I am not really an expert in firewalls. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMzLWN1c3RvbWVycy84NzAyNjEtcHJvYmxlbS13aXRoLWFkZHJlc3MtdGFibGUtcmVjb3JkLWxpbmtpbmctdG8td3Jvbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dselby](/forum/user/32169-dselby "View dselby's Profile")** - [![dselby's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32169-dselby "View dselby's Profile") Topic Author - [ Offline](/forum/user/32169-dselby) Less More - Posts: 5 - Thank you received: 0 - - 12 years 2 months ago [\#166944](#166944) by [dselby](/forum/user/32169-dselby "View dselby's Profile") Replied by *[dselby](/forum/user/32169-dselby "View dselby's Profile")* on topic *[Problem With Address Table Record linking to Wrong](/forum/33-customers/870261-problem-with-address-table-record-linking-to-wrong#166944 "-- HikaShop version -- : 2.3.1 business -- Joomla version -- : 3.3.1 -- Browser(s) name and version -- : all I have had 3 instances of customers logging on and finding that there billing_address is set up to be another customers name and address. I can see in the hikashop_address table that the original correct address record is set to not be published, the new address record is set up correctly for new customer, but there is another address record set up linking to wrong customer id. Do you have any idea why/how this would be happening? I have attached a file showing the data of the latest instance. The customer_ids are consecutive and the address_ids are consecutive in this example.")* the other thing to note is that when the new record address is created twice, as well as linked wrongly to the previous user_id it also sets the published flag to "unpublished" .. does this help to isolate the code which does this? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMzLWN1c3RvbWVycy84NzAyNjEtcHJvYmxlbS13aXRoLWFkZHJlc3MtdGFibGUtcmVjb3JkLWxpbmtpbmctdG8td3Jvbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86358 - Thank you received: 14293 - - 12 years 2 months ago [\#166947](#166947) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Problem With Address Table Record linking to Wrong](/forum/33-customers/870261-problem-with-address-table-record-linking-to-wrong#166947 "-- HikaShop version -- : 2.3.1 business -- Joomla version -- : 3.3.1 -- Browser(s) name and version -- : all I have had 3 instances of customers logging on and finding that there billing_address is set up to be another customers name and address. I can see in the hikashop_address table that the original correct address record is set to not be published, the new address record is set up correctly for new customer, but there is another address record set up linking to wrong customer id. Do you have any idea why/how this would be happening? I have attached a file showing the data of the latest instance. The customer_ids are consecutive and the address_ids are consecutive in this example.")* Hi, I don't know how that firewall work. I doubt that the user session is the same for everyone. That would render the shop unusable since everyone would have the same cart, the same login, etc. I've neer seen such error happening besides the cases I pointed out. Maybe the database structure is incorrect ? If some auto_increment is missing in some of the tables, it could potentially create strange problems like these. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMzLWN1c3RvbWVycy84NzAyNjEtcHJvYmxlbS13aXRoLWFkZHJlc3MtdGFibGUtcmVjb3JkLWxpbmtpbmctdG8td3Jvbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.051 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)