Jump to content

digita1bob

Members
  • Content count

    43
  • Joined

  • Last visited

1 Follower

Profile Information

  1. digita1bob

    [Contribution Update] All Prods v2.4

    Ok, I love the AllProds contribution, but has anyone figured out a way to eliminate duplicate entries on the allprods.php page for items that are categorized in more than one category? For instance, we might have the same book listed in the "Gift Books" and the "Children's Books" categories. Unfortunately, allprods.php lists the book twice. So our list is about three times the length that it should be due to duplicate and triplicate entries. I'm sure the change is a minor one, but I'm as clueless as they come. Any suggestions is appreciated. Bob
  2. digita1bob

    [Contribution Update] All Prods v2.4

    Well Farrukh, all I can say is "Wow!" OK, that's not true, I can also say "Thanks!" I do really appreciate your taking the effort to accomodate my trivial request. It was very kind of you. Thanks again, Bob
  3. digita1bob

    [Contribution Update] All Prods v2.4

    Thanks for taking the time to modify the contribution for me. Seriously, I wasn't expecting such incredible service. The open source community continues to amaze me. With that said, I'm getting the following error when I try and run the new version of allprods (the one with manufacturers but not model numbers): 1054 - Unknown column 'c.categories_status' in 'where clause' select p.products_id, p.products_model ,pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from products p , categories c, products_to_categories p2c left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id where c.categories_status=1 and p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and products_status = '1' order by p.products_date_added DESC, pd.products_name [TEP STOP] Any help is appreciated. Thanks again, Bob
  4. digita1bob

    [Contribution Update] All Prods v2.4

    Is it a really tricky mod to change the All Products display page to list the Manufacturer instead of the Model number? The reason I ask is my store is a bookstore and we're using the manufacturer field for the author. I'd rather the search engines list the names of the books and the authors rather than the book names and ISBN's. As always, any and all help is greatly appreciated. Regards, Bob
  5. digita1bob

    [Contribution Update] All Prods v2.4

    DOH! :shock: I'm a loser baby, so why don't you kill me.... I thought that I had, but if I did it disappeared. Yeah, that's it.... it disappeared. Anyway, thanks Mike. That did the trick. Have a great holiday weekend. Thanks again! Bob
  6. digita1bob

    [Contribution Update] All Prods v2.4

    I added that line to filenames.php and now get the following errors (similar but a little different): Warning: main(includes/languages/english/allprods.php): failed to open stream: No such file or directory in /usr/local/etc/httpd/htdocs/catalog/allprods.php on line 15 Warning: main(): Failed opening 'includes/languages/english/allprods.php' for inclusion (include_path='') in /usr/local/etc/httpd/htdocs/catalog/allprods.php on line 15 HELPPPPP!!! bob
  7. digita1bob

    [Contribution Update] All Prods v2.4

    I just finished installing All Products 2.4 and get the following errors at the top of catalog/allprods.php Warning: main(includes/languages/english/FILENAME_ALLPRODS): failed to open stream: No such file or directory in /usr/local/etc/httpd/htdocs/catalog/allprods.php on line 15 Warning: main(): Failed opening 'includes/languages/english/FILENAME_ALLPRODS' for inclusion (include_path='') in /usr/local/etc/httpd/htdocs/catalog/allprods.php on line 15 Any suggestions?? Thanks, Bob
×