SQL Error - Wishlist 2.4

[Stevis2002]

Can anybody help me with this sql error?

I did the fix....

$wishlist_query_raw = "select * from " . TABLE_WISHLIST . " where customers_id = '" . $customer_id . "' order by products_name";

but i still get the following 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 '-12, 12' at line 1

 

select * from customers_wishlist where customers_id = '2' order by products_name limit -12, 12

 

 

Any Ideas??

 

Thanks,

Steve

[OceanRanch]

Since there are zero entries in the wishlist table the "limit" in split_page_results goes negative. New version of mysql does not like negative limits.

 

Fix is here.

 

http://www.oscommerce.com/community/bugs,1605

 

HTH

Tom