[jira] Created: (OFBIZ-1892) cant create website
Locked
[jira] Created: (OFBIZ-1892) cant create website
 
|
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. |
[jira] Updated: (OFBIZ-1892) cant create website
|
|
[ https://issues.apache.org/jira/browse/OFBIZ-1892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] BJ Freeman updated OFBIZ-1892: ------------------------------ Attachment: createwebsitefix.patch patch to fix > 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 > > 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. |
[jira] Assigned: (OFBIZ-1892) cant create website
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bilgin Ibryam reassigned OFBIZ-1892: ------------------------------------ Assignee: Bilgin Ibryam > 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. |
[jira] Commented: (OFBIZ-1892) cant create website
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12616367#action_12616367 ] Bilgin Ibryam commented on OFBIZ-1892: -------------------------------------- BJ, I can't see anything wrong in trunk version. I think that you forgot to enter the required Site Name and that's the reason for the error. Can you try again and confirm before I close this issue, please? Bilgin > 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. |
[jira] Commented: (OFBIZ-1892) cant create website
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12616517#action_12616517 ] BJ Freeman commented on OFBIZ-1892: ----------------------------------- this was using the svn trunk code 678395 the productstore ID for bjfreemanteststore is 10000 but the code passed bjfreemanteststore instead of 10000. please check again. > 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. |
[jira] Commented: (OFBIZ-1892) cant create website
|
|
In reply to this post by Nicolas Malin (Jira)
[ 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. |
[jira] Commented: (OFBIZ-1892) cant create website
|
|
In reply to this post by Nicolas Malin (Jira)
[ 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. |
[jira] Commented: (OFBIZ-1892) cant create website
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12617042#action_12617042 ] BJ Freeman commented on OFBIZ-1892: ----------------------------------- ok I will review again. thanks > 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. |
[jira] Commented: (OFBIZ-1892) cant create website
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12617045#action_12617045 ] BJ Freeman commented on OFBIZ-1892: ----------------------------------- Scott: as you can see by the error the orinal code passed down the productstore name productStoreId,bjfreemanteststore(java.lang.String) this should have been 10000 this is what caused the (INSERT on table 'WEB_SITE' caused a violation of foreign key constraint 'WEB_SITE_PRDS' for key (bjfreemanteststore) since the productstoreID is 10000 not bjfreemanteststore so while you say the orginal code does use the ProductID from the the product store something is not right. > 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. |
[jira] Commented: (OFBIZ-1892) cant create website
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12617059#action_12617059 ] BJ Freeman commented on OFBIZ-1892: ----------------------------------- ok did it on the demo store and it worked. > 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. |
[jira] Closed: (OFBIZ-1892) cant create website
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] BJ Freeman closed OFBIZ-1892. ----------------------------- Resolution: Invalid did not work on the trunk version but works on the demo. > 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. |
[jira] Commented: (OFBIZ-1892) cant create website
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12617061#action_12617061 ] Scott Gray commented on OFBIZ-1892: ----------------------------------- I can't imagine what the problem could be, are you able to recreate it on the demo server? > 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. |
[jira] Commented: (OFBIZ-1892) cant create website
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12617063#action_12617063 ] Scott Gray commented on OFBIZ-1892: ----------------------------------- sorry missed your comment, you can disregard mine > 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. |
[jira] Updated: (OFBIZ-1892) cant create website
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] BJ Freeman updated OFBIZ-1892: ------------------------------ Attachment: (was: createwebsitefix.patch) > 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 > > > 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. |
[jira] Commented: (OFBIZ-1892) cant create website
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12618753#action_12618753 ] Bilgin Ibryam commented on OFBIZ-1892: -------------------------------------- Scott, thanks for your help. Bilgin > 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 > > > 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. |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |