numinix product fields

I did first post this againnst the template I was using http://www.zen-cart.com/showthread.php?213334-Westminster-New&p=1258298#post1258298 #269

Found this plugin from Numinix, product fields. Seems to have what I am looking for but having problems with the install.

After a file merge uploaded all files to the relevant locations. install.sql scripted on install is giving back 'WARNING: An Error occurred, please refresh the page and try again.'

Going to the product screen and doing an update I am getting the same error message.

I have tried to do an uninstall of the script message coming back saying 'ERROR: Cannot DROP column products_sh_eu because it does not exist.' etc.

Log files

[10-Sep-2014 16:25:50] PHP Fatal error: 1054:Unknown column 'products_barcode' in 'field list' :: update eshop_products set products_quantity = '1000', products_type = '1', products_model = 'HD-FAM901', products_price = '2.4917', products_date_available = null, products_weight = '0', products_status = '1', products_virtual = '0', products_tax_class_id = '1', manufacturers_id = '0', products_quantity_order_min = '1', products_quantity_order_units = '1', products_priced_by_attribute = '0', product_is_free = '0', product_is_call = '0', products_quantity_mixed = '1', product_is_always_free_shipping = '0', products_qty_box_status = '1', products_quantity_order_max = '0', products_sort_order = '0', products_discount_type = '0', products_discount_type_from = '0', products_price_sorter = '2.4917', products_barcode = '', products_condition = '', products_image = 'christmas/FAMX901.jpg', products_last_modified = now(), master_categories_id = '75' where products_id = '182' in /homepages/20/d503465712/htdocs/shops/ZenCart/eshop/includes/classes/db/mysql/query_factory.php on line 120

[10-Sep-2014 16:24:02] PHP Fatal error: 1062: Duplicate entry 'SHOW_PRODUCT_INFO_CONDITION' for key 'unq_config_key_zen' :: INSERT INTO eshop_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'),'); in /homepages/20/d503465712/htdocs/shops/ZenCart/eshop/includes/classes/db/mysql/query_factory.php on line 120

install.sql

ALTER TABLE products ADD products_condition varchar(32) NULL default NULL;

INSERT INTO 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'),');

extra info

Template; Westminster New

Assuming that a *barcode *was one of the fields being added, it looks like the install.sql file doesn't make that change to the database. Would you also post the uninstall SQL script? You might want to post a link to this thread in the support thread for the plugin (see the "Similar Threads" links below).

lat9:

Assuming that a *barcode *was one of the fields being added, it looks like the install.sql file doesn't make that change to the database. Would you also post the uninstall SQL script? You might want to post a link to this thread in the support thread for the plugin (see the "Similar Threads" links below).

Uninstall.sql

ALTER TABLE products DROP COLUMN products_epier;
ALTER TABLE products DROP COLUMN products_ebay;
ALTER TABLE products DROP COLUMN products_ebid;
ALTER TABLE products DROP COLUMN products_sh_na;
ALTER TABLE products DROP COLUMN products_sh_sa;
ALTER TABLE products DROP COLUMN products_sh_eu;
ALTER TABLE products DROP COLUMN products_sh_af;
ALTER TABLE products DROP COLUMN products_sh_as;
ALTER TABLE products DROP COLUMN products_sh_au;
ALTER TABLE products DROP COLUMN products_condition;
ALTER TABLE products DROP COLUMN products_upc;
ALTER TABLE products DROP COLUMN products_isbn;
ALTER TABLE products DROP COLUMN products_weight_type;
ALTER TABLE products DROP COLUMN products_dim_type;
ALTER TABLE products DROP COLUMN products_length;
ALTER TABLE products DROP COLUMN products_width;
ALTER TABLE products DROP COLUMN products_height;
ALTER TABLE products DROP COLUMN products_ready_to_ship;
ALTER TABLE products DROP COLUMN products_EHF;
ALTER TABLE products DROP COLUMN products_category;
ALTER TABLE products DROP COLUMN products_barcode;
ALTER TABLE products DROP COLUMN products_diameter;
ALTER TABLE products DROP COLUMN products_actual_weight;

DELETE FROM product_type_layout WHERE configuration_key = 'SHOW_PRODUCT_INFO_DIMENSIONS';
DELETE FROM product_type_layout WHERE configuration_key = 'SHOW_PRODUCT_INFO_DIAMETER';
DELETE FROM product_type_layout WHERE configuration_key = 'SHOW_PRODUCT_INFO_CONVERSIONS';
DELETE FROM product_type_layout WHERE configuration_key = 'SHOW_PRODUCT_INFO_SMALLER_UNITS';
DELETE FROM product_type_layout WHERE configuration_key = 'SHOW_PRODUCT_INFO_ACTUAL_WEIGHT'; >

Good point about posting a link in the similar links. I did I search for similar. But yes