Hi Karthi I have the same problem as the person who posted the errors. I truncated the the 2 tables and still doesn't work.
Do you perhaps have another solution to this? Thanks Victor On Wednesday, 21 March 2012 19:28:17 UTC+2, karthik wrote: > > 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 <[email protected]> > 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 -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php?hl=en.
