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 'ORDER BY Objekts.OBI_SORTIERUNG ASC, Objekts.OBJ_ANLAGEDATUM DESC LIMIT 10 OFFSE' at line 1
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php
toggle arguments
|
$connection = $this->_driver->getConnection(); |
|
|
|
try { |
|
$connection->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, $this->_bufferResults); |
|
$result = $this->_statement->execute($params); |
|
} finally { |
|
$connection->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true); |
|
} |
|
|
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Database/Connection.php
toggle arguments
|
{ |
|
return $this->getDisconnectRetry()->run(function () use ($query) { |
|
$statement = $this->prepare($query); |
|
$query->getValueBinder()->attachTo($statement); |
|
$statement->execute(); |
|
|
|
return $statement; |
|
}); |
|
} |
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Core/Retry/CommandRetry.php
toggle arguments
|
$lastException = null; |
|
|
|
do { |
|
try { |
|
return $action(); |
|
} catch (Exception $e) { |
|
$lastException = $e; |
|
if (!$this->strategy->shouldRetry($e, $retryCount)) { |
|
throw $e; |
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Database/Connection.php
toggle arguments
|
$query->getValueBinder()->attachTo($statement); |
|
$statement->execute(); |
|
|
|
return $statement; |
|
}); |
|
} |
|
|
|
/** |
|
* Executes a SQL statement and returns the Statement object as result. |
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Database/Query.php
toggle arguments
|
* @return \Cake\Database\StatementInterface |
|
*/ |
|
public function execute() |
|
{ |
|
$statement = $this->_connection->run($this); |
|
$this->_iterator = $this->_decorateStatement($statement); |
|
$this->_dirty = false; |
|
|
|
return $this->_iterator; |
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/ORM/Query.php
toggle arguments
|
|
|
return new $decorator($this->_results); |
|
} |
|
|
|
$statement = $this->getEagerLoader()->loadExternal($this, $this->execute()); |
|
|
|
return new ResultSet($this, $statement); |
|
} |
|
|
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Datasource/QueryTrait.php
toggle arguments
|
if ($this->_cache) { |
|
$results = $this->_cache->fetch($this); |
|
} |
|
if (!isset($results)) { |
|
$results = $this->_decorateResults($this->_execute()); |
|
if ($this->_cache) { |
|
$this->_cache->store($this, $results); |
|
} |
|
} |
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/ORM/Query.php
toggle arguments
|
'You cannot call all() on a non-select query. Use execute() instead.' |
|
); |
|
} |
|
|
|
return $this->_all(); |
|
} |
|
|
|
/** |
|
* Trigger the beforeFind event on the query's repository object. |
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Datasource/Paginator.php
toggle arguments
|
$query->applyOptions($options); |
|
} |
|
|
|
$cleanQuery = clone $query; |
|
$results = $query->all(); |
|
$numResults = count($results); |
|
$count = $cleanQuery->count(); |
|
|
|
$page = $options['page']; |
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Controller/Component/PaginatorComponent.php
toggle arguments
|
$request = $this->_registry->getController()->getRequest(); |
|
|
|
try { |
|
$results = $this->_paginator->paginate( |
|
$object, |
|
$request->getQueryParams(), |
|
$settings |
|
); |
|
|
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Controller/Controller.php
toggle arguments
|
throw new RuntimeException('Unable to locate an object compatible with paginate.'); |
|
} |
|
$settings += $this->paginate; |
|
|
|
return $this->Paginator->paginate($table, $settings); |
|
} |
|
|
|
/** |
|
* Method to check that an action is accessible from a URL. |
/kunden/348240_07620/disayomallorca.com/src/Controller/ObjektsController.php
toggle arguments
|
$this->Objekts->createSearchStatement($this->searchCriterias, $this->session); |
|
$this->paginate = $this->Objekts->preparePaginateConditions(); |
|
|
|
$this->Objekts->recursive = -1; |
|
return $results = $this->paginate('Objekts'); |
|
|
|
} |
|
|
|
function doSanitize($data, $redirect = true, $type = null){ |
/kunden/348240_07620/disayomallorca.com/src/Controller/ObjektsController.php
toggle arguments
|
$this->session = $this->getRequest()->getSession(); |
|
$this->session->write('lastUrl', $params); |
|
|
|
// perform search |
|
$success = $results = $this->doSearch(); |
|
|
|
$languageID = $this->session->read('Config.languageID'); |
|
$this->set(compact('languageID')); |
|
// further actions |
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Controller/Controller.php
toggle arguments
|
} |
|
/* @var callable $callable */ |
|
$callable = [$this, $request->getParam('action')]; |
|
|
|
$result = $callable(...array_values($request->getParam('pass'))); |
|
if ($result instanceof Response) { |
|
$this->response = $result; |
|
} |
|
|
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Http/ActionDispatcher.php
toggle arguments
|
if ($result instanceof Response) { |
|
return $result; |
|
} |
|
|
|
$response = $controller->invokeAction(); |
|
if ($response !== null && !($response instanceof Response)) { |
|
throw new LogicException('Controller actions can only return Cake\Http\Response or null.'); |
|
} |
|
|
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Http/ActionDispatcher.php
toggle arguments
|
} else { |
|
$controller = $this->factory->create($request, $response); |
|
} |
|
|
|
$response = $this->_invoke($controller); |
|
if ($request->getParam('return')) { |
|
return $response; |
|
} |
|
|
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Http/BaseApplication.php
toggle arguments
|
* @return \Psr\Http\Message\ResponseInterface |
|
*/ |
|
public function __invoke(ServerRequestInterface $request, ResponseInterface $response, $next) |
|
{ |
|
return $this->getDispatcher()->dispatch($request, $response); |
|
} |
|
|
|
/** |
|
* Get the ActionDispatcher. |
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Http/Runner.php
toggle arguments
|
$next = $this->middleware->get($this->index); |
|
if ($next) { |
|
$this->index++; |
|
|
|
return $next($request, $response, $this); |
|
} |
|
|
|
// End of the queue |
|
return $response; |
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Http/Runner.php
toggle arguments
|
$next = $this->middleware->get($this->index); |
|
if ($next) { |
|
$this->index++; |
|
|
|
return $next($request, $response, $this); |
|
} |
|
|
|
// End of the queue |
|
return $response; |
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Http/Middleware/CsrfProtectionMiddleware.php
toggle arguments
|
$token = $this->_createToken(); |
|
$request = $this->_addTokenToRequest($token, $request); |
|
$response = $this->_addTokenCookie($token, $request, $response); |
|
|
|
return $next($request, $response); |
|
} |
|
$request = $this->_validateAndUnsetTokenField($request); |
|
|
|
return $next($request, $response); |
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Http/Runner.php
toggle arguments
|
$next = $this->middleware->get($this->index); |
|
if ($next) { |
|
$this->index++; |
|
|
|
return $next($request, $response, $this); |
|
} |
|
|
|
// End of the queue |
|
return $response; |
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Http/Runner.php
toggle arguments
|
{ |
|
$this->middleware = $middleware; |
|
$this->index = 0; |
|
|
|
return $this->__invoke($request, $response); |
|
} |
|
|
|
/** |
|
* @param \Psr\Http\Message\ServerRequestInterface $request The server request |
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Routing/Middleware/RoutingMiddleware.php
toggle arguments
|
$matching[] = $next; |
|
$middleware = new MiddlewareQueue($matching); |
|
$runner = new Runner(); |
|
|
|
return $runner->run($middleware, $request, $response); |
|
} |
|
} |
|
|
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Http/Runner.php
toggle arguments
|
$next = $this->middleware->get($this->index); |
|
if ($next) { |
|
$this->index++; |
|
|
|
return $next($request, $response, $this); |
|
} |
|
|
|
// End of the queue |
|
return $response; |
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Routing/Middleware/AssetMiddleware.php
toggle arguments
|
public function __invoke($request, $response, $next) |
|
{ |
|
$url = $request->getUri()->getPath(); |
|
if (strpos($url, '..') !== false || strpos($url, '.') === false) { |
|
return $next($request, $response); |
|
} |
|
|
|
if (strpos($url, '/.') !== false) { |
|
return $next($request, $response); |
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Http/Runner.php
toggle arguments
|
$next = $this->middleware->get($this->index); |
|
if ($next) { |
|
$this->index++; |
|
|
|
return $next($request, $response, $this); |
|
} |
|
|
|
// End of the queue |
|
return $response; |
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Error/Middleware/ErrorHandlerMiddleware.php
toggle arguments
|
*/ |
|
public function __invoke($request, $response, $next) |
|
{ |
|
try { |
|
return $next($request, $response); |
|
} catch (Throwable $exception) { |
|
return $this->handleException($exception, $request, $response); |
|
} catch (Exception $exception) { |
|
return $this->handleException($exception, $request, $response); |
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Http/Runner.php
toggle arguments
|
$next = $this->middleware->get($this->index); |
|
if ($next) { |
|
$this->index++; |
|
|
|
return $next($request, $response, $this); |
|
} |
|
|
|
// End of the queue |
|
return $response; |
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Http/Runner.php
toggle arguments
|
{ |
|
$this->middleware = $middleware; |
|
$this->index = 0; |
|
|
|
return $this->__invoke($request, $response); |
|
} |
|
|
|
/** |
|
* @param \Psr\Http\Message\ServerRequestInterface $request The server request |
/kunden/348240_07620/disayomallorca.com/vendor/cakephp/cakephp/src/Http/Server.php
toggle arguments
|
} |
|
$this->dispatchEvent('Server.buildMiddleware', ['middleware' => $middleware]); |
|
$middleware->add($this->app); |
|
|
|
$response = $this->runner->run($middleware, $request, $response); |
|
|
|
if (!($response instanceof ResponseInterface)) { |
|
throw new RuntimeException(sprintf( |
|
'Application did not create a response. Got "%s" instead.', |
/kunden/348240_07620/disayomallorca.com/webroot/index.php
toggle arguments
|
// Bind your application to the server. |
|
$server = new Server(new Application(dirname(__DIR__) . '/config')); |
|
|
|
// Run the request/response through the application and emit the response. |
|
$server->emit($server->run()); |
|
|
If you are using SQL keywords as table column names, you can enable identifier
quoting for your database connection in config/app.php.
If you want to customize this error message, create
src/Template/Error/pdo_error.ctp