Bug: Category with special Chars

kaikajus

Just to report a little bug I ran over by using special chars such as ä ö ü for the category, and got a Fatal Error:

ou 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

The error occurred on or near: vanilla/library/database/class.database.php

213: if ($PDOStatement === FALSE) {

214: trigger_error(ErrorMessage($this->GetPDOErrorMessage($this->Connection()->errorInfo()), $this->ClassName, 'Query', $Sql), E_USER_ERROR);

215: }

Flam9

http://vanillaforums.org/discussion/9714/How-to-Submit-a-Bug-Report/#Item_1

kaikajus

Thanks Flam9, I used the issue tracker!

http://github.com/lussumo/Garden/issues/#issue/121