Hi.
I made a user registration form for Joomla!with custom fields.Just done it works.When I go to try again after closing the browser, the following error appears: 1062 - Duplicate entry 'id-2' for key 'PRIMARY'.How do I solve it?
Thank you🤗
Well what does your save data action look like?
So when you say "go try again after closing the browser" what do you mean? Are you creating a new user? What does the save user action look like?
If I create a new user after make the form, it works.
If I create a new user after turn off the browser, I have the fault!!!
If I create a new user after make the form, it works.
If I create a new user after turn off the browser, I have the fault!!!
What do you mean "turn off the browser"? What does the save user action look like, what happens if you disable all those other save data actions temporarily?
sorry, what do you mean " What does the save user action look like"?
Turning off the browser means for example that I turn off the operating system (I'm working in localhost)
If I remove the other Save data actions, the error persists: I have to create a new form !!!
Debugging does not work: the first page after the "create you account" action is error 1062
I mean "give me a screenshot of how you've set up the Save User action"
So take all of those data overrides out of the save user action, they shouldn't be there. Unless of course those 3 fields have been added to the users table, which would be stupid because you shouldn't make changes to core tables.
Plus even if they were okay, the first one isn't even in the right format, it should be {var:joomla_user3.id} except it should be there at all.
Ok, I removed these instructions but don't works: the error is the same.
In Save data {var:joomla_user3.id} I have written exactly
Where in Save Data have you written that exactly? And have you really just put that exactly and nothing else because if so that's not right, show me.
​
Also if you removed those 3 things, and you've disabled the save data actions does it still happen.
Sorry,
I posted a screenshot for "Save data" before.
I have disabled all "Save data" after "Save user" and not solving the error is there...🤗
And you've deleted the things out of the save user action? Have you got a link to this form?
If I send you the form, do you check it?!?
Sure simple stuff is fine just upload it here
Thanks a lot!!![file=11944]Registration_form1_05_Apr_2019_13_04_51.cf6bak[/file]
OK while I'm looking: TURN OFF AUTO MANAGE DATA TABLE on the fields_values save data actions
Then get rid of the save data actions completely and just use a single Save Custom Fields action (make sure you have the latest CFv6 update).
Then.... I don't know, because it's working for me.
OK, OK, OK!!!
It works!!!
I will replace the "Save data" with the action suggested by you ...
thank you so much.
😀
