Fatal Error creating a new category in Vanilla 2

LOVEolution

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?

LOVEolution

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.