This appears to be fixed. You can try this on any instance of Aiki:
select username, name from aiki_users LEFT JOIN aiki_users_groups on
(aiki_users.usergroup = aiki_users_groups.id)
and try to paginate the results.
** Changed in: openfontlibrary
Status: Confirmed => Fix Committed
--
You received this bug notification because you are a member of Aiki
Framework Admins, which is subscribed to aikiframework.
https://bugs.launchpad.net/bugs/579778
Title:
Pagination breaks if SQL statement contains 'JOIN'
Status in Aiki Framework:
Fix Released
Status in openclipart:
Fix Released
Status in Open Font Library:
Fix Committed
Bug description:
If you attempt to use a SQL statement with 'join' 's user gets a php
errors :
sql statement:
select posts.post_title, posts.post_content, posts.post_date, term.name as
category
from mywp_florica.wp_1posts posts join
mywp_florica.wp_1term_relationships rel on posts.id = rel.object_id
join mywp_florica.wp_1term_taxonomy tax on
tax.term_taxonomy_id = rel.term_taxonomy_id
join mywp_florica.wp_1terms term on term.term_id = tax.term_id
where posts.post_status = 'publish' and posts.post_type = 'post'
and term.name = 'media' order by posts.post_date desc
Notice Undefined variable: records_num in
<b>/var/www/floricavlad.com/system/widgets.php on line 397
Notice Undefined variable: records_num in
<b>/var/www/floricavlad.com/system/widgets.php on line 399
This is using aiki 337, note, the page still returns the proper
record. The 'records in page' field is set to 1.
My guess is that aiki isn't counting the records properly... am trying
to figure this out.. pagination needs to work better.
-- Update --
looked at the code
this line is causing problems
echo preg_match('/select(.*)from/i', $widget->normal_select,
$selectionmatch);
it does not properly populate the $selectionmatch array because it is
not checking for join statements ... think about passing the query
straight in, adding a count(*) to get that array to populate..
To manage notifications about this bug go to:
https://bugs.launchpad.net/aikiframework/+bug/579778/+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
