Column Layout Grid for Product Listing for 1.3.7

I've been using this for awhile, but just swtiched to a new tempalte.. I uploaded the two new files, but didn't run the SQL code.. I now get this:

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 zen_products_description pd, zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_to_categories p2c left join zen_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 = '54' order by p.products_sort_order, pd.products_name limit -0, 0]

I'm running 1.3.8a.. Any help would be appreciated.

Thanks
David

Opps.. I had the wrong version... Fixed.

But I'd really like to be able to incrase the space just a little between items, both items to the side, and below.. ??

Thanks
David

http://straightrazordesigns.com/index.php?main_page=index&cPath=9

How, oh how can you center the text? I've looked for the css everywhere, but can't find it.

Thanks
David

digidiva-kathy:

I have used this mod several times and love it, but do have one request from a client that I can't seem to figure out. She wants to remove the extra space from between the item name, price, etc... It looks like line breaks to me, but I can't seem to find where they're coming from. Any help is appreciated.

Did you figure this out? I'm not using the 'description' field, and I can see in view source that two line breaks <br/> are being inserted after the name before the price. It's pushing my info too far down, and I don't see where they're coming from either.

I'm still at a loss, and very open to suggestions.

Thanks
David

dwessell:

http://straightrazordesigns.com/index.php?main_page=index&cPath=9

How, oh how can you center the text? I've looked for the css everywhere, but can't find it.

Thanks
David

dwessell:

I'm still at a loss, and very open to suggestions.

Thanks
David

Look for this in your style sheet .centerBoxContentsProducts if you cant find it add it like this .centerBoxContentsProducts {text-align:center}

I am having an issue with this mod on my hompeage for new products, i use to have a button that said details for each new product and after installing this i noticed it had dissapeared (the button) does anyone know how i can get them back?
Link: https://www.truwater.com.au
Version: 1.3.8a

gee38l:

Look for this in your style sheet .centerBoxContentsProducts if you cant find it add it like this .centerBoxContentsProducts {text-align:center}

Awesome! Thanks!

i need help in new product listing stuff is perfect when i go to diff Categories my products are all over the place in fire fox i have searched and searched cant seem to find what im doing wrong if anyone could please let me know or give me more info that would be great thanks in advance and site too see prob is https://www.kustom-decals.com

I'm having a problem with long Product Names overlapping each other and extending the width of the divs around the products.

Note this is an adult themed site...but there are not yet pictures up.

WEBSITE

My items are not evenly listed click here to see Not sure what it can be ?

Good morning folks.

I'm having a strange issue with this mod.

I've installed it, and it works beautifully--I love it!

BUT: now in empty categories, my page selector which would typically not show up (e.g. [<< Prev] 1 2 [Next >>]), now shows as: -4 -3 -2 -1 0

WTF did I do!?

:oops:

I am ripping my hair out!

I have this installed just fine and working but the Price shows ABOVE the product name... I dont get it... shouldnt it be below?

fixed... show product name needs to be set to 2 in the admin.

Noella:

Also, Is it possible to link to the large image (when product is clicked) instead of to the individual product listing page?

This is something I'm also wondering.

in the file product_listing.php line 241,

class="centerBoxContentsProducts centeredContent back"

could anyone explain why it has three class? and I could not find "centerBoxContentsProducts" in any of the style sheet file.

thanks.

The product_listing.php file has changed. This mod needs to be updated for 1.3.9f.

BlessIsaacola:

The product_listing.php file has changed. This mod needs to be updated for 1.3.9f.

When I installed this on 1.3.9g it did not work via the admin panel. Specifically, I was not able to change rows to columns. I am able to edit it via the database however, and once I did that the module seemed to work fine.