Products Pagination - Support Thread

[planetjune]

I just did some googling and strrpos isn't a typo (oops - my mistake), but using it instead of strpos is a change from both version 2.0 of this plugin and the standard Zen Cart code, so I guess it's not completely stupid for me to check that it's not a mistake..?

[lat9]

I just did some googling and strrpos isn't a typo (oops - my mistake), but using it instead of strpos is a change from both version 2.0 of this plugin and the standard Zen Cart code, so I guess it's not completely stupid for me to check that it's not a mistake..?

While that class needs a teeny bit of update to align with the now-current zc157b implementation, the use of strrpos is consistent between the base Zen Cart 1.5.7+ distribution and the modification provided by Products Pagination.

[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.