[Skip to main content](#vessel-content)

#   Unable to save address in either front end or back

##

- **[Bunbury60](/forum/user/8514-bunbury60 "View Bunbury60's Profile")**
- [![Bunbury60's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8514-bunbury60 "View Bunbury60's Profile") Topic Author
- [ Offline](/forum/user/8514-bunbury60)

Less More

- Posts: 5
- Thank you received: 0
-
-

14 years 2 months ago [\#60267](#60267) by [Bunbury60](/forum/user/8514-bunbury60 "View Bunbury60's Profile")  *[Unable to save address in either front end or back](/forum/2-general-talk-about-hikashop/60267-unable-to-save-address-in-either-front-end-or-back#60267 "I have trolled the forum and have seen similar questions but can't seem to find the answer. When registering a new customer after filling out the registration form and saving it the user is registered but no billing address is saved that i can find. When i go to the back end and manage customers and try to add the address it does not save either. Running 1.5.8 Starter (as a trial) and Joomla 2.5.6  Also have a problem with Cannot instantiate mail error on registration.  Can anyone direct me to where i am going wrong. Have been through the documentation but can't find the answer.  Regards  Dennis")* was created by *[Bunbury60](/forum/user/8514-bunbury60 "View Bunbury60's Profile")*

I have trolled the forum and have seen similar questions but can't seem to find the answer.
When registering a new customer after filling out the registration form and saving it the user is registered but no billing address is saved that i can find.
When i go to the back end and manage customers and try to add the address it does not save either.
Running 1.5.8 Starter (as a trial) and Joomla 2.5.6

Also have a problem with Cannot instantiate mail error on registration.

Can anyone direct me to where i am going wrong.
Have been through the documentation but can't find the answer.

Regards

Dennis

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzYwMjY3LXVuYWJsZS10by1zYXZlLWFkZHJlc3MtaW4tZWl0aGVyLWZyb250LWVuZC1vci1iYWNrP3RtcGw9bWFya2Rvd24=) 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")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86322
- Thank you received: 14281
-
-

14 years 2 months ago [\#60311](#60311) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Unable to save address in either front end or back](/forum/2-general-talk-about-hikashop/60267-unable-to-save-address-in-either-front-end-or-back#60311 "I have trolled the forum and have seen similar questions but can't seem to find the answer. When registering a new customer after filling out the registration form and saving it the user is registered but no billing address is saved that i can find. When i go to the back end and manage customers and try to add the address it does not save either. Running 1.5.8 Starter (as a trial) and Joomla 2.5.6  Also have a problem with Cannot instantiate mail error on registration.  Can anyone direct me to where i am going wrong. Have been through the documentation but can't find the answer.  Regards  Dennis")*

Hi,

Turn on the debug mode of the joomla configuration and try again. That will display an error message which will help you/us identify the error.

For the email error, you need to configure the email settings of the joomla configuration according to your hosting company recommendations if you want your website to be able to send emails.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzYwMjY3LXVuYWJsZS10by1zYXZlLWFkZHJlc3MtaW4tZWl0aGVyLWZyb250LWVuZC1vci1iYWNrP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation.

- **[Bunbury60](/forum/user/8514-bunbury60 "View Bunbury60's Profile")**
- [![Bunbury60's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8514-bunbury60 "View Bunbury60's Profile") Topic Author
- [ Offline](/forum/user/8514-bunbury60)

Less More

- Posts: 5
- Thank you received: 0
-
-

14 years 2 months ago [\#60323](#60323) by [Bunbury60](/forum/user/8514-bunbury60 "View Bunbury60's Profile")  Replied by *[Bunbury60](/forum/user/8514-bunbury60 "View Bunbury60's Profile")* on topic *[Re: Unable to save address in either front end or back](/forum/2-general-talk-about-hikashop/60267-unable-to-save-address-in-either-front-end-or-back#60323 "I have trolled the forum and have seen similar questions but can't seem to find the answer. When registering a new customer after filling out the registration form and saving it the user is registered but no billing address is saved that i can find. When i go to the back end and manage customers and try to add the address it does not save either. Running 1.5.8 Starter (as a trial) and Joomla 2.5.6  Also have a problem with Cannot instantiate mail error on registration.  Can anyone direct me to where i am going wrong. Have been through the documentation but can't find the answer.  Regards  Dennis")*

Hi Nicholas,

Thanks the quick response.

Below is the error message

JDatabaseMySQLi::query: 1054 - Unknown column 'address_street2' in 'field list' SQL=INSERT IGNORE INTO &#96;fokfi_hikashop_address&#96; ( &#96;address_title&#96;,&#96;address_firstname&#96;,&#96;address_lastname&#96;,&#96;address_street&#96;,&#96;address_street2&#96;,&#96;address_post_code&#96;,&#96;address_city&#96;,&#96;address_telephone&#96;,&#96;address_state&#96;,&#96;address_country&#96;,&#96;address_user_id&#96;,&#96;address_default&#96; ) VALUES ( 'Mr','test','test','60 xxxx Street','','111','Wsd','1111111','state_Queensland_433','country_Australia_13','12','1' )

There are 2 address lines on the customer entry form, so it appears the second one has not has a column produced in the table

Regards

Dennis

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzYwMjY3LXVuYWJsZS10by1zYXZlLWFkZHJlc3MtaW4tZWl0aGVyLWZyb250LWVuZC1vci1iYWNrP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation.

- **[Bunbury60](/forum/user/8514-bunbury60 "View Bunbury60's Profile")**
- [![Bunbury60's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8514-bunbury60 "View Bunbury60's Profile") Topic Author
- [ Offline](/forum/user/8514-bunbury60)

Less More

- Posts: 5
- Thank you received: 0
-
-

14 years 2 months ago [\#60325](#60325) by [Bunbury60](/forum/user/8514-bunbury60 "View Bunbury60's Profile")  Replied by *[Bunbury60](/forum/user/8514-bunbury60 "View Bunbury60's Profile")* on topic *[Re: Unable to save address in either front end or back](/forum/2-general-talk-about-hikashop/60267-unable-to-save-address-in-either-front-end-or-back#60325 "I have trolled the forum and have seen similar questions but can't seem to find the answer. When registering a new customer after filling out the registration form and saving it the user is registered but no billing address is saved that i can find. When i go to the back end and manage customers and try to add the address it does not save either. Running 1.5.8 Starter (as a trial) and Joomla 2.5.6  Also have a problem with Cannot instantiate mail error on registration.  Can anyone direct me to where i am going wrong. Have been through the documentation but can't find the answer.  Regards  Dennis")*

Hi Nicholas,

I have unpublished that field in the list and it no longer causes a problem. However often people require a second line for their shipping address. Should not the database reflect the fields if they are published?

Regards

Dennis

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzYwMjY3LXVuYWJsZS10by1zYXZlLWFkZHJlc3MtaW4tZWl0aGVyLWZyb250LWVuZC1vci1iYWNrP3RtcGw9bWFya2Rvd24=) 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")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86322
- Thank you received: 14281
-
-

14 years 2 months ago [\#60373](#60373) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Unable to save address in either front end or back](/forum/2-general-talk-about-hikashop/60267-unable-to-save-address-in-either-front-end-or-back#60373 "I have trolled the forum and have seen similar questions but can't seem to find the answer. When registering a new customer after filling out the registration form and saving it the user is registered but no billing address is saved that i can find. When i go to the back end and manage customers and try to add the address it does not save either. Running 1.5.8 Starter (as a trial) and Joomla 2.5.6  Also have a problem with Cannot instantiate mail error on registration.  Can anyone direct me to where i am going wrong. Have been through the documentation but can't find the answer.  Regards  Dennis")*

That field has a bug in the current version. Just create a new field to replace it and you won't have the problem.

The following user(s) said Thank You: [Bunbury60](/forum/user/8514-bunbury60 "View Bunbury60's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzYwMjY3LXVuYWJsZS10by1zYXZlLWFkZHJlc3MtaW4tZWl0aGVyLWZyb250LWVuZC1vci1iYWNrP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.083 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
