Products Pagination - Support Thread

I have just tried to access your example and I am getting error 403 Forbidden

I'm sorry ... which example is that?

I have just submitted v1.4.3 to the Plugins area; the download should be available in a couple of days.

Changed /includes/classes/split_page_results.php and /includes/functions/extra_functions/products_pagination_functions.php:

BUGFIX: Links are displayed when zero items are returned.
BUGFIX: Page-select dropdown is displayed even if only 1 page is active.
BUGFIX: Item-count dropdown is displayed even if there are fewer items than the minimum to display.

v1.4.3 is now available in the Plugins area ...

:(> lat9:

v1.4.3 is now available in the Plugins area ...

It seems I have data base conflicts between plugin modules, see posts 27 to 32 in http://www.zen-cart.com/showthread.php?200500-FAQ-Module-Support/page4&highlight=faq+MODULE:

The module Product Pagination for Zen Cart v 1.4.3 uses configuration_key also, for example in the statement:

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added) VALUES ('Products Pagination — Maximum Links', 'PRODUCTS_PAGINATION_MAX', '10', 'This is the maximum number of product links to be displayed before pagination begins. This value should be greater than the number of Intermediate Links

Just as with Faq Manager v2.2, y got the same error for each of 4 insert statementes, namely:

ERROR: Cannot insert configuration_key "" because it already exists

So, is this a case of conflicting plug ins? the first to be installed wins? or is perhaps something I did wrongly?

As stated above, I have not been able to run the SQL install file for Product Pagination with the Zen Cart tool. I have not yet identified which of my installed modules inserted first the configuration_key that seems to prevent at least this and FAQ manager from insertig their needed tables. I do not read code. Is there a solution around? or should I just give up installing such good apps?:(

arsanat, I replied regarding the FAQ manager over in that thread; it looks like that plugin's installation SQL's use of backticks might be your issue there. There is no conflict between the FAQ Manager and Product Pagination plugins, they both just insert some values in the "Configuration" section of your store's admin (that's why they both use the INSERT INTO configuration ... constructs.

I'm at a loss as to why you are getting the same error when you run the Product Pagination install script, since there are no backticks used by that script.

You might try running the SQL scripts (both FAQ Manager and Product Pagination) using the phpMyAdmin tool that is provided by your web-hosting company. In any case, even though your database seems a bit messed up now, make sure to make a backup before you continue as it is quite possible to make a database worse.

I've submitted v1.4.4 of Product Pagination to the Plugins area; it should be available in a couple of days:

BUGFIX: Yet another possible divide-by-0 problem. If you are using the dropdown-count feature and the number of items to display is greater than your minimum value but less than the second largest value, the divide-by-0 will show. In my case I had 19 entries, with a dropdown specification of '12,24,48,96'.

v1.4.4 is now available in the Plugins area ...

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/storetest/index.php?main_page=index&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.

Ok, item #3 listed above seems to be a configuration issue on my part - it does work. The other two issues are still a problem.

batracy:

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/storetest/index.php?main_page=index&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) ...

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

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.

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.

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

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.

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

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
  }

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

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.