we need to cure this at lgm2011
** Changed in: openclipart
Milestone: 3.0 => 3.1
--
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
Status in openclipart:
Confirmed
Status in Open Font Library:
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 : aikiframework.admins@lists.launchpad.net
Unsubscribe : https://launchpad.net/~aikiframework.admins
More help : https://help.launchpad.net/ListHelp
