Saturday, February 2, 2013

Re: sql statement Cake 1.3 uses to add data

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);



On Sat, Feb 2, 2013 at 1:03 PM, Anja Liebermann <cake@anjaliebermann.de> 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" <cake@anjaliebermann.de> 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 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?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 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?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 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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

No comments: