Notice (8): Indirect modification of overloaded property UsersController::$paginate has no effect [APP/Controller/UsersController.php, line 303]Code $this->layout = 'portal';
$this->pageTitle = __('Users', True);
$this->paginate['conditions'] = array('User.id != 2');
UsersController::listing() - APP/Controller/UsersController.php, line 303
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 473
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 107
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 89
[main] - APP/webroot/index.php, line 81
Notice (8): Indirect modification of overloaded property UsersController::$paginate has no effect [APP/Controller/UsersController.php, line 304]Code $this->pageTitle = __('Users', True);
$this->paginate['conditions'] = array('User.id != 2');
$this->paginate['fields'] = array('User.group_id','User.name','User.created','User.email','User.active','User.id','User.username');
UsersController::listing() - APP/Controller/UsersController.php, line 304
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 473
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 107
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 89
[main] - APP/webroot/index.php, line 81
Notice (8): Indirect modification of overloaded property UsersController::$paginate has no effect [APP/Controller/UsersController.php, line 305]Code $this->paginate['conditions'] = array('User.id != 2');
$this->paginate['fields'] = array('User.group_id','User.name','User.created','User.email','User.active','User.id','User.username');
$this->paginate['order'] = 'User.created DESC';
UsersController::listing() - APP/Controller/UsersController.php, line 305
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 473
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 107
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 89
[main] - APP/webroot/index.php, line 81
Notice (8): Indirect modification of overloaded property UsersController::$paginate has no effect [APP/Controller/UsersController.php, line 306]Code $this->paginate['fields'] = array('User.group_id','User.name','User.created','User.email','User.active','User.id','User.username');
$this->paginate['order'] = 'User.created DESC';
$this->paginate['limit'] = 40;
UsersController::listing() - APP/Controller/UsersController.php, line 306
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 473
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 107
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 89
[main] - APP/webroot/index.php, line 81
Notice (8): Indirect modification of overloaded property UsersController::$paginate has no effect [APP/Controller/UsersController.php, line 307]Code $this->paginate['order'] = 'User.created DESC';
$this->paginate['limit'] = 40;
$this->paginate['contain'] = array('Group');
UsersController::listing() - APP/Controller/UsersController.php, line 307
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 473
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 107
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 89
[main] - APP/webroot/index.php, line 81
:: Chipotle Software ::
Database Error
Error:
SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "DISTINCT"
LINE 1: ...__votes", "News"."comments" AS "News__comments", (DISTINCT C...
^
SQL Query:
SELECT "News"."id" AS "News__id", "News"."title" AS "News__title", "News"."body" AS "News__body", "News"."created" AS "News__created", "News"."reference" AS "News__reference", "News"."theme_id" AS "News__theme_id", "News"."status" AS "News__status", "News"."user_id" AS "News__user_id", "News"."votes" AS "News__votes", "News"."comments" AS "News__comments", (DISTINCT COUNT("News"."user_id")) AS "News__news_count" FROM "news" AS "News" WHERE "News"."user_id" IN (1565, 1566, 1531, 1744, 1547, 1964, 1542, 1548, 1693, 1609, 85, 1747, 1763, 1769, 320, 1811, 1808, 1885, 1815, 920)
Notice:
If you want to customize this error message, create centauro/View/Errors/pdo_error.ctp
Stack Trace
#0 /var/chipotle/sites/cakephp/lib/Cake/Model/Datasource/DboSource.php(436): PDOStatement->execute(Array)
#1 /var/chipotle/sites/cakephp/lib/Cake/Model/Datasource/DboSource.php(403): DboSource->_execute('SELECT "News"."...', Array)
#2 /var/chipotle/sites/cakephp/lib/Cake/Model/Datasource/DboSource.php(647): DboSource->execute('SELECT "News"."...', Array, Array)
#3 /var/chipotle/sites/cakephp/lib/Cake/Model/Datasource/DboSource.php(1282): DboSource->fetchAll('SELECT "News"."...', false)
#4 /var/chipotle/sites/cakephp/lib/Cake/Model/Datasource/DboSource.php(1150): DboSource->fetchAssociated(Object(User), 'SELECT "News"."...', Array)
#5 /var/chipotle/sites/cakephp/lib/Cake/Model/Datasource/DboSource.php(1069): DboSource->queryAssociation(Object(User), Object(News), 'hasMany', 'News', Array, Array, true, Array, 0, Array)
#6 /var/chipotle/sites/cakephp/lib/Cake/Model/Model.php(2460): DboSource->read(Object(User), Array)
#7 /var/chipotle/sites/cakephp/lib/Cake/Controller/Component/PaginatorComponent.php(172): Model->find('all', Array)
#8 /var/chipotle/sites/cakephp/lib/Cake/Controller/Controller.php(1025): PaginatorComponent->paginate('User', Array, Array)
#9 /var/chipotle/sites/cakephp/centauro/Controller/UsersController.php(308): Controller->paginate('User')
#10 [internal function]: UsersController->listing()
#11 /var/chipotle/sites/cakephp/lib/Cake/Controller/Controller.php(473): ReflectionMethod->invokeArgs(Object(UsersController), Array)
#12 /var/chipotle/sites/cakephp/lib/Cake/Routing/Dispatcher.php(107): Controller->invokeAction(Object(CakeRequest))
#13 /var/chipotle/sites/cakephp/lib/Cake/Routing/Dispatcher.php(89): Dispatcher->_invoke(Object(UsersController), Object(CakeRequest), Object(CakeResponse))
#14 /var/chipotle/sites/cakephp/centauro/webroot/index.php(81): Dispatcher->dispatch(Object(CakeRequest), Object(CakeResponse))
#15 {main}
Please report bugs to Centauro developers
adding a ticket.