Products Pagination - Support Thread

[DrByte]

And the strrpos should be fine when used on older ZC versions as well. It fixes an issue with complex nested subqueries with multiple order-by clauses.

[planetjune]

Thank you, DrByte and lat9

[strelitzia]

ZC1.5.7c with the latest version of Products Pagination, I'm getting the following error log when trying to view Oder History page.

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 '' at line 1 :: SELECT count(*) AS total FROM
orders o, orders_total ot, orders_status s WHERE
o.customers_id = 2493 AND
o.orders_id = ot.orders_id AND ot.class =
'ot_total' AND s.orders_status_id =
(SELECT orders_status_id FROM orders_status_history
osh WHERE osh.orders_id = o.orders_id AND
osh.customer_notified >= 0 ==> (as called by)
/includes/classes/pp_split_page_results.php on line 122 <== in
/includes/classes/db/mysql/query_factory.php on line 170.

Looking at that query, it appears to be missing a closing parentheses from the second 'SELECT' query.

Can you replicate this?

[lat9]

ZC1.5.7c with the latest version of Products Pagination, I'm getting the following error log when trying to view Oder History page.

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 '' at line 1 :: SELECT count(*) AS total FROM
orders o, orders_total ot, orders_status s WHERE
o.customers_id = 2493 AND
o.orders_id = ot.orders_id AND ot.class =
'ot_total' AND s.orders_status_id =
(SELECT orders_status_id FROM orders_status_history
osh WHERE osh.orders_id = o.orders_id AND
osh.customer_notified >= 0 ==> (as called by)
/includes/classes/pp_split_page_results.php on line 122 <== in
/includes/classes/db/mysql/query_factory.php on line 170.

Looking at that query, it appears to be missing a closing parentheses from the second 'SELECT' query.

Can you replicate this?

I can, unfortunately. The zc157 series has changed the query on the account_history page and Products' Pagination isn't playing well.

See this GitHub issue for tracking: https://github.com/lat9/product_pagination/issues/26

[lat9]

I can, unfortunately. The zc157 series has changed the query on the account_history page and Products' Pagination isn't playing well.

See this GitHub issue for tracking: https://github.com/lat9/product_pagination/issues/26

I've got this change available on the plugin's GitHub repository if you'd like to check that correction out prior to the v2.1.1 release.

[strelitzia]

I've got this change available on the plugin's GitHub repository if you'd like to check that correction out prior to the v2.1.1 release.

I can confirm that the changes have resolved the issue. Fantastic support, thank you!

[lat9]

I can confirm that the changes have resolved the issue. Fantastic support, thank you!

Thanks for the confirmation; I'll get v2.1.1 released later this weekend.

[lat9]

I've just submitted v2.1.1 of Product Pagination for the Zen Cart moderators' review and will post back here when it's available for download.

This release contains changes associated with the following GitHub issues:

#14: Ensure unique form-name on multi-page listings with no top/bottom submit button.
#26: Correct MySQL error on account_history page for zc157 and later.

[lat9]

I've just submitted v2.1.1 of Product Pagination for the Zen Cart moderators' review and will post back here when it's available for download.

This release contains changes associated with the following GitHub issues:

#14: Ensure unique form-name on multi-page listings with no top/bottom submit button.
#26: Correct MySQL error on account_history page for zc157 and later.

Now available for download: https://www.zen-cart.com/downloads.php?do=file&id=1199

[shrimp-gumbo-mmmhhh]

Now available for download: https://www.zen-cart.com/downloads.php?do=file&id=1199

Forgive my dullness.... but I checked out the website you referred that this mod is supposed to be like .... Can you tell me a little more about what this does or what I am supposed to be looking for in the website?