OFBiz › OFBiz - User

Re: [jira] Updated: (OFBIZ-1892) cant create website

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

2 messages Options

BJ Freeman

Re: [jira] Updated: (OFBIZ-1892) cant create website

Ok I don't want to open this again since it works on the demo site.
however I have
updated to svn 680740
ant clean-all
and
ant run-install
on the content createWebSite I
put
in bjfreemanteststore
for
websiteID and site name
https://demo.hotwaxmedia.com/content/control/createWebSite
works.
however on my local copy
it comes back with
CommonCannotBeFound: [bjfreemanteststore]
in the tool tips.
Now I have traced this down to
there is no commonuilabels defined for this widget, so I am gettting
<field use-when="webSite==null&&webSiteId!=null"
name="webSiteId" tooltip="${uiLabelMap.CommonCannotBeFound}:
[${webSiteId}]"><text size="20" maxlength="20"/></field>
I am using admin login
as you see it says the webSiteId = bjfreemanteststore
yet is evaluates the field as null.

I have even gone as far as to take the text version from
http://svn.apache.org/viewvc/ofbiz/trunk/applications/content/webapp/content/website/WebSiteForms.xml?view=co&content-type=text%2Fplain
and paste in the one on my machine.

the results at the same
it won't create the website.
there is no error in my logs

BJ Freeman (JIRA) sent the following on 7/25/2008 2:17 PM:

> [ 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.
>

BJ Freeman

Re: [jira] Updated: (OFBIZ-1892) cant create website

I forgot we have a debug file now
I think I know why it worked on the demo and not locally
the demo uses the hotwax cert
the local uses
ofbiz.org cert which is expired.

2008-07-29 14:24:31,312 (http-0.0.0.0-8443-2) [
RequestHandler.java:243:INFO ] [Processing Request]: EditWebSite
sessionId=15BC9675666BC788DE897F186C9BF720.jvm1
2008-07-29 14:24:31,312 (http-0.0.0.0-8443-2) [
RequestHandler.java:433:INFO ] [RequestHandler.doRequest]: Response is a
view. sessionId=15BC9675666BC788DE897F186C9BF720.jvm1
2008-07-29 14:24:31,312 (http-0.0.0.0-8443-2) [
RequestHandler.java:584:INFO ] servletName=control, view=EditWebSite
sessionId=15BC9675666BC788DE897F186C9BF720.jvm1
2008-07-29 14:24:31,312 (http-0.0.0.0-8443-2) [
JSSESupport.java:89 :DEBUG] Error getting client certs
javax.net.ssl.SSLPeerUnverifiedException: peer not authenticated
at
com.sun.net.ssl.internal.ssl.SSLSessionImpl.getPeerCertificates(SSLSessionImpl.java:345)
at
org.apache.tomcat.util.net.jsse.JSSESupport.getX509Certificates(JSSESupport.java:87)
at
org.apache.tomcat.util.net.jsse.JSSESupport.getPeerCertificateChain(JSSESupport.java:141)
at
org.apache.coyote.http11.Http11Processor.action(Http11Processor.java:1011)
at org.apache.coyote.Request.action(Request.java:352)
at org.apache.catalina.connector.Request.getAttribute(Request.java:896)
at
org.apache.catalina.connector.Request.getAttributeNames(Request.java:936)
at
org.apache.catalina.connector.RequestFacade.getAttributeNames(RequestFacade.java:278)
at org.ofbiz.base.util.UtilHttp.getAttributeMap(UtilHttp.java:198)
at org.ofbiz.base.util.UtilHttp.getAttributeMap(UtilHttp.java:187)
at org.ofbiz.base.util.UtilHttp.getCombinedMap(UtilHttp.java:90)
at
org.ofbiz.widget.screen.ScreenRenderer.populateContextForRequest(ScreenRenderer.java:183)
at
org.ofbiz.widget.screen.ScreenRenderer.populateContextForRequest(ScreenRenderer.java:175)
at
org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:92)
at
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:651)
at
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:435)
at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:198)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:258)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:595)
2008-07-29 14:24:31,390 (http-0.0.0.0-8443-2) [
UtilXml.java:241:INFO ] XML Read 0.015s:
file:/C:/projects/java/ofbiz_all/applications/content/widget/WebSiteScreens.xml
2008-07-29 14:24:31,390 (http-0.0.0.0-8443-2) [
ScreenFactory.java:128:INFO ] Got 11 screens in 0.078s from:
file:/C:/projects/java/ofbiz_all/applications/content/widget/WebSiteScreens.xml
2008-07-29 14:24:31,390 (http-0.0.0.0-8443-2) [
PrimaryKeyFinder.java:138:INFO ] Returning null because found incomplete
primary key in find: [GenericEntity:WebSite][webSiteId,null()]
2008-07-29 14:24:31,453 (http-0.0.0.0-8443-2) [
UtilXml.java:241:INFO ] XML Read 0.016s:
file:/C:/projects/java/ofbiz_all/applications/content/widget/CommonScreens.xml
2008-07-29 14:24:31,453 (http-0.0.0.0-8443-2) [
ScreenFactory.java:128:INFO ] Got 12 screens in 0.063s from:
file:/C:/projects/java/ofbiz_all/applications/content/widget/CommonScreens.xml
2008-07-29 14:24:31,546 (http-0.0.0.0-8443-2) [
UtilXml.java:241:INFO ] XML Read 0.015s: XML Properties file
2008-07-29 14:24:31,593 (http-0.0.0.0-8443-2) [
UtilXml.java:241:INFO ] XML Read 0.015s: XML Properties file
2008-07-29 14:24:31,593 (http-0.0.0.0-8443-2) [
UtilProperties.java:549:INFO ] Loaded 390 properties for:
ContentUiLabels (en)
2008-07-29 14:24:31,640 (http-0.0.0.0-8443-2) [
UtilXml.java:241:INFO ] XML Read 0.031s: XML Properties file
2008-07-29 14:24:31,687 (http-0.0.0.0-8443-2) [
UtilProperties.java:866:INFO ] ResourceBundle ContentUiLabels (en_US)
created in 234.0 mS
2008-07-29 14:24:31,703 (http-0.0.0.0-8443-2) [
UtilXml.java:241:INFO ] XML Read 0.016s:
file:/C:/projects/java/ofbiz_all/framework/common/widget/CommonScreens.xml
2008-07-29 14:24:31,703 (http-0.0.0.0-8443-2) [
ScreenFactory.java:128:INFO ] Got 19 screens in 0.016s from:
file:/C:/projects/java/ofbiz_all/framework/common/widget/CommonScreens.xml
2008-07-29 14:24:31,890 (http-0.0.0.0-8443-2) [
UtilXml.java:241:INFO ] XML Read 0.0s:
file:/C:/projects/java/ofbiz_all/applications/content/widget/content/ContentMenus.xml
2008-07-29 14:24:31,906 (http-0.0.0.0-8443-2) [
UtilXml.java:241:INFO ] XML Read 0.016s:
file:/C:/projects/java/ofbiz_all/framework/common/widget/CommonMenus.xml
2008-07-29 14:24:31,921 (http-0.0.0.0-8443-2) [
ModelScreenWidget.java:523:INFO ] In the include-screen tag the screen
name was empty, ignoring include; in screen [GlobalDecorator]
2008-07-29 14:24:32,015 (http-0.0.0.0-8443-2) [
UtilXml.java:241:INFO ] XML Read 0.015s:
file:/C:/projects/java/ofbiz_all/applications/content/webapp/content/website/WebSiteForms.xml
2008-07-29 14:24:32,078 (http-0.0.0.0-8443-2) [
ControlServlet.java:299:INFO ] [[[EditWebSite] Done rendering page,
Servlet Finished- total:0.985,since last([EditWebSite] Set...):0.938]]

BJ Freeman sent the following on 7/29/2008 2:55 PM:

> Ok I don't want to open this again since it works on the demo site.
> however I have
> updated to svn 680740
> ant clean-all
> and
> ant run-install
> on the content createWebSite I
> put
> in bjfreemanteststore
> for
> websiteID and site name
> https://demo.hotwaxmedia.com/content/control/createWebSite
> works.
> however on my local copy
> it comes back with
> CommonCannotBeFound: [bjfreemanteststore]
> in the tool tips.
> Now I have traced this down to
> there is no commonuilabels defined for this widget, so I am gettting
> <field use-when="webSite==null&&webSiteId!=null"
> name="webSiteId" tooltip="${uiLabelMap.CommonCannotBeFound}:
> [${webSiteId}]"><text size="20" maxlength="20"/></field>
> I am using admin login
> as you see it says the webSiteId = bjfreemanteststore
> yet is evaluates the field as null.
>
> I have even gone as far as to take the text version from
> http://svn.apache.org/viewvc/ofbiz/trunk/applications/content/webapp/content/website/WebSiteForms.xml?view=co&content-type=text%2Fplain
> and paste in the one on my machine.
>
> the results at the same
> it won't create the website.
> there is no error in my logs
>
>
>
>
> BJ Freeman (JIRA) sent the following on 7/25/2008 2:17 PM:
>> [ 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.
>
>
>
>