Multi Cross Sell mod [Support thread]

I am looking through my error log in my Cpanel and I came across this error.

Tue Jan 18 11:17:09 2011] [error] [client 188.165.234.114] PHP Warning: constant() [<a href='function.constant'>function.constant</a>]: Couldn't find constant 11 in /home/fromprop/public_html/includes/modules/alysa_rounded/multi_xsell_products.php on line 43

I re downloaded the module and opened that multi_xsell_products.php and the one I have in Winmerge and I got a message saying that it's identical.

I don't understand what this error message is telling me.

Thanks!

nolsowski:

I am looking through my error log in my Cpanel and I came across this error.

Tue Jan 18 11:17:09 2011] [error] [client 188.165.234.114] PHP Warning: constant() [<a href='function.constant'>function.constant</a>]: Couldn't find constant 11 in /home/fromprop/public_html/includes/modules/alysa_rounded/multi_xsell_products.php on line 43

I re downloaded the module and opened that multi_xsell_products.php and the one I have in Winmerge and I got a message saying that it's identical.

I don't understand what this error message is telling me.

Thanks!

You have remnants of a previous cross sells confiquration installed
in this case MIN_DISPLAY_XSELL

See post #31

gilby:

You have remnants of a previous cross sells confiquration installed
in this case MIN_DISPLAY_XSELL

See post #31

Am I supposed to search with that in the quotations or without? Reason asking is because I have went into my phpadmin and searched with and got nothing. But I searched without the quotations and I got a error that says this:

Error

SQL query: Documentation

SELECT *
FROM zen_configuration
WHERE configuration_id = MIN_DISPLAY_XSELL
LIMIT 0 , 30

MySQL said: Documentation
#1054 - Unknown column 'MIN_DISPLAY_XSELL' in 'where clause'

Sorry I am completely lost when it comes the the phpadmin.

nolsowski:

Am I supposed to search with that in the quotations or without? Reason asking is because I have went into my phpadmin and searched with and got nothing. But I searched without the quotations and I got a error that says this:

Error

SQL query: Documentation

SELECT *
FROM zen_configuration
WHERE configuration_id = MIN_DISPLAY_XSELL
LIMIT 0 , 30

MySQL said: Documentation
#1054 - Unknown column 'MIN_DISPLAY_XSELL' in 'where clause'

Sorry I am completely lost when it comes the the phpadmin.

Try this instead...

SELECT *
FROM zen_configuration
WHERE configuration_key = 'MIN_DISPLAY_XSELL'
LIMIT 0 , 30

gilby:

Try this instead...

SELECT *
FROM zen_configuration
WHERE configuration_key = 'MIN_DISPLAY_XSELL'
LIMIT 0 , 30

Just tried this too and it's saying it's coming up empty.

nolsowski:

Just tried this too and it's saying it's coming up empty.

browse this table
goto the end
page backwards until you find it
then delete it

ignore the same key that has a number after it
eg MIN_DISPLAY_XSELL1
MIN_DISPLAY_XSELL2
MIN_DISPLAY_XSELL3 etc

gilby:

browse this table
goto the end
page backwards until you find it
then delete it

ignore the same key that has a number after it
eg MIN_DISPLAY_XSELL1
MIN_DISPLAY_XSELL2
MIN_DISPLAY_XSELL3 etc

Thanks! I got it deleted.

Hi
I got your mod installed correctly i think, but im stuck on the entering my first cross sell.
getting the error 'Please input at least 2 products ids/models to cross-sell'
there are only 2 text entry boxes -new cross sells & edit cross sells
i didnt merge the file tpl_product_info_display.php becuse its not in my custom template folder.
tho i have that file in a template_default folder.
im on Zen 3.8
Thank You!

Hi
i had to remove all the multi cross sell files entirely.
when i clicked on any of my product thumbnail/links to view product page the page was blank :no:
when i removed all the multi cross files they came back, thank God.

still need a mod like this though.

eg we have a product category 'coffee tables'
when a visitor looks at 'Acme coffee table'
i want the to see below listing...also in this range...
-'acme bookshelf' 'acme lamp table' etc

any help advice appreciated.
Cookie

Cookiepus:

Hi
I got your mod installed correctly i think, but im stuck on the entering my first cross sell.
getting the error 'Please input at least 2 products ids/models to cross-sell'
there are only 2 text entry boxes -new cross sells & edit cross sells
i didnt merge the file tpl_product_info_display.php becuse its not in my custom template folder.
tho i have that file in a template_default folder.
im on Zen 3.8
Thank You!

In the "New Cross Sell"
Enter a list of items that you want to cross sell sepearated with the defined separater
ege: product1,product2,product3 will cross sell these 3 products in all possible ways
Read yellow1912's tutorial in docs\how_to_use.txt

If the file tpl_product_info_display.php becuse its not in my custom template folder
then rename the sample file
SAMPLE_ADDITION_TO_tpl_product_info_display.php
to
tpl_product_info_display.php
and make sure it is in your overide folder
\includes\templates\YOUR_TEMPLATE\templates\

renaming "YOUR_TEMPLATE" to your template name of course

Cookiepus:

Hi
i had to remove all the multi cross sell files entirely.
when i clicked on any of my product thumbnail/links to view product page the page was blank :no:
when i removed all the multi cross files they came back, thank God.

still need a mod like this though.

eg we have a product category 'coffee tables'
when a visitor looks at 'Acme coffee table'
i want the to see below listing...also in this range...
-'acme bookshelf' 'acme lamp table' etc

any help advice appreciated.
Cookie

Almost certainly to do with the file
tpl_product_info_display.php if you merged it with the original instead of putting it in the overide folder

You can use this to debug
http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=860

Also https://www.zen-cart.com/tutorials/index.php?article=82

Thank you very much!
i'll try this out later today

Cookie

How do I get the price to be center under the cross sell product title?
http://frompropertorocker.com/index.php?main_page=product_info&cPath=240_242_291&products_id=1520 It looks horrible when it's just one cross sell product.

It doesn't look so bad when there is more than one like here but the price is still off centered.

Thanks!

Does anyone know how to set up the cross sell as a sidebox instead of having it under the products??

Cheers

Phil

I tried to delete both MAX_DISPLAY_XSELL and MIN_DISPLAY_XSELL, but the problem still exists as #34. Anyone who followed instructions on #32 and got the problem fixed. Please show me the steps that you went through. Thanks so much.

gilby:

I am assuming you had a previous cross sell installed??
Almost certainly some of the previous mods configuration values are still there.

Search the configuration table for configuration_key = "MAX_DISPLAY_XSELL"
And delete this entry.

While you at it see if "MIN_DISPLAY_XSELL" is also there and delete it as well

I tried to delete them, but I don't get the problem fixed. The error message is similar to #29.

Anyone who get the problem fixed, please show me the procedures how to fix the problem. Thanks so much.

ttmb33:

I tried to delete them, but I don't get the problem fixed. The error message is similar to #29.

Anyone who get the problem fixed, please show me the procedures how to fix the problem. Thanks so much.

Not sure what you have done...

Did you find MAX_DISPLAY_XSELL?

Did you then try to delete it but this key is still there?

gilby:

Same problem as in Post# 29
Answer is in Post# 31

You will need something like phpmyadmin to search the configuration table for configuration_key = "MAX_DISPLAY_XSELL"
And then delete it.

I also have this problem but it is happening on a fresh 1.3.9h install with no previous versions installed. In this case, post #31 does not apply. Please help.

Thanks

I installed this on my site. I am able to add items to the xsell in admin but when I go to the page it throws this 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 '' at line 7
in:
[select distinct p.products_id, p.products_image, pd.products_name from ntt_zen_products_xsell1 xp, ntt_zen_products p, ntt_zen_products_description pd where xp.products_id = '1665' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 order by xp.sort_order asc limit ]

I did install Cross Sell - Just Another Cross Sell Mod previously.