::roots() return SQL error about closuretable HOT 16 CLOSED

SQL think "parentid" is a SQL column but it's php variable

from closuretable.

from closuretable.

@gchabb, what is 'parentid'? Clarify, please. Provide your schema.

from closuretable.

Entity.php, line 741:
$having = "(SELECT COUNT(*) FROM {$closure} WHERE {$descendant} = parentId AND {$depth} > 0) = 0";

from closuretable.

@vjandrea, oh. It's 01:29 already...

from closuretable.

@gchabb, what database do you use?

from closuretable.

PostgreSQL 8.4
I have to use 9,X ?

from closuretable.

@gchabb, it seems I have to rewrite the query due to having behaviour in PostgreSQL.

from closuretable.

Ok :)
Le 7 oct. 2013 17:21, "Jan Iwanow" [email protected] a écrit :

@gchabb https://github.com/gchabb, it seems I have to rewrite the query
due to having behaviour in PostgreSQL.

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/53#issuecomment-25817546
.

from closuretable.

@gchabb you can take part, if you want)

from closuretable.

i have understand your words but i don't think to be able to :)

from closuretable.

great job @franzose

from closuretable.

@gchabb, many thanks! ;) Though I had to test it on multiple databases initially.

from closuretable.

i think this is the same pb with ::tree(), it return just 2 elements of my table
i have insert 23 elements with ->appendChild($child).
for the 4 roots i have make insert like this : $page->appendChild($page) because they don't have child and it seems to insert the good id in closure table but ::tree() return only 2 childs of one root (one branch).

from closuretable.

@gchabb, please, make a separate issue and provide detailed description of what you're doing and what errors or misbehavior you get.

from closuretable.

ok i do another tests and create issue

from closuretable.