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'); ?>
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+unsubscribe@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.
No comments:
Post a Comment