Results 1 to 3 of 3
  1. #1
    Join Date
    May 2011
    Location
    Harrogate, UK
    Posts
    33
    Plugin Contributions
    0

    Default Ultimate Cross Sell Error

    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)]

  2. #2
    Join Date
    Jun 2008
    Location
    Osprey, Florida
    Posts
    151
    Plugin Contributions
    14

    Default Re: Ultimate Cross Sell Error

    It would help if you do a little research in order to find answers to your questions. Creating new threads for issues that are already addressed is frown upon.

    The thread for Ultimate Cross Sell for Zen Cart is located here. Your exact problem has been addressed and answered before. Click here for Post #2 and Post #4 of the Ultimate Cross Sell thread for the question and the answer respectively.

  3. #3
    Join Date
    May 2011
    Location
    Harrogate, UK
    Posts
    33
    Plugin Contributions
    0

    Default Re: Ultimate Cross Sell Error

    Managed to sort it out. Checked the changes made to the files as instructed and noticed I somehow had doubled up the change. Removed the repeat and hey presto worked.

 

 

Similar Threads

  1. Which one? Multi Cross Sell vs Ultimate Cross Sell?
    By Renz in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 3 Jul 2013, 08:30 AM
  2. v139h Ultimate Cross Sell Scalability
    By chuckd in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 1 May 2012, 10:41 PM
  3. Ultimate cross sell problem
    By SethF in forum Addon Templates
    Replies: 5
    Last Post: 25 Oct 2011, 01:42 PM
  4. Ultimate Cross Sell Database Error Question
    By ShorelineCedar in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 23 Oct 2011, 06:52 AM
  5. Fatal Error After installing Cross Sell - Just Another Cross Sell Mod
    By kconklin in forum All Other Contributions/Addons
    Replies: 7
    Last Post: 9 Jul 2010, 02:38 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR