x Sell Advanced...not working

[ecommercegirl]

Ok I am a newbie but forgive me ignorance.

Okay I installed the advanced xsell, and i tripled checked all filles are there!
When I open the advanced cross sell from admin the page goes blank, I had issues with the sql install but i read some of the replies and followed each step.

Next problem is that I cant find the tpl_product_info_display.php file.

5. Now edit your product-info template file (tpl_product_info_display.php) and insert the following code
at the point where you wish the Cross-Sell box to appear. Usually best at the end of the file:
---------------------------------
<?php
require($template->get_template_dir('tpl_modules_xsell_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_xsell_products.php');
?>

what did this newbie doo wrong??

[ecommercegirl]

OK I am an idiot. I did forget two files!!!

But I still cant find the TPL_product_info_display.

[ecommercegirl]

Im two for two!!!!

got it!!
LOL

I forgot zen cart is override heaven!!

[Ajeh]

See? it all slowly comes together ... good luck!

[tatiana77]

thanks for the great mod

[tatiana77]

I get this message

1146 Table 'db205680436.TABLE_PRODUCTS_XSELL' doesn't exist
in:
[select count(products_id) as records from TABLE_PRODUCTS_XSELL where products_id = '29' and xsell_id = '']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

When I try to enter the item and item to cross-sell.

Sidenote, I haven't installed the original cross-sell as I can't find it in downloads... hit me upside the head if I am too much of a newbie (but getting better must admit)

[tatiana77]

Argh me again, sorry. I found Cross-sell from the Marketing section in downloads...uploaded everything, but when I try to upload the products_xsell.sql the message I get in admin is:

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 'true','false'), ', now())' at line 1
in:
[INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Cross-Sell - Display prices?', 'XSELL_DISPLAY_PRICE', 'false', 'Cross-Sell -- Do you want to display the product prices too?
Default: false', 18, 72, 'zen_cfg_select_option(array('true','false'), ', now());]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

??

Tatiana

[rainthebat]

Have you found a fix for this tatiana? I also have been getting an error very similar to this one. I just can't quite figure it out.