userlist wiki plugin paramaters sort and group can't be used together
- Status
- Closed
- Subject
- userlist wiki plugin paramaters sort and group can't be used together
- Version
- 6.x
- Category
- Error
- Feature
- Wiki Plugin (extends basic syntax)
- Submitted by
- xen
- Lastmod by
- xen
- Rating
- Description
sort and group parameters used together in th userlist plugin results in an error. The page says "An error occured while performing the request."
Example:
Plugin disabledPlugin userlist cannot be executed.
This error was traced to the order of the SQL query.- Solution
In lib/wiki-plugins/wikiplugin_userlist.php
In function wikiplugin_userlist($data, $params)line 120, the sort code (the ORDER BY) should come after group code and not before. It works when rearranged like this:
if $group {
$from .= ", users_usergroups uug";
$mid .= ' and uug.`groupName` = ? and uu.`userId` = uug.`userId`';
$bindvars[] = $group;
}
if $sort {
$sort=strtolower($sort);
if | ($sort=='desc' {
$mid .= ' ORDER BY `login` '.$sort;
}
}- Priority
- 25
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 3850
- Created
- Thursday 14 April, 2011 22:30:46 UTC
by xen - LastModif
- Thursday 26 May, 2011 02:59:05 UTC