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 MariaDB server version for the right syntax to use near '' at line 1
SQL Query:
SELECT * FROM `engins` WHERE `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 459 → PDOStatement->execute(array)
try {
$query = $this->_connection->prepare($sql, $prepareOptions);
$query->setFetchMode(PDO::FETCH_LAZY);
if (!$query->execute($params)) {
$this->_results = $query;
- CORE/Cake/Model/Datasource/DboSource.php line 425 → DboSource->_execute(string, array)
$options += array('log' => $this->fullDebug);
$t = microtime(true);
$this->_result = $this->_execute($sql, $params);
'SELECT * FROM `engins` WHERE `id` ='
array()
- CORE/Cake/Model/Datasource/DboSource.php line 404 → DboSource->execute(string, array)
*/
public function rawQuery($sql, $params = array()) {
$this->took = $this->numRows = false;
return $this->execute($sql, $params);
}
'SELECT * FROM `engins` WHERE `id` = '
array(
'log' => false
)
- APP/pages/before_content/fre/8.php line 26 → DboSource->rawQuery(string)
$fiche = $db->fetchRow($reqFiche);
// Récupére le type de location
$reqEngin = $db->rawQuery("SELECT * FROM `engins` WHERE `id` = ".$fiche['locations']['idEngin']);
$engin = $db->fetchRow($reqEngin);
'SELECT * FROM `engins` WHERE `id` = '
- APP/View/DynamicPages/get_page.ctp line 13 → include(string)
// before_content
include('../pages/utils.php');
if(file_exists('../pages/before_content/'.$locale.'/'.$page_id.'.php'))
include('../pages/before_content/'.$locale.'/'.$page_id.'.php');
elseif(file_exists('../pages/before_content/fre/'.$page_id.'.php'))
'/home/prokilou/www/app/pages/before_content/fre/8.php'
- CORE/Cake/View/View.php line 921 → include(string)
extract($dataForView);
ob_start();
include $this->__viewFile;
'/home/prokilou/www/app/View/DynamicPages/get_page.ctp'
- CORE/Cake/View/View.php line 884 → View->_evaluate(string, array)
$initialBlocks = count($this->Blocks->unclosed());
$this->getEventManager()->dispatch(new CakeEvent('View.beforeRenderFile', $this, array($viewFile)));
$content = $this->_evaluate($viewFile, $data);
$afterEvent = new CakeEvent('View.afterRenderFile', $this, array($viewFile, $content));
'/home/prokilou/www/app/View/DynamicPages/get_page.ctp'
array(
'locale' => 'fre',
'page_id' => (int) 8,
'info' => array(
'DynamicPage' => array(
[maximum depth reached]
)
),
'contents' => array(
(int) 0 => array(
[maximum depth reached]
)
),
'contenuLayout' => array(
'header' => array(
[maximum depth reached]
),
'footer' => array(
[maximum depth reached]
)
)
)
- CORE/Cake/View/View.php line 476 → View->_render(string)
if ($view !== false && $viewFileName = $this->_getViewFileName($view)) {
$this->_currentType = self::TYPE_VIEW;
$this->getEventManager()->dispatch(new CakeEvent('View.beforeRender', $this, array($viewFileName)));
$this->Blocks->set('content', $this->_render($viewFileName));
$this->getEventManager()->dispatch(new CakeEvent('View.afterRender', $this, array($viewFileName)));
'/home/prokilou/www/app/View/DynamicPages/get_page.ctp'
- CORE/Cake/Controller/Controller.php line 956 → View->render(null, null)
$this->autoRender = false;
$this->View = $View;
$this->response->body($View->render($view, $layout));
return $this->response;
- CORE/Cake/Routing/Dispatcher.php line 193 → Controller->render()
}
if ($render && $controller->autoRender) {
$response = $controller->render();
} elseif ($response->body() === null) {
- CORE/Cake/Routing/Dispatcher.php line 161 → Dispatcher->_invoke(DynamicPagesController, CakeRequest, CakeResponse)
));
}
$response = $this->_invoke($controller, $request, $response);
if (isset($request->params['return'])) {
object(DynamicPagesController) {
components => array(
[maximum depth reached]
)
helpers => array(
[maximum depth reached]
)
name => 'DynamicPages'
uses => array(
[maximum depth reached]
)
request => object(CakeRequest) {}
response => object(CakeResponse) {}
viewPath => 'DynamicPages'
layoutPath => null
viewVars => array(
[maximum depth reached]
)
view => 'get_page'
layout => 'Front/layout_default'
autoRender => false
autoLayout => true
Components => object(ComponentCollection) {}
viewClass => 'View'
View => object(View) {}
ext => '.ctp'
plugin => null
cacheAction => false
passedArgs => array(
[maximum depth reached]
)
scaffold => false
methods => array(
[maximum depth reached]
)
modelClass => 'DynamicPage'
modelKey => 'dynamic_page'
validationErrors => null
MyAuth => object(MyAuthComponent) {}
Session => object(SessionComponent) {}
ContentUIManager => object(ContentUIManagerComponent) {}
ContentSortable => object(ContentSortableComponent) {}
RequestHandler => object(RequestHandlerComponent) {}
DynamicPage => object(DynamicPage) {}
}
object(CakeRequest) {
params => array(
[maximum depth reached]
)
data => array([maximum depth reached])
query => array(
[maximum depth reached]
)
url => 'Location,compacteur-vibrant-tandem-caterpillar-cx76-xt-,5536'
base => ''
webroot => '/'
here => '/Location,compacteur-vibrant-tandem-caterpillar-cx76-xt-,5536'
}
object(CakeResponse) {
}
- APP/webroot/index.php line 97 → 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 => 'Location,compacteur-vibrant-tandem-caterpillar-cx76-xt-,5536'
base => ''
webroot => '/'
here => '/Location,compacteur-vibrant-tandem-caterpillar-cx76-xt-,5536'
}
object(CakeResponse) {
}