Ultimate Cross Sell [Support Thread]

[atemp]

Please help. I have the following error on my checkout screen. I have seen similar but not this one.

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 '(select p.products_id, p.products_image from ultimate_cross_sell_1 xp, produ' at line 7
in:
[(select p.products_id, p.products_image from ultimate_cross_sell_1 xp, products p, products_description pd where xp.products_id = '341' 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() limit 6)(select p.products_id, p.products_image from ultimate_cross_sell_1 xp, products p, products_description pd where xp.products_id = '341' 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() limit 6)]

[DKunev]

I get this error when i try to install the module in Admin > Catalog > Ultimate Cross Sell

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 'TYPE=MyISAM' at line 7
in:
[CREATE TABLE IF NOT EXISTS ultimate_cross_sell_1 ( `ID` int(10) NOT NULL auto_increment, `products_id` int(10) unsigned NOT NULL default '1', `cross_sell_id` int(10) unsigned NOT NULL default '1', `sort_order` int(10) unsigned NOT NULL default '1', PRIMARY KEY (`ID`), KEY `idx_products_id_cross_sell` (`products_id`) ) TYPE=MyISAM]
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.

Why is that?

[charmedbytina2]

Forgive me forum users, but on the UCS page in the dropdown list used to select which table you wish to edit, there are no numbers showing up. Has anyone else experienced or resolved this?

Anyone have a solution for this?

Thanks!

Tina

[kamelion0927]

Anyone have a solution for this?

Thanks!

Tina

I don't have this problem - I see and can navigate the tables using the drop down...

(I'm not trying to be rude, I just hate it when I have an issue that no one else has brought up and nobody bothers to tell me that they aren't experiencing the same issue so I know for sure if it's me or the mod.)

Sorry I can't be of more help

[willie bee]

I have installed this and tested it with two products to cross sell.

Once I get to the shopping cart I get this error and I did not see any fix for it in the previous posts.

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 '' at line 1
in:
[select * from upsell limit ]

also my footer and right hand side boxes disappear. This ONLY happens which you go to the shopping cart.

[mydanilo]

I just finished upgrading to 1.3.9h and consider switching from Cross Sell - Just Another Cross Sell Mod to this Ultimate Cross Sell.

I've tried to just modify the said files and upload all the stuff. Admin would just be blank after ftp all files. Removed them all and all is good again. So there are conflicts if previously Cross Sell - Just Another Cross Sell Mod was installed. What would be the correct procedure? I suspect all Cross Sell - Just Another Cross Sell Mod files need to be removed. Just don't want to loose all cross sells that are in place now.

I have had also cart_upsell installed. How does this mod handle the previous versions? Does everything have to be removed before installing this one?

[willie bee]

I just finished upgrading to 1.3.9h and consider switching from Cross Sell - Just Another Cross Sell Mod to this Ultimate Cross Sell.

I've tried to just modify the said files and upload all the stuff. Admin would just be blank after ftp all files. Removed them all and all is good again. So there are conflicts if previously Cross Sell - Just Another Cross Sell Mod was installed. What would be the correct procedure? I suspect all Cross Sell - Just Another Cross Sell Mod files need to be removed. Just don't want to loose all cross sells that are in place now.

I have had also cart_upsell installed. How does this mod handle the previous versions? Does everything have to be removed before installing this one?

I believe in the HTML instruction file there should be specific instructions on how not to loose your other cross sells.

[willie bee]

I have installed this and tested it with two products to cross sell.

Once I get to the shopping cart I get this error and I did not see any fix for it in the previous posts.

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 '' at line 1
in:
[select * from upsell limit ]

also my footer and right hand side boxes disappear. This ONLY happens which you go to the shopping cart.

[mydanilo]

willie bee:
Did you check if this step was done right?

Using your favorite Text Editor, add the following code to the bottom of includes\templates\YOUR_TEMPLATE\templates\tpl_shopping_cart_default.php immediately above the last </div> tag.

<!-- bof Ultimate Cross Sell Combo -->
<?php require(DIR_WS_MODULES . zen_get_module_directory(FILENAME_CART_UPSELL)); ?>
<?php require($template->get_template_dir('tpl_modules_also_purchased.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_also_purchased.php'); ?>
<!-- eof Ultimate Cross Sell Combo -->

You could test if the problem is with this file by just deleting it from your template folder and see it the error goes away. If yes, I suspect you have a mistake in the code above.

[kamelion0927]

I have installed this and tested it with two products to cross sell.

Once I get to the shopping cart I get this error and I did not see any fix for it in the previous posts.

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 '' at line 1
in:
[select * from upsell limit ]

also my footer and right hand side boxes disappear. This ONLY happens which you go to the shopping cart.

Footers and sideboxes usually disappear when there is some kind of code error - and with this mod, it's probably because the cross sell mod code is being put within the shopping cart form.

Check your debugging utility errors (in shop/cache). You can usually find out about where the error is there.