Database Error

Error: SQLSTATE[HY000]: General error: 145 Table './guiaqualimovel1/wp_postmeta' is marked as crashed and should be repaired

SQL Query: SELECT wp_posts.*, wm2.meta_value FROM wp_posts wp_posts LEFT JOIN wp_postmeta wm1 ON ( wm1.post_id = wp_posts.id AND wm1.meta_value IS NOT NULL AND wm1.meta_key = "_thumbnail_id" ) LEFT JOIN wp_postmeta wm2 ON ( wm1.meta_value = wm2.post_id AND wm2.meta_key = "amazonS3_info" AND wm2.meta_value IS NOT NULL ) WHERE wp_posts.post_status="publish" AND wp_posts.post_type="post" ORDER BY wp_posts.post_date DESC LIMIT 4

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
  				        wp_posts.*,
  				        wm2.meta_value
  				    FROM 
  				        wp_posts wp_posts
  				    LEFT JOIN 
  				        wp_postmeta wm1
  				        ON (
  				            wm1.post_id = wp_posts.id 
  				            AND wm1.meta_value IS NOT NULL
  				            AND wm1.meta_key = "_thumbnail_id"              
  				        )
  				    LEFT JOIN 
  				        wp_postmeta wm2
  				        ON (
  				            wm1.meta_value = wm2.post_id
  				            AND wm2.meta_key = "amazonS3_info"
  				            AND wm2.meta_value IS NOT NULL  
  				        )
  				    WHERE
  				        wp_posts.post_status="publish" 
  				        AND wp_posts.post_type="post"
  				    ORDER BY 
  				        wp_posts.post_date DESC LIMIT 4'
  array()

• CORE/Cake/Model/Datasource/DboSource.php line 670 → 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
  				        wp_posts.*,
  				        wm2.meta_value
  				    FROM 
  				        wp_posts wp_posts
  				    LEFT JOIN 
  				        wp_postmeta wm1
  				        ON (
  				            wm1.post_id = wp_posts.id 
  				            AND wm1.meta_value IS NOT NULL
  				            AND wm1.meta_key = "_thumbnail_id"              
  				        )
  				    LEFT JOIN 
  				        wp_postmeta wm2
  				        ON (
  				            wm1.meta_value = wm2.post_id
  				            AND wm2.meta_key = "amazonS3_info"
  				            AND wm2.meta_value IS NOT NULL  
  				        )
  				    WHERE
  				        wp_posts.post_status="publish" 
  				        AND wp_posts.post_type="post"
  				    ORDER BY 
  				        wp_posts.post_date DESC LIMIT 4'
  array()
  array()

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

          $recursive = null;
  
          if (count($args) === 1) {
              return $this->fetchAll($args[0]);
          } elseif (count($args) > 1 && (strpos($args[0], 'findBy') === 0 || strpos($args[0], 'findAllBy') === 0)) {

  'SELECT
  				        wp_posts.*,
  				        wm2.meta_value
  				    FROM 
  				        wp_posts wp_posts
  				    LEFT JOIN 
  				        wp_postmeta wm1
  				        ON (
  				            wm1.post_id = wp_posts.id 
  				            AND wm1.meta_value IS NOT NULL
  				            AND wm1.meta_key = "_thumbnail_id"              
  				        )
  				    LEFT JOIN 
  				        wp_postmeta wm2
  				        ON (
  				            wm1.meta_value = wm2.post_id
  				            AND wm2.meta_key = "amazonS3_info"
  				            AND wm2.meta_value IS NOT NULL  
  				        )
  				    WHERE
  				        wp_posts.post_status="publish" 
  				        AND wp_posts.post_type="post"
  				    ORDER BY 
  				        wp_posts.post_date DESC LIMIT 4'

• [internal function] → DboSource->query(string)

  'SELECT
  				        wp_posts.*,
  				        wm2.meta_value
  				    FROM 
  				        wp_posts wp_posts
  				    LEFT JOIN 
  				        wp_postmeta wm1
  				        ON (
  				            wm1.post_id = wp_posts.id 
  				            AND wm1.meta_value IS NOT NULL
  				            AND wm1.meta_key = "_thumbnail_id"              
  				        )
  				    LEFT JOIN 
  				        wp_postmeta wm2
  				        ON (
  				            wm1.meta_value = wm2.post_id
  				            AND wm2.meta_key = "amazonS3_info"
  				            AND wm2.meta_value IS NOT NULL  
  				        )
  				    WHERE
  				        wp_posts.post_status="publish" 
  				        AND wp_posts.post_type="post"
  				    ORDER BY 
  				        wp_posts.post_date DESC LIMIT 4'

• CORE/Cake/Model/Model.php line 3055 → call_user_func_array(array, array)

      public function query($sql) {
          $params = func_get_args();
          $db = $this->getDataSource();
          return call_user_func_array(array(&$db, 'query'), $params);
      }

  array(
  	(int) 0 => object(Mysql) {},
  	(int) 1 => 'query'
  )
  array(
  	(int) 0 => 'SELECT
  				        wp_posts.*,
  				        wm2.meta_value
  				    FROM 
  				        wp_posts wp_posts
  				    LEFT JOIN 
  				        wp_postmeta wm1
  				        ON (
  				            wm1.post_id = wp_posts.id 
  				            AND wm1.meta_value IS NOT NULL
  				            AND wm1.meta_key = "_thumbnail_id"              
  				        )
  				    LEFT JOIN 
  				        wp_postmeta wm2
  				        ON (
  				            wm1.meta_value = wm2.post_id
  				            AND wm2.meta_key = "amazonS3_info"
  				            AND wm2.meta_value IS NOT NULL  
  				        )
  				    WHERE
  				        wp_posts.post_status="publish" 
  				        AND wp_posts.post_type="post"
  				    ORDER BY 
  				        wp_posts.post_date DESC LIMIT 4'
  )

• APP/Controller/HomeController.php line 61 → Model->query(string)

                          AND wp_posts.post_type="post"
                      ORDER BY 
                          wp_posts.post_date DESC LIMIT 4';
          $posts = $this->Pagina->query($new_query);
          //$posts = $this->Pagina->query("SELECT * FROM wp_posts WHERE wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 8");

  'SELECT
  				        wp_posts.*,
  				        wm2.meta_value
  				    FROM 
  				        wp_posts wp_posts
  				    LEFT JOIN 
  				        wp_postmeta wm1
  				        ON (
  				            wm1.post_id = wp_posts.id 
  				            AND wm1.meta_value IS NOT NULL
  				            AND wm1.meta_key = "_thumbnail_id"              
  				        )
  				    LEFT JOIN 
  				        wp_postmeta wm2
  				        ON (
  				            wm1.meta_value = wm2.post_id
  				            AND wm2.meta_key = "amazonS3_info"
  				            AND wm2.meta_value IS NOT NULL  
  				        )
  				    WHERE
  				        wp_posts.post_status="publish" 
  				        AND wp_posts.post_type="post"
  				    ORDER BY 
  				        wp_posts.post_date DESC LIMIT 4'

• [internal function] → HomeController->Index()

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

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

  object(HomeController) {
  	name => 'Home'
  	uses => array(
  		[maximum depth reached]
  	)
  	helpers => array([maximum depth reached])
  	request => object(CakeRequest) {}
  	response => object(CakeResponse) {}
  	viewPath => 'Home'
  	layoutPath => null
  	viewVars => array(
  		[maximum depth reached]
  	)
  	view => 'Index'
  	layout => 'default'
  	autoRender => true
  	autoLayout => true
  	Components => object(ComponentCollection) {}
  	components => array(
  		[maximum depth reached]
  	)
  	viewClass => 'View'
  	View => null
  	ext => '.ctp'
  	plugin => null
  	cacheAction => false
  	passedArgs => array([maximum depth reached])
  	scaffold => false
  	methods => array(
  		[maximum depth reached]
  	)
  	modelClass => 'Home'
  	modelKey => 'home'
  	validationErrors => null
  	Session => object(SessionComponent) {}
  	Usados => object(Usados) {}
  	Regiao => object(Regiao) {}
  	Bairro => object(Bairro) {}
  	Pagina => object(Pagina) {}
  	Edicao => object(Edicao) {}
  	[protected] _responseClass => 'CakeResponse'
  	[protected] _mergeParent => 'AppController'
  	[protected] _eventManager => object(CakeEventManager) {}
  }
  array()

• 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 => false
  	base => ''
  	webroot => '/'
  	here => '/'
  	[protected] _detectors => array(
  		[maximum depth reached]
  	)
  	[protected] _input => ''
  }

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

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

  object(HomeController) {
  	name => 'Home'
  	uses => array(
  		[maximum depth reached]
  	)
  	helpers => array([maximum depth reached])
  	request => object(CakeRequest) {}
  	response => object(CakeResponse) {}
  	viewPath => 'Home'
  	layoutPath => null
  	viewVars => array(
  		[maximum depth reached]
  	)
  	view => 'Index'
  	layout => 'default'
  	autoRender => true
  	autoLayout => true
  	Components => object(ComponentCollection) {}
  	components => array(
  		[maximum depth reached]
  	)
  	viewClass => 'View'
  	View => null
  	ext => '.ctp'
  	plugin => null
  	cacheAction => false
  	passedArgs => array([maximum depth reached])
  	scaffold => false
  	methods => array(
  		[maximum depth reached]
  	)
  	modelClass => 'Home'
  	modelKey => 'home'
  	validationErrors => null
  	Session => object(SessionComponent) {}
  	Usados => object(Usados) {}
  	Regiao => object(Regiao) {}
  	Bairro => object(Bairro) {}
  	Pagina => object(Pagina) {}
  	Edicao => object(Edicao) {}
  	[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 => false
  	base => ''
  	webroot => '/'
  	here => '/'
  	[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] _charset => 'UTF-8'
  	[protected] _cacheDirectives => array([maximum depth reached])
  	[protected] _cookies => array([maximum depth reached])
  }

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

  $Dispatcher->dispatch(
      new CakeRequest(),
      new CakeResponse()
  );
  

  object(CakeRequest) {
  	params => array(
  		[maximum depth reached]
  	)
  	data => array([maximum depth reached])
  	query => array([maximum depth reached])
  	url => false
  	base => ''
  	webroot => '/'
  	here => '/'
  	[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] _charset => 'UTF-8'
  	[protected] _cacheDirectives => array([maximum depth reached])
  	[protected] _cookies => array([maximum depth reached])
  }