Bug #353

ACP - group # of users when using additional groups bug

Added by Ryan Gordon about 1 year ago. Updated 12 months ago.

Status:Closed Start:08/08/2009
Priority:Normal Due date:
Assigned to:Ryan Gordon % Done:

100%

Category:Admin Control Panel
Target version:1.4.10
Reproducibility: Browser:
Reported In MyBB Version:1.4.8 Database Type:
PHP Version: Database Version:

Description

in the admin\modules\users\groups.php file in the query:

Code:
default:
$query = $db->query("
SELECT g.gid, COUNT AS users
FROM ".TABLE_PREFIX."users u
LEFT JOIN ".TABLE_PREFIX."usergroups g ON (CONCAT LIKE CONCAT)
WHERE g.gid != '0' AND g.gid != NULL GROUP BY g.gid

the !=NULL should be is not null.

Associated revisions

Revision 4417
Added by Ryan Gordon about 1 year ago

Fixes ACP - group # of users when using additional groups bug (fixes:353)

History

Updated by Ryan Gordon about 1 year ago

  • Status changed from Assigned to Resolved
  • % Done changed from 0 to 100

Applied in changeset r4417.

Updated by Stefan T. about 1 year ago

  • Status changed from Resolved to Closed

Updated by Ryan Gordon 12 months ago

  • Target version changed from 1.4.9 to 1.4.10
  • Reported In MyBB Version set to 1.4.8

Also available in: Atom PDF