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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php