[Skip to main content](#vessel-content) # Can't add registered billing address ## - **[lukehold](/forum/user/7907-lukehold "View lukehold's Profile")** - [![lukehold's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7907-lukehold "View lukehold's Profile") Topic Author - [ Offline](/forum/user/7907-lukehold) Less More - Posts: 57 - Thank you received: 0 - - 14 years 4 months ago [\#55339](#55339) by [lukehold](/forum/user/7907-lukehold "View lukehold's Profile") *[Can't add registered billing address](/forum/3-bug-report/55339-cant-add-registered-billing-address#55339 "Hi, I am having some problems with selecting billing addresses. Although new users can add their addresses in step one (login/registration) of checkout, after they validate their email and return to the checkout they then find their addresses are unavailableon the billing address page and they have to enter them manually again. Please follow this product to see this happen: notascratch.com/shop/category/12-iphone-4s-cases I am also finding myself forced to request users to enter their addresses at stage one because if not, there are no empty boxes for 'new' address. This means they can't complete the order. Most payment pages request the address to be completed later in the process - registration/billing address/payment - but mine has to be registration+address/billing address/payment. This is not optimal. Can anyone help with selecting entered address and with pushing the billing stage back a step? Many thanks, Luke")* was created by *[lukehold](/forum/user/7907-lukehold "View lukehold's Profile")* Hi, I am having some problems with selecting billing addresses. Although new users can add their addresses in step one (login/registration) of checkout, after they validate their email and return to the checkout they then find their addresses are unavailableon the billing address page and they have to enter them manually again. Please follow this product to see this happen: [ notascratch.com/shop/category/12-iphone-4s-cases](http://notascratch.com/shop/category/12-iphone-4s-cases) I am also finding myself forced to request users to enter their addresses at stage one because if not, there are no empty boxes for 'new' address. This means they can't complete the order. Most payment pages request the address to be completed later in the process - registration/billing address/payment - but mine has to be registration+address/billing address/payment. This is not optimal. Can anyone help with selecting entered address and with pushing the billing stage back a step? Many thanks, Luke Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC81NTMzOS1jYW50LWFkZC1yZWdpc3RlcmVkLWJpbGxpbmctYWRkcmVzcz90bXBsPW1hcmtkb3du) or [Create an account](/register) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 14 years 4 months ago [\#55401](#55401) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Can't add registered billing address](/forum/3-bug-report/55339-cant-add-registered-billing-address#55401 "Hi, I am having some problems with selecting billing addresses. Although new users can add their addresses in step one (login/registration) of checkout, after they validate their email and return to the checkout they then find their addresses are unavailableon the billing address page and they have to enter them manually again. Please follow this product to see this happen: notascratch.com/shop/category/12-iphone-4s-cases I am also finding myself forced to request users to enter their addresses at stage one because if not, there are no empty boxes for 'new' address. This means they can't complete the order. Most payment pages request the address to be completed later in the process - registration/billing address/payment - but mine has to be registration+address/billing address/payment. This is not optimal. Can anyone help with selecting entered address and with pushing the billing stage back a step? Many thanks, Luke")* Hi, Could you try to turn on the debug mode of the joomla configuration and try again ? That might display an error message. Also, I can see that you changed quite a bit the custom fields. Was it working before you changed them ? If so, could you try to revert your changes ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC81NTMzOS1jYW50LWFkZC1yZWdpc3RlcmVkLWJpbGxpbmctYWRkcmVzcz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[lukehold](/forum/user/7907-lukehold "View lukehold's Profile")** - [![lukehold's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7907-lukehold "View lukehold's Profile") Topic Author - [ Offline](/forum/user/7907-lukehold) Less More - Posts: 57 - Thank you received: 0 - - 14 years 4 months ago - 14 years 4 months ago [\#55424](#55424) by [lukehold](/forum/user/7907-lukehold "View lukehold's Profile") Replied by *[lukehold](/forum/user/7907-lukehold "View lukehold's Profile")* on topic *[Re: Can't add registered billing address](/forum/3-bug-report/55339-cant-add-registered-billing-address#55424 "Hi, I am having some problems with selecting billing addresses. Although new users can add their addresses in step one (login/registration) of checkout, after they validate their email and return to the checkout they then find their addresses are unavailableon the billing address page and they have to enter them manually again. Please follow this product to see this happen: notascratch.com/shop/category/12-iphone-4s-cases I am also finding myself forced to request users to enter their addresses at stage one because if not, there are no empty boxes for 'new' address. This means they can't complete the order. Most payment pages request the address to be completed later in the process - registration/billing address/payment - but mine has to be registration+address/billing address/payment. This is not optimal. Can anyone help with selecting entered address and with pushing the billing stage back a step? Many thanks, Luke")* Okay, Initially I tried this and it failed at the point where it sends a verifcation email, but I can't be certain that I had deleted the test user account. I then deleted both from Hika and Joomla core. On my second attempt I reached the stage where I needed to log in. Oddly the address fields were already filled in (see attachment) which can't be right. After entering new user name/password/etc I get the same error as noted above: JDatabaseMySQLi::query: 1054 - Unknown column 'address_street2' in 'field list' SQL=INSERT IGNORE INTO `qlf7t_hikashop_address` ( `address_street`,`address_street2`,`address_city`,`county`,`address_user_id`,`address_default` ) VALUES ( '2 Lawns Courtyard, Broad Road','Wickham Market','Woodbridge','Suffolk','8','1' ) I have left debug mode on if you have a chance to test it again. What do you suggest? Note: I changed the names of some custom fields and added a new one (text entry) for County since all my customers are UK-based. The State field is linked to the Country one and not showing Country resulted in State not having any options. Since I just wanted State (or County), I had to create a new one. Thanks a lot for your help with this Nicolas, Luke - [ ![address.png](/forum/attachment/4458) ](/forum/attachment/4458 "address.png") [ ](/forum/attachment/4458?download=1 "address.png") Last edit: 14 years 4 months ago by [lukehold](/forum/user/7907-lukehold "View lukehold's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC81NTMzOS1jYW50LWFkZC1yZWdpc3RlcmVkLWJpbGxpbmctYWRkcmVzcz90bXBsPW1hcmtkb3du) or [Create an account](/register) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 14 years 4 months ago [\#55426](#55426) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Can't add registered billing address](/forum/3-bug-report/55339-cant-add-registered-billing-address#55426 "Hi, I am having some problems with selecting billing addresses. Although new users can add their addresses in step one (login/registration) of checkout, after they validate their email and return to the checkout they then find their addresses are unavailableon the billing address page and they have to enter them manually again. Please follow this product to see this happen: notascratch.com/shop/category/12-iphone-4s-cases I am also finding myself forced to request users to enter their addresses at stage one because if not, there are no empty boxes for 'new' address. This means they can't complete the order. Most payment pages request the address to be completed later in the process - registration/billing address/payment - but mine has to be registration+address/billing address/payment. This is not optimal. Can anyone help with selecting entered address and with pushing the billing stage back a step? Many thanks, Luke")* Unpublish the address_street2 field and create a new one for that information via the menu Display-Custom fields and you won't have that error anymore. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC81NTMzOS1jYW50LWFkZC1yZWdpc3RlcmVkLWJpbGxpbmctYWRkcmVzcz90bXBsPW1hcmtkb3du) or [Create an account](/register) 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.054 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)