Guest Posted January 31, 2012 Share Posted January 31, 2012 1 More issue in addition to the above. After hours of scouring the forums. I have .htaccess and htpassword_oscommerce all OK but when the client tries to set products via the xsell admin area the products don't assign but when I do them on my PC they do???? anyone have an idea or some advice. Quote Link to comment Share on other sites More sharing options...
Guest Posted February 3, 2012 Share Posted February 3, 2012 (edited) 1 More issue in addition to the above. After hours of scouring the forums. I have .htaccess and htpassword_oscommerce all OK but when the client tries to set products via the xsell admin area the products don't assign but when I do them on my PC they do???? anyone have an idea or some advice. In reference to my post: I have nailed the issue to been just on Internet Explorer for some reason. I have the client running on Google Chrome now with no issues. No issues on Safari or Fire Fox either... IE?? Why the issue? Edited February 3, 2012 by Mindbullet Quote Link to comment Share on other sites More sharing options...
sourpickles Posted February 3, 2012 Share Posted February 3, 2012 I'm a dummy I should have done a quesck search then just post a new topic like I did..... here's what I posted in the topic. I hope I can finally figure out how to fix this issue So I thought I'd try this again and see if anyone may know the answer. I asked this almost 2 years ago when I added this to our page. Basically when I add the products to xsell my as I call it "bubble" isn't white. As you can see in this link....... http://playersink.com/product_info.php?products_id=7193&osCsid=aeiqd26s4q6ovadlld7kinap71 ........ the main product description bubble is white but the xsell product is not. I was told that I must have a different template type because they never seen this before but didn't say how to go about fixing it. I know just enough php to be dangerous so I rather not go through and start messing with things just to do it. What we have works but it's just not clean and uniform. Ideas on how to fix this? If you want to see any of the php or anything please just ask and I'll post. I'd love to get this working right finally :) Thanks all! Quote Link to comment Share on other sites More sharing options...
supermario Posted February 5, 2012 Share Posted February 5, 2012 Maybe it is already asked, But I have installed V3.0 Slightly adapted for use with OSC 2.3.1 At the admin site it seems to work perfect, but see anything on the catalog site, what can I have done wrong Thx in advance, Mario Quote Link to comment Share on other sites More sharing options...
supermario Posted February 11, 2012 Share Posted February 11, 2012 Anyone got x-sell to work on osc 2.3.1? I got so far that its working in admin and i can create a cross sale. But it wont show up on products_info Any one that have succeeded? Turn off the cash it worked for me Grtz Mario Quote Link to comment Share on other sites More sharing options...
mcollina Posted February 12, 2012 Share Posted February 12, 2012 Hi, I'm using Oscommerce 2.3.1 and i ve tried to install the XSELL. In the Admin page is everything all right... I creat the table.from the sql. But in product info i'm having a little problem...This is the problem.. 1146 - Tabela 'ambiancebijoux06.TABLE_PRODUCTS_XSELL' não existe select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, specials_new_products_price from TABLE_PRODUCTS_XSELL xp left join products p on xp.xsell_id = p.products_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '2' left join specials s on p.products_id = s.products_id where xp.products_id = '436' and p.products_status = '1' order by sort_order asc limit 6 [TEP STOP] Can anyone help me??? Tks,,, Quote Link to comment Share on other sites More sharing options...
sourpickles Posted February 14, 2012 Share Posted February 14, 2012 I cant get the page to work right still like in my last post but there is one thing I'd love to do that I know I can get help with. I'd like to have the page drop down menu that's on the bottom also be available on the top of the list. I've tried to edit this myself but must be missing a line of code some where cause I can't get the page to reload after correctly. Can anyone help me out with the full code I'd have to place up top? Quote Link to comment Share on other sites More sharing options...
♥altoid Posted February 21, 2012 Share Posted February 21, 2012 For the 2.3.1 version of X-Sell here: http://addons.oscommerce.com/info/8330/v,23 In the instructions look for a typo, the word but should be the word buy, see red text below. ************ STEP 14 * *********** In catalog/includes/application_top.php Find this: if ($HTTP_GET_VARS['action'] == 'buy_now') { $parameters = array('action', 'pid', 'products_id'); } else { $parameters = array('action', 'pid'); } REPLACE with this: if ($HTTP_GET_VARS['action'] == 'buy_now') { // BOE: XSell if (isset($HTTP_GET_VARS['product_to_buy_id'])) { $parameters = array('action', 'pid', 'products_to_but_id'); } else { $parameters = array('action', 'pid', 'products_id'); } // EOE: XSell } else { $parameters = array('action', 'pid'); } Quote I am not a professional webmaster or PHP coder by background or training but I will try to help as best I can. I remember what it was like when I first started with osC. It can be overwhelming. However, I strongly recommend considering hiring a professional for extensive site modifications, site cleaning, etc. There are several good pros here on osCommerce. Look around, you'll figure out who they are. Link to comment Share on other sites More sharing options...
mcollina Posted February 27, 2012 Share Posted February 27, 2012 Hi, I'm using Oscommerce 2.3.1 and i ve tried to install the XSELL. In the Admin page is everything all right... I creat the table.from the sql. But in product info i'm having a little problem...This is the problem.. 1146 - Tabela 'ambiancebijoux06.TABLE_PRODUCTS_XSELL' não existe select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, specials_new_products_price from TABLE_PRODUCTS_XSELL xp left join products p on xp.xsell_id = p.products_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '2' left join specials s on p.products_id = s.products_id where xp.products_id = '436' and p.products_status = '1' order by sort_order asc limit 6 [TEP STOP] Can anyone help me??? Tks,,, Can anyone help me with that? in product_info.php shows these: 1146 - Tabela 'ambiancebijoux06.TABLE_PRODUCTS_XSELL' doesn't exist select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, specials_new_products_price from TABLE_PRODUCTS_XSELL xp left join products p on xp.xsell_id = p.products_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '2' left join specials s on p.products_id = s.products_id where xp.products_id = '436' and p.products_status = '1' order by sort_order asc limit 6 [TEP STOP] But I created the sql file... I dont know how to fixed these... Quote Link to comment Share on other sites More sharing options...
♥altoid Posted February 27, 2012 Share Posted February 27, 2012 Can anyone help me with that? in product_info.php shows these: 1146 - Tabela 'ambiancebijoux06.TABLE_PRODUCTS_XSELL' doesn't exist select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, specials_new_products_price from TABLE_PRODUCTS_XSELL xp left join products p on xp.xsell_id = p.products_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '2' left join specials s on p.products_id = s.products_id where xp.products_id = '436' and p.products_status = '1' order by sort_order asc limit 6 [TEP STOP] But I created the sql file... I dont know how to fixed these... Make sure you did step 4 *********** STEP 4 * ********** In catalog/includes/database_tables.php Find the ENDING: ?> Insert this BEFORE: // XSell define('TABLE_PRODUCTS_XSELL', 'products_xsell'); mcollina 1 Quote I am not a professional webmaster or PHP coder by background or training but I will try to help as best I can. I remember what it was like when I first started with osC. It can be overwhelming. However, I strongly recommend considering hiring a professional for extensive site modifications, site cleaning, etc. There are several good pros here on osCommerce. Look around, you'll figure out who they are. Link to comment Share on other sites More sharing options...
Guest Posted February 27, 2012 Share Posted February 27, 2012 Hello, I am French, I have this error message in the catalog: Warning: include(includes/languages/french/modules/boxes/bm_featured.php) [function.include]: failed to open stream: No such file or directory in Z:\xampp\htdocs\catalog\includes\classes\osc_template.php on line 86 Warning: include() [function.include]: Failed opening 'includes/languages/french/modules/boxes/bm_featured.php' for inclusion (include_path='.;\xampp\php\PEAR') in Z:\xampp\htdocs\catalog\includes\classes\osc_template.php on line 86 No problem in the administration :thumbsup: Thank you Quote Link to comment Share on other sites More sharing options...
mcollina Posted February 28, 2012 Share Posted February 28, 2012 Make sure you did step 4 Thank you very much... I did not pay attention on this... Perfect!! Quote Link to comment Share on other sites More sharing options...
Guest Posted February 28, 2012 Share Posted February 28, 2012 Hello, I am French, I have this error message in the catalog: No problem in the administration :thumbsup: Thank you I make my own questions / answers. So I confirm, this contribution works well, the error that I had just the fact that I was missing a file (bm_featured.php) french version in the directory catalog\includes\languages\french\modules\boxes of another contribution. Thank you to the creator ... Quote Link to comment Share on other sites More sharing options...
Guest Posted February 29, 2012 Share Posted February 29, 2012 I do have a problem on the Buy Now button, when I click it the result is: Product not found. Path button -> Product Not Found http://localhost/catalog/product_info.php?cPath=22_33&action=buy_now&products_id=34 Path on the image -> Product Found http://localhost/catalog/product_info.php?products_id=34 If you have an idea ... Thank you Quote Link to comment Share on other sites More sharing options...
Guest Posted March 1, 2012 Share Posted March 1, 2012 I corrected my post, sorry... Path "Buy Now" button to the mouse hovers : http://localhost/catalog/product_info.php?action=buy_now&products_id=34 Path after the click on the page -> Product not Found http://localhost/catalog/product_info.php If you have an idea ... Thank you Quote Link to comment Share on other sites More sharing options...
Mort-lemur Posted March 1, 2012 Share Posted March 1, 2012 (edited) Hi, Just a shot in the dark here - But do you have SEO URLs installed? I had a lot of errors when running on a local setup with this enabled. If you have it installed try turning it off and see if the error persists. Thanks Edited March 1, 2012 by Mort-lemur Quote Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members. Link to comment Share on other sites More sharing options...
Guest Posted March 2, 2012 Share Posted March 2, 2012 Hi, SEO URLs not activated. The link works when I click on the product image. More strange... the Buy Now button works on the first product in my database??? Just this one ! It's the black completely Quote Link to comment Share on other sites More sharing options...
Guest Posted March 2, 2012 Share Posted March 2, 2012 it is normal ? 'product_to_buy_id' or 'products_to_but_id' But that does not solve the problem... *********** * STEP 14 * *********** In catalog/includes/application_top.php Find this: if ($HTTP_GET_VARS['action'] == 'buy_now') { $parameters = array('action', 'pid', 'products_id'); } else { $parameters = array('action', 'pid'); } REPLACE with this: if ($HTTP_GET_VARS['action'] == 'buy_now') { // BOE: XSell if (isset($HTTP_GET_VARS['product_to_buy_id'])) { $parameters = array('action', 'pid', 'products_to_but_id'); } else { $parameters = array('action', 'pid', 'products_id'); } // EOE: XSell } else { $parameters = array('action', 'pid'); } Find this: case 'buy_now' : if (isset($HTTP_GET_VARS['products_id'])) { REPLACE with this: // BOF: XSell case 'buy_now' : if (isset($HTTP_GET_VARS['product_to_buy_id'])) { if (tep_has_product_attributes($HTTP_GET_VARS['product_to_buy_id'])) { tep_redirect(tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $HTTP_GET_VARS['product_to_buy_id'])); } else { $cart->add_cart($HTTP_GET_VARS['product_to_buy_id'], $cart->get_quantity($HTTP_GET_VARS['product_to_buy_id'])+1); } } elseif (isset($HTTP_GET_VARS['products_id'])) { // EOF: XSell Quote Link to comment Share on other sites More sharing options...
Mort-lemur Posted March 2, 2012 Share Posted March 2, 2012 Should be products_to_buy_id But there must be something different with your shop for the contribution not to work, - I assume that you are on OSC 2.3.1 Have you tried your store on a server rather than a local setup? it may be that whatever you are using as a local host xampp etc may be the problem? Quote Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members. Link to comment Share on other sites More sharing options...
Guest Posted March 2, 2012 Share Posted March 2, 2012 Yes I am in CSO 2.3.1 I have the same problem on the web I'm still looking ... Quote Link to comment Share on other sites More sharing options...
Guest Posted March 5, 2012 Share Posted March 5, 2012 I did a test, the cross-link only works with the product that is first in the database. Not the others. Can it mean anything for you? Quote Link to comment Share on other sites More sharing options...
Mort-lemur Posted March 5, 2012 Share Posted March 5, 2012 Without being able to see your shop and how it behaves Im afraid I cant really help Quote Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members. Link to comment Share on other sites More sharing options...
Guest Posted March 5, 2012 Share Posted March 5, 2012 You can see the problem on this page ... if you want ! http://www.axocom.com/catalog/product_info.php?products_id=29&osCsid=d569adc4e8bf7c5a28d4616172e74aba Quote Link to comment Share on other sites More sharing options...
Mort-lemur Posted March 5, 2012 Share Posted March 5, 2012 I think the problem lies in your catalog/includes/modules/xsell_products.php with the 2.3.1 button code. around line 49 To confirm this try substituting the file from the earlier contribution (by me) which uses the 2.2 buttons. If this worls then the problem lies with the later version that coded in 2.3.1 style buttons. Thanks Quote Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members. Link to comment Share on other sites More sharing options...
Guest Posted March 5, 2012 Share Posted March 5, 2012 This one ? http://addons.oscommerce.com/info/1415/v,22 I can not find yours! Thanks 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.