Re: [fw-db] Zend_Db_Select SQL 'unknown column' error

try to add the "countries.countries_id" field like this:

->join('countries',
'countries.countries_id = addresses.countries_id',
array('country','countries_id'))

emorgan wrote:
>
> Hi,
> I am using a select object in a class that extends Zend_Db_Table_Abstract
> ... I have a complex query that is giving me this error:
>
> SQLSTATE[42S22]: Column not found: 1054 Unknown column
> 'countries.countries_id' in 'where clause'
>
> What is really stumping me is that when I echo out the select statement
> just before calling fetchAll(), I get the output and run it in MySQL, and
> the query works just fine with no errors. So I'm not sure if I've stumbled
> across a bug in how the select object is being handled. Any suggestions?
>
> Here is my code to build the select object:
> $select = $this->select()
> ->from($this, array('inquiries_id', 'date_created'))
> ->setIntegrityCheck(false)
> ->joinUsing('contacts', 'contacts_id', $contactFields)
> ->joinUsing('addresses', 'addresses_id', $addressFields)
> ->join('countries',
> 'countries.countries_id = addresses.countries_id',
> 'country')
> ->join('users', 'users.users_id = inquiries.entered_by',
> array('users_id', 'username'));
>
> and it later gets modified with this:
> $select->joinUsing('inquiries_catalogs', 'inquiries_id', '')
> ->where('catalogs_id = ?', $search->catalogs_id);
>
> ... and this:
> $select->where('countries.countries_id = ?', 'GB');
>
> Below is what I get when I echo the select object:
>
> SELECT `inquiries`.`inquiries_id`, `inquiries`.`date_created`,
> `contacts`.`name`, `contacts`.`company_name`, `addresses`.`address1`,
> `addresses`.`address2`, `addresses`.`city`, `addresses`.`states_id`,
> `addresses`.`state_desc`, `addresses`.`postal`, `countries`.`country`,
> `users`.`users_id`, `users`.`username`
> FROM `inquiries`
> INNER JOIN `contacts` ON `contacts`.contacts_id = `inquiries`.contacts_id
> INNER JOIN `addresses` ON `addresses`.addresses_id =
> `inquiries`.addresses_id
> INNER JOIN `countries` ON countries.countries_id = addresses.countries_id
> INNER JOIN `users` ON users.users_id = inquiries.entered_by
> INNER JOIN `inquiries_catalogs` ON `inquiries_catalogs`.inquiries_id =
> `inquiries`.inquiries_id
> WHERE (catalogs_id = '1') AND (countries.countries_id = 'GB')
>
> Thanks!
> Eugene
>

-----
visit my website at http://www.phpscriptor.com/ http://www.phpscriptor.com/
--
View this message in context: http://www.nabble.com/Zend_Db_Select-SQL-%27unknown-column%27-error-tp21937903p21943185.html
Sent from the Zend DB mailing list archive at Nabble.com.