existing users to Customers - Cannot add or update a child row: a foreign key constraint fails - Forum | JoomShaper
Solved EasyStore

existing users to Customers - Cannot add or update a child row: a foreign key constraint fails

Asked by Yanick Galli 2 years ago Last activity 2 years ago

Hi,

I'd like to add existing Joomla users to the EasyStore customer list.

How can I do this?

ERROR:
Cannot add or update a child row: a foreign key constraint fails (#_bdjoomla.#_easystore_users, CONSTRAINT #_easystore_users_ibfk_1 FOREIGN KEY (user_id) REFERENCES #_users (id) ON DELETE CASCADE ON UPDATE CASCADE)

best regards
Yanick

Accepted answer

Marked as the solution
Ofi Khan Staff
2 years ago

You are welcome. We will improve Customer profile creation in the future. We are using different table (easystore_users) for Customer Profile. Maybe we will integrate Joomla users with EasyStore Customers.

3 more replies

Oldest first Newest first Most helpful
Ofi Khan Staff
2 years ago

Hello Yanick Galli

Sorry, this feature does not exist. You have to add the information manually in EasyStore -> Customer tab to register a new customer.

Best regards

Yanick Galli Asked this
2 years ago

Hello Ofi Khan,

Thank you for your answer.

So I won't be able to use EasyStore, I have 400 customers with their passwords encrypted in joomla...

Too bad!

Best regards.

Yanick Galli Asked this
2 years ago

Hi,

Thank you.
Yanick

Log in to reply.