Using one single listing template

[ekele]

Hello,
I am trying to install this module but I am getting an error;
"1062 Duplicate entry 'INDEX_NEW_USE_PRODUCT_LISTING' for key 2
in:
[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 ('New Listing Template', 'INDEX_NEW_USE_PRODUCT_LISTING', '1', 'Set to 1 to use the original listing templates, 2 to use the new index_listing template, 3 to use the Product Listing template.', 24, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''1'', ''2'', ''3''),'), ('Featured Listing Template', 'INDEX_FEATURED_USE_PRODUCT_LISTING', '1', 'Set to 1 to use the original listing templates, 2 to use the new index_listing template, 3 to use the Product Listing template.', 24, 2, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''1'', ''2'', ''3''),'), ('Special Listing Template', 'INDEX_SPECIAL_USE_PRODUCT_LISTING', '1', 'Set to 1 to use the original listing templates, 2 to use the new index_listing template, 3 to use the Product Listing template.', 24, 3, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''1'', ''2'', ''3''),'), ('Template Debugging', 'TEMPLATE_DEBUG', 'False', 'Display the template filenames where used', 24, 4, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''False'', ''True''),');]
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 have no idea how to repair it or what to do to install this module... Please, any help!

[jackie.taferner]

ekele,

Looks like maybe you ran the SQL twice - go check to see if the Single Listing options are now in the configuration. If they already are, go ahead and change your settings and it probably already works!

[ekele]

Well, I don't think it works. I don't have "Template debugging" in Index Listing.
I just don't know how to achive that. I am afraid to mess my database because I simply know nothing about fixing it

[jackie.taferner]

Ok, Do you have the following options listed there?

New Listing Template
Featured Listing Template
Special Listing Template

[ekele]

No, I don't.

[jackie.taferner]

Hmm, you'll probably need to get into the database in phpmyadmin then, and search for the INDEX_NEW_USE_PRODUCT_LISTING and see why it's already there - perhaps it was part of a previous add-on?

Once you've confirmed its origin, you can decide if it's ok to override it, and manually change the database using the sql install code as a guide.

If you're not comfortable with modifying the database, you may want to have a developer do it for you (check the commercial section of the forum).

The other option, is to restore your site to the way it was before, then modify the template files yourself to achieve the look you want.

You did backup your database before attempting an install, yes?

[ekele]

I have checked my shop, not my test site where I installed this module. So yes, I have: New Listing Template
Featured Listing Template
Special Listing Template
I don't have Template Debuggin.

Sorry!

[jackie.taferner]

Oh, that's good news! Well, 3 out of 4 ain't bad. Maybe debugging is hidden somewhere else in the list (they don't always group together as you expect).

Go ahead and set the templates to match, check the front of your store and you should be good to go!

[ekele]

i have just installed STL in my real shop and everything is OK! So you are right, it must have been something I installed before. Well, I think I panicked
just one more question: have you tried to install Column Divider Pro? I think it will look better.
Thank you for your help

[jackie.taferner]

Glad to hear it's working. I have not used Column Divider Pro, but if you're looking to layout your categories in column/grid format, i think that's already included with the STL module.

Just run the SQL in column_layout_grid.sql, then go to configuration > product listing. You'll see an option for "Product Listing -Layout Style" and choose row/column