Hi Hans,
You added it in r736967 and removed it in r737311. I did not update between, found a related issue running run-install, found that
adding WEB_SITE_PUB_PT fixed this issue so I commited it.
The error was
2009-01-24 15:28:56,593 (main) [ GenericDelegator.java:812:ERROR]
---- exception report ----------------------------------------------------------
Failure in create operation for entity [Content]: org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:Content][contentId,OFBIZ_PPOINT(java.lang.String)][contentName,OFBiz Site Publish
Point(java.lang.String)][contentTypeId,OFBIZ_SITE_PUB_PT(java.lang.String)][createdStamp,2009-01-24
15:28:56.594(java.sql.Timestamp)][createdTxStamp,2009-01-24 15:28:56.484(java.sql.Timestamp)][lastUpdatedStamp,2009-01-24
15:28:56.594(java.sql.Timestamp)][lastUpdatedTxStamp,2009-01-24 15:28:56.484(java.sql.Timestamp)] (SQL Exception while executing the
following:INSERT INTO public.CONTENT (CONTENT_ID, CONTENT_TYPE_ID, OWNER_CONTENT_ID, DECORATOR_CONTENT_ID, INSTANCE_OF_CONTENT_ID,
DATA_RESOURCE_ID, TEMPLATE_DATA_RESOURCE_ID, DATA_SOURCE_ID, STATUS_ID, PRIVILEGE_ENUM_ID, SERVICE_NAME, CONTENT_NAME, DESCRIPTION,
LOCALE_STRING, MIME_TYPE_ID, CHARACTER_SET_ID, CHILD_LEAF_COUNT, CHILD_BRANCH_COUNT, CREATED_DATE, CREATED_BY_USER_LOGIN,
LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERREUR: une instruction insert ou update sur la
table « content » viole la contrainte de clé
étrangère « content_to_type »
Detail: La clé (content_type_id)=(OFBIZ_SITE_PUB_PT) n'est pas présente dans la table « content_type ».)). Rolling back
transaction.
---- cause ---------------------------------------------------------------------
Exception: org.postgresql.util.PSQLException
Message: ERREUR: une instruction insert ou update sur la table « content »
viole la contrainte de clé
étrangère « content_to_type »
Detail: La clé (content_type_id)=(OFBIZ_SITE_PUB_PT) n'est pas présente dans
la table « content_type ».
---- stack trace ---------------------------------------------------------------
org.postgresql.util.PSQLException: ERREUR: une instruction insert ou update sur
la table « content » viole la contrainte de clé
étrangère « content_to_type »
Detail: La clé (content_type_id)=(OFBIZ_SITE_PUB_PT) n'est pas présente dans
la table « content_type ».
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:304)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:429)
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:165)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:111)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:793)
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1369)
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:282)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:261)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:218)
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:211)
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:261)
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
org.ofbiz.base.start.Start.startServer(Start.java:312)
org.ofbiz.base.start.Start.start(Start.java:316)
org.ofbiz.base.start.Start.main(Start.java:399)
--------------------------------------------------------------------------------
BTW I have updated since, made a fresh new DB (Postgres) populated it
(run-install) and the OFBiz site bottom button, gives me
org.ofbiz.webapp.view.ViewHandlerException: Unknown handler type: none
again(? I'm not sure it was this error I saw the 1st time, but I'm sure than between I saw the OFBiz site launched internally from
OFBiz)
There is the same error on demo server but I have another instance (alternate demo server, you can check ;o) running r737306 which
runs fine (and without OFBIZ_SITE_PUB_PT in ContentType). Not sure when this DB was last populated though...
Anyway I removed it in since it does not have any effect anymore (no errors in
log, no better result from OFBiz site button)
HTH
Cheers
Jacques
From: "Hans Bakker" <[email protected]>
Jaques,
can you tell me why you added this? this contentTypeId isn't used
anywhere....
and if it was used anywhere then it should be WEB_SITE_PUB_PT which is
already existing...
Regards,
Hans
On Sat, 2009-01-24 at 14:34 +0000, [email protected] wrote:
Author: jleroux
Date: Sat Jan 24 14:34:35 2009
New Revision: 737366
URL: http://svn.apache.org/viewvc?rev=737366&view=rev
Log:
ContentType "OFBIZ_SITE_PUB_PT" was missing, now the OFBiz site is accessible
from OFBiz :o)
Modified:
ofbiz/trunk/applications/content/data/ContentTypeData.xml
Modified: ofbiz/trunk/applications/content/data/ContentTypeData.xml
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/applications/content/data/ContentTypeData.xml?rev=737366&r1=737365&r2=737366&view=diff
==============================================================================
--- ofbiz/trunk/applications/content/data/ContentTypeData.xml (original)
+++ ofbiz/trunk/applications/content/data/ContentTypeData.xml Sat Jan 24
14:34:35 2009
@@ -96,6 +96,8 @@
<ContentType contentTypeId="COMPDOC_TEMPLATE" description="Composite Document
Template"/>
<ContentType contentTypeId="COMPDOC_INSTANCE" description="Composite Document
Instance"/>
+ <ContentType contentTypeId="OFBIZ_SITE_PUB_PT" description="OFBiz site"/>
+
<StatusType description="Content Approval Status" hasTable="N" parentTypeId=""
statusTypeId="CNTNTAPPR_STATUS"/>
<StatusItem description="Not Ready for Approval" sequenceId="01" statusCode="NOT_READY" statusId="CNTAP_NOT_READY"
statusTypeId="CNTNTAPPR_STATUS"/>
<StatusItem description="Ready for Approval" sequenceId="02" statusCode="READY" statusId="CNTAP_READY"
statusTypeId="CNTNTAPPR_STATUS"/>
--
http://www.antwebsystems.com :
Quality OFBiz support for competitive rates....
