Oops!!! Something Went Wrong. We will be back soon.

The above error occurred when the Web server was processing your request.
If you think this is a server error, please contact the webmaster.
THANK YOU.
2024-03-28 08:05:48 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', '53')
#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] => 53
                        )

                )

            [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] => al-rawda
                                    [ct] => abu-dhabi
                                    [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] => Abu Dhabi
                                            [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] => Abu Dhabi
                                            [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] => 1711613148
    [admin] => the webmaster
)