Sunday, March 18, 2012

ACL - Error Messages after Add New User

Hi,

I'm a newbie.

I use the CakePHP Version 2.1.0 and followed the following description
http://book.cakephp.org/2.0/en/tutorials-and-examples/simple-acl-controlled-application/simple-acl-controlled-application.html

Currently I'm at the point "Acts As a Requester" and have the source
code added to the Models User and Group. Also, I've successfully
created 3 groups. When I add a user to the User table the user is
created, but in the table Aros was no record is added...

I am a little puzzled, hope you can help me.

Error Messages:
----------------------------------------------------------------------------------------------

Notice (8): Array to string conversion [CORE/Cake/Model/Datasource/
DboSource.php, line 436]
Code Context

$sql = 'node'
$params = array(
(int) 0 => array(
)
)
$prepareOptions = array()
$this = object(Mysql) {}
$query = object(PDOStatement) {}

PDOStatement::execute() - [internal], line ??
DboSource::_execute() - CORE/Cake/Model/Datasource/DboSource.php, line
436
DboSource::execute() - CORE/Cake/Model/Datasource/DboSource.php, line
403
DboSource::fetchAll() - CORE/Cake/Model/Datasource/DboSource.php, line
646
DboSource::query() - CORE/Cake/Model/Datasource/DboSource.php, line
588
Model::__call() - CORE/Cake/Model/Model.php, line 776
Aro::node() - CORE/Cake/Model/Behavior/AclBehavior.php, line 88
AclBehavior::node() - CORE/Cake/Model/Behavior/AclBehavior.php, line
88
AclBehavior::afterSave() - CORE/Cake/Model/Behavior/AclBehavior.php,
line 106
ObjectCollection::trigger() - CORE/Cake/Utility/ObjectCollection.php,
line 130
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php,
line 246
Model::save() - CORE/Cake/Model/Model.php, line 1730
UsersController::add() - APP/Controller/UsersController.php, line 68
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line
488
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 103

----------------------------------------------------------------------------------------------

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 'node' at
line 1

SQL Query: node

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 436 → PDOStatement-
>execute(array)
CORE/Cake/Model/Datasource/DboSource.php line 403 → DboSource-
>_execute(string, array)
CORE/Cake/Model/Datasource/DboSource.php line 646 → DboSource-
>execute(string, array, array)
CORE/Cake/Model/Datasource/DboSource.php line 588 → DboSource-
>fetchAll(string, array, array)
CORE/Cake/Model/Model.php line 776 → DboSource->query(string,
array, Aro)
CORE/Cake/Model/Behavior/AclBehavior.php line 88 → Model-
>__call(string, array)
CORE/Cake/Model/Behavior/AclBehavior.php line 88 → Aro-
>node(array)
CORE/Cake/Model/Behavior/AclBehavior.php line 106 → AclBehavior-
>node(User, array, string)
[internal function] → AclBehavior->afterSave(User, boolean, array)
CORE/Cake/Utility/ObjectCollection.php line 130 →
call_user_func_array(array, array)
[internal function] → ObjectCollection->trigger(CakeEvent)
CORE/Cake/Event/CakeEventManager.php line 246 →
call_user_func(array, CakeEvent)
CORE/Cake/Model/Model.php line 1730 → CakeEventManager-
>dispatch(CakeEvent)
APP/Controller/UsersController.php line 68 → Model->save(array)
[internal function] → UsersController->add()
CORE/Cake/Controller/Controller.php line 488 → ReflectionMethod-
>invokeArgs(UsersController, array)
CORE/Cake/Routing/Dispatcher.php line 103 → Controller-
>invokeAction(CakeRequest)
CORE/Cake/Routing/Dispatcher.php line 85 → Dispatcher-
>_invoke(UsersController, CakeRequest, CakeResponse)
APP/webroot/index.php line 96 → Dispatcher->dispatch(CakeRequest,
CakeResponse)

--
Grüße Sie freundlich.
Tim Bischoff (Indianer3c)
Blogautor Passivhaus Experte
http://www.passivhaus-experte.de/blog

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.


To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php

No comments: