Assign random avatar

    * warning: array_fill() [function.array-fill]: Number of elements must be positive in /home/redluk/public_html/kankand6/includes/database.inc on line 240.
    * warning: implode() [function.implode]: Invalid arguments passed in /home/redluk/public_html/kankand6/includes/database.inc on line 240.
    * user warning: 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 weight, name, avatar' at line 1 query: SELECT count(*) FROM avatar_selection avs LEFT JOIN avatar_selection_roles avsr ON avs.aid = avsr.aid LEFT JOIN avatar_selection_og avso ON avs.aid = avso.aid WHERE (avsr.rid IS NULL OR avsr.rid IN (2)) AND (avso.ogid IS NULL OR avso.ogid IN ()) ORDER BY weight, name, avatar in /home/redluk/public_html/kankand6/sites/all/modules/avatar_selection/avatar_selection.module on line 446.
    * warning: array_fill() [function.array-fill]: Number of elements must be positive in /home/redluk/public_html/kankand6/includes/database.inc on line 240.
    * warning: implode() [function.implode]: Invalid arguments passed in /home/redluk/public_html/kankand6/includes/database.inc on line 240.
    * user warning: 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 weight, name, avatar LIMIT 0, 999' at line 1 query: SELECT DISTINCT avatar, name, weight FROM avatar_selection avs LEFT JOIN avatar_selection_roles avsr ON avs.aid = avsr.aid LEFT JOIN avatar_selection_og avso ON avs.aid = avso.aid WHERE (avsr.rid IS NULL OR avsr.rid IN (2)) AND (avso.ogid IS NULL OR avso.ogid IN ()) ORDER BY weight, name, avatar LIMIT 0, 999 in /home/redluk/public_html/kankand6/sites/all/modules/avatar_selection/avatar_selection.module on line 448.

This is what I get with the latest dev. Maybe it doesn't like that I have no OG :)

I downloaded today the latest dev. It fixed the problem but I still have one related to assigning a random avatar. If a user has a custom image set as avatar and wants to delete it instead of a new random avatar he gets just a path to the avatar_selection folder.
To fix the problem, in avatar_selection.module from line 339 I changed

    if ($user->picture) {
      $form_state['values']['picture'] = $user->picture;
    }
    else {
      $form_state['values']['picture'] = avatar_selection_get_random_image($user);
    }

to

    if ($user->picture && $form_state['values']['picture_delete'] != '1') {
      $form_state['values']['picture'] = $user->picture;
    }
    else {
      unset($form_state['values']['picture_delete']);
      $form_state['values']['picture'] = avatar_selection_get_random_image($user);
    }

good to hear