how to handle errors in yii

Question

I am working on an application using yii. I have an action let acmanageappointments/index. I have defined its rule as follow

array('allow', // allow authenticated user to perform 'create' and 'update' actions
                'actions'=>array('index','create','update','delete','updatestatus'),
                'users'=>array('@'),

and its action is as follow :

public function actionIndex()
    {

        $user_id = Yii::app()->user->getId();   
        $criteria = new CDbCriteria();
        $criteria->condition = 'user_id='.$user_id;
        $count=AcAppointments::model()->count($criteria);
        $pages=new CPagination($count);

        //results per page 
        $pages->pageSize=10;
        $pages->applyLimit($criteria);
        $AllAppointments = AcAppointments::model()->findAll($criteria);

        // Applying Global Date Time Format 
        $condition = array('user_id' => $user_id);
        $DTFormat = CalendarSettings::model()->findByAttributes($condition);

        $this->render('index',array(
                'AllAppointments' => $AllAppointments,
                'pages' => $pages,
                'DTFormat' => $DTFormat,
        ));


    }

This action can only be accessed with authenticated persons. when I am logged in then this function is working properly. but when I am logged out and executing this action then it gives CDbException. How can I handle this exception, and when the user is logged out and if he is trying to access this url then he should be redirected on login page . How can I do this ?

update : Here is my accessrules :

public function accessRules()
    {
        return array(
            array('allow', // allow authenticated user to perform 'create' and 'update' actions
                'actions'=>array('index','create','update','delete','updatestatus'),
                'users'=>array('@'),
            ),
            array('deny',  // deny all users
                'users'=>array('*'),
            ),
        );
    }

and here is the error :

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

What other access rules have you defined?

topher
– topher

2013-02-16 11:30:02 +00:00
Commented Feb 16, 2013 at 11:30 — topher
– topher, Commented Feb 16, 2013 at 11:30
no i havent defined any other rule

Rohitashv Singhal
– Rohitashv Singhal

2013-02-16 11:30:32 +00:00
Commented Feb 16, 2013 at 11:30 — Rohitashv Singhal
– Rohitashv Singhal, Commented Feb 16, 2013 at 11:30

Willem Renzema · Accepted Answer · 2013-02-16 16:27:29Z

1

As topher mentioned in comments, you need a filters method.

Make sure you have this in your controller, else your access rules will do nothing:

public function filters()
{
    return array(
        'accessControl', 
    );
}

If it works, give his answer credit when he updates it with this snippet.

answered Feb 16, 2013 at 16:27

Willem Renzema

5,1861 gold badge20 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ankur Agrawal · Accepted Answer · 2013-06-06 17:19:32Z

1

You can have an errorHandler setting in your config file "main.php"

'components'=>array(
    ...............
    ...............
    'errorHandler'=>array(
    // use 'site/error' action to display errors
    'errorAction'=>'site/error',
    ),
    ...............
    ...............
)

this will redirect all the exceptions to the provided URL site/error in this case.

answered Jun 6, 2013 at 17:19

Ankur Agrawal

111 bronze badge

1 Comment

Rohitashv Singhal Over a year ago

THANKS ankur ji bt, the thing which I was forgetting is the one which Willem Renzema has explained ...

topher · Accepted Answer · 2013-02-16 11:33:29Z

0

You need to define another rule that will ensure that non-authenticated users are denied access. This must be the last rule.

array('allow', // allow authenticated user to perform 'create' and 'update' actions
    'actions'=>array('index','create','update','delete','updatestatus'),
    'users'=>array('@'),
),
array('deny',
    'users'=>array('*'),
),

answered Feb 16, 2013 at 11:33

topher

14.9k8 gold badges56 silver badges71 bronze badges

7 Comments

Rohitashv Singhal Over a year ago

thnx topher, I have done that also, now I am getting the same problem

Rohitashv Singhal Over a year ago

while surfing I seen that I have to remove yii_debug from index.php, whats taht exactly

topher Over a year ago

Could you post your accessRules method?

Rohitashv Singhal Over a year ago

public function accessRules() { return array( array('allow', // allow all users to perform 'index' and 'view' actions 'actions'=>array('view','admin'), 'users'=>array('admin'), ), array('allow', // allow authenticated user to perform 'create' and 'update' actions 'actions'=>array('index','create','update','delete','updatestatus'), 'users'=>array('@'), ), array('deny', // deny all users 'users'=>array('*'), ), ); }

topher Over a year ago

It's hard to read in its current format. Update the question with this and your CDbException error message

|

Sergey · Accepted Answer · 2013-02-17 06:33:18Z

0

Check value $user_id. if you are not logged in, you get empty $user_id

$user_id = Yii::app()->user->getId();   
$criteria = new CDbCriteria();
$criteria->condition = 'user_id='.$user_id;

When you execute with this criteria you got SQL error

answered Feb 17, 2013 at 6:33

Sergey

5,20727 silver badges37 bronze badges

Collectives™ on Stack Overflow

how to handle errors in yii

4 Answers 4

Comments

1 Comment

7 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related