Re: ACL - Error Messages after Add New User

First truncate all data's in GROUP and USER table then add data's once
again.
Make sure whether you have linked GROUP and USER model correctly using
$actsAs requester. and its relations GROUP hasMany USER and USER
belongsTo GROUP

-karthi

On Mar 18, 9:26 am, Passivhaus Experte <i...@passivhaus-experte.de>
wrote:
> Hi,
>
> I'm a newbie.
>
> I use the CakePHP Version 2.1.0 and followed the following descriptionhttp://book.cakephp.org/2.0/en/tutorials-and-examples/simple-acl-cont...
>
> 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 Expertehttp://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