Problem with WISH LIST v2.4a

[Guest]

Hello,

After playing about trying to get this working with my template I finally got it working. Now for some reason, I popped out and when I returned home, I refreshed the page and am now getting this:

 

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 'order by products_name' at line 1

 

select * from customers_wishlist WHERE customers_id = order by products_name

 

[TEP STOP]

 

Does anyone know how I can fix this, and where to look?

[Guest]

Just uninstalled it step by step, checking after each undo to find out which file was making the problem.

The problem was in column_right.php I had to add this piece of code to make it install in the first place:

 

  require(DIR_WS_BOXES . 'wishlist.php');

 // STS: ADD
 $sts_block_name = 'wishlistbox';
 require(STS_RESTART_CAPTURE);
 // STS: EOADD

[Guest]

I fixed it :P

In the mod file, it gave options so that if you wished for the wishlist box to only show if users are logged in (which I had opted for). And in the column_right.php file, I needed to edit the code so it looked like this:

 

if (tep_session_is_registered('customer_id'))  require(DIR_WS_BOXES . 'wishlist.php');

// STS: ADD
$sts_block_name = 'wishlistbox';
require(STS_RESTART_CAPTURE);
// STS: EOADD

 

Does this look ok though? If you can see a problem with what I have done please let me know ;)