Great work ! Sent from my iPhone
On Oct 16, 2011, at 6:03 PM, rg1024 <[email protected]> wrote: > ** Changed in: aikiframework > Status: Fix Committed => Fix Released > > ** Changed in: aikiframework > Importance: Undecided => Medium > > -- > You received this bug notification because you are 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 -- You received this bug notification because you are a member of Aiki Framework Admins, 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.admins Post to : [email protected] Unsubscribe : https://launchpad.net/~aikiframework.admins More help : https://help.launchpad.net/ListHelp
