1062 Duplicate entry 'SHOW_PRODUCT_INFO_CONDITION' installing numinix product fields

[Xbox Memberships]

ok so i uploaded all the files using ftp and went to install the .sql file and got the following error message....

1062 Duplicate entry 'SHOW_PRODUCT_INFO_CONDITION' for key 2
in:
[INSERT INTO zen_product_type_layout (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, product_type_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Show Condition', 'SHOW_PRODUCT_INFO_CONDITION', '0', 'Show product condition on product info page (requires Numinix Product Fields)?', 1, 17, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'1\', \'0\'),');]
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.

any ideas?

[Xbox Memberships]

can anyone help me?

[heteromorphic]

I got the same error - does anyone know the fix?
heteromorphic.com

[DrByte]

1062 Duplicate entry 'SHOW_PRODUCT_INFO_CONDITION' ...

It means that setting is already in your database, and doesn't need to be re-added.

So, if you don't mind losing whatever that addon installed initially, run its uninstall so it can remove everything it ever added, and then re-run the install to set it up afresh again.

Of course, always backup your database before running any sql scripts on it. And always test on a TEST COPY of your site first, never on your live site directly.

[heteromorphic]

Thanks! Just in case that file came from another mod; is there any way to "remove" from the scipt to get the rest to run by chance? Just needed to ask - sql clueless newbie :)
If not, any way to find out if another mod is "using" that already?

Thanks!

[DrByte]

If you have enough SQL knowledge, you could comment-out, or just delete the SQL statements that have already been run, and thereby only run the statements after those ones. You might need to do that repeatedly.
But since you're having problems with a mod written by an author who supports his stuff on another website, you're probably better off asking him directly, since he has much more specialized knowledge about it than people like me who don't even use the mod.

As for finding out if a constant such as SHOW_PRODUCT_INFO_CONDITION is used anyplace else, you could use the Developers Toolkit to do a search for it, using the "search ALL files" option at the bottom of the list of search choices.

[Kevin205]

I installed Numinix_Product_Fields. The second description does not appear in the Product info page!

I have added:

<!-- bof Product description 2 -->
<?php if ($products_description2 != '') { ?>
<div id="productDescription2" class="productGeneral biggerText"><?php echo stripslashes($products_description2); ?></div>
<br class="clearBoth" />
<?php } ?>
<!-- eof Product description 2 -->

to
tpl_product_info_display.php


I have also set the following in Product Type Info Page Layout options :: Product - General


Any ideas why Second description is not showing up.

ps. I do see the products_description2 field in the products_description table

[DrByte]

Numinix supports their plugins at www.numinix.com

[RodG]

Any ideas why Second description is not showing up.

Apparently you are missing some code.

Somewhere in the php file there will/should be code that reads the data from....
products_description2 field in the products_description table

...and assigns it to the variable named "$products_description2"

Cheers
Rod