[ https://issues.apache.org/jira/browse/OFBIZ-1892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12616525#action_12616525 ]
BJ Freeman commented on OFBIZ-1892: ----------------------------------- If you look in then sql you will see I passed the site name. 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)] > 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.