runweb Posted September 13, 2007 Share Posted September 13, 2007 I istalled this contib successfully but there i only 1 little error message i don`t know what that means: Warning: Missing argument 3 for display_cross_sell_add() in /var/www/web22/html/shop-1/catalog/admin/cross_sell.php on line 300 It´s this contribution: http://www.oscommerce.com/community/contri...l/search,x-sell Contrib is working fine and realy fast, but this little error message in admin when listing a cross selling product or deleting a product from cross selling. Quote OSC Webmakers Edition modiefied with many other contribs and enhancements. + STS 4.5.7 for 2.2MS2 and RC1 Link to comment Share on other sites More sharing options...
runweb Posted September 13, 2007 Author Share Posted September 13, 2007 Additional wish for this great tool: Search and listing of all products which have currently cross sell products, that would be easier to check and hav an overview about the cross sellings. Quote OSC Webmakers Edition modiefied with many other contribs and enhancements. + STS 4.5.7 for 2.2MS2 and RC1 Link to comment Share on other sites More sharing options...
susanjackman Posted January 5, 2008 Share Posted January 5, 2008 This is showing up on the product info page that has no existing cross-sells set up. At first glance I thought it was a problem related to mySQL running version 5 on my server, but I did not have this problem on two of my other sites... so I'm thinking I missed something when I installed the contribution on this site. 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 'MAX_DISPLAY_XSELL_PRODUCTS' at line 1 select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price from products_cross_sell xp, products p, products_description pd where xp.products_id = '39' and xp.cross_sell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = '1' order by rand(1776191046) DESC limit MAX_DISPLAY_XSELL_PRODUCT Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 5, 2008 Share Posted January 5, 2008 MAX_DISPLAY_XSELL_PRODUCT is the no of items to display on the "page". Don't know the contribution but would guess it should would be held in the configuration table in your database. Post the code around this statement:- select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price from products_cross_sell xp, products p, products_description pd where xp.products_id = '39' and xp.cross_sell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = '1' order by rand(1776191046) DESC limit MAX_DISPLAY_XSELL_PRODUCT Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
susanjackman Posted January 5, 2008 Share Posted January 5, 2008 This is showing up on the product info page that has no existing cross-sells set up. At first glance I thought it was a problem related to mySQL running version 5 on my server, but I did not have this problem on two of my other sites... so I'm thinking I missed something when I installed the contribution on this site. 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 'MAX_DISPLAY_XSELL_PRODUCTS' at line 1 select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price from products_cross_sell xp, products p, products_description pd where xp.products_id = '39' and xp.cross_sell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = '1' order by rand(1776191046) DESC limit MAX_DISPLAY_XSELL_PRODUCT Solution: Forgot to add the SQL into the configuration table for said store. :rolleyes: Quote Link to comment Share on other sites More sharing options...
janetgot Posted January 28, 2008 Share Posted January 28, 2008 I installed this on a fairly heavily modified store running v2.2 RC1... I can get to the Cross Sell page in admin, but if I enter a model number and hit the search button it just keeps taking me to the login screen. Any idea what I did wrong? I've rechecked my installation twice. Thanks, Janet Quote Link to comment Share on other sites More sharing options...
Guest Posted February 3, 2008 Share Posted February 3, 2008 is this supported still? I'm getting this error at the bottom of my screen? Warning: main(includes/modules/cross_sell_products.php) [function.main]: failed to open stream: No such file or directory in /home/snsdealz/public_html/product_info.php on line 283 Warning: main() [function.include]: Failed opening 'includes/modules/cross_sell_products.php' for inclusion (include_path='.:/usr/lib/php') in /home/snsdealz/public_html/product_info.php on line 283 Quote Link to comment Share on other sites More sharing options...
adrianconchie Posted December 9, 2011 Share Posted December 9, 2011 Just installed this on v2.2 and I'm getting an error 500 page in admin/cross_sell.php Why would this be? Please help! Quote Link to comment Share on other sites More sharing options...
Douglas-John Ramm Posted January 18, 2012 Share Posted January 18, 2012 <?php //*** <Cross-Sell Mod> if ( (USE_CACHE == 'true') && !SID) { echo tep_cache_cross_sell_products(3600); echo '<br />'; //*** </Cross-Sell Mod> echo tep_cache_also_purchased(3600); } else { //*** <Cross-Sell Mod> include(DIR_WS_MODULES . FILENAME_CROSS_SELL_PRODUCTS); echo '<br />'; include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS); //*** </Cross-Sell Mod> } } ?> This code is killing my site i,m running 2.3.1 can anyone help change this code to work with version 2.3.1 Doug Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.