I'm doing some digging, and here is what I'm seeing. Not sure what to make of it.
Specifically, I am focusing on the /modules/also_products_purchased.php file. I've narrowed down the reason (I think) why it's not displaying, but I still can't figure out why.
In that file, on Line #15, there is the following code:
Code:
$also_purchased_products = $db->ExecuteRandomMulti(sprintf(SQL_ALSO_PURCHASED, (int)$_GET['products_id'], (int)$_GET['products_id'], (int)MAX_DISPLAY_ALSO_PURCHASED));
To troubleshoot, I did a
var_dump($also_purchased_products); to see what I was getting back from the query. This is what I was getting:
You can see that it returns the correct number of rows (3).....but also the EOF is true when I think it should be false.
So for good measure, I did a
var_dump(SQL_ALSO_PURCHASED); in order to see what the database query looks like, and this is what is returned:
So it seems to me like MAYBE something is wrong in the $db->ExecuteRandomMulti() on Line #15 which is causing the EOF to be true? I am clueless but I think I'm onto something.
On Line 32 where it enters the
while (!$also_purchased_products->EOF), it doesn't go into that loop because of the TRUE EOF condition.
So it would seem like EOF needs to be FALSE in order to display the products, but it's returning EOF = True in the SQL results.
Any ideas on what else to do? The WinMerge test seems to show that my files are identical to the 1.5.7 release files.
Bookmarks