Results 1 to 2 of 2

Hybrid View

  1. #1
    Join Date
    Apr 2009
    Posts
    2
    Plugin Contributions
    0

    Default Gloss Black New Products sidebox bug?

    I'm new to the forum and to Zen Cart. I've got my site 90% built, but am having a problem with the New Products sidebox. When I click the sidebox header that says, "New Products [more]" I get a blank page that says the following:

    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 '-0, 0' at line 11
    in:
    [SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status, p.master_categories_id FROM products p LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id), products_description pd WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 order by p.products_date_added DESC, pd.products_name limit -0, 0]

    I haven't modified any code; it's pretty much box-stock. Can someone shed some light on this for me? Please? Or even better, offer up some detailed instructions on how to fix it?

    The site url is: www.ezflite.net

    Thanks in advance!

    Jim

  2. #2
    Join Date
    Apr 2009
    Posts
    2
    Plugin Contributions
    0

    Default Re: Gloss Black New Products sidebox bug?

    Grrr, my apologies. Upon further investigation this doesn't look like it's a problem with the template; it happens when I have other templates installed as well.

    I'll be reposting in a different category. Mods: please delete this post.

    Sorry for the inconvenience,

    Jim

 

 

Similar Threads

  1. Changing Sidebox Font Style? - Gloss Black
    By kal in forum Addon Templates
    Replies: 0
    Last Post: 10 Dec 2008, 09:07 PM
  2. Looking for black gloss template
    By lasilhouette in forum Addon Templates
    Replies: 2
    Last Post: 12 Nov 2008, 04:51 PM
  3. New banner for gloss black template
    By jrb1512 in forum Addon Templates
    Replies: 5
    Last Post: 2 Jan 2007, 02:06 PM
  4. Gloss Black product listing Not Displaying The Products
    By trivity in forum Addon Templates
    Replies: 8
    Last Post: 23 Aug 2006, 09:53 AM
  5. Gloss Black product listing Not Displaying The Products
    By trivity in forum General Questions
    Replies: 1
    Last Post: 23 Aug 2006, 05:08 AM

Bookmarks

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
Zen-Cart, Internet Selling Services, Klamath Falls, OR