Just another Cross-Sell mod (support thread)

Run

DELETE FROM module_version_tracker where modules_code='ri_jaxs';

DROP TABLE IF EXISTS products_xsell;

DELETE FROM configuration where configuration_key='MIN_DISPLAY_XSELL';


DELETE FROM configuration where configuration_key='MAX_DISPLAY_XSELL';


DELETE FROM configuration where configuration_key='XSELL_DISPLAY_PRICE';

got:

1054 Unknown column 'modules_code' in 'where clause'
in:
[DELETE FROM zen_module_version_tracker where modules_code='ri_jaxs';]
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.

Quote:

---

Originally Posted by customk1

got:

1054 Unknown column 'modules_code' in 'where clause'
in:
[DELETE FROM zen_module_version_tracker where modules_code='ri_jaxs';]
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.

---

huhm, try module_code instead :d

ok, that allowed the processes to be run, however still no luck with the issue here:

Quote:

---

also, in the admin, i am seeing the option for:
advanced cross sell (x-sell) admin
and
cross sell products

but on selecting cross sell products i get a similar error:

The requested URL /catalogzen/admin/xsell.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

---

still dont have a file called catalogzen/admin/xsell.php

ALSO, just noticed i do not have any options for xsell in the zen cart admin/configuration... only in admin/catalog...

thanks for your patience working this thru.

Huhm, not a good sign

Run:

DELETE FROM module_version_tracker where module_code='ri_jaxs';

DROP TABLE IF EXISTS products_xsell;

DELETE FROM configuration where configuration_key='MIN_DISPLAY_XSELL';


DELETE FROM configuration where configuration_key='MAX_DISPLAY_XSELL';


DELETE FROM configuration where configuration_key='XSELL_DISPLAY_PRICE';

The go to the advanced xsell under catalog, the other link is just an extra which should have not been there, will remove it in later version.

ok, ran that successfully.

so, disregarding zencart admin catalog/cross-sell products...

i still dont have anything in zencart admin /configuration...

just want to make sure im understanding what i am supposed to have, and understand that correctly.

1. i should have an option in the drop down menu "configuration" within zencart admin

2. i should also have an option in the drop down menu "catalog" within zencart admin

is that right?

if so, i have #2, but not #1...

i get the feeling that the mod is probably working, as i can get different error messages when i try to put different products in the "advanced x-sell" boxes from the zen cart admin /catalog window...

but because i dont have any customizing options in the zen cart admin /configuration (not displaying).. then i cannot set the input methods to match my inputs...

hope this helps?

i am still getting this error when i try to view the x-sells, and below my product listings in the actual site:

Quote:

---

1146 Table 'customk1_zc1.zen_products_xsell' doesn't exist
in:
[select distinct p.products_id, p.products_image, pd.products_name from zen_products_xsell xp, zen_products p, zen_products_description pd where xp.products_id = '9' 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 rand() limit 6]

---

but i suspect this may simply be because i dont actually have anything in that table yet, because i havent created a x-sell... ??

keep the suggestions coming!

once you run that, and then you go to your advanced cross sell you should see it says installing patches etc.

Is there any way to get this to cross sell random products from a specific catogory, rather than having to input single product ids?

Thanks

Quote:

---

once you run that, and then you go to your advanced cross sell you should see it says installing patches etc.

---

havent seen anything like this... ???

best might be to uninstall and redo, but unsure now what files i actually need...

is the link you posted about 10 posts back the most updated file package that contains all the files needed?