Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

XSell Cross Sell SQL error - help


steffanih

Recommended Posts

Hello,

I am receiving this error on my product info page after installing the latest release of XSell - Cross Sell and not finding much information on how to resolve it. Any ideas?

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_PRODUCTS' at line 1

select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price from products_xsell xp, products p, products_description pd where p.products_id not in(33) and xp.products_id = '215' 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(15818) DESC limit MAX_DISPLAY_XSELL_PRODUCTS

[TEP STOP]

Thanks!

Link to comment
Share on other sites

You need add the MAX_DISPLAY_XSELL_PRODUCTS variable into configures table

 

Try the following sql:

 

insert into `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) values('Cross Sell Products','MAX_DISPLAY_XSELL_PRODUCTS','6','Maximum number of cross sell products to display in products page','3','15',NULL,'2009-05-20 20:10:05',NULL,NULL);

Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here!

8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself.

Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues.

Any issues with oscommerce, I am here to help you.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...