JHTML List User an J1.6

[Steffen Janke]

Hello

I'm just a component of Joomla 1.5 to 1.6/1.7 to switch. Well I have a problem, I call there on the active Joomla User:
$lists['user']            = JHTML::_( 'list.users', 'joomlaid', $darst->joomlaid, true, null, 'name', false );
Now I get all users displayed many times (depending on how many groups in the User)
Is this an Error?
I've patched this file: libraries/joomla/html/list.php (line 189)
from:
. $and
. ' ORDER BY '. $order
;
to
. $and
. ' GROUP BY u.id'
. ' ORDER BY '. $order
;

regards Steffen

[Tuan Pham Ngoc]

I agree that this is a bug in Joomla 1.6, Joomla 1.7. To fix this, we
can simply use DISTINCT in the sql command :

$query = 'SELECT DISTINCT u.id AS value, u.name AS text'
. ' FROM #__users AS u'
. ' JOIN #__user_usergroup_map AS m ON m.user_id = u.id'
. ' WHERE u.block = 0'

. $and
. ' ORDER BY '. $order
;

[Omar Ramos]

Has this been posted on JoomlaCode.org as a bug?

http://joomlacode.org/gf/project/joomla/tracker/?action=TrackerItemBrowse&tracker_id=8103

If not, please do so and we can make sure to get this corrected in an upcoming release.

-Omar

--
You received this message because you are subscribed to the Google Groups "Joomla! General Development" group.
To post to this group, send an email to joomla-de...@googlegroups.com.
To unsubscribe from this group, send email to joomla-dev-gene...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/joomla-dev-general?hl=en-GB.

[Steffen Janke]

I've tried to create an account there more often, but not received a confirmation email. Therefore, I can report there either.

2011/8/2 Omar Ramos <orw...@gmail.com>

[Steffen Janke]

Now the account creation has worked, and I reported it.

2011/8/2 Steffen Janke <steffe...@googlemail.com>

[Omar Ramos]

Awesome, for reference this is the link to the new tracker item Steffen created:

http://joomlacode.org/gf/project/joomla/tracker/?action=TrackerItemEdit&tracker_item_id=26564

-Omar

[elin]

Most likely that should be deprecated since it is designed for the <1.5 user table.

If you want a select list of users I would recommend using a user field type in JForm.

Elin