Closed (fixed)
Project:
Views Alpha Pager
Version:
4.7.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Reporter:
Created:
10 May 2007 at 10:39 UTC
Updated:
25 May 2007 at 15:35 UTC
It seems the current 4.7-dev release just doesn't page. Whatever letter is selected, the same view results are returned - starting from 'A'. Pretty much rendering the module useless.
The 5.x-dev branch had this problem until the recent CVS commits which resolved it.
Comments
Comment #1
buddaHere's the generated $view->query if it's of any help in debugging...
SELECT node.nid, node.title AS node_title, node.changed AS node_changed, node_data_field_description_of_work.field_description_of_work_value AS node_data_field_description_of_work_field_description_of_work_value, node_data_field_description_of_work.field_description_of_work_format AS node_data_field_description_of_work_field_description_of_work_format FROM {node} node LEFT JOIN {node_content_profile} node_data_field_description_of_work ON node.vid = node_data_field_description_of_work.vid WHERE left(trim(LEADING 'And ' FROM (trim(LEADING 'The ' FROM (trim(LEADING 'A ' FROM (trim(LEADING '\'' FROM (trim(LEADING '"' FROM (trim(LEADING ' ' FROM (upper(node.title))))))))))))), 1) = 'B' AND (node.status = '1') AND (node.type IN ('content_profile')) ORDER BY left(trim(LEADING 'And ' FROM (trim(LEADING 'The ' FROM (trim(LEADING 'A ' FROM (trim(LEADING '\'' FROM (trim(LEADING '"' FROM (trim(LEADING ' ' FROM (upper(node.title))))))))))))), 1), node_title ASCComment #2
buddaI had a thought this morning, it is probably related to the fact that my view is a table based one? I noticed support was only recently added to the 5.x branch for table based views.
Any chance of a back port?
Comment #3
douggreen commentedI had to make changes to views_alpha_pager 5.x to accommodate changes in views DRUPAL-5--1-6-BETA5. I just noticed that there is also a DRUPAL-4-7--1-6-BETA5 branch, so I suspect that there might be similar incompatibilities in 4.7.x. Please try using a stable version of views from the DRUPAL-4-7--1-5. If this solves the problem, it confirms what needs to be back-ported.
I don't think that it is table related, although that's possible. I believe the recent support for tables was in selecting the correct sort field.
Comment #4
buddaYeah Alpha pager works fine with VIews 4.7-1.5
Comment #5
douggreen commentedOK, I'll back-port the changes for views 1.6 version to the DRUPAL-4-7 tag.
Comment #6
buddaHi Doug, is it possible to backport for 4.7 Views beta from 2 weeks ago? i've got
views.module,v 1.159.2.59installed but Alpha Pager doesn't work.Comment #7
douggreen commentedPlease test and let me know if this works and is stable so I can cut a tag. If this works for you please change the status to closed.
Comment #8
buddaWorks perfect. Installed on http://www.liverpooleveryparentmatters.org.uk/directory/browse for testing.