[development] problem with db_rewrite_sql

[Lluís]

I tunned by module so now:
- just one $grant is assigned to user (before "visitor" and "editor"
was assigned to "editors")
- two records are saved for the node, one read-only and one read&write

The problem persists, any other hint?

On Tue, Nov 24, 2009 at 5:17 PM, Earl Miles <merlin at logrus.com> wrote:
> Lluís wrote:
>>
>> ok, I have now read "Creative querying".
>>
>> Otherwise, I have a problem using "views" and "group by" modules, the
>> query is basically a
>>
>> "SELECT a, SUM(b) FROM table JOIN... WHERE ... GROUP BY a"
>>
>> It works perfectly before db_rewrite_sql (show more rows, but the SUM
>> is ok); but after de db_rewrite_sql it show the correct rows but
>> SUM(b) is doubled.
>
> Yes, probably because the user is a member of 2 different roles that have
> access, and therefore the GROUP BY ends up counting both. There's a problem
> similar to this in core in counting forum posts, for example. I don't know
> of any solutions to this, either. This is a really unfortunate effect of the
> query we use. :/
>



-- 
*Les normes hi són perquè hi pensis abans de saltar-te-les
*La vida és com una taronja, què esperes a exprimir-la?
*Si creus que l'educació és cara, prova la ignorància.
*La vida és com una moneda, la pots gastar en el que vulguis però
només una vegada.
*Abans d'imprimir aquest missatge, pensa en el medi ambient.