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???
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"
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?
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.
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