Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Options
Fatal Error creating a new category in Vanilla 2
I am getting this message when I try to create a new category. I have added 1 category before with no problems...
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by r.Sort, r.Name asc' at line 4
select coalesce(p.`Vanilla.Discussions.View`, 0) as `Vanilla.Discussions.View`, coalesce(p.`Vanilla.Discussions.Add`, 0) as `Vanilla.Discussions.Add`, coalesce(p.`Vanilla.Discussions.Edit`, 0) as `Vanilla.Discussions.Edit`, coalesce(p.`Vanilla.Discussions.Announce`, 0) as `Vanilla.Discussions.Announce`, coalesce(p.`Vanilla.Discussions.Sink`, 0) as `Vanilla.Discussions.Sink`, coalesce(p.`Vanilla.Discussions.Close`, 0) as `Vanilla.Discussions.Close`, coalesce(p.`Vanilla.Discussions.Delete`, 0) as `Vanilla.Discussions.Delete`, coalesce(p.`Vanilla.Comments.Add`, 0) as `Vanilla.Comments.Add`, coalesce(p.`Vanilla.Comments.Edit`, 0) as `Vanilla.Comments.Edit`, coalesce(p.`Vanilla.Comments.Delete`, 0) as `Vanilla.Comments.Delete`, r.RoleID as `RoleID`, r.Name as `Name`, r.CanSession as `CanSession` from GDN_Role r left join GDN_Permission p on p.RoleID = r.RoleID and p.JunctionTable = 'Category' and p.JunctionColumn = 'CategoryID' and p.JunctionID = order by r.Sort, r.Name asc
I can tell there's a problem with the "p.JunctionID = (blank)" in the last line...any ideas why that is blank?
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by r.Sort, r.Name asc' at line 4
select coalesce(p.`Vanilla.Discussions.View`, 0) as `Vanilla.Discussions.View`, coalesce(p.`Vanilla.Discussions.Add`, 0) as `Vanilla.Discussions.Add`, coalesce(p.`Vanilla.Discussions.Edit`, 0) as `Vanilla.Discussions.Edit`, coalesce(p.`Vanilla.Discussions.Announce`, 0) as `Vanilla.Discussions.Announce`, coalesce(p.`Vanilla.Discussions.Sink`, 0) as `Vanilla.Discussions.Sink`, coalesce(p.`Vanilla.Discussions.Close`, 0) as `Vanilla.Discussions.Close`, coalesce(p.`Vanilla.Discussions.Delete`, 0) as `Vanilla.Discussions.Delete`, coalesce(p.`Vanilla.Comments.Add`, 0) as `Vanilla.Comments.Add`, coalesce(p.`Vanilla.Comments.Edit`, 0) as `Vanilla.Comments.Edit`, coalesce(p.`Vanilla.Comments.Delete`, 0) as `Vanilla.Comments.Delete`, r.RoleID as `RoleID`, r.Name as `Name`, r.CanSession as `CanSession` from GDN_Role r left join GDN_Permission p on p.RoleID = r.RoleID and p.JunctionTable = 'Category' and p.JunctionColumn = 'CategoryID' and p.JunctionID = order by r.Sort, r.Name asc
I can tell there's a problem with the "p.JunctionID = (blank)" in the last line...any ideas why that is blank?
0
Comments
Could that be somehow causing this problem? I think that's the only thing that has changed.