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: i...@itfutures.edu.au <i...@itfutures.edu.au>*
*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.
