Home arrow Forum I can sync users manually??
  Welcome, Guest. Please login or register.
Did you miss your activation email?
December 05, 2008, 03:13:57 AM
Home New Posts Search Calendar


Login with username, password and session length
+  Joomla Forum
|-+  Joomla Hacks
| |-+  Joomla-SMF Forum Support
| | |-+  Joomla-SMF 1.0.x (Moderators: -Wolverine, kai920)
| | | |-+  I can sync users manually??
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Go Down Print
Author Topic: I can sync users manually??  (Read 2915 times)
Xema
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 6


View Profile
I can sync users manually??
« on: November 21, 2005, 06:14:38 PM »

first iīm spanish and i donīt speak english, sorry but i try:

1. Platform: Apache
2. PHP version: 5.0.4
3. Joomla 1.0.3
4. SMF version: 1.1 RC1
5. Issue description:

well i try to configure SMF+ joomla, but i canīt. i had a forum in phpBB and i can traslate to SMF (itīs all OK)
and Now i have a SMF with 2000 users and joomla with 1. I isntall the component and all is OK, but the users no sync when i veryfy in the admin say:
"SMF and Joomla users in sync. "
but itīs donīt work.

6. localhost....


I can sync users manually?? from the phpMyAdmin or similar???

thanks

PD: sorry by my horrible english
Logged
johnny
Developer
Joomla Master
*****

Karma: +5/-1
Offline Offline

Posts: 114



View Profile
Re: I can sync users manually??
« Reply #1 on: November 21, 2005, 07:19:28 PM »

i know your error, some users cannot be synced.

all you got to do is edit that user manually using phpMyAdmin and correct the error mentioned on the error text.
Logged
Xema
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 6


View Profile
Re: I can sync users manually??
« Reply #2 on: November 22, 2005, 07:41:14 AM »

some users not, any users sync  Undecided

ok, what is the sintax of SQL for sync manually???
Logged
jj
Joomla Pro
**

Karma: +5/-2
Offline Offline

Posts: 53


View Profile
Re: I can sync users manually??
« Reply #3 on: November 22, 2005, 07:59:44 AM »

Xema, post your error message in the forum.

We will tell you what to do  Smiley
Logged
Xema
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 6


View Profile
Re: I can sync users manually??
« Reply #4 on: November 22, 2005, 09:27:28 AM »

i donīt have any message of error

i have this: "SMF and Joomla users in sync. "

but itīs false any user is sync
Logged
jj
Joomla Pro
**

Karma: +5/-2
Offline Offline

Posts: 53


View Profile
Re: I can sync users manually??
« Reply #5 on: November 22, 2005, 11:22:23 AM »

Some user name Joomla will not accept and SMF will not accept either

You have to change user name

example


USER NAME JJ 'JONES <-- Not good for Joomla or SMF

NOT EVEN ONE USER SYNC WITH SMF?

Try user log in to SMF first THEN JOOMLA?
Logged
Xema
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 6


View Profile
Re: I can sync users manually??
« Reply #6 on: November 22, 2005, 01:29:26 PM »

itīs posible that some user itīs wront but any user of 2000???
for example my first user is: Xema
and any of the twenty first names not have any stranger character...

in SMF all users is OK all can log, but any in Joomla.... after log in SMF and go to joomla to try but say: "the name or password is incorrect"
Logged
Xema
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 6


View Profile
Re: I can sync users manually??
« Reply #7 on: November 28, 2005, 01:39:17 PM »

help me, please. i can do? how?
Logged
jj
Joomla Pro
**

Karma: +5/-2
Offline Offline

Posts: 53


View Profile
Re: I can sync users manually??
« Reply #8 on: November 28, 2005, 02:09:20 PM »

Xena, what program did you use to convert your users from PostNuke to Joomla?

all of them I have found are bad. "Juice" causes password errors.
Logged
-Wolverine
Moderator
Joomla Guru
*****

Karma: +376/-34
Offline Offline

Posts: 3393


Lead Developer


View Profile WWW
Re: I can sync users manually??
« Reply #9 on: November 28, 2005, 02:46:46 PM »

Xema, mi espanol es peor que tu ingles pero.... para clarificacion, el database(base de datos??) para Joomla esta el mismo database para SMF, cierto?  Y tu instalacion de Joomla no esta un upgrade de Mambo?  Es possible que tu tienes una mesa en el database con el nombre mos_users o como asi?  Cuando yo instale Joomla de Mambo me olvide que las mesas tienen nombres diferentes. 

Cual es el prefijo de tu SMF database mesas y tu Joomla database mesas?

Tambien, tu sitio esta en linea?  Cual es la direccion? 
Logged

Need help?  Check Here First!
Get the JSMF User Guide
SEARCH this forum.
Xema
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 6


View Profile
Re: I can sync users manually??
« Reply #10 on: November 28, 2005, 05:00:36 PM »

jj i donīt have PostNuke, i convert PHPBB2 to SMF and now i want sync with joomla

Gracias wolverine por la traducción.

I have one BBDD with 2 "prefijos" from tables of joomla jos_ and tables of SMF smf_

the installation of joomla is new, i donīt upgrade any.

My website is now in localhost, i want up when all is OK
Logged
-Wolverine
Moderator
Joomla Guru
*****

Karma: +376/-34
Offline Offline

Posts: 3393


Lead Developer


View Profile WWW
Re: I can sync users manually??
« Reply #11 on: November 28, 2005, 06:33:32 PM »

well, looking at the code essentially the sync happens like this, first select all the SMF users that aren't in jos_users and then add them.  The SQL to select the users is like this:

Code:
SELECT memberName, realName, passwd, emailAddress, dateRegistered, is_activated, validation_code
FROM smf_members 
LEFT JOIN jos_users
ON jos_users.username=smf_members.memberName 
WHERE jos_users.username IS NULL

That selects the users in smf that are not in Joomla.  The insert is using Joomla functions so the exact SQL is somewhere in the depths of the Joomla source.  Maybe by doing the above select you can detect an issue.  Essentially, the elements that get inserted into jos_users are:

realName
memberName
emailAddress
password


There is some more to it, but that is the essentials. 
Logged

Need help?  Check Here First!
Get the JSMF User Guide
SEARCH this forum.
Pages: [1] Go Up Print 
« previous next »
Jump to:  



Login with username, password and session length

Powered by MySQL Powered by PHP Joomla Forum | Powered by SMF 1.1 RC1.
© 2001-2005, Lewis Media. All Rights Reserved.
Joomla Bridge by JoomlaHacks.com
Valid XHTML 1.0! Valid CSS!

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
Joomla Hacks



Joomla Hacks
German Lang French Lang Italian Lang Spanish Lang Japanese Lang Chinese Lang
Joomla Comment
Search Contact About Advertise Blogs Topsites Submit News Register Login