-
Notifications
You must be signed in to change notification settings - Fork 132
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
Issue with add site tree item (using ms-sql) #162
Comments
Sorry, completely missed that issue out. |
Hi, I have the same problem here. What I see is that although the form does not pass the id as value, by the time the sql gets generated the insert has id = 1
|
ignore my previous comment. it is the tree_id which is 1 and it is of course ok. Still debugging |
At least for me the problem is the alias. If it is empty I get the error above. The database is set up correctly to allow nulls. Not sure what is going on but if you are having this problem just make sure you fill the alias. |
I can only add one site tree item to a site tree. When I attempt to add a second, I get this error:
('23000', "[23000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of UNIQUE KEY constraint 'sitetree_treeitem_tree_id_15363010_uniq'. Cannot insert duplicate key in object 'dbo.sitetree_treeitem'. The duplicate key value is (1, ). (2627) (SQLExecDirectW); [01000] [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated. (3621)")
Please let me know how I can help (clarifications, more detail, etc).
The text was updated successfully, but these errors were encountered: