Hi all. New Zen user and a little confused. I'm not computer stupid but am not familiar with PHP or CSS. As a result, I'm a little slow!

I've just installed the Column Layout / Grid Layout for Products Listing (Add On Module for Zen Cart v1.3.8) and have followed the install instructions. Other add-ons have installed OK but this one is giving the following error when I try to view the product listings...

Fatal error: Call to undefined function: zen_get_generated_category_path_rev() in /homepages/16/d189229113/htdocs/eshop/zen-cart/includes/modules/magic/product_listing.php on line 209

I think it's something to do with my directories but can't understand where. Anyone got any ideas???

My site is www/ns-a.co.uk/eshop/zen-cart/ and isn't public yet..

Many thanks

I think you installed the wrong version of grid/column layout. Look at the admin (admin/tools/server/version info) area and find out what version cart you are using.

I'm using Version 1.3.7.1. The install guide states that it is OK for anything after 1.3.5 unless I'm being daft....

Which version of Column / Grid Layout are you using?

I'm using the latest version from the downloads section. It reads...

Column Layout / Grid Layout for Products Listing (Add On Module for Zen Cart v1.3.8)

NOTE: This module is updated for Zen Cart 1.3.8, therefore for older version of Zen Cart (prior to v1.3.5) you must still use the earlier version of the module. This module and instructions are exclusive to new version of Zen Cart. This will work both for upgrades as well as for fresh installs.

It may be that the above instruction is a type and should state (prior to V1.3.7).

I've not run an upgrade yet and assume it isn't too tricky. Would this be the way to go...?

Yes, That's an incorrect statement. It should say that it is ONLY compatible with 1.3.8 (a)

You should only need to edit or replace your includes/modules/product_listing.php

(Or includes/modules/yourtemplate/product_listing.php)
depending... of course.

OK.

I think I follow except...

When I remove the revised includes/modules/yourtemplate/product_listing.php file that I installed, everything goes back to normal.

Does this measn that I need to upgrate or have I failed to follow you...

Sorry to be so slow but this is really confusing...

You need to install this contribution:
http://www.zen-cart.com/index.php?main_page=download_contrib&contrib_id=77&update_id=4

Not the one you have.

It looks like you only need to replace/modify the includes/modules/yourtemplate/product_listing.php with the one in the correct contributtion (above)

You are a star - I'll watch out next time on the old version info and never assume new add-ons are backwards compatible.

Works as it should now.

As a final thought, is there a resource page that can be viewed anywhere in the downloads section that shows earlier versions of the add-ons (like the one you sent me...)

Anyway, thanks again

Your version is not so old that you need to look in the older contributions, Just be sure to read which version you are downloading on the specific contribution page. With that said, there is an archived list - just in case -
http://www.zen-cart.com/archived_contributions

I have made a newbie mistake, I didn't backup my db before running the sql that came with the version i had downloaded, now i see i ran the wrong one! I'm getting a syntax error on the SQL I'm running which came with the release:

in('PRODUCT_LISTING_LAYOUT_STYLE','PRODUCT_LISTING_COLUMNS_PER_ROW');

INSERT INTO configuration (configuration_title, configuration_key, configuration_value,
configuration_description, configuration_group_id, sort_order,
last_modified, date_added, use_function, set_function)
VALUES ('Product Listing - Layout Style', 'PRODUCT_LISTING_LAYOUT_STYLE', 'rows',
'Select the layout style:<br />Each product can be listed in its own row (rows option)
or products can be listed in multiple columns per row (columns option)', '8', '40', NULL,
now(), NULL, 'zen_cfg_select_option(array("rows", "columns"),');

INSERT INTO configuration (configuration_title, configuration_key, configuration_value,
configuration_description, configuration_group_id, sort_order,
last_modified, date_added, use_function, set_function)
VALUES ('Product Listing - Columns Per Row', 'PRODUCT_LISTING_COLUMNS_PER_ROW', '3',
'Select the number of columns of products to show in each row in the product listing.
The default setting is 3.', '8', '41', NULL, now(), NULL, NULL);

Now when I go to my products I get a blank page

This is the error I get:

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 'in('PRODUCT_LISTING_LAYOUT_STYLE','PRODUCT_LISTING_COLUMNS_PER_ROW')' at line 1
in:
[in('PRODUCT_LISTING_LAYOUT_STYLE','PRODUCT_LISTING_COLUMNS_PER_ROW');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I am also getting an error when I come to this step in the directions:

Set the following settings:

A. Product Listing - Layout Style
Set the type of layout you want to use. By default, the current Zen Cart layout will be used.
It is called "rows". If you want to use the column and row layout, choose "columns".

The error is as follows:

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

'-0, 0'

It soulds like you have some admin setting at 0 in Configuration > Maximum Values. This can trigger an obscure bug, which has been discussed recently. Known Bugs (and fixes) with v1.3.8, post 34.

gjh42:

'-0, 0'

It soulds like you have some admin setting at 0 in Configuration > Maximum Values. This can trigger an obscure bug, which has been discussed recently. Known Bugs (and fixes) with v1.3.8, post 34.

Thanks, that lead me to my solution:

Configuration > Maximum Values > Products Listing- Number Per Page was conflicting.

Explained:

The default Configuration > Product Listing - Columns Per Row is 3, but I had changed it to 4.

The default for Configuration > Maximum Values > Products Listing- Number Per Page is also 3. When changed to 4 the error disappeared.

Thank you. I'll post in the Know Bugs thread as well.

Hi, This is a new Install of 1.3.8 with Column Layout / Grid Layout

I only installed a few items in my store, but they are only being displayed in 1 column. I have the settings to display in the standard 3 columns, but I must have missed something.

any guesses?

mtcoffinz.com/shop

Thanks

Well, if anyone else had this type of issue, check to make sure that you changed ALL of the "Your_Template" folders to your custom template name.

That fixed it for me because I apparently missed one!

I got the same issue as urs, but not the same solution i think!

I am also getting one colum...

http://trendyhandbags.co.uk/leather-c-40.html

Any ideas?

CiriusRizk:

Well, if anyone else had this type of issue, check to make sure that you changed ALL of the "Your_Template" folders to your custom template name.

That fixed it for me because I apparently missed one!

You are getting the table heading output for the stock "rows" layout:

Product Image
Item Name-
Price

which should not appear if you are using the Column Grid files.
Did you double check that all of the mod files are in the correct places, and that they are actually full files and not empty shells?