Products Pagination - Support Thread

It does it on the product pages as well not just the main page slider

The problem is that the main page's slider defines the paging for the slider using the same class name as the products' pagination. Since stylesheet_slider sorts higher alphabetically than stylesheet_prod_pagination, it's being loaded after the pagination stylesheet and causing its styles for the pagination class to be applied to the pagination links.

Since the slider is only used on your home page, I suggest renaming stylesheet_slider.css to index_home.css so that it's only loaded on the home page. That way its definitions for the styling of the pagination class won't conflict with those in the products' pages.

Thanks for the reply. Pulling the pagination from the slider css worked

Glad you got it sorted out!

Hello and thanks for this great addon! :)

I have a one question, how can I setup this to work with descending model order? Products are listed in descending order by their model number, but pagination is opposite of that. First product with largest model number is displayed last in pagination and I have to click "previous" to go to the second product.
What I'm trying to say is that I want to reverse pagination order. By clicking next-button, it should go to product that has smaller model number. Pagination numbers should be 1=largest model number, 2=one smaller and so on...

My site is: www(dot)hkproduction(dot)fi(/)kauppa

Is there something that I can change from the code? I don't believe it's the settings that causes this, because it worked with the original prev-next code.

For some reason, pagination is still having issues with dropping the search_in_description variable on the advanced search results page. If I use the search on the advanced search page for burningbutterfly . com for "red" and choose the "search in description" option, I initially get 115 results but that drops to 17 when I paginate. If I manually add the search_in_description back into the url, the correct number of products returns. I'm using the most recent version and have replicated the error on a clean install of zen cart v1.5.1. I've also looked at a couple of other sites that use this mod and it's happening there too.

When I use web developer for ff to display hidden content, search_in_description is attached to the function.

If you get the chance, would you please direct me where I need to look to try to fix this?

Thanks in advance!

I see the issue, but no "ready" fix at this time (that search page was a pain, if I remember correctly!). I'll give it a look later today or early tomorrow.

I think I found it ... look in the plugin's /includes/classes/split_page_results.php, starting at line 95:

//-bof-product pagination
//    if (strpos($query_lower, 'distinct') || strpos($query_lower, 'group by')) {
    if ((strpos($query_lower, 'distinct') || strpos($query_lower, 'group by')) && is_numeric($count_key)) {
//-eof-product_pagination

and back that change out:

    if (strpos($query_lower, 'distinct') || strpos($query_lower, 'group by')) {

Let me know if this gets it (it did on one of my sites) and I'll package up a bugfix release.

lat9:

I think I found it ... look in the plugin's /includes/classes/split_page_results.php, starting at line 95:

//-bof-product pagination
// if (strpos($query_lower, 'distinct') || strpos($query_lower, 'group by')) {
if ((strpos($query_lower, 'distinct') || strpos($query_lower, 'group by')) && is_numeric($count_key)) {
//-eof-product_pagination

> and back that change out:
> ```
    if (strpos($query_lower, 'distinct') || strpos($query_lower, 'group by')) {

Let me know if this gets it (it did on one of my sites) and I'll package up a bugfix release.

Unfortunately not. Because it isn't passing parameters, I was thinking (and please feel free to correct me if I'm wrong) it had to be one of the href lines in either the class or function. Either way, it isn't a big deal - I'm not getting enough visitors to necessitate a full in-depth search; I just like to know how things work so I can learn to fix them myself.

What version of products_pagination are you using? I ask because the mini-form for the dropdown pagecount has an onchange="this.form.submit();" parameter, but yours has onsubmit="this.form.submit();", so there's been some messing in /includes/classes/split_page_results.php. It's also not usual that all the next-page links are disabled.

lat9:

What version of products_pagination are you using? I ask because the mini-form for the dropdown pagecount has an onchange="this.form.submit();" parameter, but yours has onsubmit="this.form.submit();", so there's been some messing in /includes/classes/split_page_results.php. It's also not usual that all the next-page links are disabled.

Thanks for looking! I'm using v1.4.6 The differences would be me playing with both the function and split_page_results.php file (trying to figure out where the gap in communication is by comparing it to the way the alpha filter works). For some reason, I just can't get it to acknowledge $parameters...

I just noticed something. After restoring the files to their defaults (plus the change in your previous post), the parameters are in the form, but the form action doesn't have them. So instead of the action being

index.php?main_page=advanced_search_result&keyword=RED&search_in_description=1&categories_id=&inc_subcat=1&manufacturers_id=&pfrom=&pto=&dfrom=&dto=

it's

index.php?main_page=advanced_search_result&keyword=RED&inc_subcat=1&sort=4a

Could it have something to do with zen_get_all_params()?

I think I fixed the item per page dropdown. Whether or not it broke something else remains to be seen...

In includes/functions/extra_functions/products_pagination_functions.php on line 75, I changed it from

$dropdown  = '<div class="pp_count">' . (($displayForm) ? zen_draw_form('pp_count_form' . $formSuffix, zen_href_link($_GET['main_page'], zen_get_all_get_params()), 'post') : '') . zen_hide_session_id() . zen_draw_hidden_field ('main_page', $_GET['main_page']) . $baseValue;

to

$dropdown  = '<div class="pp_count">' . (($displayForm) ? zen_draw_form('pp_count_form' . $formSuffix, '', 'post') : '') . zen_hide_session_id() . zen_draw_hidden_field ('main_page', $_GET['main_page']) . $baseValue;

The form is a little jumpy now, but it's working.

Going through the search for "red" including product descriptions, the initial search finds 115 but clicking on any of the links or the per-page dropdown reverts to 17. I'm quite puzzled, since my needlework site's running the latest version (+fix) and has no problems (www. latitude9needlearts.com/index.php?main_page=advanced_search_result&keyword=the&search_in_description=1&categories_id=&inc_subcat=1&manufacturers_id=&pfrom=&pto=&dfrom=&dto=).

When you say you replicated the issue on a clean install of v1.5.1, I'm *assuming *that you're using your database and products. One difference I did notice is that my site (with an unmodified version of /includes/modules/pages/advanced_search/header_php.php) defaults the advanced search "search_in_descriptions" to 1 while your page defaults to 0.

I actually changed the default from 1 to 0 in the advanced search header.php file because if you look at some of the results from the "red" search, if they want a color, they're probably not looking for lip balm (that has red raspberry seed oil in it). Though this issue was happening before the switch.

Anyway, now that I think about it, my site was recently migrated to a "better server" by host gator and I've had nothing but obscure issues since so that might explain why I'm seeing the problem even on a clean install. I'm actually going to be changing hosts this weekend so I'll do some more troubleshooting before I install my customized site (ie make sure it isn't the seo mod that's causing the conflict and/or that it isn't a user error). The only reason I'm confused as to why this isn't working is because the dynamic filter is working and it's pretty much the same principal. Thanks so much for your help - I really appreciate it. Have a great weekend!

(P.S. Love your needlework site - the froggies make me want to start cross stitching again. :))

kamelion0927:

I actually changed the default from 1 to 0 in the advanced search header.php file because if you look at some of the results from the "red" search, if they want a color, they're probably not looking for lip balm (that has red raspberry seed oil in it). Though this issue was happening before the switch.

Anyway, now that I think about it, my site was recently migrated to a "better server" by host gator and I've had nothing but obscure issues since so that might explain why I'm seeing the problem even on a clean install. I'm actually going to be changing hosts this weekend so I'll do some more troubleshooting before I install my customized site (ie make sure it isn't the seo mod that's causing the conflict and/or that it isn't a user error). The only reason I'm confused as to why this isn't working is because the dynamic filter is working and it's pretty much the same principal. Thanks so much for your help - I really appreciate it. Have a great weekend!

(P.S. Love your needlework site - the froggies make me want to start cross stitching again. :))
Thanks for the update (and the compliment), I just wanted to be sure that it wasn't something weird ... not that it's not! I just don't get why my v1.5.1 site works and yours doesn't; this plugin just isn't that intrusive.

Finally got it sorted. The parameters were being excluded because of a change to functions_general.php that were made to accommodate the Dynamic Filter Add-On. I removed the changes from said mod and now both Dynamic Filter and Pagination are working with no thrown errors. Sooo, moral of my tale, if you are using this mod with Dynamic Filter AND have zen cart v1.5.1 installed, your best bet is to use functions_general.php that comes with zen cart v1.5.1 and not the one in the Dynamic Filter package. Thanks again!

Thanks for the report! What I was seeing on your site didn't make sense to me.

If I change the "items per page" to 90, it takes me to the home page.
Example. Go to http://theplaypages.com

the use the search and search for "lelo". Scroll to the bottom and change the "Items per page" to 90. It takes me back to the home page.

Can this be fixed?

palmislandinc:

If I change the "items per page" to 90, it takes me to the home page.
Example. Go to http://theplaypages.com

the use the search and search for "lelo". Scroll to the bottom and change the "Items per page" to 90. It takes me back to the home page.

Can this be fixed?
I'm sure it can! What's your setting for Configuration->Product Listing->Display Multiple Products Qty Box Status and Set Button Location?

P.S. It's good form to place a "warning" next to a website link that contains adult products.