Column / Grid Layout Problem

[ThePatch]

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

[ThePatch]

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.

[jdyach]

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]

[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.

[jdyach]

'-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.

[CiriusRizk]

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

[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!

[seorank]

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?

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!

[gjh42]

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?