What happens when you try the save? Does it create a new row instead or does it fail somewhere?
On 28 May 2014, at 15:10, jagguy <[email protected]> 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'); > ?> > > > > > P: (03) 9866 7737 > E: [email protected] > A: Suite 5 / Level 1 / 424 St Kilda Rd, Melbourne, 3004 > > > > Connect with us: > > > > 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 [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/cake-php. > For more options, visit https://groups.google.com/d/optout. -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/d/optout.
