** Changed in: aikiframework
Milestone: 0.7 => 0.8
--
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:
Confirmed
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..
_______________________________________________
Mailing list: https://launchpad.net/~aikiframework.admins
Post to : [email protected]
Unsubscribe : https://launchpad.net/~aikiframework.admins
More help : https://help.launchpad.net/ListHelp
