- Posts: 90
- Thank you received: 0
how to edit a customer's email
- tanyatanya
-
Topic Author
- Offline
Less
More
13 years 7 months ago #98353
by tanyatanya
how to edit a customer's email was created 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
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
Replied by nicolas on topic how to edit a customer's email
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.
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.
- tanyatanya
-
Topic Author
- Offline
Less
More
- Posts: 90
- Thank you received: 0
13 years 7 months ago #98524
by tanyatanya
Replied by tanyatanya on topic how to edit a customer's email
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
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
Replied by Xavier on topic how to edit a customer's email
Hi,
It can't save because the email address already exist. You can't have two times the same email address.
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.
- tanyatanya
-
Topic Author
- Offline
Less
More
- Posts: 90
- Thank you received: 0
13 years 7 months ago #98622
by tanyatanya
Replied by tanyatanya on topic how to edit a customer's email
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
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.075 seconds