Errors

Notice (8): Undefined index: Ville [APP/Controller/CommentsController.php, line 41]

            ));
            
            $lat = $d['ville']['Ville']['lat'];

$ville = 'showroom'
$d = array(
	'ville' => array()
)

CommentsController::index() - APP/Controller/CommentsController.php, line 41
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 111

Notice (8): Trying to access array offset on value of type null [APP/Controller/CommentsController.php, line 41]

Code Context

            ));
            
            $lat = $d['ville']['Ville']['lat'];

$ville = 'showroom'
$d = array(
	'ville' => array()
)

CommentsController::index() - APP/Controller/CommentsController.php, line 41
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 111

Notice (8): Undefined index: Ville [APP/Controller/CommentsController.php, line 42]

Code Context

            
            $lat = $d['ville']['Ville']['lat'];
            $lng = $d['ville']['Ville']['lng'];

$ville = 'showroom'
$d = array(
	'ville' => array()
)
$lat = null

CommentsController::index() - APP/Controller/CommentsController.php, line 42
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 111

Notice (8): Trying to access array offset on value of type null [APP/Controller/CommentsController.php, line 42]

Code Context

            
            $lat = $d['ville']['Ville']['lat'];
            $lng = $d['ville']['Ville']['lng'];

$ville = 'showroom'
$d = array(
	'ville' => array()
)
$lat = null

CommentsController::index() - APP/Controller/CommentsController.php, line 42
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 111

Warning (2): Cannot modify header information - headers already sent by (output started at /homepages/3/d279718623/htdocs/dmprenov/lib/Cake/Utility/Debugger.php:797) [CORE/Cake/Network/CakeResponse.php, line 458]

Code Context

            setcookie(
                $name, $c['value'], $c['expire'], $c['path'],
                $c['domain'], $c['secure'], $c['httpOnly']

$c = array(
	'name' => 'CakeCookie[autologin]',
	'value' => '',
	'expire' => (int) 1695339184,
	'path' => '/',
	'domain' => '',
	'secure' => false,
	'httpOnly' => false
)
$name = 'CakeCookie[autologin]'

setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 458
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 429
ExceptionRenderer::_outputMessage() - CORE/Cake/Error/ExceptionRenderer.php, line 294
ExceptionRenderer::pdoError() - CORE/Cake/Error/ExceptionRenderer.php, line 281
ExceptionRenderer::render() - CORE/Cake/Error/ExceptionRenderer.php, line 190
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 127
[main] - [internal], line ??

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 '*pi()/180)) * sin((Ville.lat*pi()/180))+cos((*pi()/180)) * cos((Ville.lat*pi()/1' at line 1

SQL Query: SELECT `Comment`.*, `Ville`.*, (((acos(sin((*pi()/180)) * sin((Ville.lat*pi()/180))+cos((*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance FROM `db285787289`.`comments` AS `Comment` LEFT JOIN `db285787289`.`villes` AS `Ville` ON (`Comment`.`etab_id` = `Ville`.`id`) WHERE 1 = 1 GROUP BY `Comment`.`id` HAVING distance < 80000 ORDER BY `Comment`.`id` DESC LIMIT 20

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 502 → PDOStatement->execute()

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

CORE/Cake/Model/Datasource/DboSource.php line 468 → DboSource->_execute()

        $options += array('log' => $this->fullDebug);

        $t = microtime(true);
        $this->_result = $this->_execute($sql, $params);

CORE/Cake/Model/Datasource/DboSource.php line 715 → DboSource->execute()

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

CORE/Cake/Model/Datasource/DboSource.php line 1226 → DboSource->fetchAll()

        // Build SQL statement with the primary model, plus hasOne and belongsTo associations
        $query = $this->buildAssociationQuery($Model, $queryData);

        $resultSet = $this->fetchAll($query, $Model->cacheQueries);
        unset($query);

CORE/Cake/Model/Model.php line 3053 → DboSource->read()

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

CORE/Cake/Model/Model.php line 3025 → Model->_readDataSource()

            return null;
        }

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

CORE/Cake/Controller/Component/PaginatorComponent.php line 212 → Model->find()

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

CORE/Cake/Controller/Controller.php line 1107 → PaginatorComponent->paginate()

 * @link https://book.cakephp.org/2.0/en/controllers.html#Controller::paginate
 */
    public function paginate($object = null, $scope = array(), $whitelist = array()) {
        return $this->Components->load('Paginator', $this->paginate)->paginate($object, $scope, $whitelist);
    }

APP/Controller/CommentsController.php line 56 → Controller->paginate()

            'order'  => 'Comment.id DESC'
            );
            
            $d['data'] = $this->paginate('Comment');

[internal function] → CommentsController->index()

CORE/Cake/Controller/Controller.php line 499 → ReflectionMethod->invokeArgs()

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

CORE/Cake/Routing/Dispatcher.php line 193 → Controller->invokeAction()


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

CORE/Cake/Routing/Dispatcher.php line 167 → Dispatcher->_invoke()

            ));
        }

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

APP/webroot/index.php line 111 → Dispatcher->dispatch()

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