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 <[email protected]> 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.
