views:

355

answers:

4

I'm using Kohana 3.

I'm writing an update query, and it is working for everything except this one section.

If I do a var_dump() on the results of $db->execute() I get either a 1 or 0 to say it failed or not. It is failing in this example (returning 0).

How can I figure out what error is happening? It justs seems to be silenty failing at the time being. I tried doing echo mysql_error() but it didn't work, as I expected, as Kohana 3's db library uses PDO I'm pretty sure.

How can I figure out the error that has occurred?

A: 

I think the answer to your question is given here

AntonioCS
That looks like it's for Kohana 2.x . 3 is a whole rewrite.
alex
Oh ok sorry about that :(
AntonioCS
A: 

Inside the Controller run the profiler:

$this->profiler = new Profiler;

And then after rendering View you'll see a list of queries that were executed. Try them out by connecting to the database or by using some software (like MySQL Query Browser).

Good luck!

Mike P.
+1  A: 

Try executing this after calling $db->execute():

echo Database::instance()->last_query
dusan
A: 

It should throw an exception if it's a SQL error. You can catch this and echo it to get the error. See http://kerkness.ca/wiki/doku.php?id=crud_with_the_query_builder

zombor