Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    36
    Plugin Contributions
    1

    help question Advanced Search Plus

    I have looked and tried to find the answer to this. But, I can't. I want to allow my customers to search just by the price. But, if they do, they get the following 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 'order by e.toc_chapter, e.toc_sort_order, e.pages_title' at line 1
    in:
    [SELECT * from ezpages e where order by e.toc_chapter, e.toc_sort_order, e.pages_title]

    Does anyone have any idea how to fix this?

  2. #2
    Join Date
    Jan 2009
    Location
    Charlottesville, VA
    Posts
    51
    Plugin Contributions
    0

    Default Re: Advanced Search Plus

    Have you modified the module? I just tried searching for a price 0n my site and I found products that matched.

    Frank

 

 

Similar Threads

  1. v151 Advanced Search Plus
    By twitchtoo in forum All Other Contributions/Addons
    Replies: 21
    Last Post: 4 Oct 2017, 01:13 AM
  2. Advanced Search Plus Error
    By newbie456 in forum All Other Contributions/Addons
    Replies: 10
    Last Post: 15 Nov 2013, 12:04 AM
  3. Advanced Search Plus - Infinite Redirect
    By hey_you in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 27 Jul 2010, 02:57 PM
  4. Need help on Advanced Search Plus
    By neal99 in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 25 Feb 2010, 03:25 PM
  5. A fix to Advanced Search Plus results?
    By FrankDeRosa in forum All Other Contributions/Addons
    Replies: 9
    Last Post: 28 Dec 2009, 11:04 AM

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