Public bug reported:
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)
** Affects: aikiframework
Importance: Undecided
Status: New
** Description changed:
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)
--
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:
New
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
