i have test sql in last aiki and it's work. There were problems with pagination and GROUP but it is corrected..i hope.
-- 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
