Column Layout Grid for Product Listing

dropbop:

Did you copy the files to your template folders?

Try double checking that you changed the names of the YOUR_TEMPLATE folders to the actual name of your template folders (includes/templates/yourtemplate). Its probably the most common mistake.

Another thing you could check is that you installed the SQL statement correctly, if at all.

If none of those are the problem, you may need to ask your website designer about it, they may have used some custom code that could be stopping it from working properly.

Hope that helps,

DB

umm im not sure if i could do this. i dont want to screw up my files, not even gonna think about SQL.
isnt there other way?
and i didnt use webmasters i did it all myself. are u actually reffering to my post?:lookaroun

dessau77:

umm im not sure if i could do this. i dont want to screw up my files, not even gonna think about SQL.
isnt there other way?
and i didnt use webmasters i did it all myself. are u actually reffering to my post?:lookaroun

Sorry, was late late when I was posting and was half asleep.

For the mod to work properly you need to install the SQL statement supplied with the mod. This will add the new bits to the database which will put the settings in the Admin.

What I meant by Website Designer, I was actually supposed to say Template designer. :S

I´m also trying t install this addon but without success. I´m using v1.3.9d but I hoped this contribution would work anyway.

My problem is that I can´t run the sql statement and the answer to that problem on page 4 in this thread didn´t help me.

Is there any solution to this?

Does this work correctly with 1.3.9e?

Any problems??

Hi,

Im trying to get this running on my site. Works ok on the default template but with template Im using the products still appear in one row (although it does change the format of the page to one narrow column rather than one wide column)

Any ideas?

v 1.3.9e
Template zenfalvour 7b
Image handler2

Cheers,
Andy

Ok Found the problem was a spelling error in one of the folders I had created.
:huh:

I have this error on every product pages of my categories link. I tried install the add on it worker well with my 1st template. I uploaded a new template an error came up. I tried reintsalling zen cart and even the template, same error every time.

I'm using zc 1.3.8a / php v 5.2.9..

Error Message>>

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 = '1' order by p.products_sort_order, pd.products_name limit -0, 0]

I'm really stuck on this for days.. PLEASE HELPP!!!! :(

alekt:

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

alekt:

no nothing appears to be set at 0

A

Hi alekt, did you manage to fix the problem? I'm having the same problem. Hope u cud share the solution.

Thks!

Have installed this on 1.3.9E and works fine.

http://christmas.yorkshiregardencentre.co.uk/index.php?main_page=index&cPath=23

Greg:clap:

mooki:

Hi alekt, did you manage to fix the problem? I'm having the same problem. Hope u cud share the solution.

Thks!

no:no::no::no:

ZC 1.3.8a with column layout grid and single listing template.

After I installed these two mods, the listings, New, Featured and Specials have disappeared from my main page twice within the last couple of weeks and will magically reappear.
Other than adding new products, no changes are made to the listings or the mod settings handling them when this occurs, .

Has any one seen behavior when using both of these mods together?
http://minu.me/2sm4

NEVERMIND!
It's September and the last time this happened was after being moved to a new server. It's all about time.

DUH!

PinkLeopard:

Does this work correctly with 1.3.9e?

Any problems??

Answer my own question...works like a charm.

OK I give up. Someone please help. Ive read all 14 pages and can't solve my problem.

Website https://www.herbschina.com using 1.3.8a.

I installed the column/grid layout module . Installed the file for the module dir (created new in my custom folder) no problem.

Installed the file for the template dir (in my custom folder) no problem.
Did the sql cut and paste/submit routine and no error message.

Result is 1 COLUMN ONLY. centered and loOks great. BUT ADMIN IS SET FOR COLUMN LAYOUT 3 COLUMNS. I TRIED 2 AND 4 COLUMNS WITH THE SAME RESULT.

I reinstalled the mod from scratch several times and still the same.

What is my problem???????????

You are getting the grid layout for the individual products, but also the headings for the row layout. This means that one of the mod files is not in the correct folder. What are the exact paths to both files?

Thanks for the quick reply. Files are as follows.

product_listing.php is in /public_html/zen/includes/modules/Custom-green shade

tpl_modules_product_listing.php /public_html/zen/includes/templates/Custom -green shade/templates

gjh42, r u there?

Can u help, please?

Are your custom folders named /Custom-green shade/ or /Custom -green shade/? Either way, spaces in file/folder names can cause problems in many programs. It is a standard web recommendation to use only lowercase letters, numbers, and perhaps _ or - in file/foldernames.

Thanks. I think best is to uninstall the Mod including the sql and then download a fresh copy and start from scratch.

i started from scratch and it worked.

Now one final question. How can I put in a horizontal line between rows or a box around each product???