Full service web hosting, great prices and support. Starts at $1.99/month!
Results 1 to 4 of 4

Thread: Search no longer working (Details inside)

  1. #1

    Default Search no longer working (Details inside)


    I have been working on our OSCMAX site for a while now, only inputting the products for the moment.
    Today I added more products and used the search feature to check I had set them up right. I preformed a search on the site which brough back results, but when i click a product it says "page cannot be displayed".
    It worked fine up until today. Any ideas???

    Logs are clean both on apache and oscmax. No errors, nothing.

    Windows XP PRO SP1, Apache 2, MySQL 4.1, PHP 5 (i think).

    You can view our site at http://ink4u.no-ip.org
    This is a temp address for development only.

    Thank you

  2. #2

    Default RE: Search no longer working (Details inside)

    Works for me.....

  3. #3

    Default RE: Search no longer working (Details inside)

    My admin search (catalog) is experiencing an out of memory error, but my storefront search is working fine. This was working better when I was using a stock osCommerce.

    Here's the message:
    Warning: mysql_query(): Unable to save result set in [my path omitted]/admin/includes/functions/database.php on line 45
    2008 - MySQL client ran out of memory
    select p.products_ship_price, p.products_id, p.products_model, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p2c.categories_id from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and pd.products_name like '%chrome%' or p.products_model like '%chrome%' order by pd.products_name
    I'm wide open to suggestions.

  4. #4

    Default RE: Search no longer working (Details inside)

    Running this same sql in phpmyadmin takes bloody forever but it succeeds.

Similar Threads

  1. Forum Search not working well
    By kenlyle in forum osCMax v2 Features Discussion
    Replies: 5
    Last Post: 08-05-2006, 12:34 PM
  2. Customers Orders no longer show
    By heaven in forum osCmax v2 Installation issues
    Replies: 3
    Last Post: 12-21-2005, 03:37 PM
    By EddyXP in forum osCmax v1.7 Discussion
    Replies: 1
    Last Post: 07-30-2004, 02:47 PM
  4. Longer Product Name
    By jhixson in forum osCmax v1.7 Discussion
    Replies: 4
    Last Post: 03-08-2004, 10:52 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