Bug #353

ACP - group # of users when using additional groups bug

Added by Ryan Gordon over 2 years ago. Updated over 2 years ago.

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

100%

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

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 over 2 years ago

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

History

Updated by Ryan Gordon over 2 years ago

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

Applied in changeset r4417.

Updated by Stefan T. over 2 years ago

  • Status changed from Resolved to Closed

Updated by Ryan Gordon over 2 years 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