Help Please ! Fatal Error: Allowed Memory Size Of 134217728 Bytes Exhausted

Yii 1.1 General Discussion
1

Hi,

I received the following error using a very generic Gii controller/admin form (CGridView). It pulls in data if I go to the default controller/index page. Data set should be the same in both cases. So I have to believe the CGridView may be the difference.

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 32 bytes) in /var/www/yiiroot/framework/base/CBehavior.php on line 110

Hardware is in the cloud, RackSpace I beleive.

I searched the forum and saw the suggestion of using a memory limit statement in the index.php.

So my index.php was updated but nothing changed.

This started after I loaded 2.5 million records in the table in the database (mysql)

I have not had any other performance or memory limit errors. I am also running this on a test box in my office with only 4 gig of RAM.

My admin.php file




<?php $this->widget('zii.widgets.grid.CGridView', array(

	'id' => 'placement-stats-grid',

	'dataProvider' => $model->search(),

	'filter' => $model,

	'htmlOptions'=>array('style'=>'cursor: pointer;'),

        'selectionChanged'=>"function(id){window.location='" . Yii::app()->urlManager->createUrl($this->id.'/view', array('id'=>'')) . "'+ $.fn.yiiGridView.getSelection(id);}",

	'columns' => array(  

        'id',

        array(

                'name'   => 'placement_id',

                'value'  => 'isset($data->placement->name)?$data->placement->name:"N/A"',

                'filter' => CHtml::listData(Placement::model()->sort()->findAll(),'id','name'),

                ),

	'appnexus_id',	

	'imp_date',

	array(

		'name'   => 'imps',

		'htmlOptions' => array( 'style'=>'text-align: right' )

		),	

	array(

		'name'   => 'imps_sold',

		'htmlOptions' => array( 'style'=>'text-align: right' )

		),  

	array(

		'name'   => 'imps_default',

		'htmlOptions' => array( 'style'=>'text-align: right' )

		),     

	array(

		'name'   =>  'revenue',

		'htmlOptions' => array( 'style'=>'text-align: right' )

		),        

	array(

		'name'   => 'media_cost',

		'htmlOptions' => array( 'style'=>'text-align: right' )

		),	

	array(

		'name'   => 'sold_publisher_rpm',

		'htmlOptions' => array( 'style'=>'text-align: right' )

		),

	),

)); 

?>
2

By process of elimination I commented out the filter and it solved the problem


array(

                'name'   => 'placement_id',

                'value'  => 'isset($data->placement->name)?$data->placement->name:"N/A"',

             //   'filter' => CHtml::listData(Placement::model()->sort()->findAll(),'id','name'),

                ),
3

OPS! this solution also served to me. Thank you! :D