Product problems

[fusionsp]

OK i cant seem to find it anywhere here. I had the information before but I seem to have deleted something.

I need to add the UPC/ISBN fields and I have the Numinix module.

But I seem to remember when I initially started looking into this there was a 2 step installation that needed to be done to make it all work. Like you had to install 2 different modules.

which ones do I need to have installed to have those fields added to my admin for products?

[kobra]

Re-check the downloads and description

[fusionsp]

OK I need help.

I installed both of the required items to have the UPC/ISBN boxes and its working internally. My issue is when you click on any item on the website, it directs you to an error.

1054 Unknown column 'pd.products_description2' in 'field list'
in:
[SELECT p.products_weight, pd.products_description2 FROM products p, products_description pd WHERE p.products_id = 1297 AND p.products_id = pd.products_id AND pd.language_id = '1' LIMIT 1]

I had this appear internally and it just went away on its own. I assumed it was a caching issue. But Now I clicked on products and its doing it externally now.

What caused this and how do i fix it....

[kobra]

All your version info
sever type
ZenCart
php
mysql

[fusionsp]

All your version info
sever type
ZenCart
php
mysql

server type: not sure what your asking here, its a linux base
version: 1.39f
php: 5.2.14
mysql: 5.1.47-community-log


Does this matter on versions of that? I just knew that the last module I added was that one. So I assume its something that needs changed from that.

[kobra]

Did you install the sql patch included with the module?

[fusionsp]

Did you install the sql patch included with the module?

well I installed all 3 patches.

There was one that came with the UPC/ISBN product field called product_fields.sql

ALTER TABLE products ADD products_upc varchar(32) NULL default NULL after products_model;
ALTER TABLE products ADD products_isbn varchar(32) NULL default NULL after products_upc;

one that came with numinix product fields

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

and one that added those fields in that module product fields optional fields (upc_isbn)

ALTER TABLE products ADD products_upc varchar(32) NULL default NULL after products_model;
ALTER TABLE products ADD products_isbn varchar(32) NULL default NULL after products_upc;
ALTER TABLE products ADD products_ean varchar(32) NULL default NULL after products_isbn;
ALTER TABLE products ADD products_asin varchar(32) NULL default NULL after products_ean;

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 UPC', 'SHOW_PRODUCT_INFO_UPC', '0', 'Show product UPC on product info page (requires Numinix Product Fields)?', 1, 17, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'1\', \'0\'),'),
(NULL, 'Show ISBN', 'SHOW_PRODUCT_INFO_ISBN', '0', 'Show product ISBN on product info page (requires Numinix Product Fields)?', 1, 17, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'1\', \'0\'),');

i added all three of these sql files.

[kobra]

well I installed all 3 patches.

From a fresh download of it on this site all I see is
product_fields.sql
uninstall.sql

http://www.zen-cart.com/index.php?ma...roducts_id=651

Where did you get yours??
Maybe we are not talking about the same one??

[fusionsp]

No its the same. if you look at in you have to install one to have the other. Not sure why their packaged separately, but they are.

the second one is called Numinix product fields. it used to be listed here but i cant find it anymore. now its only on his site.

http://www.numinix.com/zen-cart-modu...product-fields

ok, just went to his site....he said i should undo and revert back and only use the numinix product fields one. he said the individual upc/isbn one is no longer supported.

[fusionsp]

so...I tried his idea and now I cant get it to uninstall. the unistall package has 28 statements and it errors out stating it cannot process all the statements.

I have worked so hard, Im ready to do a fresh load. but i dont know if i can take redoing everything again.