Change : $this->Tutorsession->setFlash To $this->Session->setFlash
Andras Kende http://www.kende.com/ On Wednesday, May 28, 2014 7:10:55 AM UTC-7, jagguy wrote: > > Hi, > > In cakephp I cant edit a row from my mysql db but I can add a new row on > the same table without error. > Not sure what to do or how to debug this. The edittutorsession function is > the problem > > 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 'setFlash' at line 1 > > public function addtutorsession() { > > > $te= $this->Tutorsession->Teacher->find('list', array('fields' => > 'Teacher.fullname')); > $this->set( 'te',$te); > > $this->set( 'st',$this->Tutorsession->Student->find('list', > array('fields' => array('Student.fullname') ))); > > > if ($this->request->is('post')) { > $this->Tutorsession->create(); > if ($this->Tutorsession->save($this->request->data)) { > $this->Session->setFlash(__('Your post has been saved.')); > return $this->redirect(array('action' => 'displayall')); > } > $this->Session->setFlash(__('Unable to add your post.')); > } > > } > > > public function edittutorsession($id = null) { > > > $te= $this->Tutorsession->Teacher->find('list', array('fields' => > 'Teacher.fullname')); > $this->set( 'te',$te); > > $this->set( 'st',$this->Tutorsession->Student->find('list', > array('fields' => array('Student.fullname') ))); > > > > if (!$id) { > throw new NotFoundException(__('Invalid post')); > } > > $post = $this->Tutorsession->findById($id); > if (!$post) { > throw new NotFoundException(__('Invalid post')); > } > > if ($this->request->is(array('post', 'put'))) { > $this->Tutorsession->id = $id; > if ($this->Tutorsession->save($this->request->data)) { > $this->Tutorsession->setFlash(__('Your post has been updated.')); > return $this->redirect(array('action' => 'displayall')); > } > $this->Session->setFlash(__('Unable to update your post.')); > } > > if (!$this->request->data) { > $this->request->data = $post; > } > } > > > /////////////// > view edittutorsession > > <?php > echo $this->Form->create('Tutorsession'); > echo $this->Form->input('teacher_id', array('options' => $te)); > echo $this->Form->input('student_id', array('options' => $st)); > > echo $this->Form->input('subject'); //text > echo $this->Form->input('sessiondate', > array('label' => 'Session')); > echo $this->Form->input('sessiontime', > array('label' => 'time')); > echo $this->Form->input('available'); > echo $this->Form->end('Save Post'); > ?> > > > > > <http://itfutures.edu.au?referer=email> > *P: (03) 9866 7737* > *E: in...@itfutures.edu.au <javascript:>* > *A: Suite 5 / Level 1 / 424 St Kilda Rd, Melbourne, 3004 > <https://www.google.com.au/url?sa=t&rct=j&q=&esrc=s&source=web&cd=15&cad=rja&uact=8&ved=0CKQBEPUXMA4&url=http%3A%2F%2Fmaps.google.com.au%2Fmaps%3Fgl%3Dau%26hq%3Ditfutures%26daddr%3D1%2F424%2BSt%2BKilda%2BRd%2C%2BMelbourne%2BVIC%2B3004%26panel%3D1%26f%3Dd%26fb%3D1%26geocode%3DFdKovv0dMSWkCCnfp02hHWjWajGLbygrlMPvUw%26cid%3D6048267865728511883&ei=hHUYU_abH8-okgXV7oGYDg&usg=AFQjCNEBpgXrGRhNzMxOzPLHRVSQkdpXUQ&bvm=bv.62577051,d.dGI>* > > > *Connect with us: * > > <http://plus.google.com/+itfutureseduau> > <http://linkedin.com/company/it-futures> > <http://youtube.com/user/itfutureseduau> <http://twitter.com/itfutures> > <http://facebook.com/itfutures> > > Please consider the environment before printing this email. > > > > This e-mail and any attachments to it (the "Communication") is, unless > otherwise stated, confidential, may contain copyright material and is for > the use only of the intended recipient. If you receive the Communication in > error, please notify the sender immediately by return e-mail, delete the > Communication and the return e-mail, and do not read, copy, retransmit or > otherwise deal with it. Any views expressed in the Communication are those > of the individual sender only, unless expressly stated to be those of > National Training and Solutions Provider Pty Ltd ABN 34 123 831 023, or any > of its related entities. NTSP does not accept liability in connection with > the integrity of or errors in the Communication, computer virus, data > corruption, interference or delay arising from or in respect of the > Communication. > -- 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 unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/d/optout.