[jira] [Comment Edited] (OFBIZ-7451) Update Blog summary throws database exception when characters exceeds more than 255 characters

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-7451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17202795#comment-17202795 ]

Jacques Le Roux edited comment on OFBIZ-7451 at 9/27/20, 9:36 AM:
------------------------------------------------------------------

-This is not related to blog but blog article and it works as expected seen from DB side. Now I don't know how to see the article summary either in back or front ends but as an admin. Not sure id this is right! This is true for trunk. WIthout the demos I have no time to handle the other cases...-
OK, this was wrongly reported. The issue is in ecommerce, where you can only edit as an admin (!).

The Following Errors Occurred:

Error doing entity-auto operation for entity Content in service createContent: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Content][contentId,10027(java.lang.String)][contentName,testtesttest(java.lang.String)][contentTypeId,DOCUMENT(java.lang.String)][createdByUserLogin,admin(java.lang.String)][createdDate,2020-09-27 11:30:19.75(java.sql.Timestamp)][createdStamp,2020-09-27 11:30:19.75(java.sql.Timestamp)][createdTxStamp,2020-09-27 11:30:19.625(java.sql.Timestamp)][dataResourceId,BLOG_TPL_TOPLEFT(java.lang.String)][description,testtesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttest(java.lang.String)][lastModifiedByUserLogin,admin(java.lang.String)][lastModifiedDate,2020-09-27 11:30:19.75(java.sql.Timestamp)][lastUpdatedStamp,2020-09-27 11:30:19.75(java.sql.Timestamp)][lastUpdatedTxStamp,2020-09-27 11:30:19.625(java.sql.Timestamp)][ownerContentId,10000(java.lang.String)][statusId,CTNT_INITIAL_DRAFT(java.lang.String)] (SQL Exception while executing the following:null (A truncation error was encountered trying to shrink VARCHAR 'testtesttesttesttesttesttesttesttesttesttesttesttesttesttest&' to length 255.)) (Error while inserting: [GenericEntity:Content][contentId,10027(java.lang.String)][contentName,testtesttest(java.lang.String)][contentTypeId,DOCUMENT(java.lang.String)][createdByUserLogin,admin(java.lang.String)][createdDate,2020-09-27 11:30:19.75(java.sql.Timestamp)][createdStamp,2020-09-27 11:30:19.75(java.sql.Timestamp)][createdTxStamp,2020-09-27 11:30:19.625(java.sql.Timestamp)][dataResourceId,BLOG_TPL_TOPLEFT(java.lang.String)][description,testtesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttest(java.lang.String)][lastModifiedByUserLogin,admin(java.lang.String)][lastModifiedDate,2020-09-27 11:30:19.75(java.sql.Timestamp)][lastUpdatedStamp,2020-09-27 11:30:19.75(java.sql.Timestamp)][lastUpdatedTxStamp,2020-09-27 11:30:19.625(java.sql.Timestamp)][ownerContentId,10000(java.lang.String)][statusId,CTNT_INITIAL_DRAFT(java.lang.String)] (SQL Exception while executing the following:null (A truncation error was encountered trying to shrink VARCHAR 'testtesttesttesttesttesttesttesttesttesttesttesttesttesttest&' to length 255.)))




was (Author: jacques.le.roux):
-This is not related to blog but blog article and it works as expected seen from DB side. Now I don't know how to see the article summary either in back or front ends but as an admin. Not sure id this is right! This is true for trunk. WIthout the demos I have no time to handle the other cases...-
OK, this was wrongly reported. The issue is in ecommerce, where you can only edit as an admin (!).


{noformat}
The Following Errors Occurred:

Error doing entity-auto operation for entity Content in service createContent: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:Content][contentId,10027(java.lang.String)][contentName,testtesttest(java.lang.String)][contentTypeId,DOCUMENT(java.lang.String)][createdByUserLogin,admin(java.lang.String)][createdDate,2020-09-27 11:30:19.75(java.sql.Timestamp)][createdStamp,2020-09-27 11:30:19.75(java.sql.Timestamp)][createdTxStamp,2020-09-27 11:30:19.625(java.sql.Timestamp)][dataResourceId,BLOG_TPL_TOPLEFT(java.lang.String)][description,testtesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttest(java.lang.String)][lastModifiedByUserLogin,admin(java.lang.String)][lastModifiedDate,2020-09-27 11:30:19.75(java.sql.Timestamp)][lastUpdatedStamp,2020-09-27 11:30:19.75(java.sql.Timestamp)][lastUpdatedTxStamp,2020-09-27 11:30:19.625(java.sql.Timestamp)][ownerContentId,10000(java.lang.String)][statusId,CTNT_INITIAL_DRAFT(java.lang.String)] (SQL Exception while executing the following:null (A truncation error was encountered trying to shrink VARCHAR 'testtesttesttesttesttesttesttesttesttesttesttesttesttesttest&' to length 255.)) (Error while inserting: [GenericEntity:Content][contentId,10027(java.lang.String)][contentName,testtesttest(java.lang.String)][contentTypeId,DOCUMENT(java.lang.String)][createdByUserLogin,admin(java.lang.String)][createdDate,2020-09-27 11:30:19.75(java.sql.Timestamp)][createdStamp,2020-09-27 11:30:19.75(java.sql.Timestamp)][createdTxStamp,2020-09-27 11:30:19.625(java.sql.Timestamp)][dataResourceId,BLOG_TPL_TOPLEFT(java.lang.String)][description,testtesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttest(java.lang.String)][lastModifiedByUserLogin,admin(java.lang.String)][lastModifiedDate,2020-09-27 11:30:19.75(java.sql.Timestamp)][lastUpdatedStamp,2020-09-27 11:30:19.75(java.sql.Timestamp)][lastUpdatedTxStamp,2020-09-27 11:30:19.625(java.sql.Timestamp)][ownerContentId,10000(java.lang.String)][statusId,CTNT_INITIAL_DRAFT(java.lang.String)] (SQL Exception while executing the following:null (A truncation error was encountered trying to shrink VARCHAR 'testtesttesttesttesttesttesttesttesttesttesttesttesttesttest&' to length 255.)))
{noformat}

> Update Blog summary throws database exception when characters exceeds more than 255 characters
> ----------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-7451
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-7451
>             Project: OFBiz
>          Issue Type: Bug
>          Components: ecommerce
>    Affects Versions: Trunk
>            Reporter: Vishal Chhabria
>            Assignee: Ankit Joshi
>            Priority: Minor
>

--
This message was sent by Atlassian Jira
(v8.3.4#803005)