** Changed in: aikiframework
       Status: Fix Committed => Fix Released

** Changed in: aikiframework
   Importance: Undecided => Medium

-- 
You received this bug notification because you are a member of Aiki
Framework Developers, which is subscribed to aikiframework.
https://bugs.launchpad.net/bugs/838895

Title:
  pagination break if SQL contans GROUP BY

Status in Aiki Framework:
  Fix Released

Bug description:
  I use this SQL on OCAL and pagination is not displayed at all

  select username, avatar, full_name, first_login, count(ocal_files.id)
  AS uploads from aiki_users, ocal_files where username != '' AND
  num_uploads != 0 AND aiki_users.username = ocal_files.user_name AND
  filename RLIKE ".svg" AND upload_published = 1 GROUP BY username ORDER
  BY uploads DESC

  probably because of GROUP BY (there is no JOIN and inner query)

To manage notifications about this bug go to:
https://bugs.launchpad.net/aikiframework/+bug/838895/+subscriptions

_______________________________________________
Mailing list: https://launchpad.net/~aikiframework-devel
Post to     : aikiframework-devel@lists.launchpad.net
Unsubscribe : https://launchpad.net/~aikiframework-devel
More help   : https://help.launchpad.net/ListHelp

Reply via email to