Multi Cross Sell mod [Support thread]

Quote:

---

Originally Posted by bloomingvine

Just setting up an upgrade shop with 1.5 released. I uploaded from the old database and installed multi-cross sell, which I really need in my shop. It is the best mod. However, in 1.5, there is no boxes folder in the admin, so there is no way to install the mod through admin. Is there any way to get a sql patch ti install it? I loaded the3 old database and pasted into product infodisplay in template default, and all my cross sells from the old store are there and displaying. there is just no way to add more or access the mod from admin. Thanks. no hurry.

---

I attempted to install this mod on a fresh install of v1.50. Had a little trouble merging some of the files - I think I'll wait until gilby is able to issue an upgrade.

As a work around to your admin access problem, using the Admin>Admin Access Management>Admin Page Registration facility and the details in /includes/boxes/extra_boxes/multi_xsell_catalog_dhtml.php one is able to activate the Admin->Catalog->Advanced Cross-Sell option. I'm afraid I can't remember if Admin->configuration->cross sell is subsequently activated of if I navigated there by amending the ?gID= in the Configuration url.

Of course, my installation problems may not have been caused by merging files but by the mods incompatability with v1.50, I don't really know enough to decide which.

Anyway hopefully this might give you something to play with.

Back next year!

Thanks, I was able to go to the page by navigating and changing the url as you suggested, but it seems there is an indefined link in the code on the page. I also moved the boxes/extra_boxes/multi_xsell_catalog_dhtml.php file out into the main admin folder to try to get it to install that way. When I try to type in the admin access page, under filename I am trying all sorts of variations of the path name, but it can't find it. I did just the filename, no path, the whole path with the boxes folder which I uploaded for good measure, and the path to the file I put in the main admin folder. It also returne the error that language is not de4rfined and I need to put the key on the page I think.

As for merging files, I think there was only one file altered, the product info display file. I used the one in template default since I use a heavily modified classic template.

Yeah, I can wait for an update. I am not switching over to the new cart till all my favorite mods are updated. Just testing stuff so far. This is my most important one as I sell artwork on all kinds of products and it is helpful to see all the different products with the same pieces. Happy New Year!

Well as a work around for 1.5 you could do this:

Install as before. You won't see anything in the admin menus yet.

Then run the following sql patch:

Code:

---

INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('multiXsell', 'BOX_CATALOG_MULTI_XSELL_PRODUCTS', 'FILENAME_MXSELL_PRODUCTS', '', 'catalog', 'Y', 999);

---

if your site uses a prefix for the database tables then you'll have to change the 'admin_pages' to 'prefixadmin_pages' ( and in the next one) . that will let you see the menu item in the 'catalog' menu.

using that you install the mod with the install button

however you still won't be able to see the configuration menus. for that you can run this sql :

Code:

---

SELECT (@sort_order:=MAX(sort_order)+1) FROM admin_pages WHERE menu_key='configuration';
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Cross Sell Settings' LIMIT 1;
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('configMultiXsell', 'BOX_CATOLOG_MULTI_XSELL_PRODUCTS', 'FILENAME_CONFIGURATION', CONCAT('gID=', @configuration_group_id), 'configuration', 'Y', @sort_order);

---

that should get you functional with this great mod even if it not ideal .

Quote:

---

Originally Posted by niccol

Well as a work around for 1.5 you could do this:

Install as before. You won't see anything in the admin menus yet.

Then run the following sql patch:

Code:

---

INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('multiXsell', 'BOX_CATALOG_MULTI_XSELL_PRODUCTS', 'FILENAME_MXSELL_PRODUCTS', '', 'catalog', 'Y', 999);

---

if your site uses a prefix for the database tables then you'll have to change the 'admin_pages' to 'prefixadmin_pages' ( and in the next one) . that will let you see the menu item in the 'catalog' menu.

using that you install the mod with the install button

however you still won't be able to see the configuration menus. for that you can run this sql :

Code:

---

SELECT (@sort_order:=MAX(sort_order)+1) FROM admin_pages WHERE menu_key='configuration';
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Cross Sell Settings' LIMIT 1;
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('configMultiXsell', 'BOX_CATOLOG_MULTI_XSELL_PRODUCTS', 'FILENAME_CONFIGURATION', CONCAT('gID=', @configuration_group_id), 'configuration', 'Y', @sort_order);

---

that should get you functional with this great mod even if it not ideal .

---

That installed the instance of multi cross sell to the catalog menu, however, when clicked it directed me to multi_xsell.php instead of the file mentioned above. It then said file not found. So I changed the file that was originally to go in the boxes folder to just multi_xsell.php and when I click on the menu item in the admin I get the following error Fatal error: Call to undefined function zen_href_link() in /home/content/36/5920136/html/store/admin42666wild/multi_xsell.php on line 17

Thanks for trying though, I really appreciate it!

Well, the first part of the sql just makes the menu item visible.

It should direct you to :

your-admin/multi_xsell.php

Which seems to be what you are saying that you experienced. On that page there is an 'install' button.

You then click on the install button. Which, puts some records into the database, including the menu items for the configuration.

But you need to then use the second sql statement to show the menu items in the configuration menu items.

The order is important. And it is important that the module is fully uninstalled before you start. That means that the files are removed and the database entries are removed.

I think that something else is going on here. If you are getting that error to that particular function as undefined then something is not installed correctly. As I say, my instructions were based on starting from a clean install so if files and database have been altered before that then it is hard to comment on those changes.

Quote:

---

Originally Posted by niccol

Well, the first part of the sql just makes the menu item visible.

It should direct you to :

your-admin/multi_xsell.php

Which seems to be what you are saying that you experienced. On that page there is an 'install' button.

You then click on the install button. Which, puts some records into the database, including the menu items for the configuration.

But you need to then use the second sql statement to show the menu items in the configuration menu items.

The order is important. And it is important that the module is fully uninstalled before you start. That means that the files are removed and the database entries are removed.

I think that something else is going on here. If you are getting that error to that particular function as undefined then something is not installed correctly. As I say, my instructions were based on starting from a clean install so if files and database have been altered before that then it is hard to comment on those changes.

---

I had missed the initial file that is out in the main admin folder. Now when I click on the menu item in catalog, I see a box that says edit cross sells with a pull down menu of 1-5 and a remove button on the far right. I may have to reinstall. This is my first mod on a fresh install of zen 1.5 for testing, but I loaded the old database from zen1.3.9h .

Quote:

---

Originally Posted by niccol

Well, the first part of the sql just makes the menu item visible.

It should direct you to :

your-admin/multi_xsell.php

Which seems to be what you are saying that you experienced. On that page there is an 'install' button.

You then click on the install button. Which, puts some records into the database, including the menu items for the configuration.

But you need to then use the second sql statement to show the menu items in the configuration menu items.

The order is important. And it is important that the module is fully uninstalled before you start. That means that the files are removed and the database entries are removed.

I think that something else is going on here. If you are getting that error to that particular function as undefined then something is not installed correctly. As I say, my instructions were based on starting from a clean install so if files and database have been altered before that then it is hard to comment on those changes.

---

I see, so it may not be working because I used the old database? I can't import 600 products any other way. Way too much work.

OK. Well, that means that you have some of it installed fine but other bits not so much.

Basically, you need to remove anything from the databases that is to do with the mod and configuration. ( but not the actual cross sells )

So, you are interested in the following tables in the database:
configuration (mulptiple rows)
configuration_group ( 1 row )
admin_pages ( 1 or 2 rows )

but you DO NOT want to alter the products_xsell table.

If you can do that with phpMyAdmin then that is the easiest way to do it. Just go through the tables and delete the rows. ( after having backed up obviously)

Then run my first sql.
Then navigate to the page and click on 'install'
Then run the second sql

If you are not happy with phpMyAdmin I'd recommend that you give it a go anyway. It is good to know how to do it. And if not then I can probably write you an sql statement that would get rid of it all for you, but....

Quote:

---

Originally Posted by niccol

OK. Well, that means that you have some of it installed fine but other bits not so much.

Basically, you need to remove anything from the databases that is to do with the mod and configuration. ( but not the actual cross sells )

So, you are interested in the following tables in the database:
configuration (mulptiple rows)
configuration_group ( 1 row )
admin_pages ( 1 or 2 rows )

but you DO NOT want to alter the products_xsell table.

If you can do that with phpMyAdmin then that is the easiest way to do it. Just go through the tables and delete the rows. ( after having backed up obviously)

Then run my first sql.
Then navigate to the page and click on 'install'
Then run the second sql

If you are not happy with phpMyAdmin I'd recommend that you give it a go anyway. It is good to know how to do it. And if not then I can probably write you an sql statement that would get rid of it all for you, but....

---

Thanks, I removed the items you mentioned from the database and that removed it. I did see the install button then before running the second squl patch. However, That produced an error and I found I had one file missing in the uploads again. I have to re edit the databases and try again.

Quote:

---

Originally Posted by gilby

It easier to work out with a live site.....

However Multi Cross Sell uses..
class="centerBoxWrapper" and class="centerBoxHeading"

So find what styling has been applied to the "also purchased box" and apply it to these classes.

---

My test site is technically 'live' (www.mylocalpoolshop.com.au/TanyaPools) but I'm still having problems. I've applied these styles to the same place as the 'also purchased' box but to no satisfaction.

I am no programmer and am not terribly savvy with these things but am certainly learning quite a bit as I go.

Do I have to change the stylesheet or do I have to change the actual files in the downloaded files? If I'm not a wrong path here, can you please advise me what the right path is?

Thanks very much for your help.

Quote:

---

Originally Posted by My_Red_Zebra

My test site is technically 'live' (www.mylocalpoolshop.com.au/TanyaPools) but I'm still having problems. I've applied these styles to the same place as the 'also purchased' box but to no satisfaction.

I am no programmer and am not terribly savvy with these things but am certainly learning quite a bit as I go.

Do I have to change the stylesheet or do I have to change the actual files in the downloaded files? If I'm not a wrong path here, can you please advise me what the right path is?

Thanks very much for your help.

---

Undo what you have done
You have duplicated id="alsoPurchased"

Then in includes\templates\YOUR_TEMPLATE\templates\tpl_modules_multi_xsell_products.php
around line 30 find..

PHP Code:

---

    <h2 class="centerBoxHeading"><?php echo constant('TEXT_MXSELL' . $mxsell . '_PRODUCTS'); ?></h2>

---

add <span> tags and change to

PHP Code:

---

    <h2 class="centerBoxHeading"><span><?php echo constant('TEXT_MXSELL' . $mxsell . '_PRODUCTS'); ?></span></h2>

---

See if that works....

Quote:

---

Originally Posted by gilby

Undo what you have done
You have duplicated id="alsoPurchased"

Then in includes\templates\YOUR_TEMPLATE\templates\tpl_modules_multi_xsell_products.php
around line 30 find..

PHP Code:

---

    <h2 class="centerBoxHeading"><?php echo constant('TEXT_MXSELL' . $mxsell . '_PRODUCTS'); ?></h2>

---

add <span> tags and change to

PHP Code:

---

    <h2 class="centerBoxHeading"><span><?php echo constant('TEXT_MXSELL' . $mxsell . '_PRODUCTS'); ?></span></h2>

---

See if that works....

---

Thanks very much Gilby. Almost there now.

We have a light blue bar/line under the heading which shouldn't be there. How do I remove that? Also, is it very hard to get the blue shaded box around the products the same as in the 'also purchased' box?

Quote:

---

Originally Posted by My_Red_Zebra

Thanks very much Gilby. Almost there now.

We have a light blue bar/line under the heading which shouldn't be there. How do I remove that? Also, is it very hard to get the blue shaded box around the products the same as in the 'also purchased' box?

---

Just a typo
you have

Code:

---

    <h2 class="centerBoxHeading"><span><?php echo constant('TEXT_MXSELL' . $mxsell . '_PRODUCTS'); ?><span></h2>

---

and it should be

Code:

---

    <h2 class="centerBoxHeading"><span><?php echo constant('TEXT_MXSELL' . $mxsell . '_PRODUCTS'); ?></span></h2>

---

I am running Zen v1.3.9h and PHP 5.2

I just installed this mod and everything seemed to install fine. However, I don't see anywhere in the admin to add/manage cross sell items.

The only options I see are:

Admin >> Configuration >> Cross Sell Settings

and

Admin >> Catalog >> Multi Cross Sell

The first is obviously the page with config settings and the latter has only a small drop down and a Go button, and nothing else. And nothing happens when I click "GO".

I fear I am missing something, but all files seem to have copied correctly.

Quote:

---

Originally Posted by morganmoran

I am running Zen v1.3.9h and PHP 5.2

I just installed this mod and everything seemed to install fine. However, I don't see anywhere in the admin to add/manage cross sell items.

The only options I see are:

Admin >> Configuration >> Cross Sell Settings

and

Admin >> Catalog >> Multi Cross Sell

The first is obviously the page with config settings and the latter has only a small drop down and a Go button, and nothing else. And nothing happens when I click "GO".

I fear I am missing something, but all files seem to have copied correctly.

---

Go to Admin->Catalog->Multi Cross Sell
Click Install
Go to Admin->Configuration->Cross Sell Settings
By default one cross sell is installed
Configure as required.

Go to Admin->Catalog->Multi Cross Sell
Below the Go button it should show the cross sell options

Clean up Cross Sell 1
New Cross Sells 1
Edit Cross Sells 1
Delete All Cross Sells 1
Multi Cross Sell Summary
List All Cross Sells 1

If these don't show you have missed something in the uploads
go to your "cache" directory and check the error logs there.

Brilliant, thanks so much. I didn't notice before that the bottom of the box is missing it's line too. How would I fix that one?

Also, would it be hard to format the box to look the same as the 'Also Purchased' Box - all shaded in blue etc.??

Quote:

---

Originally Posted by My_Red_Zebra

Brilliant, thanks so much. I didn't notice before that the bottom of the box is missing it's line too. How would I fix that one?

Also, would it be hard to format the box to look the same as the 'Also Purchased' Box - all shaded in blue etc.??

---

Again its a matter of playing with the CSS and the styles for those elements.
Your site is down at this time so I can't see it

Hello
i cant seem to control the sort order which my items appears in the cross sell.
Editing each products sort order (in the products info page) doesn't seem to have any effect.
i don't have the random setting set to 'on' either.
Any advice appreciated.
Thanks for the mod!

Quote:

---

Originally Posted by Cookiepus

Hello
i cant seem to control the sort order which my items appears in the cross sell.
Editing each products sort order (in the products info page) doesn't seem to have any effect.
i don't have the random setting set to 'on' either.
Any advice appreciated.
Thanks for the mod!

---

admin/catalog/Multi Cross Sell

Either "Edit Cross Sells" and enter the Product
or "List all Cross Sells" and select "edit" for the one you want

Then add numbers into the "sort order" of the cross sells

Thanks Gilby
i didnt know that was built in.
what a great mod.
i have my items grouped in cross sells of around 8.
Do i have to enter sort order for each & every item?
i mean, can i set it so certain items will appear first in each cross sell group?
Cheers
Cookie

Quote:

---

Originally Posted by Cookiepus

Thanks Gilby
i didnt know that was built in.
what a great mod.
i have my items grouped in cross sells of around 8.
Do i have to enter sort order for each & every item?
i mean, can i set it so certain items will appear first in each cross sell group?
Cheers
Cookie

---

In this version no you need to do it manually.

I am looking to have a default sort order based on the entry sequence. (This could only work for one way cross sells)

OK - well
thanks again
Cookie

Quote:

---

Originally Posted by gilby

Again its a matter of playing with the CSS and the styles for those elements.
Your site is down at this time so I can't see it

---

Thanks, I'll see how I go. BTW the site is back up & running. Was only down for a short time. :smile:

Zen Cart v1.3.8/v1.3.8
Multi Cross Sell Admin v1.02

Hi,
Above is the version of Zen Cart which I am using and my Multiple Cross Sell.

I am having problems using this feature....

Could anyone give me basic info on how to use it..

Thank You

Quote:

---

Originally Posted by gilby

Again its a matter of playing with the CSS and the styles for those elements.
Your site is down at this time so I can't see it

---

Okay, not having any luck. Saying that, I am a total novice at this sort of thing. I've got something that is reasonable looking but I need the bottom line on my box and need to centre the product titles under the image. Any advice on this would be greatly appreciated.

Quote:

---

Originally Posted by My_Red_Zebra

Okay, not having any luck. Saying that, I am a total novice at this sort of thing. I've got something that is reasonable looking but I need the bottom line on my box and need to centre the product titles under the image. Any advice on this would be greatly appreciated.

---

I remember using "view source on that page and at the bottom of the "also purchased" box there was a line with a class added by your template.
You simply grab that line and add it to the bottom of the cross sell box.
You have removed the "also purchased" box from your site so I cannot tell you exactly what that line is.

Quote:

---

Originally Posted by budgieoc18

Zen Cart v1.3.8/v1.3.8
Multi Cross Sell Admin v1.02

Hi,
Above is the version of Zen Cart which I am using and my Multiple Cross Sell.

I am having problems using this feature....

Could anyone give me basic info on how to use it..

Thank You

---

Have you looked in the mod here?
\docs\README-MultiCrossSell.txt
and
\docs\how_to_use.txt

Quote:

---

Originally Posted by niccol

Well as a work around for 1.5 you could do this:

Install as before. You won't see anything in the admin menus yet.

Then run the following sql patch:

Code:

---

INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('multiXsell', 'BOX_CATALOG_MULTI_XSELL_PRODUCTS', 'FILENAME_MXSELL_PRODUCTS', '', 'catalog', 'Y', 999);

---

if your site uses a prefix for the database tables then you'll have to change the 'admin_pages' to 'prefixadmin_pages' ( and in the next one) . that will let you see the menu item in the 'catalog' menu.

using that you install the mod with the install button

however you still won't be able to see the configuration menus. for that you can run this sql :

Code:

---

SELECT (@sort_order:=MAX(sort_order)+1) FROM admin_pages WHERE menu_key='configuration';
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Cross Sell Settings' LIMIT 1;
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('configMultiXsell', 'BOX_CATOLOG_MULTI_XSELL_PRODUCTS', 'FILENAME_CONFIGURATION', CONCAT('gID=', @configuration_group_id), 'configuration', 'Y', @sort_order);

---

that should get you functional with this great mod even if it not ideal .

---

Nick,

Could you be so kind as to provide the SQl script to add 'Admin/Configuration/Cross Sell Settings' to the admin?

Thanx in advance!

Where is the SQL file located?

Nevermind. I got it. But I still don't have a Cross Sell option in my configuration menu.

@stizzed
sorry missed your question. those sql statements in my post are the ones that I use to get full ( I think) functionality. What exactly don't you have?

@The Mech
A bit more info would help. Zen Cart version?

In general, this is not my mod. Gilby is the man. I jsut posted what I did to get it to play with Zen 1.5.

The only other thing that I may not have answered because this was originally posted for a specific question was that you may need to ensure that BOX_CATOLOG_MULTI_XSELL_PRODUCTS is actually defined somewhere. I can't remember if I had to define that in a new language file or not, to be honest. If I get time I will re-install on a clean server and have a look at it. But it would be best if a Zen 1.5 compatible version was released, and I am kind of busy with other mods...

Thanks Niccol,
zen-cart-v150-full-release-12302011

When running your patch for 1.5:

Code:

---

SELECT (@sort_order:=MAX(sort_order)+1) FROM admin_pages WHERE menu_key='configuration';
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Cross Sell Settings' LIMIT 1;
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('configMultiXsell', 'BOX_CATOLOG_MULTI_XSELL_PRODUCTS', 'FILENAME_CONFIGURATION', CONCAT('gID=', @configuration_group_id), 'configuration', 'Y', @sort_order);

---

I get this:

Code:

---

Error

SQL query:

INSERT INTO admin_pages( page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order )
VALUES (
'configMultiXsell', 'BOX_CATOLOG_MULTI_XSELL_PRODUCTS', 'FILENAME_CONFIGURATION', CONCAT( 'gID=', @configuration_group_id ) , 'configuration', 'Y', @sort_order
);

MySQL said: Documentation
#1048 - Column 'page_params' cannot be null

---

I tried changing the CONCAT bit to 'gID=31' where 31 was the next gID. It entered without error at that point, but nothing happened.

basically that means that you have not got the entry in the configuration_group table there already. that should have been created by the original install of the mod.

have you followed the instructions correctly. For instance :

Code:

---

using that you install the mod with the install button

---

Quote:

---

Originally Posted by niccol

basically that means that you have not got the entry in the configuration_group table there already. that should have been created by the original install of the mod.

have you followed the instructions correctly. For instance :

Code:

---

using that you install the mod with the install button

---

---

Yeah, and after installing, I ran your SQL.

I've found that the first SQL works without a table prefix but the second SQL only works with...

The above sql's may work for you with the existing 139 code. If so good!

My testing has shown that some functions relied on by this mod have changed in 1.5.0 and may result in blank admin pages on some sites.

------------------
Just an update as to where I am with this.

- Have sorted out the install and uninstall, that now works fine.
- Fixed a number of compatibility problems.

Working on making it work WITH 1.5.0 and not just work IN 1.5.0
eg: replacing some of the gets with posts.

At this stage it looks like being around 2 to 3 weeks before it should be ready.

@The_Mech
Yeah, that may well be it. I hope you get it to work. To be honest I slightly regret having even posted this as it is much better to wait for Gilby to do his update. I have it running fine on 1.5 but then I have tweaked the code anyway.

And as Gilby actively supports this mod I sort of feel that one should have the courtesy of waiting for that update. Gilby, I apologise for having got tangled up in it all. I absolutely understand how much work goes into it all and probably should have kept my mouth shut. It was just one of those cases when I had just done something myself and someone asked how to do it. Apologies.

Quote:

---

Originally Posted by niccol

@The_Mech
Yeah, that may well be it. I hope you get it to work. To be honest I slightly regret having even posted this as it is much better to wait for Gilby to do his update. I have it running fine on 1.5 but then I have tweaked the code anyway.

And as Gilby actively supports this mod I sort of feel that one should have the courtesy of waiting for that update. Gilby, I apologise for having got tangled up in it all. I absolutely understand how much work goes into it all and probably should have kept my mouth shut. It was just one of those cases when I had just done something myself and someone asked how to do it. Apologies.

---

No need to apologise and if it seemed I was having a go at you, I wasn't. I was just mentioning that there had been some problems that I had seen in some setups with the existing code.

As well I have been busy with my real job and haven't needed to get started on this until recently. If you or anyone want to improve or update it, go ahead I won't be miffed.

As it is, I certainly didn't write this from scratch. I looked at what was available and took what I thought was the best from other cross sells (especially yellow1912's version) and made changes that suited what I wanted it to do at the time.

Others have taken this and adapted it to their own use.
Take a look at ultimate_zc's version. He needed it to work a different way and has done it his way.

I rarely find a mod that works exactly the way I want it and often adapt it to what I need at the time. At the time I adapted yellow1912's cross sell I thought that this might also be useful to others as well, that why I submitted it.
I don't see this as "mine, keep off" it was just an evolution from what was available at the time. It is still useful to me so I will still work on it, but that doesn't mean others can't also.

@gilby
I completely understand.
I kind of just wanted people to know that I was just 'getting it to work' in 1.5 rather than having looked at the code in any deep way, which I haven't. The sql statements are very much a 'hack' and I haven't looked at the code closely enough to make any other observations other than that.
As I say I am kind of busy with other mods and other projects. So, I also completely appreciate your position with this mod. I was trying to find a way of saying ' wait for an official update' without seeming to pressure you to produce one because I know that it takes work and that no-one is ultimately responsible for a mod at all.

Quote:

---

Originally Posted by niccol

@stizzed
sorry missed your question. those sql statements in my post are the ones that I use to get full ( I think) functionality. What exactly don't you have?

---

niccol,

Thank you for the response and sharing your knowledge of this very useful mod!

'Admin->Configuration->Cross Sell Settings' is not there. I am able to use the mod because 'Admin->Catalog->Multi Cross Sell' is there (and works) but am not able to tweak the settings...

Thankx in advance!

Well the second sql statement should make the configuration menu setting visible.

Code:

---

SELECT (@sort_order:=MAX(sort_order)+1) FROM admin_pages WHERE menu_key='configuration';
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Cross Sell Settings' LIMIT 1;
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('configMultiXsell', 'BOX_CATOLOG_MULTI_XSELL_PRODUCTS', 'FILENAME_CONFIGURATION', CONCAT('gID=', @configuration_group_id), 'configuration', 'Y', @sort_order);

---

As has been noted if you are using a table prefix for your store then you'd have to add that to the table names. Like prefix_admin_pages and prefix_configuration group.

I think that is it.

Quote:

---

Originally Posted by niccol

Well the second sql statement should make the configuration menu setting visible.

Code:

---

SELECT (@sort_order:=MAX(sort_order)+1) FROM admin_pages WHERE menu_key='configuration';
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Cross Sell Settings' LIMIT 1;
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('configMultiXsell', 'BOX_CATOLOG_MULTI_XSELL_PRODUCTS', 'FILENAME_CONFIGURATION', CONCAT('gID=', @configuration_group_id), 'configuration', 'Y', @sort_order);

---

As has been noted if you are using a table prefix for your store then you'd have to add that to the table names. Like prefix_admin_pages and prefix_configuration group.

I think that is it.

---

Interesting... I ran both originally, do not use prefixes, and still, no 'Cross Sell Settings' on the Admin Menu...

I do seem to remember an error with the CONCAT portion of the INSERT statement.

Thoughts?

Quote:

---

Originally Posted by niccol

Well the second sql statement should make the configuration menu setting visible.

Code:

---

SELECT (@sort_order:=MAX(sort_order)+1) FROM admin_pages WHERE menu_key='configuration';
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Cross Sell Settings' LIMIT 1;
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('configMultiXsell', 'BOX_CATOLOG_MULTI_XSELL_PRODUCTS', 'FILENAME_CONFIGURATION', CONCAT('gID=', @configuration_group_id), 'configuration', 'Y', @sort_order);

---

As has been noted if you are using a table prefix for your store then you'd have to add that to the table names. Like prefix_admin_pages and prefix_configuration group.

I think that is it.

---

Yep! Checked the script, compared it to the database and everything looks like it made it in. Still not making the menu... :cry:

Quote:

---

Originally Posted by niccol

Well the second sql statement should make the configuration menu setting visible.

Code:

---

SELECT (@sort_order:=MAX(sort_order)+1) FROM admin_pages WHERE menu_key='configuration';
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Cross Sell Settings' LIMIT 1;
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('configMultiXsell', 'BOX_CATOLOG_MULTI_XSELL_PRODUCTS', 'FILENAME_CONFIGURATION', CONCAT('gID=', @configuration_group_id), 'configuration', 'Y', @sort_order);

---

As has been noted if you are using a table prefix for your store then you'd have to add that to the table names. Like prefix_admin_pages and prefix_configuration group.

I think that is it.

---

Found it! :clap: There is a simple misspelling in the statement 'BOX_CATOLOG_MULTI_XSELL_PRODUCTS'. As you can see 'CATOLOG' is misspelled.

Now however, instead of 'ADMIN>CONFIGURATION>Cross Sell Settings' we have 'ADMIN>CONFIGURATION>Multi Cross Sell'. When selecting this entry however, the proper menu options are there.

Any idea why the Menu Option Name is wrong?

Thanks in advance!

Well, the 'hack' that I posted has three parts.

1. Run the first sql statement. This will make the item in the catalog item visible.

2. Use the normal 'install' button in that page. This will run more sql statements.

3. Run the second sql statement. This will make the config menu item visible if the other two steps have been completed correctly.

Step three will cause an error if the other two steps have not been completed successfully. What it is doign is finding the configuration_id that is created by the normal instal and assigning it a admin page. If the configuration doesn't exist then the sql will fail.

If you are seeing this then you will need to wait for an official update.

great :smile:

the title is 'wrong' because this is a 'hack'. that title is already define in the code so I used that. You can easily define another constant and use whatever text you want, but this 'hack' avoided having to describe to people how to make a new language file and then define a new constant and then use that new constant in the sql statement.

Quote:

---

Originally Posted by niccol

great :smile:

the title is 'wrong' because this is a 'hack'. that title is already define in the code so I used that. You can easily define another constant and use whatever text you want, but this 'hack' avoided having to describe to people how to make a new language file and then define a new constant and then use that new constant in the sql statement.

---

Thanks again Nick! As you do not see a problem with the title and the mod seems to work as it is I won't take the time to try to 'fix' it. :D

I very much appreciate your assistance!

Hi everyone,
I'm having what looks like the same exact problem morganmoran had and despite my best efforts I can't figure out how to fix it.
Here's the info:
-ZC 1.3.9g
-PHP 5.2.17
-Double checked that all files from install package are where they need to be.
-Double checked that I included the code from the Document.txt file in the tpl_product_info_display.php file.
-Went to my admin under Catalog => Multi Cross Sell and clicked the install button.
-Now on the Multi Cross Sell Admin v1.02 page I have: "Select cross sell to edit" with a dropdown which has "1" selected, and a "Go" button.

When I click the "Go" button it seems to execute some process (i.e. I can tell that something is loading) but after 1-2 seconds nothing has happened, it's done loading, and the page remains the same. I'm expecting something to pop up or appear so that I can adjust the parameters for the cross sell, but nothing happens.

Can anyone point me in the right direction?
Thanks.

Quote:

---

Originally Posted by morganmoran

I am running Zen v1.3.9h and PHP 5.2

I just installed this mod and everything seemed to install fine. However, I don't see anywhere in the admin to add/manage cross sell items.

The only options I see are:

Admin >> Configuration >> Cross Sell Settings

and

Admin >> Catalog >> Multi Cross Sell

The first is obviously the page with config settings and the latter has only a small drop down and a Go button, and nothing else. And nothing happens when I click "GO".

I fear I am missing something, but all files seem to have copied correctly.

---

Quote:

---

Originally Posted by bhensarl

Hi everyone,
-Now on the Multi Cross Sell Admin v1.02 page I have: "Select cross sell to edit" with a dropdown which has "1" selected, and a "Go" button.

When I click the "Go" button it seems to execute some process (i.e. I can tell that something is loading) but after 1-2 seconds nothing has happened, it's done loading, and the page remains the same. I'm expecting something to pop up or appear so that I can adjust the parameters for the cross sell, but nothing happens.

Can anyone point me in the right direction?
Thanks.

---

This is one of the problems with the existing code working with 1.5.0

You will find in your cache directory debug files that show what this problem is.
Not sure off the top of my head what the fix for that problem is.

However its not the only one that can pop up.

I should have a fully working update in 2 to 3 weeks.

Thanks, gilby.

Checked the debug and found the problem here:

Quote:

---

[19-Feb-2012 12:01:15] PHP Warning: require(../includes/languages/english/extra_definitions/multi_xsell_box_defines.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/content/52/6977852/html/admin8dr7kj34/multi_xsell.php on line 222
[19-Feb-2012 12:01:15] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required '../includes/languages/english/extra_definitions/multi_xsell_box_defines.php' (include_path='.:/usr/local/php5/lib/php') in /home/content/52/6977852/html/admin8dr7kj34/multi_xsell.php on line 222

---

It looks like the "multi_xsell_box_defines.php" in the install package should be located at languages/english/extra_definitions/ instead of going all the way to languages/english/extra_definitions/YOURTHEME/ .

Works like a charm now. Thanks for this great addon!

Quote:

---

Originally Posted by bhensarl

Thanks, gilby.

Checked the debug and found the problem here:


It looks like the "multi_xsell_box_defines.php" in the install package should be located at languages/english/extra_definitions/ instead of going all the way to languages/english/extra_definitions/YOURTHEME/ .

Works like a charm now. Thanks for this great addon!

---

Yes thats one way around that problem!

Now all you have to do is rename your admin again as you have posted it for all to see.

Which facebook addon works best for the social media button for this mod?

Thanks

Quote:

---

Originally Posted by perkiekat

Which facebook addon works best for the social media button for this mod?

Thanks

---

I haven't tried it with any of the available mods here...

It is basically a placeholder in the mod that can be used for social media, (or other purposes).

You need to have a good understanding of how to setup Open Graph variables on the product info pages for the sample code to work correctly.

Quote:

---

Originally Posted by gilby

I haven't tried it with any of the available mods here...

It is basically a placeholder in the mod that can be used for social media, (or other purposes).

You need to have a good understanding of how to setup Open Graph variables on the product info pages for the sample code to work correctly.

---

Thank you for the info. Where is the "placeholder" for social media located at within this mod?
I checked the documentation and I do not see any information pertaining to where it is located. Maybe I missed it??
Thank you

Quote:

---

Originally Posted by perkiekat

Thank you for the info. Where is the "placeholder" for social media located at within this mod?
I checked the documentation and I do not see any information pertaining to where it is located. Maybe I missed it??
Thank you

---

includes\modules\YOUR_TEMPLATE\multi_xsell_products.php
line 65 has the default placeholder code
line 72 has the sample "commented out" facebook code

Quote:

---

Originally Posted by gilby

includes\modules\YOUR_TEMPLATE\multi_xsell_products.php
line 65 has the default placeholder code
line 72 has the sample "commented out" facebook code

---

Thanks, but not sure how to make this work ... :shocking:
so I will pass on it right now until I can dig deeper. Will just add the Like button for now in the site.

Hello Gilby,

I was wondering if you will be releasing a new version for 1.5.0?

Best Regards

Multi Cross Sell has now been updated to work with zen-cart v1.5.0

Quote:

---

Originally Posted by gilby

Multi Cross Sell has now been updated to work with zen-cart v1.5.0

---

Woo-Hoo! :clap:

Thanx Gilby!

Just a quick note to say congratulations, Gilby. I know how much work goes in :-) It is appreciated.

Hi, first of all; great mod! Just installed it and it works great.

I've read from another post that in the older version it is possible to increase the number of cross-sells. With the lastest version for ZC1.5 you already added 15 cross-sells. But is it still possible to increase this number?

Hmm... to quick wit my question. Now that I looked again (and better! sry..) there should be no need to do this :P But maybe others may wonder if it is possible or not ;-)

Quote:

---

Originally Posted by Gerjan

Hmm... to quick wit my question. Now that I looked again (and better! sry..) there should be no need to do this :P But maybe others may wonder if it is possible or not ;-)

---

Its hard coded to 15 but you could allter it in the php files if you wish. This is 15 different "header descriptions" of the cross sells.
Such as "We suggest"
or "Similar matching products"

Each of these cross sells (different headers) can have tens of thousands of individual product cross sells each.

Don't confuse the different cross sells (headers) with individual product cross sells.

I use 4 in one of my websites.
15 for most websites is more than enough (imo).
But it can be altered if necessary
nb: Each cross sell (different header) creates a table for its use.

Hi, I am a newly registered member but I have been browsing this forum for years now... I just wanted to thank you for this module I have installed it on Zen 1.5 and it's great! Appreciate your efforts to make this happen. I was wondering if there is a way to display the cross sell product in a sidebox on the product info page! how do you incorporate that into a sidebox? Any suggestions or help will be greatly appreciated.
Thanks

Quote:

---

Originally Posted by manu_sag

Hi, I am a newly registered member but I have been browsing this forum for years now... I just wanted to thank you for this module I have installed it on Zen 1.5 and it's great! Appreciate your efforts to make this happen. I was wondering if there is a way to display the cross sell product in a sidebox on the product info page! how do you incorporate that into a sidebox? Any suggestions or help will be greatly appreciated.
Thanks

---

At this time it is only for center boxes.
No plans for extending to sideboxes or display on the checkout page in the foreseeable future.

That doesn't mean that you couldn't dedicate one of the cross sells to a side box display. It just means you would have to custom code the sidebox yourself.

Thanks for the quick response... I am no expert in php but I'll do some research around this and see if I can make it happen but thank you very much for this great module.

installed in V1.5 and when selected INSTALL i get the error "WARNING: An Error occurred, please refresh the page and try again."

Tried 3 times now, giving up LOL

Quote:

---

Originally Posted by windsurfer

installed in V1.5 and when selected INSTALL i get the error "WARNING: An Error occurred, please refresh the page and try again."

---

Have you checked the cache directory for "error messages"?

I assume you were able to register the page?
(otherwise you wouldn't see an install button)

New (clean) Install?
or upgrade over a previous Multi Cross Sell?
or upgrade from a previous "other" Cross Sell?

Quote:

---

Originally Posted by gilby

Have you checked the cache directory for "error messages"?

I assume you were able to register the page?
(otherwise you wouldn't see an install button)

New (clean) Install?
or upgrade over a previous Multi Cross Sell?
or upgrade from a previous "other" Cross Sell?

---

I have the same question, update from v1.3.9, is there any sql to delete the old install?

hey gilby

have you read the post? i think it is due to this

http://www.zen-cart.com/forum/showpo...78&postcount=9

Quote:

---

Originally Posted by boomup

I have the same question, update from v1.3.9, is there any sql to delete the old install?

---

If the old install was Multi Cross Sell then click the "remove" button.

If a different cross sell then check that mod for an uninstall sql.

Quote:

---

Originally Posted by boomup

hey gilby

have you read the post? i think it is due to this

http://www.zen-cart.com/forum/showpo...78&postcount=9

---

Yes I aware of that, although to date it hasn't created a problem that I aware of.

Quote:

---

Originally Posted by gilby

Yes I aware of that, although to date it hasn't created a problem that I aware of.

---

Could you tell me how to fix it? thanks a lot

Quote:

---

Originally Posted by boomup

Could you tell me how to fix it? thanks a lot

---

Look in the cache directory for "error messages"?

i installed fresh and not upgrade.
I am using all your files except

it doesn't work with my "tpl_product_info_display.php"
it doesn't work with your "tpl_product_info_display.php"
it doesn't work with merged "tpl_product_info_display.php"

Below is the error log ( I have replaced the name of my admin with ADMIN

[09-Mar-2012 17:54:02 UTC] PHP Fatal 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 'TYPE=MyISAM' at line 7 :: CREATE TABLE IF NOT EXISTS products_xsell1 (

`ID` int(10) NOT NULL auto_increment,

`products_id` int(10) unsigned NOT NULL default '1',

`xsell_id` int(10) unsigned NOT NULL default '1',

`sort_order` int(10) unsigned NOT NULL default '1',

PRIMARY KEY (`ID`),

KEY `idx_products_id_xsell` (`products_id`) ) TYPE=MyISAM in C:\wamp\www\includes\classes\db\mysql\query_factory.php on line 101

[09-Mar-2012 17:54:02 UTC] PHP Stack trace:

[09-Mar-2012 17:54:02 UTC] PHP 1. {main}() C:\wamp\www\ADMIN\multi_xsell.php:0

[09-Mar-2012 17:54:02 UTC] PHP 2. install_multi_cross_sell() C:\wamp\www\ADMIN\multi_xsell.php:67

[09-Mar-2012 17:54:02 UTC] PHP 3. add_mxs_table() C:\wamp\www\ADMIN\includes\functions\extra_functions\multi_xsell.php:245

[09-Mar-2012 17:54:02 UTC] PHP 4. queryFactory->Execute() C:\wamp\www\ADMIN\includes\functions\extra_functions\multi_xsell.php:294

[09-Mar-2012 17:54:02 UTC] PHP 5. queryFactory->set_error() C:\wamp\www\includes\classes\db\mysql\query_factory.php:208

[09-Mar-2012 17:54:02 UTC] PHP 6. queryFactory->show_error() C:\wamp\www\includes\classes\db\mysql\query_factory.php:86

[09-Mar-2012 17:54:02 UTC] PHP 7. trigger_error() C:\wamp\www\includes\classes\db\mysql\query_factory.php:101

Found the problem.

Got it going and am in admin/catalog/multi cross sell
I have entered the 2 model numbers and haven't got the foggiest idea on what to push next. no matter which button i select it won't save the cross sell and the instructions in the how to use file are pisspoor in my opnion.
Can anybody clarify on how to save a cross sell ?
Thank you

Can have multiple Cross Sell's for different purposes ( don't see where this setting is located)
Customise each Cross Sell's Box headings to be more relevent to its purpose. ( don't see where this setting is located)

Enable and Disable each individual Cross Sell from the admin. ( don't see where this setting is located)

Quote:

---

Originally Posted by windsurfer

Found the problem.

---

And to help me and others who read this...
Was it a Multi Cross Sell problem? (so I can fix it)
or was it another issue?

Quote:

---

Originally Posted by windsurfer

Got it going and am in admin/catalog/multi cross sell
I have entered the 2 model numbers and haven't got the foggiest idea on what to push next. no matter which button i select it won't save the cross sell and the instructions in the how to use file are pisspoor in my opnion.
Can anybody clarify on how to save a cross sell ?
Thank you

---

Are you getting an error message on the top line?

The default setup is to use product ID numbers separated by commas, NOT Model numbers
Unless you changed it in Admin->Configuration->Cross Sell Settings

Yes the documentation is a mish mash of old mod documentation and new mod documentation. Documentation is not what I do well.

Quote:

---

Originally Posted by windsurfer

Can have multiple Cross Sell's for different purposes ( don't see where this setting is located)

---

Admin->Configuration->Cross Sell Settings

Quote:

---

Originally Posted by windsurfer

Customise each Cross Sell's Box headings to be more relevent to its purpose. ( don't see where this setting is located)

---

includes\languages\english\extra_definitions\YOUR_TEMPLATE\multi_xsell_box_defin es.php
You need to edit this file as required and reupload it.

Quote:

---

Originally Posted by windsurfer

Enable and Disable each individual Cross Sell from the admin. ( don't see where this setting is located)

---

Admin->Configuration->Cross Sell Settings

First i did change the setting to model number
Second, there are 2 fields that can have an entry
Product Cross Sell applies to:
Product model(s):
and

Edit Current Cross Sell
Product model:

there are also 3 buttons on the screen
Update
Insert
Search

That's it
Now when i enter a model number in the "Product Cross Sell applies to:" field with the insert button beside it

and a model number in the " Product model:" field with the search button beside it

No matter which button i select it does nopt save the cross sell and i have no idea as to how to save it.
I know the model numbers i enter are correct so i am at a loss here.
Like i said, there are no instructions on how to go about using this mod and it's certainly not self explanatory, so any help would be appreciated.
Also where are the instructions on how to edit the includes\languages\english\extra_definitions\YOUR_TEMPLATE\multi_xsell_box_defin es.php
and what do we edit ?

Quote:

---

Originally Posted by windsurfer

First i did change the setting to model number
Second, there are 2 fields that can have an entry
Product Cross Sell applies to:
Product model(s):
and

Edit Current Cross Sell
Product model:

there are also 3 buttons on the screen
Update
Insert
Search

That's it
Now when i enter a model number in the "Product Cross Sell applies to:" field with the insert button beside it

and a model number in the " Product model:" field with the search button beside it

No matter which button i select it does nopt save the cross sell and i have no idea as to how to save it.
I know the model numbers i enter are correct so i am at a loss here.
Like i said, there are no instructions on how to go about using this mod and it's certainly not self explanatory, so any help would be appreciated.
Also where are the instructions on how to edit the includes\languages\english\extra_definitions\YOUR_TEMPLATE\multi_xsell_box_defin es.php
and what do we edit ?

---

When you click either of these 3 buttons
You should get a message on the top line that is either success or error with some details of the error or results of the success
Are you getting these messages?

Assuming the entry is set to Model Number and the separater is a comma.
If you have 4 items to cross sell with Model numbers
790423 790444 790524AZ and 42786-40

You would type into the NEW cross sells box
790423,790444,790524AZ,42786-40
and press ENTER of click the INSERT button
You should then get a list of 12 success messages or some error messages at the top of the next page.

Are you receiving these messages????

you edit includes\languages\english\extra_definitions\YOUR_TEMPLATE\multi_xsell_box_defin es.php
on your computer and upload it to the correct position on your website.
This file contains a list of defines such as...

PHP Code:

---

define('TEXT_MXSELL1_PRODUCTS', 'Suggested Matching Items...');
define('TEXT_MXSELL2_PRODUCTS', 'We also Suggest...');
define('TEXT_MXSELL3_PRODUCTS', 'Suggested Cross Sell 3...');
define('TEXT_MXSELL4_PRODUCTS', 'Suggested Cross Sell 4...');
define('TEXT_MXSELL5_PRODUCTS', 'Suggested Cross Sell 5...');
define('TEXT_MXSELL6_PRODUCTS', 'Suggested Cross Sell 6...'); 


---

These are the headers that appear on the different cross sells. Edit them to what you want and upload it to your website.

Quote:

---

Originally Posted by gilby

Look in the cache directory for "error messages"?

---

there is no error info, just a warning when i try to install, it is as:


WARNING: An Error occurred, please refresh the page and try again.

I refreshed my website again and again, it is always there.

I checked my database, the old tables are there, could you give me a sql to delete the old ones, so that i could install again

Quote:

---

Originally Posted by boomup

there is no error info, just a warning when i try to install, it is as:


WARNING: An Error occurred, please refresh the page and try again.

I refreshed my website again and again, it is always there.

---

Is this a live website or is it on your computer?

Did you rename the YOUR_RENAMED_ADMIN directory to your admin name?

Did you rename the 3 YOUR_TEMPLATE directories to your template names before uploading to your website?

I deleted all table concerning multi cross sell, and re-install, the same warning info shown, and can not continue, when i change my browser to IE, there is a 500 error, no error info in cache directory

Hey gilby

i got the error info, just as following, please help me out, thanks a lot

PHP Fatal 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 'TYPE=MyISAM' at line 7 :: CREATE TABLE IF NOT EXISTS zen_products_xsell1 (
`ID` int(10) NOT NULL auto_increment,
`products_id` int(10) unsigned NOT NULL default '1',
`xsell_id` int(10) unsigned NOT NULL default '1',
`sort_order` int(10) unsigned NOT NULL default '1',
PRIMARY KEY (`ID`),
KEY `idx_products_id_xsell` (`products_id`) ) TYPE=MyISAM in /public_html/includes/classes/db/mysql/query_factory.php on line 101

Quote:

---

Originally Posted by boomup

Hey gilby

i got the error info, just as following, please help me out, thanks a lot

PHP Fatal 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 'TYPE=MyISAM' at line 7 :: CREATE TABLE IF NOT EXISTS zen_products_xsell1 (
`ID` int(10) NOT NULL auto_increment,
`products_id` int(10) unsigned NOT NULL default '1',
`xsell_id` int(10) unsigned NOT NULL default '1',
`sort_order` int(10) unsigned NOT NULL default '1',
PRIMARY KEY (`ID`),
KEY `idx_products_id_xsell` (`products_id`) ) TYPE=MyISAM in /public_html/includes/classes/db/mysql/query_factory.php on line 101

---

Edit YOUR_RENAMED_ADMIN\includes\functions\extra_functions\multi_xsell.php
Around line 294 find

PHP Code:

---

    KEY `idx_products_id_xsell` (`products_id`) ) TYPE=MyISAM"); 


---

Change to

PHP Code:

---

    KEY `idx_products_id_xsell` (`products_id`) ) ENGINE=MyISAM"); 


---

TYPE is now deprecated
and ENGINE is the correct replacement.
See if that works?

I changed mine to ENGINE and that worked

Quote:

---

Originally Posted by windsurfer

I changed mine to ENGINE and that worked

---

Thanks for confirming that worked for you.

Another bug fix to add to the next version!!!

Hey gilby

i changed it into ENGINE, and it works well now, thanks a lot

Quote:

---

Originally Posted by boomup

Hey gilby

i changed it into ENGINE, and it works well now, thanks a lot

---

2 out of 2 :P

ZC 1.5 new install
MySQL 5.0.45
PHP 5.2.12
www.bestdealcaraudio.com


Hi I am getting an error and the product info page doesn't display and it looks like it has something to do with the Multi Cross Sell Mod! Any idea what this may be I looked at the subject file and I don't see anything changed it was working fine before!
Any help or advice will be greatly appreciated
Thanks in advance



[31-Mar-2012 09:33:37] PHP Fatal 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' at line 8 :: select distinct p.products_id, p.products_image, pd.products_name
from TABLE_PRODUCTS_XSELL xp, products p, products_description pd
where xp.products_id = '137'
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 MAX_DISPLAY_XSELL in bestdealcaraudio/includes/classes/db/mysql/query_factory.php on line 101

After some more research I have resolved the problem. Thanks anyway it had nothing to do with a previous cross sell Mod installed. it was a problem with the tabbed product display
Thanks

hello - i am using version 1.03 on zen cart 1.3.9h. i need to have at least 50 seperate cross sells (we sell sets of furniture so need to have each sets products cross selling to each other) now i have made some progress in changing the default 15 cross sells, from editing line 270 in admin/includes/functions/extra_functions/multi_xsell.php and changing the maximum value in the array to 50, but the problem is that when i then go to install the cross sell mod in the cross sell admin - it will only write a maximum of 25 cross sell tables to the db - this is also the same for the configuration table.
therefore if i try to edit any cross sells above 25 it falls over :(

anyone have any ideas on how to get around this? help would be much appreciated

Quote:

---

Originally Posted by bigduffeye

hello - i am using version 1.03 on zen cart 1.3.9h. i need to have at least 50 seperate cross sells (we sell sets of furniture so need to have each sets products cross selling to each other)

---

Unless I have missed something here...
From what you have said, you ONLY need one cross sell table to do this NOT 50
Each Cross Sell Table can do thousands of different cross sells.

Having more than one table is useful if you want different header descriptions.
So... if all you want to do is have a header such as "Make a Set with this Matching Furniture"
with lots of different sets of Furniture.
Then you need only 1 table.

Quote:

---

Originally Posted by bigduffeye

now i have made some progress in changing the default 15 cross sells, from editing line 270 in admin/includes/functions/extra_functions/multi_xsell.php and changing the maximum value in the array to 50, but the problem is that when i then go to install the cross sell mod in the cross sell admin - it will only write a maximum of 25 cross sell tables to the db - this is also the same for the configuration table.
therefore if i try to edit any cross sells above 25 it falls over :(

anyone have any ideas on how to get around this? help would be much appreciated

---

If you really need 50 cross sells (and I suggest you don't as you are misunderstanding how this works)
admin/multi_xsell.php around line 90

PHP Code:

---

      if(!defined('MIN_DISPLAY_XSELL'. $counter) && ($counter <= 25)) { 
        // hard code a max of 25 so we don't crash the server 


---

You ONLY need more cross sell tables if the Header is distinctly different.
Same header, use the same table for as many "sets" as you want.

thanks gilby - i get what you are saying, but i really do need 50 different cross sell tables, each furniture set can only have items from its own specific set in the cross sell.

see here
http://www.wearebeds.com/catalog/ind...roducts_id=275
and then we need a new cross sell for a different furniture set like this
http://www.wearebeds.com/catalog/ind...roducts_id=265

but you solved my problem anyway! thanks a lot!