Failed: Please enter a valid Username:. No spaces, more than 2 characters and contain 0-9,a-z,A-Z
I only have 76 users of about 500 imported.. it won't do them all, and that is the error message i get.
User number 76 is called administrator and is definately the default administrator. Seems it couldnt overwrite it or something and stopped with a silly error message.
I had a test account in SMF and one in Mambo. It turned out that I had used slightly different usernames but had used the same e-mail address so the sync thought they were different people with the same e-mail.
Once I changed the test account usernames to be EXACTLY the same, the sync worked fine.
The only user in mambo was administrator with a unique email adress, i never registered that email on the VB that converted to SMF.
That one existing user in Mambo was deleted by me too.. I EMTIED the usertable of mambo.. it was entirely empty.. (strange thing is that i held my non existing session in the backend lol).. but even then it didn't synch..
Your error is about a duplicate email. You're syncing an SMF user w/c email is already in mambo. Do you know how to query it manually?
Cowboy I've got this problem as well, can you supply the code that will find out which fields in the database have the same email addresses please? I'm assuming after I find out which fields need to be deleted that the sychron. process will work?
You have to manually query it from SMF table for now.
Here's how you find the email from SMF that already exist in Joomla:
Code:
SELECT jos1.username, jos1.email, smf.memberName, smf.emailAddress FROM smf_members smf, jos_users jos1 LEFT JOIN jos_users jos ON smf.memberName = jos.username WHERE jos.username is NULL AND jos1.email = smf.emailAddress
so for example: user "test1" with email "test1@test.com" is in Joomla. and "test111" with email "test1@test.com" is in SMF. You see that test1 and test111 is using the same email! The query will give you: "test1", "test1@test.com", "test111", "test1@test.com" therefore, you have to change "test111" email from smf_members.
Here's how you find duplicate emails from singel table, example SMF:
Code:
SELECT memberName, emailAddress, COUNT(emailAddress) AS NumOccurrences FROM smf_members GROUP BY emailAddress HAVING ( COUNT(emailAddress) > 1 )
Hi Cowboy, slight problem haven't upgraded to Joomla yet, its next on my to-do list You refer to jos1 table can you give the equivalent of this in mambo. Obviously jos_user would be the same as mos_user but what does jos1 relate to?
Once I've got this information I'll create simple php page that your members can then use to find this information and be presented with it via html.
Joomla Hacks is a Joomla Components, Joomla Modules, Joomla Templates, & Joomla Mambots resource portal. None of the text or images in this public website may be copied without the expressed written consent of the authors. Copyright 2005 by JoomlaHacks.com. Powered by Joomla. All rights reserved. Terms of Use
Author
Forum
Logged
You refer to jos1 table can you give the equivalent of this in mambo. Obviously jos_user would be the same as mos_user but what does jos1 relate to?
