Results 1 to 10 of 12

Threaded View

  1. #1

    Default help - in admin > orders > Search by Product Name or ID:XX or Model > jumbo mumbo

    when I search:
    in admin > orders > Search by Product Name or ID:XX or Model


    I search for a 4317943:

    1054 Unknown column 'o.orders_id' in 'on clause'
    in:
    [select count(distinct o.orders_id) as total from (zen_orders o, zen_orders_status s left join zen_orders_products op on (op.orders_id = o.orders_id) ) left join zen_orders_total ot on (o.orders_id = ot.orders_id) where (o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total') and (op.products_model like '%4317943%' or op.products_name like '4317943%')]
    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.
    Last edited by keylesslocks; 5 Sep 2008 at 09:31 PM. Reason: change notification
    MonkFunk Music Community
    Free Music Website

 

 

Similar Threads

  1. Search box in Admin not searching in product name?
    By rudyh01 in forum Basic Configuration
    Replies: 6
    Last Post: 13 Dec 2011, 03:47 PM
  2. Can't find a way to search by Model in Advanced Search - could somebody help please?
    By Athens Collectibles in forum Templates, Stylesheets, Page Layout
    Replies: 3
    Last Post: 11 Sep 2011, 12:14 PM
  3. Replies: 1
    Last Post: 26 Jun 2010, 02:41 PM
  4. Search box not searching capitalized product name/model number
    By saitomedia in forum General Questions
    Replies: 2
    Last Post: 10 Feb 2010, 08:01 AM
  5. Can't search product name / model in order box.
    By kimsonvu in forum General Questions
    Replies: 1
    Last Post: 26 Aug 2008, 09:13 PM

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