2024-03-29 10:53:39 Apache
Yii Framework/1.1.21CDbCommand 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 ') and (show_in = 'A') and del_status=0' at line 1. The SQL statement executed was: select pcid from Propcat_Master where parent_id = 1 and pcid in () and (show_in = 'A') and del_status=0
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 ') and (show_in = 'A') and del_status=0' at line 1. The SQL statement executed was: select pcid from Propcat_Master where parent_id = 1 and pcid in () and (show_in = 'A') and del_status=0
[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/public_html/protected/controllers/AgentsearchController.php(4898): CDbCommand->queryAll()
#2 /home/pricepropindi/public_html/protected/controllers/AgentsearchController.php(411): AgentSearchController->getAllSubcatsForAgent(1, '3', '51')
#3 /home/pricepropindi/yii/web/actions/CInlineAction.php(49): AgentSearchController->actionsearch_agents()
#4 /home/pricepropindi/yii/web/CController.php(308): CInlineAction->runWithParams(Array)
#5 /home/pricepropindi/yii/web/CController.php(286): CController->runAction(Object(CInlineAction))
#6 /home/pricepropindi/yii/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#7 /home/pricepropindi/yii/web/CWebApplication.php(282): CController->run('search_agents')
#8 /home/pricepropindi/yii/web/CWebApplication.php(141): CWebApplication->runController('Agentsearch/sea...')
#9 /home/pricepropindi/yii/base/CApplication.php(185): CWebApplication->processRequest()
#10 /home/pricepropindi/public_html/index.php(30): CApplication->run()
#11 {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/public_html/protected/controllers/AgentsearchController.php
[line] => 4898
[function] => queryAll
[class] => CDbCommand
[type] => ->
[args] => Array
(
)
)
[2] => Array
(
[file] => /home/pricepropindi/public_html/protected/controllers/AgentsearchController.php
[line] => 411
[function] => getAllSubcatsForAgent
[class] => AgentSearchController
[type] => ->
[args] => Array
(
[0] => 1
[1] => 3
[2] => 51
)
)
[3] => Array
(
[file] => /home/pricepropindi/yii/web/actions/CInlineAction.php
[line] => 49
[function] => actionsearch_agents
[class] => AgentSearchController
[type] => ->
[args] => Array
(
)
)
[4] => Array
(
[file] => /home/pricepropindi/yii/web/CController.php
[line] => 308
[function] => runWithParams
[class] => CInlineAction
[type] => ->
[args] => Array
(
[0] => Array
(
[loc] => palm-jumeirah
[ct] => dubai
[country] => uae
)
)
)
[5] => Array
(
[file] => /home/pricepropindi/yii/web/CController.php
[line] => 286
[function] => runAction
[class] => CController
[type] => ->
[args] => Array
(
[0] => CInlineAction Object
(
[_id:CAction:private] => search_agents
[_controller:CAction:private] => AgentSearchController Object
(
[pagtitle] =>
[indexctstname_url] => Dubai
[layout] => //layouts/pp_structure
[menu] => Array
(
)
[breadcrumbs] => Array
(
)
[defaultAction] => index
[_id:CController:private] => agentsearch
[_action:CController:private] => CInlineAction Object
*RECURSION*
[_pageTitle:CController:private] =>
[_cachingStack:CController:private] =>
[_clips:CController:private] =>
[_dynamicOutput:CController:private] =>
[_pageStates:CController:private] =>
[_module:CController:private] =>
[_widgetStack:CBaseController:private] => Array
(
)
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
)
)
[6] => Array
(
[file] => /home/pricepropindi/yii/web/CController.php
[line] => 265
[function] => runActionWithFilters
[class] => CController
[type] => ->
[args] => Array
(
[0] => CInlineAction Object
(
[_id:CAction:private] => search_agents
[_controller:CAction:private] => AgentSearchController Object
(
[pagtitle] =>
[indexctstname_url] => Dubai
[layout] => //layouts/pp_structure
[menu] => Array
(
)
[breadcrumbs] => Array
(
)
[defaultAction] => index
[_id:CController:private] => agentsearch
[_action:CController:private] => CInlineAction Object
*RECURSION*
[_pageTitle:CController:private] =>
[_cachingStack:CController:private] =>
[_clips:CController:private] =>
[_dynamicOutput:CController:private] =>
[_pageStates:CController:private] =>
[_module:CController:private] =>
[_widgetStack:CBaseController:private] => Array
(
)
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
[1] => Array
(
)
)
)
[7] => Array
(
[file] => /home/pricepropindi/yii/web/CWebApplication.php
[line] => 282
[function] => run
[class] => CController
[type] => ->
[args] => Array
(
[0] => search_agents
)
)
[8] => Array
(
[file] => /home/pricepropindi/yii/web/CWebApplication.php
[line] => 141
[function] => runController
[class] => CWebApplication
[type] => ->
[args] => Array
(
[0] => Agentsearch/search_agents
)
)
[9] => Array
(
[file] => /home/pricepropindi/yii/base/CApplication.php
[line] => 185
[function] => processRequest
[class] => CWebApplication
[type] => ->
[args] => Array
(
)
)
[10] => Array
(
[file] => /home/pricepropindi/public_html/index.php
[line] => 30
[function] => run
[class] => CApplication
[type] => ->
[args] => Array
(
)
)
)
[version] => Apache Yii Framework/1.1.21
[time] => 1711709619
[admin] => the webmaster
)