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

OK, I'm a bonehead -- I am running two queries, one to select the record set
for the page and one to select a count of all records. Turns out I was
looking at the wrong query. I'm sorry but thanks anyway.

PHPScriptor wrote:
>
> 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
>>
>
>

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