zend database error output

Question

I cant see my error of Sql. It cuts my queries, and the error is meaningless except it informs there is an error. Like error in statement "select * from o.."

how can I get full query, so i can investigate how the error occured?

I previously wrote a sql function that throws debugging string if sql has error. I though zend'ers have needed and there should exists a code:

if(($error = mysql_error($conn)){
  $cagiri=debug_backtrace();
  $i=count($cagiri);

And says

  [Caller__Function__] => dbSave
  [Caller__Class__] => classBasic
  [Arguments] => Array
  (
   [0] => function : loadLinks
   [1] => 
   [1] => sql error: Duplicate entry 'http://www.istanbulboncugu.com/Lokma' for key 'url'
   [2] => query: insert into downloadLinks set `title`= 'Lokma : İstanbul - Avrupa', `url`= 'http://www.istanbulboncugu.com/Lokma', `site`= 'rssSehirFirsati', `status`= 'new'

So I dont dig 30 query, if there is error, Error string shows function that composed the query. Etc. I think Zend have lacks that kind of awareness. I know zend not prefers hard and log path against smart ways ?!?

nerkn · Accepted Answer · 2010-10-25 11:46:18Z

2

I start using that code, if there is error.

function results($q){
  $results  = Array();
  try{
    $results =  $this->_db->query($q)->fetchAll();
  }catch(Exception $e){
    var_dump($q);
    die($e->getMessage());
  }
  return $results;
}

answered Oct 25, 2010 at 11:46

nerkn

1,9761 gold badge24 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Lee · Accepted Answer · 2010-10-23 20:50:22Z

1

If you are using Zend_Db_Select you can get the full created query by doing

$select->__toString();

In reply to your comment, this is how you can get the SQL error message:

try {
    $this->db->insert('Users', $array );
} catch (Exception $e){
    echo $e->getMessage();
}

edited Oct 23, 2010 at 20:50

answered Oct 22, 2010 at 15:40

Lee

3512 silver badges4 bronze badges

2 Comments

Eugene M Over a year ago

you can also type echo $select; - same thing.

nerkn Over a year ago

dude, I meant when there is error. Of course I can print my sqls.

Collectives™ on Stack Overflow

zend database error output

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related