Just another Cross-Sell mod (support thread)

[scitrenbaum]

I have been trying for days to install the Cross Sell module, and no matter what I do, it just isn't working. I can't get the Cross Sell Products to show up in the catalog as an option.

When I got to one of my product pages, this is the error I get.


Warning: include(includes/modules/FILENAME_XSELL_PRODUCTS.php) [function.include]: failed to open stream: No such file or directory in /home/scentime/public_html/catalog/includes/templates/new_template/templates/tpl_modules_xsell_products.php on line 17

Warning: include() [function.include]: Failed opening 'includes/modules/FILENAME_XSELL_PRODUCTS.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/scentime/public_html/catalog/includes/templates/new_template/templates/tpl_modules_xsell_products.php on line 17

This is a sample product page

http://www.scentimentalprints.com/ca...roducts_id=183

I then tried to install the Advanced Cross Sell (even though I recognized it probably wouldn't work if I couldn't get the regular one to work) and when I go to the Advanced Cross Sell tab (which at least shows up), this is the error I get

1146 Table 'scentime_scentimentalprints.TABLE_PRODUCTS_XSELL' doesn't exist
in:
[select p.products_id, p.products_model, pd.products_name, count(p.products_id) as xsells from products p, products_description pd, TABLE_PRODUCTS_XSELL px where p.products_id = pd.products_id and p.products_id = px.products_id and pd.language_id ='1' group by p.products_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.

I am in dire need to help, and don't know much about mySQL stuff!

Thank you!

[yellow1912]

The same error, the same answer:

It seems that you are missing the definition of TABLE_PRODUCTS_XSELL. If you are using a custom template, make sure you change the name of the folders in the mod (as instructed in the readme file) BEFORE you upload all the files and folders to your server.

[scitrenbaum]

I'm not sure if this is the correct place to post this, but since yellow1912 seems to be incredibly knowledgeable, I figured I would give it a shot!

I have Cross Sell installed and working, however, for the life of me I cannot get the images for it to format properly.

Here is a page on the site demonstrating my issue.

http://www.scentimentalprints.com/ca...roducts_id=180

When you look at the "Also Available" items, they are pretty much on top of eachother, and no amount of padding or margin is making a difference.

I want them to stack on top of eachother in a column.

Any idea what css to alter to get them to do this? Right now, using Web Developer Toolbar, the only thing I can figure out to alter is called

#crossSell .centerBoxContentsCrossSell centeredContent back

which doesn't seem to be doing anything.

Any help at all would be greatly appreciated!

[yellow1912]

Remove style="width: 50%;"
That should fix the problem (or at least part of it)

[bifficus]

Hey Zenners,

I have a weird issue where my cross sell header appears and disappears. To view this behavior go to this link: http://www.pccapital.ca/notebook-1/t...ase-buy-3.html

Choose the "We Also Recommend" tab. Then, mouse over the header above the Cross Sell Products (it should say "Free Shipping on Two or My Items"). If you can't see it, or want to make it reappear, scroll to the bottom of the page, then mouse over the header area again. Neat, ehh? But I want to get rid of that behavior just the same,

I will include the code from my tpl_modules_xsell_products.php below. If anyone can see where there is an issue, or if I have included the wrong code, please let me know.

Thanks!

Code:

<?php
/**
 * Cross Sell products
 *
 * Derived from:
 * Original Idea From Isaac Mualem [email protected] <mailto:[email protected]>
 * Portions Copyright (c) 2002 osCommerce
 * Complete Recoding From Stephen Walker [email protected]
 * Released under the GNU General Public License
 *
 * Adapted to Zen Cart by Merlin - Spring 2005
 * Reworked for Zen Cart v1.3.0  03-30-2006
 */


// calculate whether any cross-sell products are configured for the current product, and display if relevant
include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_XSELL_PRODUCTS));

if (zen_not_null($xsell_data)) {
  $info_box_contents = array();
  $list_box_contents = $xsell_data;
  $title = '';
?>
<!-- bof: tpl_modules_xsell_products -->
<div class="centerBoxWrapper" id="crossSell">
<h2 class="centerBoxHeading"><?php echo TEXT_XSELL_PRODUCTS; ?></h2>
<?php
/**
 * require the list_box_content template to display the cross-sell info. This info was prepared in modules/xsell_products.php
 */
require($template->get_template_dir('tpl_columnar_display.php',DIR_WS_TEMPLATE, $current_page_base,'common'). '/tpl_columnar_display.php');
?>
<br><br><br>
</div>
<!-- eof: tpl_modules_xsell_products -->
<?php } ?>

[bifficus]

Update: I have learned that this is called the "peekaboo bug" and affects IE6 and CSS. I haven't fixed it though. And this bug does only affect me on Cross Sell. Will keep working on it and post again later.

Hey Zenners,

I have a weird issue where my cross sell header appears and disappears. To view this behavior go to this link: http://www.pccapital.ca/notebook-1/t...ase-buy-3.html

Choose the "We Also Recommend" tab. Then, mouse over the header above the Cross Sell Products (it should say "Free Shipping on Two or My Items"). If you can't see it, or want to make it reappear, scroll to the bottom of the page, then mouse over the header area again. Neat, ehh? But I want to get rid of that behavior just the same,

I will include the code from my tpl_modules_xsell_products.php below. If anyone can see where there is an issue, or if I have included the wrong code, please let me know.

Thanks!

Code:

<?php
/**
 * Cross Sell products
 *
 * Derived from:
 * Original Idea From Isaac Mualem [email protected] <mailto:[email protected]>
 * Portions Copyright (c) 2002 osCommerce
 * Complete Recoding From Stephen Walker [email protected]
 * Released under the GNU General Public License
 *
 * Adapted to Zen Cart by Merlin - Spring 2005
 * Reworked for Zen Cart v1.3.0  03-30-2006
 */


// calculate whether any cross-sell products are configured for the current product, and display if relevant
include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_XSELL_PRODUCTS));

if (zen_not_null($xsell_data)) {
  $info_box_contents = array();
  $list_box_contents = $xsell_data;
  $title = '';
?>
<!-- bof: tpl_modules_xsell_products -->
<div class="centerBoxWrapper" id="crossSell">
<h2 class="centerBoxHeading"><?php echo TEXT_XSELL_PRODUCTS; ?></h2>
<?php
/**
 * require the list_box_content template to display the cross-sell info. This info was prepared in modules/xsell_products.php
 */
require($template->get_template_dir('tpl_columnar_display.php',DIR_WS_TEMPLATE, $current_page_base,'common'). '/tpl_columnar_display.php');
?>
<br><br><br>
</div>
<!-- eof: tpl_modules_xsell_products -->
<?php } ?>

[nev]

Hi,

Got this message on when i ran the sql "products_xsell.sql" to get the basic cross sell mod in.

Anyone have any idea how to fix 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 'true','false'), ', now())' at line 1
in:
[INSERT INTO zen_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());]


its a virgin instaltion of zen cart except for an added language pack, which i don't see how it could create a conflict with this.

the table is created, and when tested i can add data, and it displays.

What is missing is the display price Y/N in the admin panel, and the price is not displayed in the front end.

(hope that is all that 's not working), so just to be on the safe side, i'd appreciate it if someone has an answer on how to fix this.

thanks
nev

[yellow1912]

Please note that Cross Sell mod was written and supported by another author.

Anyway, try to run this on your phpmyadmin, see if you can get it through:
INSERT INTO zen_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());

[nev]

didnt work

got this back


SQL query:

INSERT INTO zen_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( )
)

MySQL said:

#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


any other ideas?

yeah i know that it was written by someone else.. but.. i ran into so many questions on the original here i figured i'd try

and thank you for helping

[trishac]

I'm not able to install the sql file for Cross Sell. I 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 'true','false'), ', now())' at line 1
in:
[INSERT INTO zen_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.

I mistakenly installed the Advanced Cross Sell program first and then went back to install Cross Sell. Did I mess this up? If so, what can I do to fix this?