Alright after a bit more research, with debug level set at 2 run this after your query.
$log = $this->b->a->getDataSource()->log(false,false); debug($log); Reference for the above is coming from here: http://stackoverflow.com/questions/3647065/how-can-i-see-cakephps-sql-dump-in-the-controller On Sat, Feb 2, 2013 at 1:03 PM, Anja Liebermann <[email protected]>wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi Jonathan, > > debug 2 ( or also 3) only shows me the SELECT statements, but not the > INSERT statements. > > > Calamity Jane > > > Am 02.02.2013 20:01, schrieb Jonathan Sundquist: > > You should be able to set debug level to 2 and see all statement types. > > On Feb 2, 2013 12:58 PM, "Anja Liebermann" <[email protected]> > wrote: > > > > Hello everybody, > > > > I need help to find out why my model isn't saving. I use version 1.3.14 > > and develop with Cake since some years but at this moment I am > > completely stuck. Duh... > > > > I have Model A which hasOne Model B. B belongsTo A. > > > > In controller B I try to move data from B to A by calling after some > > transformations > > $this->B->A->save($this->data). > > That worked fine until I did some changes to my code and now I am stuck > > with a boolean false for this saving attempt. The data also really isn't > > saved to my table. But why? > > $this->data contains of course an array with ['A'] and all the data > > which should go to A. > > > > I already disabled any beforeSave and validation rules, but still no > save. > > > > My question: How can I see with which sql statement Cake tries to add > > the data to my table? All I found is ways to see the select statements, > > but none for inset / update statements. > > > > Any hints on that would be appreciated and of course hints for other > > things I can try to find the source of my error, too! > > > > Hope I listed all information needed. > > > > > > Calamity Jane > >> > >> -- > >> 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?hl=en. > >> For more options, visit https://groups.google.com/groups/opt_out. > >> > >> > >> > > > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.11 (GNU/Linux) > > iEUEARECAAYFAlENYvgACgkQbOdiIJzHNKHRWgCZAbB9ij3e2OQ+E5y9cYjzjjpD > xzkAliwuayu+uVNC+kDZEvKoQ3kuNkk= > =C0dq > -----END PGP SIGNATURE----- > > -- > 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?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
