Xarigami

project tracker

Xarigami Core [key: xgami]

All trackers
Summary
Issue List
Road Map
Changelog

Issue xgami-000873

Issue summary Details
Project:
Xarigami Core
Key:
xgami-000873
Type:
Bug
Reporter:
Jo
Priority:
High
Severity:
Major
Status:
Closed
Resolution:
Fixed
Owner:
Jo
Due:
- xarigami cumulus 1.4.0
Milestone:
None

countallactive broken in postgres

Reported:  Jul 12, 2011 02:47 AM    Updated: Jul 12, 2011 02:49 AM by

Closed: Jul 12, 2011 02:49 AM    by Jo

Version affected: - xarigami cumulus 1.3.5

Issue with select distinct and postgres9 in countallactive and get all active.

Actions

Thanks shawn.

Revision: 310a542b6df9813070d192d384cc38ce709c890e
| Parent: 9e46bcac655eec68304730514ba3b5b175475c0d
| Author: shawn.rapp@gmail.com
| Date: 12/07/2011 02:08:22
| Branch: com.2skies.xarigami.core
|
| Changelog:
|
| Removed * fields from countallactive.php statement as the fields are not needed to count rows and conditions can use fields not listed in results. Improves performance to drop unnecessary fields in returns. This fixes compatibility in PostGresql 9 which does not allow COUNT(*) to be a virtual field with result fields.
| In getallactive.php altered statement to be able to make GROUP BY work as intended in PostGreSQL 9.
|
| Changes against parent 9e46bcac655eec68304730514ba3b5b175475c0d
|
| patched html/modules/roles/xaruserapi/countallactive.php
| patched html/modules/roles/xaruserapi/getallactive.php

#