No Pagination: WSN Support

WSN Support » WSN Links » No Pagination » No Pagination

No Pagination
Pageination is missing from the list of categories

Version: 4.0.26
Example URL: http://www.franklincountry.com/business-finder/

No Pagination

kiwibob
Member

Usergroup: Customer
Joined: Oct 18, 2004
Total Topics: 4
Total Posts: 14

Posted 04/27/07 - 11:39 PM:	#1
I've upgraded to version 4 and now have two problems. First the list of categories does not allow the user to get to the next page. I can't for the life of me see why this should be. I've fallen the site back but I can set up a test site with the problem if necessary Secondly it's become apparent that I don't know what mods the developer made to the templates when this site was set up. I'd like to move to the current set of templates and integrate the mods but I don't know what version the mods were based on. Is there a way to tell? Edited by kiwibob on 04/28/07 - 12:13 AM

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 6022

Posted 04/28/07 - 01:27 PM:	#2
If they didn't specify what version they wrote the templates for I don't think there's a way to tell, but presumably it's the version you were using before you upgraded? Right now it looks like you've somehow got it set to use mysqli on a server that doesn't support it. I don't see how that's possible to induce, unless you downgrade PHP/MySQL. Anyhow, edit config.php to change each instance of mysqli to mysql. I think I'll need to see the problem to get an idea (unless there's a procedure to reproduce). Edited by Paul on 04/28/07 - 01:40 PM
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

kiwibob
Member

Usergroup: Customer
Joined: Oct 18, 2004
Total Topics: 4
Total Posts: 14

Posted 08/13/07 - 10:27 PM:	#3
Hi Paul, Sorry this has taken so long to get back to. I upgraded to V4 a few weeks ago but I now see that the list of categories still offers no page: nos. I've tried it with the distributed templates and also upgraded to 4.0.36 but no difference. see http://www.franklincountry.com/business-finder/ I've checked the config.php and it is mysql, not mysqli. Any thoughts?

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 6022

Posted 08/15/07 - 09:56 PM:	#4
The category pagination only works for subcategory pages I see, not for the main index. Made the main index work in the next release.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

kiwibob
Member

Usergroup: Customer
Joined: Oct 18, 2004
Total Topics: 4
Total Posts: 14

Posted 08/16/07 - 11:57 AM:	#5
Ah. I was convinced I'd broken something. Thanks very much for that.

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 6022

Posted 08/16/07 - 01:26 PM:	#6
Note you need to include the <IF {SUBCATMULTIPAGE}...</IF> stuff from the main index template after upgrading.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

kiwibob
Member

Usergroup: Customer
Joined: Oct 18, 2004
Total Topics: 4
Total Posts: 14

Posted 08/17/07 - 08:33 PM:	#7
Sorry Paul, I've done the upgrade but these still seems to be a problem. The Page no now exists on page one which looks fine but the 2nd page shows the next 100 (I think I didn't count them) rather than the next 50. Page 3 seems to be even longer (150 I guess) You can see this on http://www.franklincountry.com/business-finder/

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 6022

Posted 08/20/07 - 03:43 AM:

Change

 $catdata = $db->select($settings->categoryfields, 'categoriestable', "parent=0 AND validated=1 AND hide=0 AND isalbum=0 AND deleted=0", $ordercats, "LIMIT $start,$end");

 $catdata = $db->select($settings->categoryfields, 'categoriestable', "parent=0 AND validated=1 AND hide=0 AND isalbum=0 AND deleted=0", $ordercats, "LIMIT $start,$subperpage");

in index.php

"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

You don't have permission to post.

Please login or register.