(ZEND) Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]:

Question

When I try to execute this Sql-Statement I have this error :

*Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id_actualite' in where clause is ambiguous' in C:\wamp\www\contradictors\library\Zend\Db\Statement\Pdo.php on line 234*

Here is my code :

    <?php
        class Critique extends Zend_Db_Table
        {
             protected $_name = "Critique" ;

             public function select_critique($limit1, $limit2)
             {
                   $db = $this -> getDefaultAdapter() ;
                   $last_actu = $db -> select()
                                    -> order('id_actualite DESC')
                                    -> from('Actualite')
                                    -> limit($limit1) ;
                   $last_actu = $last_actu -> query() ;
                   $last_actu = $last_actu -> fetch() ;

                   $select = $db -> select()
                                 -> from('Critique')
                                 -> order('id_critique DESC')
                                 -> join('Actualite', 'Critique.id_actualite = Actualite.id_actualite')
                                 -> where('id_actualite = ' . $last_actu['id_actualite'])
                                 -> limit($limit2) ;
                  return $select -> query() ;
             }
        }
   ?>

I don't have any idea about this error :( thank you

mu is too short · Accepted Answer · 2011-12-03 21:42:21Z

2

You have two columns named id_actualite: Critique.id_actualite and Actualite.id_actualite, so the where clause

where('id_actualite = ' . $last_actu['id_actualite'])

is ambiguous. Try changing it to

where('Critique.id_actualite = ' . $last_actu['id_actualite'])

or

where('Actualite.id_actualite = ' . $last_actu['id_actualite'])

edited Dec 3, 2011 at 21:42

mu is too short

436k71 gold badges863 silver badges822 bronze badges

answered Dec 3, 2011 at 21:34

Baruch

22k32 gold badges138 silver badges215 bronze badges

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

1 Comment

Baruch Over a year ago

@Mehdi Your welcome. Please accept the answer if it works. Accepting and upvoting are the usual ways of thanking.

Collectives™ on Stack Overflow

(ZEND) Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]:

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related