MyPMS Enhanced - To fix this problem in myPMS enhansed and probably the other varients of myPMS open open.php in the Components/com_pms directory. At around line 254 find the line
[code:1] if($cb_use=='1') $query="SELECT t1.username,t1.name FROM #__users AS t1, #__comprofiler AS t2 WHERE t1.block!='1' AND t2.approved='1' AND t2.confirmed='1' AND t1.username!='$my->username' AND t1.id=t2.user_id ORDER BY username";[/code:1]and change it to
[code:1] if($cb_use=='1') $query="SELECT t1.username,t1.name FROM #__users AS t1, #__comprofiler AS t2 WHERE t1.block!='1' AND t2.approved='1' AND t2.confirmed='1' AND t1.username!='$my->username' AND t1.id=t2.user_id ORDER BY name";[/code:1]then find at line 255
[code:1] else $query="SELECT username,name FROM #__users WHERE block!='1' AND username!='$my->username' ORDER BY username";[/code:1] and change it to
[code:1] else $query="SELECT username,name FROM #__users WHERE block!='1' AND username!='$my->username' ORDER BY name";[/code:1]