Column Layout Grid for Product Listing

Help
I have just installed this mod column grid layout on my shop
I am running 1.38a
no upgrades
no add ons

I am getting this message whenver i try to swicth it on

the below is displayed instead of product listing


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 7
in:
[select p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.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 p2c.categories_id = '65' order by p.products_sort_order, pd.products_name limit -0, 0]



:unsure:

A

Check in the Configuration ... Maximum Values ... do you have something set to 0 or something related to this add on set to 0? :unsure:

no nothing appears to be set at 0

A

I'm having trouble with this one. Installed okay and finally got it listed but it only shows 3 across even when I have more product than that, same thing with subcategory, not all products showing.

I'm running 1.38, this mod, image handler and dg reviews. My site is jaceriisland.com

TIA,
Patty

Fixed it by reinstalling the product listing.

Patty

I tried to add on the column layout, it's work!! Thanks for providing a easy add-on module.

BTW, I am trying to change the details alignment. The current version is :
"Image" <br> "price" <br><br> "..more info" <br><br> "product's name"

I would like change them to :

"Image" <br> "product's name"<br> "price" <br> "..more info" (it's good if this one can be image)

Any idea where to change the layout?

Admin > Configuration > Product Listing > give desired sort orders to the elements.

Hi, I still have the same problem re: the 3 column grid. Patty, could you (or anyone else) kindly expand on the meaning here of 'reinstalling' the product listing. Does this mean just uploading? - as we have done that but we still have the error. Thanks.

Quote:

---

Originally Posted by fashion2

How do I add the product listing in columns to my configuration/product listing? I've downloaded the "column layout grid for Product Listing" (I believe that would be the needed additional add-on) but now I'm stuck. I'd like to list my products so they are displayed as 3-4 images next to each other with the title in small font below.

I'm using zen cart 1.3.8a, the zen template "lavender". My URL is http://fashionfoot.net

Thanks for any help you can give me
FashionFoot

---

The original question in this post was solved by this person saying "Oh, nevermind! I fixed it!"
But I'm having the same issue and I can't find the solution to this, and they didn't say how they fixed it (thanks).

I'm sorry I'm a newbie and I'm not sure, first off, where exactly to install the files (what php directory). I installed them but when i go into Config>Product Listing, there is no "Layout Settings" option, so I can't change it to the grid view.

Can someone please help me with this? I'm putting up new products that really require them to be in a grid view instead of in big long rows.
:(

My site address is:
http://www.rocksterize.com/rkstrstore

I'm w/ rocksterize on this...

I've installed the add-on files to the correct places (....store/includes/modules/custom & ...store/includes/templates/custom/templates) & added the SQL file and nothing has changed. :dontgetit

I'm using Zen Cart 1.3.8a (Windows server).
My URL: http://www.kidsteamspirit.com/store/...ex&cPath=65_69

Please help :smile: It would be GREATLY appreciated from this newbie.