[Solar-talk] problem with related tables with latest svn

[Paul M Jones]

On Apr 12, 2008, at 08:21 , Paul M Jones wrote:
> On Apr 12, 2008, at 06:45 , Jeff Surgeson wrote:
>
>>        SELECT
>> 	COUNT(gallery.id)
>> 	FROM gallery
>> 	WHERE
>> 		gallerycat.sub_cat_name = \'bike images\'
>> 	LIMIT 1
>
> The reason it doesn't work is the WHERE clause; there's no FROM or  
> JOIN to the "gallerycat" table.  I'll go back over the countPages()  
> code and make sure it's not stripping things out that it needs.   
> Sorry for the trouble.

I've figured out what the trouble is; Solar_Sql_Model::countPages()  
does not honor "eager" joins.  Will start working on that right now.   
Again, sorry for the trouble.


-- pmj