makeRoot() fails on already existing items about baum HOT 5 CLOSED

From what I can deduce of the error the table has null values for the lft column. That is not possible and the error comes because of that situation.

As you say you already had that table in place and you added the necessary columns, try to run Category::rebuild();. Issuing this method will rebuild the lft, rgt and depth column values provided you have a parent_id field available in your table.

from baum.

Is this still happening?

from baum.

Hey, no you can close it. Probably it was my fault, however I switched over to another solution. I will try it in my next project ( Baum::rebuild() ) and feed back, if it worked ;)

from baum.

Hi, the same happens to me with L5, I created a new project with Baum, but I had some problems so I removed Baum to check it in a more clean enviroment. Now after creating some tasks (is a tasks and subtasks system), I'm trying to enable the "Task extends \Baum\Node". But when for ex I try the $task->makeRoot(); i receive InvalidArgumentException in Builder.php line 457. When I try: \App\Task::rebuild;, with or without force, null return is produced, but when I do $task->save(); I've got the same error: line 457 .. .at Builder->where('lft', '<=', null) ....

In the Task i've: parent_id = 0, lft,rgt,depth and path stays in null.

Any Idea? Thanks in advance!,
David Lyons

from baum.

Solved!!!! The problem was that I've setup parent_id manually and it was not nullable. So I did the migration:
$table->integer('parent_id')->nullable()->default()->change();
Then in the Tinker:
\App\Task::rebuild(true);
And everything is fine!!

Thanks for this package!

from baum.