Jump to content

Reysolboy

Members
  • Content count

    4
  • Joined

  • Last visited

About Reysolboy

  • Birthday 03/04/1982

Profile Information

  • Real Name
    Daniel Cabrera
  • Website
  1. Reysolboy

    "Dynamenu" for osCommerce

    It's ok I fixed the error with the help of a friend. You have to substitute in featured.php the SQL command for this one other (originally line 35): $featured_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c," . TABLE_PRODUCTS . " p left outer join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left outer join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . $featured_products_category_id . "' and p.products_status = '1' and f.status = '1' order by rand() DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS);
  2. Reysolboy

    "Dynamenu" for osCommerce

    Hi again, i posted a doubt just some lines above, and well if anyone could check in their dynamenu if they have the same error than me, please tell me. Just knowing if someone else has the same error than me would be useful. Like that, I'd know that I did something wrong. Thank you :)
  3. Reysolboy

    "Dynamenu" for osCommerce

    Hi, first of all thank you for this contribution, it is really useful!! But I am having some problems, I don't know if the other dynamenu users have the same problem. Using an horizontal menu in the header, when I pass the mouse over the categories, the drop down menu works fine. When I click in the subcategories shown in the drop down menu, it works. But when I click in the main category, it shows me this error : Maybe I didn't install it correctly, maybe I missed something ... I don't know. I spent a lot of time trying to fix it but I really can't guess why the DB gives this error. Does anybody have the same problem? If so, somebody has a solution? Thanks in advance :)
×