free <PREV | NEXT> mod help
 

I found this mod in http://www.xcartmod.com/cart/product/previous-next-products.html but can't get it to work. Can anyone please help. Thank you.

Re: free <PREV | NEXT> mod help
 

Moving to Third Party Add-Ons

Re: free <PREV | NEXT> mod help
 

Take a look at this one

http://www.xcartmods.net/next-previous-product.html

Re: free <PREV | NEXT> mod help
 

Hi,

I just tested that Previous/Next freebie Mod on my site and it worked perfectly.

I'm running X-Cart 4.1.10, so it should work fine on your 4.1.9 site as well.

Here's some things to double-check:

1. There are 3 files this MOD deals with...
1a) product.php (at the root-level) is modified by adding a block of code near the end
1b) skin1/customer/main/product.tpl is modified by adding an include at the top of the file
1c) skin1/customer/next_prev.tpl (new file) is added

2. You can change the install file to install.txt to open it in a text editor. Notice that it has 3 steps. Follow them exactly and it should work fine.

The Previous and Next products will then be listed near the top of each Detailed Product Page.

If you get any error, please let us know what it is(?)

Robert

Re: free <PREV | NEXT> mod help
 

Ahhh... I think I discovered your problem with getting this to work. It was working fine for me on X-Cart version 4.1.10 but I was on mySQL 4 at the time. When I recently upgraded to mySQL 5, this was the only mod I had that broke.

If you do not have products assigned to different memberships, then you can remove that part from the SQL Query.

To get this mod to work with X-Cart 4.1.x on mySQL 5, I made the following change:

File: product.php (root-level)

Change the SQL Query to read:

That's it... working fine on my live site now.

Robert

Re: free <PREV | NEXT> mod help
 

Hi

What should i put in the
skin1/customer/next_prev.tpl (new file)

Thanks

Re: free <PREV | NEXT> mod help
 

Hello,

Just upload next_prev.tpl to skin1/customer/ folder without changes.

Alex

Re: free <PREV | NEXT> mod help
 

Thanks.

I did.

I get this error.

INVALID SQL: 1054 : Unknown column 'pr.productid' in 'on clause'
SQL QUERY FAILURE:SELECT pr.productid, pr.product, mem.membershipid FROM xcart_products AS pr, xcart_products_categories AS cat LEFT JOIN xcart_product_memberships AS mem ON mem.productid = pr.productid WHERE cat.categoryid = '263' AND pr.productid = cat.productid AND pr.forsale='Y' ORDER BY pr.product

Any idea?

Re: free <PREV | NEXT> mod help
 

I suppose you use MySQL 5. You need to change this text in product.php:

$mem_list = func_query("SELECT pr.productid, pr.product, mem.membershipid FROM $sql_tbl[products] AS pr, $sql_tbl[products_categories] AS cat LEFT JOIN $sql_tbl[product_memberships] AS mem ON mem.productid = pr.productid WHERE cat.categoryid = '$product_info[categoryid]' AND pr.productid = cat.productid AND pr.forsale='Y' ORDER BY pr.product");

to this text:

$mem_list = func_query("SELECT pr.productid, pr.product, mem.membershipid FROM $sql_tbl[products_categories] AS cat, $sql_tbl[products] AS pr LEFT JOIN $sql_tbl[product_memberships] AS mem ON mem.productid = pr.productid WHERE cat.categoryid = '$product_info[categoryid]' AND pr.productid = cat.productid AND pr.forsale='Y' ORDER BY pr.product");

Re: free <PREV | NEXT> mod help
 

OK

Did Change the SQL Query to read

No error now

but no next/prev either