Users don't show up in Mambo backend even after login

[Aravot]

Mambo 4.5.2.3
SMF 1.0.3
Bridge 3.19a
Using SMF Registration
one database
------------------------------------

After registering few test users and logging in with each user at least couple of times I found that some user show up in Mambo backend some not, don't know why, maybe it's a bug.

More detail:

• All users are in SMF member list (pic 1)
• Mambo Admin Main page shows users as logged in (pic 2)
• Mambo displays 15 users but it doesn't show the users (pic 3)
• However User Home Pages component shows all users even if Mambo doesn't show the users. (pic 4)

I need users to show up in Mambo 'User Manager' so I could change user's group

(pic 1)


(pic 2)


(pic 3)


(pic 4)

[Orstio]

Do any of those users have the same real name and/or email address as other users?

[Aravot]

Do any of those users have the same real name and/or email address as other users?

No it goes like this:

username       email
test2              [email protected]
test3              [email protected]

[Orstio]

Were all of the users registered in the same way?

[Aravot]

Were all of the users registered in the same way?

Yes, exactly the same, 6 different computers but with the same configurations.

[Kindred]

Aravot...  but were all of them registered by clicking the same reg link?   (and the reg method was not changed between the "working" users and the other ones?

[Aravot]

Aravot...  but were all of them registered by clicking the same reg link?   (and the reg method was not changed between the "working" users and the other ones?

All are test users entered by me exactly the same way, entered by this order test2, test3, test4, test6, test5 the last two (test6, test5) show up but not the first 3.

[Aravot]

OK, I found out why the rest of user don't show up in Mambo backend but don't know why or how to fix it.

After turning the debug mod on in Mambo, Global Configuration -> Debug Site - > Yes.
Whenever I login with the user(s) that aren't in Mambo backend I get the following error however this error doesn't happen if the user is in the backend.

Edited: Link to test site removed.

Error Message:

Notice: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND g2.group_id='Registered'' at line 4 in /home/mysite.com/public_html/orstio/includes/database.php on line 221

/home/mysite.com/public_html/orstio/includes/database.php:319
/home/mysite.com/public_html/orstio/includes/gacl_api.class.php:1679
/home/mysite.com/public_html/orstio/includes/mambo.php:467
/home/mysite.com/public_html/orstio/includes/mambo.php:424
/home/mysite.com/public_html/orstio/index.php:107
Notice: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND g2.group_id='Public Backend'' at line 4 in /home/mysite.com/public_html/orstio/includes/database.php on line 221

/home/mysite.com/public_html/orstio/includes/database.php:319
/home/mysite.com/public_html/orstio/includes/gacl_api.class.php:1679
/home/mysite.com/public_html/orstio/includes/mambo.php:468
/home/mysite.com/public_html/orstio/includes/mambo.php:424
/home/mysite.com/public_html/orstio/index.php:107
Notice: Undefined index: is_admin in /home/mysite.com/public_html/orstio/smf/Sources/Security.php on line 556

Notice: Undefined index: permissions in /home/mysite.com/public_html/orstio/smf/Sources/Security.php on line 563

Warning: in_array(): Wrong datatype for second argument in /home/mysite.com/public_html/orstio/smf/Sources/Security.php on line 563
session_start(): Cannot send session cache limiter - headers already sent (output started at /home/mysite.com/public_html/orstio/includes/database.php:221)

[Aravot]

Did anyone figured this out

Mambo 4.5.2.3
SMF 1.0.3
Gallery2 component 2.0.6


Since in the first line of error I saw 'g2.group_id' and it seems I am the only one with this problem I thought this could be cause by Gallery2 module hence I post a copy at G2 forum.

http://gallery.menalto.com/index.php?name=PNphpBB2&file=viewtopic&p=157437

[Orstio]

The problem is in Mambo's bloated ACL.

What you can do to fix those users:

Login as each user, and edit them in the Mambo "My Details" page.  Save the details, and the user will be entered into the ACL.

What you can do to prevent a recurrence:

Go to PhpMyAdmin, and use the following query:

Code Select Expand

ALTER TABLE `mos_core_acl_aro` CHANGE `aro_id` `aro_id` INT( 11 ) NOT NULL AUTO_INCREMENT

[Aravot]

The problem is in Mambo's bloated ACL.

What you can do to fix those users:

Login as each user, and edit them in the Mambo "My Details" page.  Save the details, and the user will be entered into the ACL.

I bow to you, that solved it thank you. 

What you can do to prevent a recurrence:

Go to PhpMyAdmin, and use the following query:

Code Select Expand

ALTER TABLE `mos_core_acl_aro` CHANGE `aro_id` `aro_id` INT( 11 ) NOT NULL AUTO_INCREMENT

I am not comfy  playing with PhpMyAdmin, what does that code do, translation into English

[Orstio]

It just forces that particular table to auto-increment the value for aro_id.  This prevents aro_id values of zero, which is the main problem causing what you are seeing.

[Koffieboer]

Login as each user, and edit ...

How do you do this without knowing the password?

[Koffieboer]

... furthermore, ... I've got 16 users in mamb1_ and 18 in smf_



17 users in acl_aro, which are the 16 from mamb1 and one user which was removed from mamb1 before smf was installed. Is this one giving me the problems? How can I get both 18 in mamb1, smf1 and also on the acl ?

(and what's that value 0)?

[Radeon]

Hi, i'm having this problem to. Altough all of my users are npt showing up in the backend. How should they register? I'm currently using "SFM Registration" as it were set to from the beginning.

Is there like any sql query or a small script i could run that will sync the users? I relly need to be able to give some of my users access to the backend of my site =/

Edit: When i use Bridge registration it seams to work. Altough the bridge registration looks so awful =(

[Aravot]

Login as each user, and edit ...

How do you do this without knowing the password?

Send an email to your users with a link to 'Your Detail' module and ask them to click on 'Update' button, that's what I did.

Make sure to change Itemid=?? to match your setup
http://www.example.com/index.php?option=com_user&task=UserDetails&Itemid=21

[Orstio]

Hi, i'm having this problem to. Altough all of my users are npt showing up in the backend. How should they register? I'm currently using "SFM Registration" as it were set to from the beginning.

Is there like any sql query or a small script i could run that will sync the users? I relly need to be able to give some of my users access to the backend of my site =/

Edit: When i use Bridge registration it seams to work. Altough the bridge registration looks so awful =(

When using SMF registration, the users are not migrated into the Mambo database until they login for the first time.  After each one logs in, each will show up in Mambo.

17 users in acl_aro, which are the 16 from mamb1 and one user which was removed from mamb1 before smf was installed. Is this one giving me the problems? How can I get both 18 in mamb1, smf1 and also on the acl ?

First, run the mos2smf script, which will migrate your Mambo users into SMF:

http://mamboforge.net/frs/download.php/6246/mos2smf1.1.zip