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.

Fatal Error creating a new category in Vanilla 2

edited January 2010 in Vanilla 2.0 - 2.8
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?


  • One other note. I have created a new Role between the time I added the first category and tried adding the second (the one that gave me the error msg).

    Could that be somehow causing this problem? I think that's the only thing that has changed.
Sign In or Register to comment.