yii - Project Hosting on Google Code

Today 3 hours ago r1536 (Added CPagination::offset and CPagination::limit) committed by qiang.xue - Added CPagination::offset and CPagination::limit Added CPagination::offset and CPagination::limit 3 hours ago r1535 (refactored YiiBase::import()) committed by qiang.xue - refactored YiiBase::import() refactored YiiBase::import() 5 hours ago r1534 (refactored CLinkPager and CListPager.) committed by qiang.xue - refactored CLinkPager and CListPager. refactored CLinkPager and CListPager. 11 hours ago r1533 (merge from 1.0) committed by qiang.xue - merge from 1.0 merge from 1.0 12 hours ago r1532 ([No log message]) committed by qiang.xue - [No log message] [No log message] 21 hours ago issue 38 (CHhtml links and buttons don't work with ajax.) commented on by mirko.eesti - It`s almost a year now. What`s the status? It`s almost a year now. What`s the status? Yesterday 27 hours ago r1531 (Added CComponent::evaluateExpression().) committed by qiang.xue - Added CComponent::evaluateExpression(). Added CComponent::evaluateExpression(). 30 hours ago r1530 ([No log message]) committed by qiang.xue - [No log message] [No log message] 32 hours ago issue 685 (CDateFormatter does not support 'Z' timezone format) reported by marciodicksmiderle - What steps will reproduce the problem? 1. Use 'Z' to format a timestamp What is the expected output? What do you see instead? Should get a string like -0200, but got the 'Z' string instead. What version of the product are you using? On what operating system? yii-1.0.10.r1472 linux Please provide any additional information below. Corrected CDateFormatter is attached. What steps will reproduce the problem? 1. Use 'Z' to format a timestamp What is the expected output? What do you see instead? Should get a string like -0200, but got the 'Z' string instead. What version of the product are you using? On what operating system? yii-1.0.10.r1472 linux Please provide any additional information below. Corrected CDateFormatter is attached. 41 hours ago issue 684 (YiiBase::import() should fail noisily if set_include_path() ...) reported by sh...@node.mu - set_include_path() doesn't work if one has defined php_admin_value include_path in apache. Yiibase::import() relies on set_include_path(), but doesn't check whether it was successful. I suggest throwing an exception if set_include_path() fails. I'm using Yii 1.0.10. set_include_path() doesn't work if one has defined php_admin_value include_path in apache. Yiibase::import() relies on set_include_path(), but doesn't check whether it was successful. I suggest throwing an exception if set_include_path() fails. I'm using Yii 1.0.10. 44 hours ago r1529 ([No log message]) committed by qiang.xue - [No log message] [No log message] 44 hours ago r1528 ([No log message]) committed by qiang.xue - [No log message] [No log message] 44 hours ago r1527 (* Added CDataProvider and CActiveDataProvider) committed by qiang.xue - * Added CDataProvider and CActiveDataProvider * Added CDataProvider and CActiveDataProvider 45 hours ago r1526 (Added CSort::getOrderBy().) committed by qiang.xue - Added CSort::getOrderBy(). Added CSort::getOrderBy(). Last 7 days Nov 18, 2009 issue 682 (CExistValidator generates invalid query for text field on MS...) commented on by sanderb - Sorry this is about CUniqueValidator, not CExistValidator. Sorry this is about CUniqueValidator, not CExistValidator. Nov 18, 2009 issue 683 (CHttpSession do not support save array) reported by ukyo.pu - What steps will reproduce the problem? 1.get and open a session_obj 2.save session to session_obj like:$session_obj['test_array'] ['build_ring'] = 'Y'; 3.the session will not save this value What is the expected output? What do you see instead? It should be support this way of create and saving session. What version of the product are you using? On what operating system? 1.1a Please provide any additional information below. when using the way below is OK: $session_obj['build_ring_set'] = array('build_ring'=>'Y'); but the way below was not: $session_obj['test_array']['build_ring'] = 'Y'; What steps will reproduce the problem? 1.get and open a session_obj 2.save session to session_obj like:$session_obj['test_array'] ['build_ring'] = 'Y'; 3.the session will not save this value What is the expected output? What do you see instead? It should be support this way of create and saving session. What version of the product are you using? On what operating system? 1.1a Please provide any additional information below. when using the way below is OK: $session_obj['build_ring_set'] = array('build_ring'=>'Y'); but the way below was not: $session_obj['test_array']['build_ring'] = 'Y'; Nov 18, 2009 issue 682 (CExistValidator generates invalid query for text field on MS...) reported by sanderb - What steps will reproduce the problem? 1. Use CExistvalidator as a validator on a text field 2. Exception page shows up with the following message: CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 10007 The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. [10007] (severity 5) [(null)] What is the expected output? What do you see instead? The following SQL query was generated: Error in querying SQL: SELECT TOP 2 * FROM [dbo].[Field] WHERE ([label]=:value) AND (profile_id=:ycp0). Bind with parameter :value='High', :ycp0='1' Judging from the error message, it should instead be something like this: SELECT TOP 2 * FROM [dbo].[Field] WHERE ([label] LIKE :value) AND (profile_id=:ycp0) What version of the product are you using? On what operating system? Yii 1.1b on Windows 2003 Server (using the MSSQL PDO driver, obviously) What steps will reproduce the problem? 1. Use CExistvalidator as a validator on a text field 2. Exception page shows up with the following message: CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 10007 The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. [10007] (severity 5) [(null)] What is the expected output? What do you see instead? The following SQL query was generated: Error in querying SQL: SELECT TOP 2 * FROM [dbo].[Field] WHERE ([label]=:value) AND (profile_id=:ycp0). Bind with parameter :value='High', :ycp0='1' Judging from the error message, it should instead be something like this: SELECT TOP 2 * FROM [dbo].[Field] WHERE ([label] LIKE :value) AND (profile_id=:ycp0) What version of the product are you using? On what operating system? Yii 1.1b on Windows 2003 Server (using the MSSQL PDO driver, obviously) Nov 17, 2009 r1525 ([No log message]) committed by qiang.xue - [No log message] [No log message] Nov 17, 2009 issue 679 (对子域名路由的支持) Labels changed by qiang.xue - Fixed in 1.0.11. Labels: Milestone-1.0.11 −Milestone-1.1rc Fixed in 1.0.11. Labels: Milestone-1.0.11 −Milestone-1.1rc Nov 17, 2009 issue 679 (对子域名路由的支持) changed by qiang.xue - This issue was closed by revision r1524. Status: Fixed This issue was closed by revision r1524. Status: Fixed Nov 17, 2009 r1524 (* (Fixes issue 679) Added support for parsing and creating U...) committed by qiang.xue - * (Fixes issue 679 ) Added support for parsing and creating URLs with parameterized hostnames * (Fixes issue 679 ) Added support for parsing and creating URLs with parameterized hostnames Nov 17, 2009 issue 679 (对子域名路由的支持) commented on by qiang.xue - Also refer to: http://www.yiiframework.com/doc/cookbook/55/ Also refer to: http://www.yiiframework.com/doc/cookbook/55/ Nov 17, 2009 issue 666 (Logging facility causing memory issues and lacks flexibility) commented on by maqdev - I confirm. CLogger is unusable if you writing some long running console application. And could not extend CLogger. I totally copied this class and reimplemented to allow flush logs. I confirm. CLogger is unusable if you writing some long running console application. And could not extend CLogger. I totally copied this class and reimplemented to allow flush logs. Nov 16, 2009 issue 681 (Charset header not sended with partial_render) Status changed by qiang.xue - It is by design that Yii doesn't send any header by default. Status: WontFix It is by design that Yii doesn't send any header by default. Status: WontFix Nov 16, 2009 issue 681 (Charset header not sended with partial_render) reported by chronos290483 - What steps will reproduce the problem? 1.Create an action : public function actionTestAjax(){ return 'This line contains this following character : é'; } 2.Create an ajaxLink : <div id="#divForAjaxReturn"></div> <?php echo CHtml::ajaxLink("Test", array('testAjax'), array('update'=>'#divForAjaxReturn')); 3.Test with Firefox and IE You will not receive any response with IE. A parsererror is invoked. What is the expected output? What do you see instead? With Internet Explorer the return of ajax query is not parsed. What version of the product are you using? On what operating system? Ubuntu Karmic Koala Firefox 3.5 IE 6 and 8 on Windows XP emulated by virtualbox. Windows XP IE 7 Please provide any additional information below. This works with : public function actionTestAjax(){ header('Content-type: text/html; charset=utf-8'); return 'This line contains this following character : é'; } Sorry for my english. Ask me if any question. What steps will reproduce the problem? 1.Create an action : public function actionTestAjax(){ return 'This line contains this following character : é'; } 2.Create an ajaxLink : <div id="#divForAjaxReturn"></div> <?php echo CHtml::ajaxLink("Test", array('testAjax'), array('update'=>'#divForAjaxReturn')); 3.Test with Firefox and IE You will not receive any response with IE. A parsererror is invoked. What is the expected output? What do you see instead? With Internet Explorer the return of ajax query is not parsed. What version of the product are you using? On what operating system? Ubuntu Karmic Koala Firefox 3.5 IE 6 and 8 on Windows XP emulated by virtualbox. Windows XP IE 7 Please provide any additional information below. This works with : public function actionTestAjax(){ header('Content-type: text/html; charset=utf-8'); return 'This line contains this following character : é'; } Sorry for my english. Ask me if any question. Nov 16, 2009 issue 680 (CPhpAuthManager->save() to return boolean for success/failur...) reported by DarkNSF - It would be more consistent to have CPhpAuthManager->save() return a boolean for success/failure. It would be more consistent to have CPhpAuthManager->save() return a boolean for success/failure. Nov 16, 2009 issue 679 (对子域名路由的支持) commented on by qiang.xue - set this for 1.1 RC release. set this for 1.1 RC release. Nov 16, 2009 issue 679 (对子域名路由的支持) commented on by donzir - qiang, will you accept this issue ? qiang, will you accept this issue ? Nov 16, 2009 issue 679 (对子域名路由的支持) Labels changed by qiang.xue - Labels: Milestone-1.1rc −Milestone-1.0.11 Labels: Milestone-1.1rc −Milestone-1.0.11 Nov 16, 2009 issue 679 (对子域名路由的支持) commented on by donzir - 相关信息： ZF的实现（非常强大）：http://gonefish.cn/?cat=12 symfony的实现：http://www.symfony-project.org/blog/2009/03/02/call-the-expert-adding- subdomain-requirements-to-routing-yml 我觉得可以依照ZF的方式来进行。相关信息： ZF的实现（非常强大）：http://gonefish.cn/?cat=12 symfony的实现：http://www.symfony-project.org/blog/2009/03/02/call-the-expert-adding- subdomain-requirements-to-routing-yml 我觉得可以依照ZF的方式来进行。 Nov 16, 2009 issue 679 (对子域名路由的支持) reported by donzir - What steps will reproduce the problem? 1.当我想为模块设置子域名路由的时候，发现不可以 2.当我为参数设置域名子路由的时候，发现不可以 What is the expected output? What do you see instead? 希望像Zend Framework一样提供灵活的路由设置。 What version of the product are you using? On what operating system? 1.0.9 Please provide any additional information below. 这个功能真的很有用。我想知道yii对此是否有计划进行支持呢？ What steps will reproduce the problem? 1.当我想为模块设置子域名路由的时候，发现不可以 2.当我为参数设置域名子路由的时候，发现不可以 What is the expected output? What do you see instead? 希望像Zend Framework一样提供灵活的路由设置。 What version of the product are you using? On what operating system? 1.0.9 Please provide any additional information below. 这个功能真的很有用。我想知道yii对此是否有计划进行支持呢？ Nov 14, 2009 r1523 (Fixed the bug that CQueue::peek() should return the first it...) committed by qiang.xue - Fixed the bug that CQueue::peek() should return the first item in the queue. Fixed the bug that CQueue::peek() should return the first item in the queue. Last 30 days Nov 13, 2009 issue 678 (Output BOM after 'language' set to 'zh_tw' in CLinkPager) commented on by qiang.xue - Will need to wait for users to contribute for the updated translation. Thanks. Will need to wait for users to contribute for the updated translation. Thanks. Nov 13, 2009 issue 678 (Output BOM after 'language' set to 'zh_tw' in CLinkPager) changed by qiang.xue - This issue was closed by revision r1522. Status: Fixed This issue was closed by revision r1522. Status: Fixed Nov 13, 2009 r1522 ((Fixes issue 678)) committed by qiang.xue - (Fixes issue 678 ) (Fixes issue 678 ) Nov 13, 2009 issue 678 (Output BOM after 'language' set to 'zh_tw' in CLinkPager) commented on by Hienjningz - Sorry for chosen a wrong milestone, actually I found this problem in 1.0.10.r1472. Sorry for chosen a wrong milestone, actually I found this problem in 1.0.10.r1472. Nov 13, 2009 issue 678 (Output BOM after 'language' set to 'zh_tw' in CLinkPager) reported by Hienjningz - I found a strange behavior in yii-1.0.10.r1472, that it output a BOM after 'language' set to 'zh_tw' when use CLinkPager. I've tried this out by set 'language' to 'zh_tw' in the main configuration of demos/blog, and post enough posts to makes the pager appears, then I got a BOM (0xFEFF) from the final render result. BTW, caption of the CLinkPager still English, haven't translated yet. I found a strange behavior in yii-1.0.10.r1472, that it output a BOM after 'language' set to 'zh_tw' when use CLinkPager. I've tried this out by set 'language' to 'zh_tw' in the main configuration of demos/blog, and post enough posts to makes the pager appears, then I got a BOM (0xFEFF) from the final render result. BTW, caption of the CLinkPager still English, haven't translated yet. Nov 13, 2009 issue 675 (Count with Group By) commented on by hmsegura - I think you will find the solution in http://www.yiiframework.com/forum/index.php?/topic/5504-countcdbcriteria-with-distinct-and-select-params/ I think you will find the solution in http://www.yiiframework.com/forum/index.php?/topic/5504-countcdbcriteria-with-distinct-and-select-params/ Nov 12, 2009 issue 677 (CPgsqlColumnSchema::extractType() not enough precize) reported by eliovir - What steps will reproduce the problem? 1. for a smallint column 2. use db->extractType() 3. you'll get string What is the expected output? What do you see instead? integer What version of the product are you using? On what operating system? trunk Please provide any additional information below. This is a more (certainly not exhaustive) function protected function extractType($dbType) { if(preg_match('/(integer\|oid\|serial\|bigint\|smallint)/',$dbType)) $this->type='integer'; else if(strpos($dbType,'bool')!==false) $this->type='boolean'; else if(preg_match('/(real\|float\|double\|numeric)/',$dbType)) $this->type='double'; else if(strpos($dbType,'timestamp')!==false) $this->type='datetime'; else if(strpos($dbType,'date')!==false) $this->type='date'; else $this->type='string'; } NB: * data types in French: http://docs.postgresqlfr.org/8.3/datatype.html * data types in English: http://www.postgresql.org/docs/8.3/static/datatype.html What steps will reproduce the problem? 1. for a smallint column 2. use db->extractType() 3. you'll get string What is the expected output? What do you see instead? integer What version of the product are you using? On what operating system? trunk Please provide any additional information below. This is a more (certainly not exhaustive) function protected function extractType($dbType) { if(preg_match('/(integer\|oid\|serial\|bigint\|smallint)/',$dbType)) $this->type='integer'; else if(strpos($dbType,'bool')!==false) $this->type='boolean'; else if(preg_match('/(real\|float\|double\|numeric)/',$dbType)) $this->type='double'; else if(strpos($dbType,'timestamp')!==false) $this->type='datetime'; else if(strpos($dbType,'date')!==false) $this->type='date'; else $this->type='string'; } NB: * data types in French: http://docs.postgresqlfr.org/8.3/datatype.html * data types in English: http://www.postgresql.org/docs/8.3/static/datatype.html Nov 12, 2009 issue 675 (Count with Group By) commented on by sebathi - I think to made a select of the group by like this: SELECT count() FROM (SELECT group_by_selection FROM `table` GROUP BY group_by_selection) as XXX I think to made a select of the group by like this: SELECT count() FROM (SELECT group_by_selection FROM `table` GROUP BY group_by_selection) as XXX Nov 12, 2009 issue 675 (Count with Group By) commented on by Twelve.60 - model()->count($criteria) should check if $criteria->group exists, if it does, do a count of the count, e.g. SELECT COUNT() FROM (SELECT COUNT() FROM `ggstats_player_cache` GROUP BY player_id ORDER BY a_damage_per_round_real DESC) as xxx model()->count($criteria) should check if $criteria->group exists, if it does, do a count of the count, e.g. SELECT COUNT() FROM (SELECT COUNT() FROM `ggstats_player_cache` GROUP BY player_id ORDER BY a_damage_per_round_real DESC) as xxx Nov 12, 2009 issue 675 (Count with Group By) commented on by hmsegura - hi a similar problem here http://www.yiiframework.com/forum/index.php?/topic/5504-countcdbcriteria-with-distinct-and-select-params/ hi a similar problem here http://www.yiiframework.com/forum/index.php?/topic/5504-countcdbcriteria-with-distinct-and-select-params/ Nov 12, 2009 issue 676 (CDbCritera::mergeWith ignores different parameter bindings [...) reported by sanderb - I described this problem in a forum thread here: http://www.yiiframework.com/forum/index.php?/topic/5532-cdbcriteria-mergewith-is-replacing-instead-of-merging/ I found that the problem was that Yii doesn't take into account different parameter bindings between the two merging CDbCriteria objects, and subsequently fails to merge them properly. I think I fixed this (at least for my situation, but I believe it will apply globally), for my solution see the attached file. I'm sorry I couldn't provide a proper patch, somehow I couldn't get Eclipse to create a patch from local history (I'm not using version control for my current project yet). This fix is for Yii 1.1b. Feel free to ask me if there's a problem with my solution or if you need more clarification :) I described this problem in a forum thread here: http://www.yiiframework.com/forum/index.php?/topic/5532-cdbcriteria-mergewith-is-replacing-instead-of-merging/ I found that the problem was that Yii doesn't take into account different parameter bindings between the two merging CDbCriteria objects, and subsequently fails to merge them properly. I think I fixed this (at least for my situation, but I believe it will apply globally), for my solution see the attached file. I'm sorry I couldn't provide a proper patch, somehow I couldn't get Eclipse to create a patch from local history (I'm not using version control for my current project yet). This fix is for Yii 1.1b. Feel free to ask me if there's a problem with my solution or if you need more clarification :) Nov 11, 2009 issue 675 (Count with Group By) commented on by Twelve.60 - Temp Solution ending up being: $rows = Yii::app()->db->createCommand('SELECT COUNT(DISTINCT player_id) FROM `'.PlayerCache::tableName().'`')->queryScalar(); Temp Solution ending up being: $rows = Yii::app()->db->createCommand('SELECT COUNT(DISTINCT player_id) FROM `'.PlayerCache::tableName().'`')->queryScalar(); Nov 11, 2009 issue 563 (AR Relation (multiple) Primary Key in MSSQL) commented on by blackjenova - now by using: yii-1.0.10.r1472 I got an error (where it's not in 1.0.8): "CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 10007 Invalid column name 'uid'. [10007] (severity 5) [(null)]" now by using: yii-1.0.10.r1472 I got an error (where it's not in 1.0.8): "CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 10007 Invalid column name 'uid'. [10007] (severity 5) [(null)]" Nov 11, 2009 issue 563 (AR Relation (multiple) Primary Key in MSSQL) commented on by blackjenova - sorry, just read it. How can I get the generated SQL ? sorry, just read it. How can I get the generated SQL ? Nov 11, 2009 issue 675 (Count with Group By) reported by Twelve.60 - What steps will reproduce the problem? 1. Doing a 'Group By' query with ActiveRecord (my example below) <?php $criteria=new CDbCriteria; $criteria->select = 'player_id as id' .', SUM(c_kills) as c_kills' .', SUM(c_deaths) as c_deaths' .', SUM(c_assists) as c_assists' .', IFNULL(SUM(s_damage_real)/SUM(c_rounds_total), 0) as a_damage_per_round_real' .', SUM(c_rounds_total) as c_rounds_total'; $criteria->group = 'player_id'; $criteria->order = 'a_damage_per_round_real DESC'; echo PlayerCache::model()->count($criteria); ?> Query Performed (Got using trace): SELECT COUNT() FROM `ggstats_player_cache` GROUP BY player_id ORDER BY a_damage_per_round_real DESC What is the expected output? What do you see instead? PlayerCache::model()->count($criteria) should return the number of rows returned (e.g. the number of players found). Instead it grabs the first value of the first row returned (e.g. number of occurances of the first player found). What version of the product are you using? On what operating system? yii-1.0.10.r1472 - Linux Fedora Please provide any additional information below. What steps will reproduce the problem? 1. Doing a 'Group By' query with ActiveRecord (my example below) <?php $criteria=new CDbCriteria; $criteria->select = 'player_id as id' .', SUM(c_kills) as c_kills' .', SUM(c_deaths) as c_deaths' .', SUM(c_assists) as c_assists' .', IFNULL(SUM(s_damage_real)/SUM(c_rounds_total), 0) as a_damage_per_round_real' .', SUM(c_rounds_total) as c_rounds_total'; $criteria->group = 'player_id'; $criteria->order = 'a_damage_per_round_real DESC'; echo PlayerCache::model()->count($criteria); ?> Query Performed (Got using trace): SELECT COUNT() FROM `ggstats_player_cache` GROUP BY player_id ORDER BY a_damage_per_round_real DESC What is the expected output? What do you see instead? PlayerCache::model()->count($criteria) should return the number of rows returned (e.g. the number of players found). Instead it grabs the first value of the first row returned (e.g. number of occurances of the first player found). What version of the product are you using? On what operating system? yii-1.0.10.r1472 - Linux Fedora Please provide any additional information below. Nov 11, 2009 issue 674 (Postgresql composite primary key with autoincrement) reported by makro76 - What steps will reproduce the problem? 1. Using active record, after new record insert, it doesn't return new value for autoincrement column in PK What is the expected output? What do you see instead? I'm expecting new value from table sequence A null value is return What version of the product are you using? On what operating system? Yii 1.1b on linux The problem is probably in CPgsqlSchema.php file in function createTable on line 90. It doesn't consider a sequence if primary key is made by more than 1 column. Here's my fix... hope it can be useful @@ -89,7 +89,18 @@ if(is_string($table->primaryKey) && isset($this->_sequences[$table->primaryKey])) $table->sequenceName=$this->_sequences[$table->primaryKey]; - + else if(is_array($table->primaryKey)) + { + foreach($table->primaryKey as $pk) + { + if(isset($this->_sequences[$pk])) + { + $table->sequenceName=$this->_sequences[$pk]; + break; + } + } + } + return $table; } What steps will reproduce the problem? 1. Using active record, after new record insert, it doesn't return new value for autoincrement column in PK What is the expected output? What do you see instead? I'm expecting new value from table sequence A null value is return What version of the product are you using? On what operating system? Yii 1.1b on linux The problem is probably in CPgsqlSchema.php file in function createTable on line 90. It doesn't consider a sequence if primary key is made by more than 1 column. Here's my fix... hope it can be useful @@ -89,7 +89,18 @@ if(is_string($table->primaryKey) && isset($this->_sequences[$table->primaryKey])) $table->sequenceName=$this->_sequences[$table->primaryKey]; - + else if(is_array($table->primaryKey)) + { + foreach($table->primaryKey as $pk) + { + if(isset($this->_sequences[$pk])) + { + $table->sequenceName=$this->_sequences[$pk]; + break; + } + } + } + return $table; } Nov 10, 2009 r1521 (merge from 1.0) committed by qiang.xue - merge from 1.0 merge from 1.0 Nov 10, 2009 issue 672 (italian translation for views) changed by qiang.xue - This issue was closed by revision r1520. Status: Fixed This issue was closed by revision r1520. Status: Fixed

issue 675 (Count with Group By) reported by Twelve.60 - What steps will reproduce the problem? 1. Doing a 'Group By' query with ActiveRecord (my example below) <?php $criteria=new CDbCriteria; $criteria->select = 'player_id as id' .', SUM(c_kills) as c_kills' .', SUM(c_deaths) as c_deaths' .', SUM(c_assists) as c_assists' .', IFNULL(SUM(s_damage_real)/SUM(c_rounds_total), 0) as a_damage_per_round_real' .', SUM(c_rounds_total) as c_rounds_total'; $criteria->group = 'player_id'; $criteria->order = 'a_damage_per_round_real DESC'; echo PlayerCache::model()->count($criteria); ?> Query Performed (Got using trace): SELECT COUNT(*) FROM `ggstats_player_cache` GROUP BY player_id ORDER BY a_damage_per_round_real DESC What is the expected output? What do you see instead? PlayerCache::model()->count($criteria) should return the number of rows returned (e.g. the number of players found). Instead it grabs the first value of the first row returned (e.g. number of occurances of the first player found). What version of the product are you using? On what operating system? yii-1.0.10.r1472 - Linux Fedora Please provide any additional information below.

What steps will reproduce the problem? 1. Doing a 'Group By' query with ActiveRecord (my example below) <?php $criteria=new CDbCriteria; $criteria->select = 'player_id as id' .', SUM(c_kills) as c_kills' .', SUM(c_deaths) as c_deaths' .', SUM(c_assists) as c_assists' .', IFNULL(SUM(s_damage_real)/SUM(c_rounds_total), 0) as a_damage_per_round_real' .', SUM(c_rounds_total) as c_rounds_total'; $criteria->group = 'player_id'; $criteria->order = 'a_damage_per_round_real DESC'; echo PlayerCache::model()->count($criteria); ?> Query Performed (Got using trace): SELECT COUNT(*) FROM `ggstats_player_cache` GROUP BY player_id ORDER BY a_damage_per_round_real DESC What is the expected output? What do you see instead? PlayerCache::model()->count($criteria) should return the number of rows returned (e.g. the number of players found). Instead it grabs the first value of the first row returned (e.g. number of occurances of the first player found). What version of the product are you using? On what operating system? yii-1.0.10.r1472 - Linux Fedora Please provide any additional information below.

Today

Yesterday

Last 7 days

Last 30 days