Zend_Db_Table_Row_Exception

Question

I have this query below which I am trying to port to Zend (even further below lol). I am getting this error:

Uncaught exception 'Zend_Db_Table_Row_Exception' with message 'Specified column "admin_vfname" is not in the row'

But when I echo the $select and copy the sql into Navicat it runs fine? What is wrong with it because I can't clearly identify it?

SELECT `pay_administrator_actions`.*, `pay_administrator_actions`.* 
FROM `pay_administrator_actions` 
INNER JOIN `pay_administrator` 
ON pay_administrator.admin_uid = pay_administrator_actions.admin_uid 
WHERE (CONCAT(pay_administrator.admin_vfname, pay_administrator.admin_vlname) LIKE '%Daly%') 
LIMIT 10 

public function findActionsByName($name, $page, $rowCount) 
{
    $name = '%'.$name.'%';                
    $select = $this->select();
    $select->setIntegrityCheck(false);                
    $select->from('pay_administrator_actions');  
    $select->join('pay_administrator', 'pay_administrator.admin_uid = pay_administrator_actions.admin_uid', 'pay_administrator_actions.*');
    $select->where('CONCAT(pay_administrator.admin_vfname, pay_administrator.admin_vlname) LIKE  ?', $name);
    $select->limitPage($page, $rowCount);                
    return $this->fetchAll($select);
}

admin_vfname is in pay_administrator and in the query it is selecting * from that table so not sure why it can't find the row? — Kal
– Kal, Commented Jun 7, 2013 at 9:50
Change pay_administrator_actions.* to pay_administrator.* in your join. — Rikesh
– Rikesh, Commented Jun 7, 2013 at 9:54
Oh I see it now, woops, thank you put that as an answer and I'll accept :) — Kal
– Kal, Commented Jun 7, 2013 at 10:11

Rikesh · Accepted Answer · 2013-06-07 10:13:17Z

1

So as per my comment you need to change pay_administrator_actions.* to pay_administrator.* in your join.

$select->join('pay_administrator', 'pay_administrator.admin_uid =    
pay_administrator_actions.admin_uid', 'pay_administrator.*');

answered Jun 7, 2013 at 10:13

Rikesh

26.5k14 gold badges82 silver badges90 bronze badges

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

Comments

MrsPop88 · Accepted Answer · 2020-08-06 11:31:39Z

1

I had this error, turned out I had a space after column alias. So something like:

->from('orders', ('id, count(*) AS total order ')

Hope this helps another user!

answered Aug 6, 2020 at 11:31

MrsPop88

3034 silver badges14 bronze badges

Collectives™ on Stack Overflow

Zend_Db_Table_Row_Exception

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related