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

Thread: Help with printable catalog

  1. #1

    Default Help with printable catalog

    i am using osc max 2, when i click on the printable catalog i get an 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 '-10, 10' at line 1
    select distinct p.products_id, p.products_image, p.products_model, p.products_quantity, p.products_weight, pd.products_name, p.manufacturers_id, p.products_price, p.products_date_added, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, m.manufacturers_name, pd.products_description, cd.categories_name, p.products_tax_class_id, p2c.categories_id from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join categories_description cd on p2c.categories_id = cd.categories_id left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and cd.language_id = '1' order by p.products_price DESC, pd.products_name LIMIT -10, 10
    [TEP STOP]
    Can anyone help please....

  2. #2

    Default RE: Help with printable catalog

    Do you have any product setup? I think I got this or simular error cause of this....

  3. #3


    Yes, i have about 60 products in the store, everything else is working, this is very puzzling....

Similar Threads

  1. Help With Printable Catalog
    By Makrin in forum osCmax v2 Customization/Mods
    Replies: 1
    Last Post: 08-25-2005, 12:00 PM
  2. printable catalog template
    By Anonymous in forum osCmax v1.7 Discussion
    Replies: 3
    Last Post: 01-11-2005, 12:53 PM
  3. Printable Catalog Bug?
    By warrenthewindmill in forum osCmax v1.7 Discussion
    Replies: 4
    Last Post: 11-16-2003, 09:22 AM
  4. Need help with printable catalog
    By crujones in forum osCmax v1.7 Discussion
    Replies: 1
    Last Post: 09-13-2003, 09:37 PM
  5. Printable Catalog HELP!!
    By Arpit in forum osCommerce 2.2 Modification Help
    Replies: 2
    Last Post: 06-03-2003, 04:56 AM



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts