Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

dealing with existing data applied to nestedset #612

Open
omarIbrahim2 opened this issue Feb 25, 2025 · 0 comments
Open

dealing with existing data applied to nestedset #612

omarIbrahim2 opened this issue Feb 25, 2025 · 0 comments

Comments

@omarIbrahim2
Copy link

i have a project which has tables and data exist when i set up migration needed in nestedset package _lft and _rgt default is 0
when i try to update the data and create childrens and reconstruct the the tree
this error appeared
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '0 else _lft end, _rgt = case when _rgt between 2 and 1 then _rgt-1 wh...' at line 1
how can i solve this problem ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant