[
https://issues.apache.org/jira/browse/OFBIZ-1892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12617037#action_12617037
]
Scott Gray commented on OFBIZ-1892:
-----------------------------------
Hi BJ,
I'm not sure of the reason for the problem you're having but note the following
two points:
1. if you view the source code of the page that is generated you will see that
the dropdown does indeed use the productStoreId for the value of each option,
the product store name is only used for display.
2. your patch does nothing except change what is _displayed_ in the dropdown
and the order in which they are sorted, the option value remains the same.
> cant create website
> -------------------
>
> Key: OFBIZ-1892
> URL: https://issues.apache.org/jira/browse/OFBIZ-1892
> Project: OFBiz
> Issue Type: Bug
> Components: content
> Affects Versions: SVN trunk
> Reporter: BJ Freeman
> Assignee: Bilgin Ibryam
> Priority: Minor
> Fix For: SVN trunk
>
> Attachments: createwebsitefix.patch
>
>
> Ok here it is.
> https://localhost:8443/content/control/EditWebSite
> uses the Storename in the Product Store ID box and passes that instead
> of the productstoreID so it has a PFK error.
> ---- exception report
> ----------------------------------------------------------
> Failure in create operation for entity [WebSite]:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:WebSite][allowProductStoreChange,null()][cookieDomain,bjfreemanteststore(java.lang.String)][createdStamp,2008-07-23
> 14:04:10.593(java.sql.Timestamp)][createdTxStamp,2008-07-23
> 14:04:10.593(java.sql.Timestamp)][enableHttps,null()][httpHost,null()][httpPort,null()][httpsHost,null()][httpsPort,null()][lastUpdatedStamp,2008-07-23
> 14:04:10.593(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-23
> 14:04:10.593(java.sql.Timestamp)][productStoreId,bjfreemanteststore(java.lang.String)][secureContentPrefix,null()][siteName,bjfreemanteststore(java.lang.String)][standardContentPrefix,null()][webSiteId,bjfreemanteststore(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO OFBIZ.WEB_SITE
> (WEB_SITE_ID, SITE_NAME, ALLOW_PRODUCT_STORE_CHANGE, HTTP_HOST,
> HTTP_PORT, HTTPS_HOST, HTTPS_PORT, ENABLE_HTTPS,
> STANDARD_CONTENT_PREFIX, SECURE_CONTENT_PREFIX, COOKIE_DOMAIN,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
> CREATED_TX_STAMP, PRODUCT_STORE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'WEB_SITE' caused a violation of
> foreign key constraint 'WEB_SITE_PRDS' for key (bjfreemanteststore).
> The statement has been rolled back.)). Rolling back transaction.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
