inserting users error

please I get database query error when inserting moodle users to joomla

I guess you solved this then?
www.joomdle.com/en/forum/r09-support/106...current-transa/14674

Can you post to that thread so there is a resolution please?

As for you error: it says the user already exists in Joomla, so you cannot add him again.

Hi Sir Duran. Yes I cannot add the user who has already joomla account but I cannot add either the ones who don't have.
I can add them when I make a joomla account with the same username and password to the moodle. That's when I only get sso from moodle to joomla and vice versa. :pinch:

Hi.

I tested in a postgresql and I can replicate the problem.
I will try to fix it when I find some time, and post here when it is ready.

Yes sir. Thank you.Hopefully, I can find solution as soon as possible.

Ok, I found the problem and the fix is easy.

Edit administrator/components/com_joomdle/helpers/content.php, function create_joomla_user().
Change: By:

It worked!! Thank you!