2. PHPRunner General questions
  3. Wrong count of records and search error on list page
This topic is locked

Wrong count of records and search error on list page

 		2/5/2008 7:26:30 PM
PHPRunner General questions
V
 vytb author

The records are counted as "Details found: 1 Page 1 of 1 " and while trying to search I get get an error "Invalid use of group function"

with the following query which otherwise works OK. Where is the problem? php version is 4.1.320
[codebox]select `_st_inter`.`SubjectId`,

`population`.`data`,

`_st_inter`.`Last_update`,

count(`_st_course`.`SubjectId`) as `Course_count`

From `_st_inter`

left Join `population` ON `_st_inter`.`SubjectId` = `population`.`subjectID`

left Join `_st_course` ON `_st_inter`.`SubjectId` = `_st_course`.`subjectID`

group by `_st_inter`.`SubjectId`[/codebox]
Alexey admin 2/6/2008

Hi,
PHPRunner currently can not count records in group by query properly.

We'll fix this issue in PHPRunner 4.2
I recommend you to create a view for your query in the database using CREATE VIEW command.

Then use this view in PHPRunner.
V
 		vytb author 2/15/2008

Hi,

PHPRunner currently can not count records in group by query properly.

We'll fix this issue in PHPRunner 4.2
I recommend you to create a view for your query in the database using CREATE VIEW command.

Then use this view in PHPRunner.



Hi again,
Is this issue fixed int the curent beta of PHPR?