Agile Support Forum

Hello,

I'm getting an error when my existing user tries to become a seller.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id_customer=13' at line 1

UPDATE ps_customer_owner SET id_owner= WHERE id_customer=13

Prestashop v1.7.1
Agile Multiseller v3.7.2.0

This is what I do:
Create an user
Login with new user
Go to My Account and click "Seller Account"
Click Seller Terms & conditions checkbox
Click Register me button.

Couldn't find this on the forums, seen this before?

thanks for using our modules.

please provide following details information
- version of your PrestaShop
- version of the agile multiple seller module
- the full error message such as the line # of the source code.

shokinro wrote:thanks for using our modules.

please provide following details information
- version of your PrestaShop
- version of the agile multiple seller module
- the full error message such as the line # of the source code.

Edited original post to add prestashop and multiple seller versions

Does this issue happens to all customers or only happens to a specific customer?
We have released a new version of the module, I suggest you update to the latest version of the modules and see if it fixes the issue.
If the issue persists, please contact [email protected], we will take a look at your store.

Thanks for the reply.

I created a couple new users, registering as client, then from account I went to register as seller and it works.

Seems that my admin user is the problem.

I'll update, test and get back to you.

thanks for your feedback.
+