Database Error

Erro: 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 'ORDER BY `Publicacao`.`id` desc LIMIT 20' at line 1

SQL Query: SELECT `Publicacao`.`id`, `Publicacao`.`titulo`, `Publicacao`.`slug`, `Publicacao`.`tipo`, `Publicacao`.`introducao`, `Publicacao`.`texto`, `Publicacao`.`imagem`, `Publicacao`.`publicar`, `Publicacao`.`created`, `Publicacao`.`modified`, `Publicacao`.`editora_id`, `Publicacao`.`font`, `Editora`.`id`, `Editora`.`nome`, `Editora`.`publicar`, `Editora`.`created`, `Editora`.`modified` FROM `htjadvbrsite`.`publicacoes` AS `Publicacao` LEFT JOIN `htjadvbrsite`.`editora` AS `Editora` ON (`Publicacao`.`editora_id` = `Editora`.`id`) WHERE `Publicacao`.`tipo` = ORDER BY `Publicacao`.`id` desc LIMIT 20

Advertência: Se você quiser customizar esta mensagem de erro, crie app/View/Errors/pdo_error.ctp

Stack Trace

• CORE/Cake/Model/Datasource/DboSource.php line 436 → 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 403 → DboSource->_execute(string, array)

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

  'SELECT `Publicacao`.`id`, `Publicacao`.`titulo`, `Publicacao`.`slug`, `Publicacao`.`tipo`, `Publicacao`.`introducao`, `Publicacao`.`texto`, `Publicacao`.`imagem`, `Publicacao`.`publicar`, `Publicacao`.`created`, `Publicacao`.`modified`, `Publicacao`.`editora_id`, `Publicacao`.`font`, `Editora`.`id`, `Editora`.`nome`, `Editora`.`publicar`, `Editora`.`created`, `Editora`.`modified` FROM `htjadvbrsite`.`publicacoes` AS `Publicacao` LEFT JOIN `htjadvbrsite`.`editora` AS `Editora` ON (`Publicacao`.`editora_id` = `Editora`.`id`)  WHERE `Publicacao`.`tipo` =   ORDER BY `Publicacao`.`id` desc  LIMIT 20'
  array()

• CORE/Cake/Model/Datasource/DboSource.php line 646 → 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 `Publicacao`.`id`, `Publicacao`.`titulo`, `Publicacao`.`slug`, `Publicacao`.`tipo`, `Publicacao`.`introducao`, `Publicacao`.`texto`, `Publicacao`.`imagem`, `Publicacao`.`publicar`, `Publicacao`.`created`, `Publicacao`.`modified`, `Publicacao`.`editora_id`, `Publicacao`.`font`, `Editora`.`id`, `Editora`.`nome`, `Editora`.`publicar`, `Editora`.`created`, `Editora`.`modified` FROM `htjadvbrsite`.`publicacoes` AS `Publicacao` LEFT JOIN `htjadvbrsite`.`editora` AS `Editora` ON (`Publicacao`.`editora_id` = `Editora`.`id`)  WHERE `Publicacao`.`tipo` =   ORDER BY `Publicacao`.`id` desc  LIMIT 20'
  array()
  array()

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

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

  'SELECT `Publicacao`.`id`, `Publicacao`.`titulo`, `Publicacao`.`slug`, `Publicacao`.`tipo`, `Publicacao`.`introducao`, `Publicacao`.`texto`, `Publicacao`.`imagem`, `Publicacao`.`publicar`, `Publicacao`.`created`, `Publicacao`.`modified`, `Publicacao`.`editora_id`, `Publicacao`.`font`, `Editora`.`id`, `Editora`.`nome`, `Editora`.`publicar`, `Editora`.`created`, `Editora`.`modified` FROM `htjadvbrsite`.`publicacoes` AS `Publicacao` LEFT JOIN `htjadvbrsite`.`editora` AS `Editora` ON (`Publicacao`.`editora_id` = `Editora`.`id`)  WHERE `Publicacao`.`tipo` =   ORDER BY `Publicacao`.`id` desc  LIMIT 20'
  false

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

              return null;
          }
  
          $results = $this->getDataSource()->read($this, $query);
          $this->resetAssociations();

  object(Publicacao) {
  	displayField => 'titulo'
  	actsAs => array(
  	)
  	validate => array(
  	)
  	belongsTo => array(
  	)
  	hasMany => array(
  	)
  	hasAndBelongsToMany => array(
  	)
  	useDbConfig => 'default'
  	useTable => 'publicacoes'
  	id => false
  	data => array()
  	schemaName => 'htjadvbrsite'
  	table => 'publicacoes'
  	primaryKey => 'id'
  	validationErrors => array()
  	validationDomain => null
  	name => 'Publicacao'
  	alias => 'Publicacao'
  	tableToModel => array(
  	)
  	cacheQueries => false
  	hasOne => array()
  	Behaviors => object(BehaviorCollection) {}
  	whitelist => array()
  	cacheSources => true
  	findQueryType => 'all'
  	recursive => (int) 1
  	order => null
  	virtualFields => array()
  	__backAssociation => array()
  	__backInnerAssociation => array()
  	__backOriginalAssociation => array()
  	__backContainableAssociation => array()
  	findMethods => array(
  	)
  	Autor => object(Autor) {}
  	Editora => object(Editora) {}
  	tablePrefix => ''
  	Loja => object(Loja) {}
  	AutorPublicacao => object(AppModel) {}
  }
  array(
  	'conditions' => array(
  	),
  	'fields' => null,
  	'joins' => array(),
  	'limit' => (int) 20,
  	'offset' => null,
  	'order' => array(
  	),
  	'page' => (int) 1,
  	'group' => null,
  	'callbacks' => true,
  	'maxLimit' => (int) 100,
  	'paramType' => 'named'
  )

• CORE/Cake/Controller/Component/PaginatorComponent.php line 172 → Model->find(string, array)

              if ($recursive != $object->recursive) {
                  $parameters['recursive'] = $recursive;
              }
              $results = $object->find($type, array_merge($parameters, $extra));
          }

  'all'
  array(
  	'conditions' => array(
  	),
  	'fields' => null,
  	'order' => array(
  	),
  	'limit' => (int) 20,
  	'page' => (int) 1,
  	'maxLimit' => (int) 100,
  	'paramType' => 'named'
  )

• CORE/Cake/Controller/Controller.php line 1087 → PaginatorComponent->paginate(null, array, array)

   * @deprecated Use PaginatorComponent instead
   */
      public function paginate($object = null, $scope = array(), $whitelist = array()) {
          return $this->Components->load('Paginator', $this->paginate)->paginate($object, $scope, $whitelist);
      }

  null
  array()
  array()

• APP/Controller/PublicacoesController.php line 38 → Controller->paginate()

          $this->paginate['conditions'][] = 'Publicacao.tipo =' . $this->request->query['tipo'];
          $this->paginate['order'] = array('Publicacao.id'=>'desc');
  
          $this->set('publicacoes', $this->paginate());
          $this->set(compact('autores', 'editoras', 'seo'));

• [internal function] → PublicacoesController->index()

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

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

  object(PublicacoesController) {
  	uses => array(
  	)
  	paginate => array(
  	)
  	components => array(
  	)
  	helpers => array(
  	)
  	name => 'Publicacoes'
  	request => object(CakeRequest) {}
  	response => object(CakeResponse) {}
  	viewPath => 'Publicacoes'
  	layoutPath => null
  	viewVars => array(
  	)
  	view => 'index'
  	layout => 'default'
  	autoRender => true
  	autoLayout => true
  	Components => object(ComponentCollection) {}
  	viewClass => 'View'
  	View => null
  	ext => '.ctp'
  	plugin => null
  	cacheAction => false
  	passedArgs => array()
  	scaffold => false
  	methods => array(
  	)
  	modelClass => 'Publicacao'
  	modelKey => 'publicacao'
  	validationErrors => null
  	Auth => object(AuthComponent) {}
  	Cookie => object(CookieComponent) {}
  	Session => object(SessionComponent) {}
  	Texto => object(Texto) {}
  	Seo => object(Seo) {}
  	Publicacao => object(Publicacao) {}
  }
  array()

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

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

  object(CakeRequest) {
  	params => array(
  	)
  	data => array()
  	query => array()
  	url => 'publicacoes'
  	base => ''
  	webroot => '/'
  	here => '/publicacoes'
  }

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

              ));
          }
  
          return $this->_invoke($controller, $request, $response);
      }

  object(PublicacoesController) {
  	uses => array(
  	)
  	paginate => array(
  	)
  	components => array(
  	)
  	helpers => array(
  	)
  	name => 'Publicacoes'
  	request => object(CakeRequest) {}
  	response => object(CakeResponse) {}
  	viewPath => 'Publicacoes'
  	layoutPath => null
  	viewVars => array(
  	)
  	view => 'index'
  	layout => 'default'
  	autoRender => true
  	autoLayout => true
  	Components => object(ComponentCollection) {}
  	viewClass => 'View'
  	View => null
  	ext => '.ctp'
  	plugin => null
  	cacheAction => false
  	passedArgs => array()
  	scaffold => false
  	methods => array(
  	)
  	modelClass => 'Publicacao'
  	modelKey => 'publicacao'
  	validationErrors => null
  	Auth => object(AuthComponent) {}
  	Cookie => object(CookieComponent) {}
  	Session => object(SessionComponent) {}
  	Texto => object(Texto) {}
  	Seo => object(Seo) {}
  	Publicacao => object(Publicacao) {}
  }
  object(CakeRequest) {
  	params => array(
  	)
  	data => array()
  	query => array()
  	url => 'publicacoes'
  	base => ''
  	webroot => '/'
  	here => '/publicacoes'
  }
  object(CakeResponse) {
  	
  }

• 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(
  	)
  	data => array()
  	query => array()
  	url => 'publicacoes'
  	base => ''
  	webroot => '/'
  	here => '/publicacoes'
  }
  object(CakeResponse) {
  	
  }