Re: svn commit: r737366 - /ofbiz/trunk/applications/content/data/ContentTypeData.xml

[Hans Bakker]

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, [hidden email] 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....

[Jacques Le Roux]

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" <[hidden email]>

> 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, [hidden email] 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....
>