Database Error

Error: 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 ') )) OR (`Client`.`id` IN (select distinct(id) from agd_clients as Client ' at line 7

SQL Query: SELECT `Client`.`id`, `Client`.`category_id` FROM `indexeg_new2014`.`agd_clients` AS `Client` WHERE `Client`.`category_id` IS NULL AND ((`Client`.`id` IN (select distinct(client_id) from agd_branches as Branch where `Branch`.`region_id` in (SELECT `r1`.`id` FROM agd_regions r1 JOIN agd_regions r2 ON `r1`.`lft` >= `r2`.`lft` AND `r1`.`rght` <= `r2`.`rght` WHERE `r2`.`id` = ) )) OR (`Client`.`id` IN (select distinct(id) from agd_clients as Client where `Client`.`company_name` like '%%' or `Client`.`business_field` like '%%' or `Client`.`keywords` like '%%' or `Client`.`id` in (SELECT DISTINCT(foreign_key) FROM agd_i18n as I18n WHERE content LIKE '%%' and model='Client')))) GROUP BY `Client`.`category_id`

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

Stack Trace

• CORE/Cake/Model/Datasource/DboSource.php line 460 → PDOStatement->execute(array)

          try {
              $query = $this->_connection->prepare($sql, $prepareOptions);
              $query->setFetchMode(PDO::FETCH_LAZY);
              if (!$query->execute($params)) {
                  $this->_results = $query;

  array()

• CORE/Cake/Model/Datasource/DboSource.php line 426 → DboSource->_execute(string, array)

          $options += array('log' => $this->fullDebug);
  
          $t = microtime(true);
          $this->_result = $this->_execute($sql, $params);
  

  'SELECT `Client`.`id`, `Client`.`category_id` FROM `indexeg_new2014`.`agd_clients` AS `Client`   WHERE `Client`.`category_id` IS NULL AND ((`Client`.`id` IN (select distinct(client_id) from agd_branches as Branch
                              where
                              `Branch`.`region_id` in
                              (SELECT `r1`.`id` FROM agd_regions r1
                              JOIN agd_regions r2 ON `r1`.`lft` >= `r2`.`lft` AND `r1`.`rght` <= `r2`.`rght`
                              WHERE `r2`.`id` = 
                              ) )) OR (`Client`.`id` IN (select distinct(id) from agd_clients as Client
                              where
                              `Client`.`company_name` like '%%' or
                              `Client`.`business_field` like '%%' or
                              `Client`.`keywords` like '%%' or
                              `Client`.`id` in
                              (SELECT DISTINCT(foreign_key)
                                      FROM agd_i18n as I18n
                                      WHERE
                                      content LIKE '%%' and model='Client'))))  GROUP BY `Client`.`category_id`'
  array()

• CORE/Cake/Model/Datasource/DboSource.php line 666 → DboSource->execute(string, array, array)

          if ($cache && ($cached = $this->getQueryCache($sql, $params)) !== false) {
              return $cached;
          }
          if ($result = $this->execute($sql, array(), $params)) {
              $out = array();

  'SELECT `Client`.`id`, `Client`.`category_id` FROM `indexeg_new2014`.`agd_clients` AS `Client`   WHERE `Client`.`category_id` IS NULL AND ((`Client`.`id` IN (select distinct(client_id) from agd_branches as Branch
                              where
                              `Branch`.`region_id` in
                              (SELECT `r1`.`id` FROM agd_regions r1
                              JOIN agd_regions r2 ON `r1`.`lft` >= `r2`.`lft` AND `r1`.`rght` <= `r2`.`rght`
                              WHERE `r2`.`id` = 
                              ) )) OR (`Client`.`id` IN (select distinct(id) from agd_clients as Client
                              where
                              `Client`.`company_name` like '%%' or
                              `Client`.`business_field` like '%%' or
                              `Client`.`keywords` like '%%' or
                              `Client`.`id` in
                              (SELECT DISTINCT(foreign_key)
                                      FROM agd_i18n as I18n
                                      WHERE
                                      content LIKE '%%' and model='Client'))))  GROUP BY `Client`.`category_id`'
  array()
  array()

• CORE/Cake/Model/Datasource/DboSource.php line 1077 → DboSource->fetchAll(string, boolean)

  
          $query = trim($this->generateAssociationQuery($model, null, null, null, null, $queryData, false, $null));
  
          $resultSet = $this->fetchAll($query, $model->cacheQueries);
  

  'SELECT `Client`.`id`, `Client`.`category_id` FROM `indexeg_new2014`.`agd_clients` AS `Client`   WHERE `Client`.`category_id` IS NULL AND ((`Client`.`id` IN (select distinct(client_id) from agd_branches as Branch
                              where
                              `Branch`.`region_id` in
                              (SELECT `r1`.`id` FROM agd_regions r1
                              JOIN agd_regions r2 ON `r1`.`lft` >= `r2`.`lft` AND `r1`.`rght` <= `r2`.`rght`
                              WHERE `r2`.`id` = 
                              ) )) OR (`Client`.`id` IN (select distinct(id) from agd_clients as Client
                              where
                              `Client`.`company_name` like '%%' or
                              `Client`.`business_field` like '%%' or
                              `Client`.`keywords` like '%%' or
                              `Client`.`id` in
                              (SELECT DISTINCT(foreign_key)
                                      FROM agd_i18n as I18n
                                      WHERE
                                      content LIKE '%%' and model='Client'))))  GROUP BY `Client`.`category_id`'
  false

• CORE/Cake/Model/Model.php line 2750 → DboSource->read(Client, array)

   * @return array
   */
      protected function _readDataSource($type, $query) {
          $results = $this->getDataSource()->read($this, $query);
          $this->resetAssociations();

  object(Client) {
  	name => 'Client'
  	virtualFields => array(
  		[maximum depth reached]
  	)
  	validate => array(
  		[maximum depth reached]
  	)
  	belongsTo => array(
  		[maximum depth reached]
  	)
  	hasMany => array(
  		[maximum depth reached]
  	)
  	hasOne => array(
  		[maximum depth reached]
  	)
  	useCache => true
  	actsAs => array(
  		[maximum depth reached]
  	)
  	useDbConfig => 'default'
  	useTable => 'clients'
  	id => false
  	data => array([maximum depth reached])
  	schemaName => 'indexeg_new2014'
  	table => 'clients'
  	primaryKey => 'id'
  	validationErrors => array([maximum depth reached])
  	validationDomain => null
  	tablePrefix => 'agd_'
  	plugin => 'Indexeg'
  	alias => 'Client'
  	tableToModel => array(
  		[maximum depth reached]
  	)
  	cacheQueries => false
  	hasAndBelongsToMany => array([maximum depth reached])
  	Behaviors => object(BehaviorCollection) {}
  	whitelist => array([maximum depth reached])
  	cacheSources => true
  	findQueryType => 'list'
  	recursive => (int) -1
  	order => null
  	__backAssociation => array([maximum depth reached])
  	__backInnerAssociation => array([maximum depth reached])
  	__backOriginalAssociation => array([maximum depth reached])
  	__backContainableAssociation => array([maximum depth reached])
  	findMethods => array(
  		[maximum depth reached]
  	)
  	[protected] _displayFields => array([maximum depth reached])
  	[protected] _editFields => array([maximum depth reached])
  	[protected] _schema => array(
  		[maximum depth reached]
  	)
  	[protected] _associationKeys => array(
  		[maximum depth reached]
  	)
  	[protected] _associations => array(
  		[maximum depth reached]
  	)
  	[protected] _insertID => null
  	[protected] _sourceConfigured => true
  	[protected] _eventManager => object(CakeEventManager) {}
  	[protected] _validator => null
  }
  array(
  	'conditions' => array(
  		'Client.category_id' => null,
  		'OR' => array(
  			[maximum depth reached]
  		)
  	),
  	'fields' => array(
  		(int) 0 => 'Client.id',
  		(int) 1 => 'Client.category_id'
  	),
  	'joins' => array(),
  	'limit' => null,
  	'offset' => null,
  	'order' => array(
  		(int) 0 => null
  	),
  	'page' => (int) 1,
  	'group' => array(
  		(int) 0 => 'Client.category_id'
  	),
  	'callbacks' => true,
  	'recursive' => (int) -1,
  	'list' => array(
  		'groupPath' => null,
  		'valuePath' => '{n}.Client.category_id',
  		'keyPath' => '{n}.Client.id'
  	)
  )

• CORE/Cake/Model/Model.php line 2722 → Model->_readDataSource(string, array)

              return null;
          }
  
          return $this->_readDataSource($type, $query);
      }

  'list'
  array(
  	'conditions' => array(
  		'Client.category_id' => null,
  		'OR' => array(
  			[maximum depth reached]
  		)
  	),
  	'fields' => array(
  		(int) 0 => 'Client.id',
  		(int) 1 => 'Client.category_id'
  	),
  	'joins' => array(),
  	'limit' => null,
  	'offset' => null,
  	'order' => array(
  		(int) 0 => null
  	),
  	'page' => (int) 1,
  	'group' => array(
  		(int) 0 => 'Client.category_id'
  	),
  	'callbacks' => true,
  	'recursive' => (int) -1,
  	'list' => array(
  		'groupPath' => null,
  		'valuePath' => '{n}.Client.category_id',
  		'keyPath' => '{n}.Client.id'
  	)
  )

• [internal function] → Model->find(string, array)

  'list'
  array(
  	'conditions' => array(
  		'Client.category_id' => null,
  		'OR' => array(
  			[maximum depth reached]
  		)
  	),
  	'group' => array(
  		(int) 0 => 'Client.category_id'
  	),
  	'recursive' => (int) -1,
  	'fields' => array(
  		(int) 0 => 'Client.id',
  		(int) 1 => 'Client.category_id'
  	)
  )

• APP/Plugin/Croogo/Model/CroogoAppModel.php line 81 → call_user_func_array(array, array)

          }
  
          $args = func_get_args();
          $results = call_user_func_array(array('parent', 'find'), $args);
          if ($this->useCache) {

  array(
  	(int) 0 => 'parent',
  	(int) 1 => 'find'
  )
  array(
  	(int) 0 => 'list',
  	(int) 1 => array(
  		'conditions' => array(
  			[maximum depth reached]
  		),
  		'group' => array(
  			[maximum depth reached]
  		),
  		'recursive' => (int) -1,
  		'fields' => array(
  			[maximum depth reached]
  		)
  	)
  )

• APP/Plugin/Indexeg/Controller/ClientsController.php line 290 → CroogoAppModel->find(string, array)

                  'Client.id',
                  'Client.category_id'
              )
          ));
          $this->Session->write('SRHCATS',$categories);

  'list'
  array(
  	'conditions' => array(
  		'Client.category_id' => null,
  		'OR' => array(
  			[maximum depth reached]
  		)
  	),
  	'group' => array(
  		(int) 0 => 'Client.category_id'
  	),
  	'recursive' => (int) -1,
  	'fields' => array(
  		(int) 0 => 'Client.id',
  		(int) 1 => 'Client.category_id'
  	)
  )

• APP/Plugin/Indexeg/Controller/ClientsController.php line 197 → ClientsController->_advancedSearch(integer, null, null, null, null, null)

              $region = Sanitize::clean($this->request->params['named']['region']);
              $city = Sanitize::clean($this->request->params['named']['city']);
  
              $this->set('clients',$this->_advancedSearch($limit,$name, $category, $country, $region, $city));
          }

  (int) 10
  null
  null
  null
  null
  null

• [internal function] → ClientsController->search(string, string, string, string)

  'www.eldib-office.com'
  'eng'
  'search'
  'www.eldib-office.com'

• CORE/Cake/Controller/Controller.php line 490 → ReflectionMethod->invokeArgs(ClientsController, array)

                      'action' => $request->params['action']
                  ));
              }
              return $method->invokeArgs($this, $request->params['pass']);
  

  object(ClientsController) {
  	name => 'Clients'
  	uses => array(
  		[maximum depth reached]
  	)
  	components => array(
  		[maximum depth reached]
  	)
  	helpers => array(
  		[maximum depth reached]
  	)
  	paginate => array(
  		[maximum depth reached]
  	)
  	usePaginationCache => true
  	viewClass => 'Theme'
  	theme => 'Agd'
  	request => object(CakeRequest) {}
  	response => object(CakeResponse) {}
  	viewPath => 'Clients'
  	layoutPath => null
  	viewVars => array([maximum depth reached])
  	view => 'search'
  	layout => 'search'
  	autoRender => true
  	autoLayout => true
  	Components => object(ComponentCollection) {}
  	View => null
  	ext => '.ctp'
  	plugin => 'Indexeg'
  	cacheAction => false
  	passedArgs => array(
  		[maximum depth reached]
  	)
  	scaffold => false
  	methods => array(
  		[maximum depth reached]
  	)
  	modelClass => 'Client'
  	modelKey => 'client'
  	validationErrors => null
  	Croogo => object(CroogoComponent) {}
  	Security => object(SecurityComponent) {}
  	Acl => object(AclComponent) {}
  	Auth => object(AuthComponent) {}
  	Session => object(SessionComponent) {}
  	RequestHandler => object(RequestHandlerComponent) {}
  	Paginator => object(PaginatorComponent) {}
  	Akismet => object(AkismetComponent) {}
  	Recaptcha => object(RecaptchaComponent) {}
  	AhmedGalal => object(AhmedGalalComponent) {}
  	AclFilter => object(AclFilterComponent) {}
  	CroogoAccess => object(AclAccessComponent) {}
  	Settings => object(SettingsComponent) {}
  	Setting => object(Setting) {}
  	Client => object(Client) {}
  	[protected] _responseClass => 'CakeResponse'
  	[protected] _mergeParent => 'AppController'
  	[protected] _eventManager => object(CakeEventManager) {}
  }
  array(
  	(int) 0 => 'www.eldib-office.com',
  	(int) 1 => 'eng',
  	(int) 2 => 'search',
  	(int) 3 => 'www.eldib-office.com'
  )

• CORE/Cake/Routing/Dispatcher.php line 187 → Controller->invokeAction(CakeRequest)

          $controller->startupProcess();
  
          $render = true;
          $result = $controller->invokeAction($request);
          if ($result instanceof CakeResponse) {

  object(CakeRequest) {
  	params => array(
  		[maximum depth reached]
  	)
  	data => array([maximum depth reached])
  	query => array([maximum depth reached])
  	url => 'eng/search/www.eldib-office.com/eng/search/www.eldib-office.com'
  	base => ''
  	webroot => '/'
  	here => '/eng/search/www.eldib-office.com/eng/search/www.eldib-office.com'
  	[protected] _detectors => array(
  		[maximum depth reached]
  	)
  	[protected] _input => ''
  }

• CORE/Cake/Routing/Dispatcher.php line 162 → Dispatcher->_invoke(ClientsController, CakeRequest, CakeResponse)

              ));
          }
  
          $response = $this->_invoke($controller, $request, $response);
          if (isset($request->params['return'])) {

  object(ClientsController) {
  	name => 'Clients'
  	uses => array(
  		[maximum depth reached]
  	)
  	components => array(
  		[maximum depth reached]
  	)
  	helpers => array(
  		[maximum depth reached]
  	)
  	paginate => array(
  		[maximum depth reached]
  	)
  	usePaginationCache => true
  	viewClass => 'Theme'
  	theme => 'Agd'
  	request => object(CakeRequest) {}
  	response => object(CakeResponse) {}
  	viewPath => 'Clients'
  	layoutPath => null
  	viewVars => array([maximum depth reached])
  	view => 'search'
  	layout => 'search'
  	autoRender => true
  	autoLayout => true
  	Components => object(ComponentCollection) {}
  	View => null
  	ext => '.ctp'
  	plugin => 'Indexeg'
  	cacheAction => false
  	passedArgs => array(
  		[maximum depth reached]
  	)
  	scaffold => false
  	methods => array(
  		[maximum depth reached]
  	)
  	modelClass => 'Client'
  	modelKey => 'client'
  	validationErrors => null
  	Croogo => object(CroogoComponent) {}
  	Security => object(SecurityComponent) {}
  	Acl => object(AclComponent) {}
  	Auth => object(AuthComponent) {}
  	Session => object(SessionComponent) {}
  	RequestHandler => object(RequestHandlerComponent) {}
  	Paginator => object(PaginatorComponent) {}
  	Akismet => object(AkismetComponent) {}
  	Recaptcha => object(RecaptchaComponent) {}
  	AhmedGalal => object(AhmedGalalComponent) {}
  	AclFilter => object(AclFilterComponent) {}
  	CroogoAccess => object(AclAccessComponent) {}
  	Settings => object(SettingsComponent) {}
  	Setting => object(Setting) {}
  	Client => object(Client) {}
  	[protected] _responseClass => 'CakeResponse'
  	[protected] _mergeParent => 'AppController'
  	[protected] _eventManager => object(CakeEventManager) {}
  }
  object(CakeRequest) {
  	params => array(
  		[maximum depth reached]
  	)
  	data => array([maximum depth reached])
  	query => array([maximum depth reached])
  	url => 'eng/search/www.eldib-office.com/eng/search/www.eldib-office.com'
  	base => ''
  	webroot => '/'
  	here => '/eng/search/www.eldib-office.com/eng/search/www.eldib-office.com'
  	[protected] _detectors => array(
  		[maximum depth reached]
  	)
  	[protected] _input => ''
  }
  object(CakeResponse) {
  	[protected] _statusCodes => array(
  		[maximum depth reached]
  	)
  	[protected] _mimeTypes => array(
  		[maximum depth reached]
  	)
  	[protected] _protocol => 'HTTP/1.1'
  	[protected] _status => (int) 200
  	[protected] _contentType => 'text/html'
  	[protected] _headers => array([maximum depth reached])
  	[protected] _body => null
  	[protected] _file => null
  	[protected] _fileRange => null
  	[protected] _charset => 'UTF-8'
  	[protected] _cacheDirectives => array([maximum depth reached])
  	[protected] _cookies => array([maximum depth reached])
  }

• APP/webroot/index.php line 96 → Dispatcher->dispatch(CakeRequest, CakeResponse)

  App::uses('Dispatcher', 'Routing');
  
  $Dispatcher = new Dispatcher();
  $Dispatcher->dispatch(new CakeRequest(), new CakeResponse(array('charset' => Configure::read('App.encoding'))));
  

  object(CakeRequest) {
  	params => array(
  		[maximum depth reached]
  	)
  	data => array([maximum depth reached])
  	query => array([maximum depth reached])
  	url => 'eng/search/www.eldib-office.com/eng/search/www.eldib-office.com'
  	base => ''
  	webroot => '/'
  	here => '/eng/search/www.eldib-office.com/eng/search/www.eldib-office.com'
  	[protected] _detectors => array(
  		[maximum depth reached]
  	)
  	[protected] _input => ''
  }
  object(CakeResponse) {
  	[protected] _statusCodes => array(
  		[maximum depth reached]
  	)
  	[protected] _mimeTypes => array(
  		[maximum depth reached]
  	)
  	[protected] _protocol => 'HTTP/1.1'
  	[protected] _status => (int) 200
  	[protected] _contentType => 'text/html'
  	[protected] _headers => array([maximum depth reached])
  	[protected] _body => null
  	[protected] _file => null
  	[protected] _fileRange => null
  	[protected] _charset => 'UTF-8'
  	[protected] _cacheDirectives => array([maximum depth reached])
  	[protected] _cookies => array([maximum depth reached])
  }