Problems with Split_Page_Results.

[valley]

Hello,

 

Hello,

I have a store with MS 2.2 but for some reason I have an old version

of split_page _results.php in both catalog and admin which work well

with both. I have no problems with reviews, manufacturers, new products etc

reported with the 20 20 issue in the forum.

 

However recently I have installed the POINTS and REWARD contribution

with a function call

$points_query = "select o.unique_id, o.comment, o.orders_id, o.points_pending, o.date_added, o.status from " . TABLE_CUSTOMERS_POINTS_PENDING . " o where o.customer_id = '" . (int)$customer_id . "'   order by unique_id DESC";
$points_split = new splitPageResults($points_query, MAX_DISPLAY_POINTS_RECORD);
$points_query = tep_db_query($points_split->sql_query);

 

Which produce an ERROR 1065 QUERRY WAS EMPTY .

 

I have tried the NEW versions of split_page_results.php with the

latest OSC download which produces NO ERROR for my_points.php but produces

Data base access 1064 error

in all of the other standard OSC files like new products, manufacturers

and reviews etc with a function call like this.

 

$points_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_POINTS_RECORD, $points_query, $points_query_numrows);

 

using the above statement still produces the ERROR 1065 in my_points.php.

 

To see the error please ceheck out

http://affiliatesexcel.com

login: [email protected]

password: tests

 

and click on My pints link in shopping cart or at the bottom of My account page.

 

This was reported in BUGS REPORT but I haven't had any reply.

 

Looks like a very simple issue. Can any of the experts help ?