SQL SYNTAX ERROR IN POSTGRESQL

File: avatar_selection.module

Message: user warning: query: SELECT count(*) FROM avatar_selection avs LEFT JOIN avatar_selection_roles avsr ON avs.aid = avsr.aid WHERE avsr.rid IS NULL OR avsr.rid IN (2,3) ORDER BY weight, name, avatar in [...]\sites\all\modules\avatar_selection\avatar_selection.module on line 453.

Solution: Delete ORDER BY Clause in sql sentences type SELECT count(*). Ex: SELECT count(*) FROM avatar_selection avs LEFT JOIN avatar_selection_roles avsr ON avs.aid = avsr.aid WHERE avsr.rid IS NULL OR avsr.rid IN (2,3)
Lines: 398, 402, 410, 415, 433, 438, 448, 453, 461

I attach fixed file. Rename avatar_selection.module.txt to avatar_selection.module and replace in your site.