Products Pagination - Support Thread

[lat9]

This is a nice idea and looks like it would work well for what I need, but it seems there are still some problems. The installation worked fine and I was able to configure and start testing without any errors. My testing though has identified the following issues:

1) Couldn't get the items per page drop down selection to actually work unless the page selection drop down was also enabled. This is a problem as I don't want the page drop down enabled.

2) Once "all" is selected, you cannot select or return to a specific number of items per page. It just remains on "all".

3) Changing the Maximum Links and the Intermediate Links seems to have no effect on the display.

Here's a URL so you can see what is happening: http://www.tracyandprice.com/storete...cPath=71_79_81

This is my test store, so it doesn't matter if it gets broken. It is configured mostly with the default settings except for the number of items per page (I removed 10 as an option) so the default would display 25.

Since it's a test store, would you do me a favor and go to your admin's Configuration->Product Listing->Include Product Listing Alpha Sorter and change that to 'false'? I'm guessing that your problem(s) have something to do with that dropdown (that, of course, I haven't tested with) ...

[batracy]

Ok, changed that - doesn't seem to make any difference.

[lat9]

Just to let you know I'm working on it ... it's a bit of a mess with the multiple-products-add-to-cart but I should have it sorted out by tomorrow.

[lat9]

I've submitted v1.4.5 to the plugins area to correct the problem if your store has Configuration->Product Listing->Display Multiple Products Qty Box Status and Set Button Location set to anything other than 0 (disabled).

Previous versions, for that configuration, wound up with a <form> inside a <form> (not valid HTML) so that the pagecount and page-select dropdowns' operation were quite messed up (aka not working ).

Many thanks to batracy for pointing out the issue.

[whitewaveweb]

Hi,

I have installed the following mod and it seems to be working fine until i get to my products_all page where i get a error my log says

[28-Nov-2012 18:41:12] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) as total FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacture' at line 1 :: select count(distinct *) as total FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) left join zen_products_to_categories p2c on p.products_id = p2c.products_id left join zen_products_description pd on p.products_id = pd.products_id join zen_products_attributes p2a on p.products_id = p2a.products_id join zen_products_options po on p2a.options_id = po.products_options_id join zen_products_options_values pov on p2a.options_values_id = pov.products_options_values_id WHERE p.products_status = 1 AND (p.products_date_available IS NULL OR p.products_date_available <= current_date) AND pd.language_id = 1 in /home/sites/DOMAIN/public_html/rugsonline/includes/classes/db/mysql/query_factory.php on line 120

Any advice would be much appreciated.

Thanks

[lat9]

Which version of Products Pagination did you install? What is your version of Zen Cart? What other plugins do you have installed?

A link to your site would help.

[lat9]

Try this change to /includes/classes/split_pages_results.php (change starts at line 95 for v1.4.5 of this plugin):

//-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

[lat9]

Here's yet another patch; I'll be uploading v1.4.6 shortly to add the 'DISTINCT' patch as well as this one). The problem is that if the multiple-add-to-cart is enabled, changing the page-count on the advanced_search_results page causes the home page to be displayed:

Either copy /includes/modules/product_listing.php to /includes/modules/YOUR_TEMPLATE/product_listing.php or edit the existing file, towards the bottom:

  if ($how_many > 0 && PRODUCT_LISTING_MULTIPLE_ADD_TO_CART != 0 and $show_submit == true and $listing_split->number_of_rows > 0) {
  // bof: multiple products
//-bof-products pagination
//    echo zen_draw_form('multiple_products_cart_quantity', zen_href_link(FILENAME_DEFAULT, zen_get_all_get_params(array('action')) . 'action=multiple_products_add_product', $request_type), 'post', 'enctype="multipart/form-data"');
    echo zen_draw_form('multiple_products_cart_quantity', zen_href_link($_GET['main_page'], zen_get_all_get_params(array('action')) . 'action=multiple_products_add_product', $request_type), 'post', 'enctype="multipart/form-data"');
//-eof-products pagination
  }

[orncrete]

Just installed for ver 1.5 Problem I am having is I get dots instead of page numbers. Can you give me a clue as to what I need to do to fix this? Site is http://thestatuewarehouse.com/ Thanks

[lat9]

You have a conflict between the stylesheet_prod_pagination.css and the stylesheet_slides.css. Both of these files define styles associated with a pagination class. Since it looks like the stylesheet_slides.css only affects items on your home page, you could try renaming it to index_home.css.