[jira] [Commented] (OFBIZ-9368) OEM Party Id field should have lookup on Edit Product page

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-9368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16118351#comment-16118351 ]

Aditya Sharma commented on OFBIZ-9368:
--------------------------------------

Thanks, Jacques :)

I noticed following logs:
2017-08-06 19:21:47,966 |OFBiz-batch-2        |DatabaseUtil                  |W| Column [MANUFACTURER_PARTY_ID] of table [OFBIZ.PRODUCT] of entity [Product] exists in the database but has no corresponding field

2017-08-06 19:21:47,966 |OFBiz-batch-2        |DatabaseUtil                  |W| Entity [Product] has 74 fields but table [OFBIZ.PRODUCT] has 75 columns.

IMO there should be no unwanted logs thus we should have a SQL query to remove the field.

> OEM Party Id field should have lookup on Edit Product page
> ----------------------------------------------------------
>
>                 Key: OFBIZ-9368
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-9368
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: product
>    Affects Versions: Trunk
>            Reporter: Aditya Sharma
>            Assignee: Jacques Le Roux
>            Priority: Trivial
>         Attachments: OFBIZ-9368.patch, OFBIZ-9368.patch, OFBIZ-9368_plugins.patch
>
>
> Steps to reproduce:
> 1. Go to Catalog component (https://demo-trunk.ofbiz.apache.org/catalog/control/main)
> 2. Click on Products from submenu.(https://demo-trunk.ofbiz.apache.org/catalog/control/FindProduct)
> 3. Provide search preference and click on Find button.
> 4. Click on any Product Id link (https://demo-trunk.ofbiz.apache.org/catalog/control/EditProduct?productId=WG-9943).
> OEM Party Id is a text field with no look up. A user needs to know the correct partyId else it will give an error due to the violation of "Referential Integrity".

--
This message was sent by Atlassian JIRA
(v6.4.14#64029)