Array ( [code] => 500 [type] => CDbException [errorCode] => 42000 [message] => 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 MariaDB server version for the right syntax to use near ')' at line 1. The SQL statement executed was: SELECT * FROM `Country_Master` `t` WHERE cmid in () [file] => /home/pricepropindi/yii/db/CDbCommand.php [line] => 543 [trace] => #0 /home/pricepropindi/yii/db/CDbCommand.php(396): CDbCommand->queryInternal('fetchAll', Array, Array) #1 /home/pricepropindi/yii/db/ar/CActiveRecord.php(1359): CDbCommand->queryAll() #2 /home/pricepropindi/yii/db/ar/CActiveRecord.php(1478): CActiveRecord->query(Object(CDbCriteria), true) #3 /home/pricepropindi/public_html/protected/extensions/components/MyClass.php(11): CActiveRecord->findAll('cmid in ()') #4 /home/pricepropindi/public_html/protected/controllers/JobservicesearchController.php(1044): MyClass->Country_Info(NULL) #5 /home/pricepropindi/public_html/themes/pp/views/layouts/header_common.php(335): JobServiceSearchController->GetfunctionForCityStateCond2(NULL) #6 /home/pricepropindi/yii/web/CBaseController.php(126): require('/home/priceprop...') #7 /home/pricepropindi/yii/web/CBaseController.php(95): CBaseController->renderInternal('/home/priceprop...', Array, true) #8 /home/pricepropindi/yii/web/widgets/CContentDecorator.php(76): CBaseController->renderFile('/home/priceprop...', Array, true) #9 /home/pricepropindi/yii/web/widgets/CContentDecorator.php(54): CContentDecorator->decorate('') #10 /home/pricepropindi/yii/web/widgets/COutputProcessor.php(44): CContentDecorator->processOutput('') #11 /home/pricepropindi/yii/web/CBaseController.php(215): COutputProcessor->run() #12 /home/pricepropindi/yii/web/CBaseController.php(309): CBaseController->endWidget('CContentDecorat...') #13 /home/pricepropindi/public_html/themes/pp/views/layouts/pp_structure.php(203): CBaseController->endContent() #14 /home/pricepropindi/yii/web/CBaseController.php(126): require('/home/priceprop...') #15 /home/pricepropindi/yii/web/CBaseController.php(95): CBaseController->renderInternal('/home/priceprop...', Array, true) #16 /home/pricepropindi/yii/web/CController.php(787): CBaseController->renderFile('/home/priceprop...', Array, true) #17 /home/pricepropindi/public_html/protected/controllers/JobservicesearchController.php(1029): CController->render('job_search_resu...', Array) #18 /home/pricepropindi/yii/web/actions/CInlineAction.php(49): JobServiceSearchController->actionJobSearchResult() #19 /home/pricepropindi/yii/web/CController.php(308): CInlineAction->runWithParams(Array) #20 /home/pricepropindi/yii/web/CController.php(286): CController->runAction(Object(CInlineAction)) #21 /home/pricepropindi/yii/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array) #22 /home/pricepropindi/yii/web/CWebApplication.php(282): CController->run('JobSearchResult') #23 /home/pricepropindi/yii/web/CWebApplication.php(141): CWebApplication->runController('Jobservicesearc...') #24 /home/pricepropindi/yii/base/CApplication.php(185): CWebApplication->processRequest() #25 /home/pricepropindi/public_html/index.php(30): CApplication->run() #26 {main} [traces] => Array ( [0] => Array ( [file] => /home/pricepropindi/yii/db/CDbCommand.php [line] => 396 [function] => queryInternal [class] => CDbCommand [type] => -> [args] => Array ( [0] => fetchAll [1] => Array ( [0] => 2 ) [2] => Array ( ) ) ) [1] => Array ( [file] => /home/pricepropindi/yii/db/ar/CActiveRecord.php [line] => 1359 [function] => queryAll [class] => CDbCommand [type] => -> [args] => Array ( ) ) [2] => Array ( [file] => /home/pricepropindi/yii/db/ar/CActiveRecord.php [line] => 1478 [function] => query [class] => CActiveRecord [type] => -> [args] => Array ( [0] => CDbCriteria Object ( [select] => * [distinct] => [condition] => cmid in () [params] => Array ( ) [limit] => -1 [offset] => -1 [order] => [group] => [join] => [having] => [with] => [alias] => [together] => [index] => [scopes] => [_e:CComponent:private] => [_m:CComponent:private] => ) [1] => 1 ) ) [3] => Array ( [file] => /home/pricepropindi/public_html/protected/extensions/components/MyClass.php [line] => 11 [function] => findAll [class] => CActiveRecord [type] => -> [args] => Array ( [0] => cmid in () ) ) [4] => Array ( [file] => /home/pricepropindi/public_html/protected/controllers/JobservicesearchController.php [line] => 1044 [function] => Country_Info [class] => MyClass [type] => -> [args] => Array ( [0] => ) ) [5] => Array ( [file] => /home/pricepropindi/public_html/themes/pp/views/layouts/header_common.php [line] => 335 [function] => GetfunctionForCityStateCond2 [class] => JobServiceSearchController [type] => -> [args] => Array ( [0] => ) ) [6] => Array ( [file] => /home/pricepropindi/yii/web/CBaseController.php [line] => 126 [args] => Array ( [0] => /home/pricepropindi/public_html/themes/pp/views/layouts/header_common.php ) [function] => require ) [7] => Array ( [file] => /home/pricepropindi/yii/web/CBaseController.php [line] => 95 [function] => renderInternal [class] => CBaseController [type] => -> [args] => Array ( [0] => /home/pricepropindi/public_html/themes/pp/views//layouts/header_common.php [1] => Array ( [content] => ) [2] => 1 ) ) [8] => Array ( [file] => /home/pricepropindi/yii/web/widgets/CContentDecorator.php [line] => 76 [function] => renderFile [class] => CBaseController [type] => -> [args] => Array ( [0] => /home/pricepropindi/public_html/themes/pp/views//layouts/header_common.php [1] => Array ( [content] => ) [2] => 1 ) ) [9] => Array ( [file] => /home/pricepropindi/yii/web/widgets/CContentDecorator.php [line] => 54 [function] => decorate [class] => CContentDecorator [type] => -> [args] => Array ( [0] => ) ) [10] => Array ( [file] => /home/pricepropindi/yii/web/widgets/COutputProcessor.php [line] => 44 [function] => processOutput [class] => CContentDecorator [type] => -> [args] => Array ( [0] => ) ) [11] => Array ( [file] => /home/pricepropindi/yii/web/CBaseController.php [line] => 215 [function] => run [class] => COutputProcessor [type] => -> [args] => Array ( ) ) [12] => Array ( [file] => /home/pricepropindi/yii/web/CBaseController.php [line] => 309 [function] => endWidget [class] => CBaseController [type] => -> [args] => Array ( [0] => CContentDecorator ) ) [13] => Array ( [file] => /home/pricepropindi/public_html/themes/pp/views/layouts/pp_structure.php [line] => 203 [function] => endContent [class] => CBaseController [type] => -> [args] => Array ( ) ) [14] => Array ( [file] => /home/pricepropindi/yii/web/CBaseController.php [line] => 126 [args] => Array ( [0] => /home/pricepropindi/public_html/themes/pp/views/layouts/pp_structure.php ) [function] => require ) [15] => Array ( [file] => /home/pricepropindi/yii/web/CBaseController.php [line] => 95 [function] => renderInternal [class] => CBaseController [type] => -> [args] => Array ( [0] => /home/pricepropindi/public_html/themes/pp/views//layouts/pp_structure.php [1] => Array ( [content] =>