Numinix Product Fields w/ 1.5.8a Not Working

[mcqueeneycoins]

Quick update--I went through and updated the files using the 3.1.3 fileset I found on numinix website. This seems to have resolved the product dimensions issue, but I'm still getting the same error when trying to copy products:

WARNING: An Error occurred, please let us know! If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you entered valid data.

As far as my error logs, there are several similar entries like this one:

--> PHP Warning: Constant TEXT_COMPOSITION already defined in /myadmin/includes/languages/english/npf_definitions/lang.composition.php on line 13.

In addition, here is the error for the copy:

Request URI: /myadmin/index.php?cmd=category_product_listing&action=copy_product_confirm&cPath=191&page=1, IP address: xxx, Language id 1
#1 trigger_error() called at [/includes/classes/db/mysql/query_factory.php:667]
#2 queryFactory->show_error() called at [/includes/classes/db/mysql/query_factory.php:634]
#3 queryFactory->set_error() called at [/includes/classes/db/mysql/query_factory.php:275]
#4 queryFactory->Execute() called at [/includes/functions/database.php:130]
#5 zen_db_perform() called at [/myadmin/includes/modules/copy_product_confirm.php:109]
#6 require(/myadmin/includes/modules/copy_product_confirm.php) called at [/myadmin/category_product_listing.php:253]
#7 require(/myadmin/category_product_listing.php) called at [/myadmin/index.php:11]
--> PHP Fatal error: 1054:Unknown column 'products_description2' in 'field list' :: INSERT INTO products (products_type, products_quantity, products_model, products_upc, products_ean, products_asin, products_image, products_price, products_virtual, products_weight, products_tax_class_id, manufacturers_id, products_ordered, products_quantity_order_min, products_quantity_order_units, products_priced_by_attribute, product_is_free, product_is_call, products_quantity_mixed, product_is_always_free_shipping, products_qty_box_status, products_quantity_order_max, products_sort_order, products_discount_type, products_discount_type_from, products_price_sorter, master_categories_id, products_mixed_discount_quantity, metatags_title_status, metatags_products_name_status, metatags_model_status, metatags_price_status, metatags_title_tagline_status, products_condition, additional_skus_only, mintage, mint_location, mint_mark, strike_type, composition, weight, grade, product_condition, test, products_description2, products_status, products_date_added, products_date_available) VALUES ('1', '1000', 'GIFT-1000', '', '', '', '', '10', '1', '0', '7', '0', '0', '1', '1', '0', '0', '0', '1', '0', '1', '0', '0', '0', '0', '10.0000', '191', '1', '0', '0', '0', '0', '0', '', '', '', '', '', '', '', '0', '', '', '', '', '0', now(), null) ==> (as called by) /includes/functions/database.php on line 130 <== in /includes/classes/db/mysql/query_factory.php on line 667.

[OldNGrey]

Quick update--I went through and updated the files using the 3.1.3 fileset I found on numinix website. This seems to have resolved the product dimensions issue, but I'm still getting the same error when trying to copy products:

Did you remove any files that existed but are not in the latest version?

--> PHP Warning: Constant TEXT_COMPOSITION already defined in /myadmin/includes/languages/english/npf_definitions/lang.composition.php on line 13.[/CODE]

Have you got the old language file as well as a new lang.xx file?

Sort these problems first then tackle the copy problem.

I haven't used the Numinix addons as provided since zc1.3.7. I modified my main files include the extra fields .

[mcqueeneycoins]

Did you remove any files that existed but are not in the latest version?


Have you got the old language file as well as a new lang.xx file?

Sort these problems first then tackle the copy problem.

I haven't used the Numinix addons as provided since zc1.3.7. I modified my main files include the extra fields .

Thanks for pointing me in the right direction! I updated the language files when I upgraded, but missed modifying the contents *slaps face*. I made the changes to the language files and the sql array and now the only error left is the copy error, which is still throwing. If I manually add the column to the product table for products_description2, it removes that error but throws another one related to additional skus only, so it seems to be a more widespread database issue? If it helps, these fields do not show up when editing a product even though they show enabled in the NPF menu. Maybe there was an sql statement I missed somewhere adding these to the tables?

[OldNGrey]

Correction "since zc157"

[mcqueeneycoins]

I've continued to play with this without much success. I tried enabling the extra fields in the product type layout settings and get additional errors, primarily with the UPC, ISBN and SKU fields. Products Description 2 won't show up when editing a product.

Example of error I'm getting:

--> PHP Fatal error: 1054:Unknown column 'p.products_isbn' in 'field list' :: SELECT p.products_weight, p.products_condition, p.products_upc, p.products_isbn, pd.products_description2
FROM products p, products_description pd
WHERE p.products_id = 3
AND p.products_id = pd.products_id
AND pd.language_id = '1' LIMIT 1 ==> (as called by) /includes/templates/bootstrap/product_info/extra_main_template_vars/numinix_product_fields.php on line 31 <== in /includes/classes/db/mysql/query_factory.php on line 667.

Do you think running the uninstall sql script without removing the files would "refresh" the database and solve this problem? Or do you think it's a deeper issue in the files? I'm not an expert, but if I understand it, it's trying to pull info from those extra fields but isn't finding them which makes me think it might be a database issue?

[jimmie]

unknown column. means not in the database, just add field in db

[numinix]

Hi Numinix,

Attachment 20474

how do i change which shipping modula i wish to use?
and then will it list each option fir the shipping offered? and if the shipping option names are below the shipping module name what is the Condition box for?

do you have a clear detailed user useage for each field your addon makes??

This plugin just adds the ability to create fields and store data in the database. You'll need a programmer to write code to use that data. We have other plugins that rely on data from some of these built in fields (or they create fields when installed).

If you are looking to create flat shipping rates specific to each product, you'll need to code up a shipping module. Or, you could try one of the existing flat rate modules that allow you to create groups of products and apply a flat rate to the group.