ok, need to update aiki on the site, and then test the large sql
statement and see if that is problem and/or if it is solved.
** Changed in: openfontlibrary
Assignee: rg1024 (rg1024) => Christopher Adams (christopheradams)
--
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:
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..
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
