Skip to main content

how to edit a customer's email

13 years 7 months ago #98353 by tanyatanya
hi,

my customer has placed an order but would like to change the email address that he has registered on his account - i've tried editing it in the customer section but it just says 'error saving' when i try to save the change. is there a way to do this?

kind regards,
tanya

Please Log in or Create an account to join the conversation.

13 years 7 months ago #98522 by nicolas
Hi,

You should turn on the "debug mode" option of the joomla configuration page and try again in order to get the real error message behind that error in order to understand why it is not working.

Please Log in or Create an account to join the conversation.

13 years 7 months ago #98524 by tanyatanya
hi,

error code as follows:

500 - An error has occurred.

JDatabaseMySQL::query: 1062 - Duplicate entry 'mark.swanston@landclean.net' for key 'user_email' SQL=UPDATE `jos_hikashop_user` SET `user_email`='mark.swanston@landclean.net',`user_partner_activated`='0',`user_partner_email`='' WHERE user_id='1233'

Call stack
# Function Location
1 JAdministrator->dispatch() /home/sites/spaldingfasteners.co.uk/public_html/administrator/index.php:67
2 JComponentHelper->renderComponent() /home/sites/spaldingfasteners.co.uk/public_html/administrator/includes/application.php:136
3 require_once() /home/sites/spaldingfasteners.co.uk/public_html/libraries/joomla/application/component/helper.php:162
4 hikashopController->execute() /home/sites/spaldingfasteners.co.uk/public_html/administrator/components/com_hikashop/hikashop.php:54
5 JController->execute() /home/sites/spaldingfasteners.co.uk/public_html/administrator/components/com_hikashop/helpers/helper.php:1212
6 hikashopController->apply() /home/sites/spaldingfasteners.co.uk/public_html/libraries/joomla/application/component/controller.php:236
7 hikashopController->store() /home/sites/spaldingfasteners.co.uk/public_html/administrator/components/com_hikashop/helpers/helper.php:998
8 hikashopUserClass->saveForm() /home/sites/spaldingfasteners.co.uk/public_html/administrator/components/com_hikashop/helpers/helper.php:1062
9 hikashopUserClass->save() /home/sites/spaldingfasteners.co.uk/public_html/administrator/components/com_hikashop/classes/user.php:235
10 hikashopClass->save() /home/sites/spaldingfasteners.co.uk/public_html/administrator/components/com_hikashop/classes/user.php:132
11 JDatabaseMySQL->updateObject() /home/sites/spaldingfasteners.co.uk/public_html/administrator/components/com_hikashop/helpers/helper.php:1266
12 JDatabaseMySQL->query() /home/sites/spaldingfasteners.co.uk/public_html/libraries/joomla/database/database/mysql.php:583
13 JError->raiseError() /home/sites/spaldingfasteners.co.uk/public_html/libraries/joomla/database/database/mysql.php:231
14 JError->raise() /home/sites/spaldingfasteners.co.uk/public_html/libraries/joomla/error/error.php:171
15 JException->__construct() /home/sites/spaldingfasteners.co.uk/public_html/libraries/joomla/error/error.php:136

Please Log in or Create an account to join the conversation.

13 years 7 months ago - 13 years 7 months ago #98611 by Xavier
Hi,

It can't save because the email address already exist. You can't have two times the same email address.
Last edit: 13 years 7 months ago by Xavier.

Please Log in or Create an account to join the conversation.

13 years 7 months ago #98622 by tanyatanya
Thank you for your reply - that has solved my problem.
My customer had registered twice with 2 different email addresses so I just had to delete his old user information 1st.
Thanks again!
Tanya

Please Log in or Create an account to join the conversation.

Time to create page: 0.045 seconds
Powered by Kunena Forum