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 Priority: Minor Fix For: SVN trunk
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.