No more columns for datatype:text

36 views
Skip to first unread message

Mark Orciuch

unread,
May 10, 2021, 4:45:02 PM5/10/21
to dotCMS User Group
Hello,

I received this error when attempting to add a new text field in custom content type. I though I saw a reference to workaround for this problem in a post but can't remember where. Many thanks in advance for a tip on resolving this.

Image 2.png

Mark Pitely

unread,
May 10, 2021, 5:00:25 PM5/10/21
to dot...@googlegroups.com
I have been using the new Relationships - and they are absolutely wonderful. It seems like every problem I had in the past with them has been resolved.
So I am sorry if I scared you (or other people) off from using them. I'm not sure when they moved to these new ones.
So, I think you can easily extend a structure now with a 1:1 relationship to a different data structure and it will work basically seamlessly.
Structure 1: <hits limits on text fields>
Related Content -> Structure 2 <now has more fields>

You can simply pull from the first entry and do:
$con.extendedfields.mynewfield.

If you need me to explain more, let me know. I'm also guessing that you have hit the maximum number of text fields allowed in a single structure.

Mark Pitely
Marywood University

--
http://dotcms.com - Open Source Java Content Management
---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/07d9c7c1-a7c1-455e-9f48-118f80602065n%40googlegroups.com.

Xander Steinmann

unread,
May 11, 2021, 2:25:36 AM5/11/21
to dotCMS User Group
DotCMS can only store 25 text fields per content type, so you either need to use different field types that don't store as text (like textarea, WYSIWYG but also number, boolean, date) or you should extend your content type as Mark pointed out. 

Kind regards,

Xander

Op maandag 10 mei 2021 om 23:00:25 UTC+2 schreef Mark Pitely:

Mark Pitely

unread,
May 11, 2021, 9:08:18 AM5/11/21
to dot...@googlegroups.com
Also, the 'Key/Value' field allows you to have multiple simple fields. If most of these text fields are being used for integers or single-word answers, it might be a much better solution.
Users can create new ones, so it does depend on the use case. That could be great.

Mark Pitely
Marywood University

Nathan Keiter

unread,
May 11, 2021, 9:38:14 AM5/11/21
to dot...@googlegroups.com
The convenient dot notation (.) on the new relationships doesn't work if the user is logged in on the front end. It only works for non-logged-in users.


This would return null if the user is logged in. -> $con.extendedfields


https://github.com/dotCMS/core/issues/20331


If the user is logged, in you have to use pullRelatedField() instead.


#set( $relatedContent = $dotcontent.pullRelatedField( $con.id, "ContentTypeVar.extendedfields", "", 1, $sortOrder))


$relatedContent.mynewfield

Nathan I. Keiter | Lead Network Applications Programmer | I.D.E.A Council Member
Gettysburg College | Information Technology | DataSystems
Campus Box 2453 | 300 North Washington Street | Gettysburg, PA 17325
Phone: 717.337.6993
https://www.gettysburg.edu<https://www.gettysburg.edu/>
________________________________
From: dot...@googlegroups.com <dot...@googlegroups.com> on behalf of Mark Pitely <pit...@maryu.marywood.edu>
Sent: Monday, May 10, 2021 5:00 PM
To: dot...@googlegroups.com
Subject: Re: [dotcms] No more columns for datatype:text

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
________________________________
I have been using the new Relationships - and they are absolutely wonderful. It seems like every problem I had in the past with them has been resolved.
So I am sorry if I scared you (or other people) off from using them. I'm not sure when they moved to these new ones.
So, I think you can easily extend a structure now with a 1:1 relationship to a different data structure and it will work basically seamlessly.
Structure 1: <hits limits on text fields>
Related Content -> Structure 2 <now has more fields>

You can simply pull from the first entry and do:
$con.extendedfields.mynewfield.

If you need me to explain more, let me know. I'm also guessing that you have hit the maximum number of text fields allowed in a single structure.

Mark Pitely
Marywood University

On Mon, May 10, 2021 at 4:45 PM Mark Orciuch <mark_o...@ngsltd.com<mailto:mark_o...@ngsltd.com>> wrote:
Hello,

I received this error when attempting to add a new text field in custom content type. I though I saw a reference to workaround for this problem in a post but can't remember where. Many thanks in advance for a tip on resolving this.

[Image 2.png]

--
http://dotcms.com<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,R-7f4q4MphUQprfDHXGKFDVPnS-T6OaMQ1dBMT0GimvKEERyezBl38u1vLAc6ezGdy42s0rirP_DDRMzqHuew919ViGuhAD4uXh2AUKoom_I__aR7A,,&typo=1> - Open Source Java Content Management
---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com<mailto:dotcms+un...@googlegroups.com>.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/07d9c7c1-a7c1-455e-9f48-118f80602065n%40googlegroups.com<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2f07d9c7c1-a7c1-455e-9f48-118f80602065n%2540googlegroups.com%3futm_medium%3demail%26utm_source%3dfooter&c=E,1,sEa8ox4pqO_Z-penI-ey70PqKPUou7emRV__N1diQx23WontwUfyndp0PjSBdhjZmn6OKE56PBZLF_XtrBHVGsLmHfUVUWEOMMBzDMjY5_oZbZ0dxqFRSPCb&typo=1>.

--
http://dotcms.com<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,BUVsWHfJNAJnHYI8eTca3i6B-AXiH_tu-JWYCszgtFHjC4R8hc25FDzLRp_ZwGDf1_8-7q_ksGj5lc27PkyaFGwr81KQtqZS0d3vb7Ld2k51lA,,&typo=1> - Open Source Java Content Management
---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com<mailto:dotcms+un...@googlegroups.com>.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/CAFeiKqN8gfJPQuqkbZkktpqHLFvZEsogrKd8qX_vH%2BxjpTJszQ%40mail.gmail.com<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2fCAFeiKqN8gfJPQuqkbZkktpqHLFvZEsogrKd8qX_vH%252BxjpTJszQ%2540mail.gmail.com%3futm_medium%3demail%26utm_source%3dfooter&c=E,1,8xWAOuEs7_hPALFwXmnPvr-LaAqdcOPOycZcvcIat9r8J2eLuDyxlVKQvDdDjvQjqFDIBZKobAtkmevjiAI0vzSERvdvjkHnoZIWG_cwJUI,&typo=1>.

Mark Pitely

unread,
May 11, 2021, 9:43:56 AM5/11/21
to dot...@googlegroups.com
Oh, wow, thanks for that heads' up!
I was actually going through some code to try to figure out why it failed as a logged in user; I thought it was my fault.
I don't usually test/develop that way. I use an incognito mode window for dotCMS and a plain window for the output (makes it easier to inspect).

Mark Pitely
Marywood University

--
http://dotcms.com - Open Source Java Content Management

---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/1620740289862.63056%40gettysburg.edu.

Nathan Keiter

unread,
May 11, 2021, 9:47:20 AM5/11/21
to dot...@googlegroups.com
Here's the documentation on pullRelatedField (I forgot to include it.) https://dotcms.com/docs/latest/WindowsInstall/pull-and-display-related-content#UsageField


[cid:4aa1be05-aaec-447f-bc07-a60d6159e620]

Nathan I. Keiter | Lead Network Applications Programmer | I.D.E.A Council Member
Gettysburg College | Information Technology | DataSystems
Campus Box 2453 | 300 North Washington Street | Gettysburg, PA 17325
Phone: 717.337.6993
https://www.gettysburg.edu<https://www.gettysburg.edu/>
________________________________
From: dot...@googlegroups.com <dot...@googlegroups.com> on behalf of Mark Pitely <pit...@maryu.marywood.edu>
Sent: Tuesday, May 11, 2021 9:43 AM
To: dot...@googlegroups.com
Subject: Re: [dotcms] No more columns for datatype:text

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
________________________________
Oh, wow, thanks for that heads' up!
I was actually going through some code to try to figure out why it failed as a logged in user; I thought it was my fault.
I don't usually test/develop that way. I use an incognito mode window for dotCMS and a plain window for the output (makes it easier to inspect).

Mark Pitely
Marywood University

On Tue, May 11, 2021 at 9:38 AM 'Nathan Keiter' via dotCMS User Group <dot...@googlegroups.com<mailto:dot...@googlegroups.com>> wrote:
The convenient dot notation (.) on the new relationships doesn't work if the user is logged in on the front end. It only works for non-logged-in users.


This would return null if the user is logged in. -> $con.extendedfields


https://github.com/dotCMS/core/issues/20331


If the user is logged, in you have to use pullRelatedField() instead.


#set( $relatedContent = $dotcontent.pullRelatedField( $con.id<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fcon.id&c=E,1,w_xy4p_CWtTrCoUvG6YxQ9VezhKB4Ap8kcaFGDcG__1u-cR1tvkaEBQIKg0_KPmBHv34vwaTPmB-wjeia-UDIUhOYfNMgPQ6CQES_Q0xEvXvF3qoAmE,&typo=1>, "ContentTypeVar.extendedfields", "", 1, $sortOrder))


$relatedContent.mynewfield

Nathan I. Keiter | Lead Network Applications Programmer | I.D.E.A Council Member
Gettysburg College | Information Technology | DataSystems
Campus Box 2453 | 300 North Washington Street | Gettysburg, PA 17325
Phone: 717.337.6993
https://www.gettysburg.edu<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fwww.gettysburg.edu&c=E,1,OftsNsKiQXKVcpI25cwcCp5V0gncTyTmZ3HC4l2zZApPXuk-2CKkPYVi-cnKFHu7o0EF4iAkSinqx6Ube35GlHlM4GhV_AaPRpfsgAdaEzuv8a2lviilubbTsQ,,&typo=1><https://www.gettysburg.edu/<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fwww.gettysburg.edu%2f&c=E,1,JOkifu4u4mMy_fUx4dkQyst19JmjogpFf9ZvDSUeEfS6Tv7vIUc6TbvMYS1yw7orqConk6G3FvShIHWI2_DqoYllnfGP3OhNGkVIl2hdEWrWB2iNZT4,&typo=1>>
________________________________
From: dot...@googlegroups.com<mailto:dot...@googlegroups.com> <dot...@googlegroups.com<mailto:dot...@googlegroups.com>> on behalf of Mark Pitely <pit...@maryu.marywood.edu<mailto:pit...@maryu.marywood.edu>>
Sent: Monday, May 10, 2021 5:00 PM
To: dot...@googlegroups.com<mailto:dot...@googlegroups.com>
Subject: Re: [dotcms] No more columns for datatype:text

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
________________________________
I have been using the new Relationships - and they are absolutely wonderful. It seems like every problem I had in the past with them has been resolved.
So I am sorry if I scared you (or other people) off from using them. I'm not sure when they moved to these new ones.
So, I think you can easily extend a structure now with a 1:1 relationship to a different data structure and it will work basically seamlessly.
Structure 1: <hits limits on text fields>
Related Content -> Structure 2 <now has more fields>

You can simply pull from the first entry and do:
$con.extendedfields.mynewfield.

If you need me to explain more, let me know. I'm also guessing that you have hit the maximum number of text fields allowed in a single structure.

Mark Pitely
Marywood University

On Mon, May 10, 2021 at 4:45 PM Mark Orciuch <mark_o...@ngsltd.com<mailto:mark_o...@ngsltd.com><mailto:mark_o...@ngsltd.com<mailto:mark_o...@ngsltd.com>>> wrote:
Hello,

I received this error when attempting to add a new text field in custom content type. I though I saw a reference to workaround for this problem in a post but can't remember where. Many thanks in advance for a tip on resolving this.

[Image 2.png]

--
http://dotcms.com<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,y5SezWJpiwWaLzDzxYtOl2nh_QntBjO6Mexew7WrsRlzNVDIJXndtZVDopuj32qVHsL1WbF4LkUFyvc-NGWqPd1011Z-Omgm_-8v7rg0bvKBa6lUUUYwjzqm5A,,&typo=1><https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,R-7f4q4MphUQprfDHXGKFDVPnS-T6OaMQ1dBMT0GimvKEERyezBl38u1vLAc6ezGdy42s0rirP_DDRMzqHuew919ViGuhAD4uXh2AUKoom_I__aR7A,,&typo=1> - Open Source Java Content Management
---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com<mailto:dotcms%2Bunsu...@googlegroups.com><mailto:dotcms+un...@googlegroups.com<mailto:dotcms%2Bunsu...@googlegroups.com>>.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/07d9c7c1-a7c1-455e-9f48-118f80602065n%40googlegroups.com<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2f07d9c7c1-a7c1-455e-9f48-118f80602065n%2540googlegroups.com&c=E,1,tEC9VMI6-zMEY-Dg3YSVenkF91Hl_x5qj_hZPyduXE41EnQIKkOkA42vE0XcnuBzzY68jriXZIwEVV_1I8IRVTGHbGyT0HqJ_849x7sG81IwEORundzkigvssw,,&typo=1><https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2f07d9c7c1-a7c1-455e-9f48-118f80602065n%2540googlegroups.com%3futm_medium%3demail%26utm_source%3dfooter&c=E,1,sEa8ox4pqO_Z-penI-ey70PqKPUou7emRV__N1diQx23WontwUfyndp0PjSBdhjZmn6OKE56PBZLF_XtrBHVGsLmHfUVUWEOMMBzDMjY5_oZbZ0dxqFRSPCb&typo=1>.

--
http://dotcms.com<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,10-r0H6sV_mmOaK8MDP8Of6vVf87C8NEmX2ibMo6-4bfG6JOFbLrXnYd7wBOx06TTO3U0MMx6FRb7wNrzdufIwcm6urSyPyEa4I0moHY0fEVzg,,&typo=1><https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,BUVsWHfJNAJnHYI8eTca3i6B-AXiH_tu-JWYCszgtFHjC4R8hc25FDzLRp_ZwGDf1_8-7q_ksGj5lc27PkyaFGwr81KQtqZS0d3vb7Ld2k51lA,,&typo=1> - Open Source Java Content Management
---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com<mailto:dotcms%2Bunsu...@googlegroups.com><mailto:dotcms+un...@googlegroups.com<mailto:dotcms%2Bunsu...@googlegroups.com>>.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/CAFeiKqN8gfJPQuqkbZkktpqHLFvZEsogrKd8qX_vH%2BxjpTJszQ%40mail.gmail.com<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2fCAFeiKqN8gfJPQuqkbZkktpqHLFvZEsogrKd8qX_vH%252BxjpTJszQ%2540mail.gmail.com&c=E,1,mN0cNYsBsHmogDCMQcixIjwLNfAH595OOt7lIMuYHmPAjNrOtRTTELLwQV42I2zXo8ATjS8zFcTom3-Z5n0W2DJ-UU4YLpzVqXjqyHJaP9l16bigVrU,&typo=1><https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2fCAFeiKqN8gfJPQuqkbZkktpqHLFvZEsogrKd8qX_vH%252BxjpTJszQ%2540mail.gmail.com%3futm_medium%3demail%26utm_source%3dfooter&c=E,1,8xWAOuEs7_hPALFwXmnPvr-LaAqdcOPOycZcvcIat9r8J2eLuDyxlVKQvDdDjvQjqFDIBZKobAtkmevjiAI0vzSERvdvjkHnoZIWG_cwJUI,&typo=1>.

--
http://dotcms.com<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,CdknWgf5H9fSR2mMNhyvm3-OqWYVINibLJairClJ_fccGTSBFs459jlD5yLo4YzeDtgmgYysvR09DL02mkEUbLqFW_tVey_TrwZetYNMexgXSELY&typo=1> - Open Source Java Content Management
---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com<mailto:dotcms%2Bunsu...@googlegroups.com>.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/1620740289862.63056%40gettysburg.edu<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2f1620740289862.63056%2540gettysburg.edu&c=E,1,Hdyp9HzfhGxBgDsLZjvfoZvGtVEosycMcl4Npe_TDRTMMYy5a8fk1CdjZ181jJ3QqFeQi8Yye_VJEmNcVBgA0kbu4jDmpRUBPdhIsNEAVIHbpw,,&typo=1>.

--
http://dotcms.com<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,DcQ3uEWm8cDeJRPMqnIBdIf591UjYaw_7mfrI9NcFOsB3iXwSS8cs1EoBtT7dcMc_lLjviUmOeUT9_GMHi9G9qDfgqNg9F5SCZVXXlml&typo=1> - Open Source Java Content Management
---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com<mailto:dotcms+un...@googlegroups.com>.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/CAFeiKqPsm2scpTPOAN3e-Za%2BO795Dw%2BAxNG2Vfc7DXQ3qO_4qA%40mail.gmail.com<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2fCAFeiKqPsm2scpTPOAN3e-Za%252BO795Dw%252BAxNG2Vfc7DXQ3qO_4qA%2540mail.gmail.com%3futm_medium%3demail%26utm_source%3dfooter&c=E,1,HnjpcOksTMXuw_lMNEh4ORvnnNNV7njpiuC5C0K7Yn759ywlriabhPOoAz3nC-CxKwUwcs2Ma5qri1-NbiCuxJAIMBpP3QxtF5rUM0iKBsQ-ARyM&typo=1>.

Nathan Keiter

unread,
May 11, 2021, 9:51:17 AM5/11/21
to dot...@googlegroups.com
Yes Mark,


It's a bug, but until they get it fixed pullRelatedField is the safest approach.

Nathan I. Keiter | Lead Network Applications Programmer | I.D.E.A Council Member
Gettysburg College | Information Technology | DataSystems
Campus Box 2453 | 300 North Washington Street | Gettysburg, PA 17325
Phone: 717.337.6993
https://www.gettysburg.edu<https://www.gettysburg.edu/>
________________________________
From: dot...@googlegroups.com <dot...@googlegroups.com> on behalf of Mark Pitely <pit...@maryu.marywood.edu>
Sent: Tuesday, May 11, 2021 9:43 AM
To: dot...@googlegroups.com
Subject: Re: [dotcms] No more columns for datatype:text

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
________________________________
Oh, wow, thanks for that heads' up!
I was actually going through some code to try to figure out why it failed as a logged in user; I thought it was my fault.
I don't usually test/develop that way. I use an incognito mode window for dotCMS and a plain window for the output (makes it easier to inspect).

Mark Pitely
Marywood University

On Tue, May 11, 2021 at 9:38 AM 'Nathan Keiter' via dotCMS User Group <dot...@googlegroups.com<mailto:dot...@googlegroups.com>> wrote:
The convenient dot notation (.) on the new relationships doesn't work if the user is logged in on the front end. It only works for non-logged-in users.


This would return null if the user is logged in. -> $con.extendedfields


https://github.com/dotCMS/core/issues/20331


If the user is logged, in you have to use pullRelatedField() instead.


#set( $relatedContent = $dotcontent.pullRelatedField( $con.id<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fcon.id&c=E,1,w_xy4p_CWtTrCoUvG6YxQ9VezhKB4Ap8kcaFGDcG__1u-cR1tvkaEBQIKg0_KPmBHv34vwaTPmB-wjeia-UDIUhOYfNMgPQ6CQES_Q0xEvXvF3qoAmE,&typo=1>, "ContentTypeVar.extendedfields", "", 1, $sortOrder))


$relatedContent.mynewfield

Nathan I. Keiter | Lead Network Applications Programmer | I.D.E.A Council Member
Gettysburg College | Information Technology | DataSystems
Campus Box 2453 | 300 North Washington Street | Gettysburg, PA 17325
Phone: 717.337.6993
From: dot...@googlegroups.com<mailto:dot...@googlegroups.com> <dot...@googlegroups.com<mailto:dot...@googlegroups.com>> on behalf of Mark Pitely <pit...@maryu.marywood.edu<mailto:pit...@maryu.marywood.edu>>
Sent: Monday, May 10, 2021 5:00 PM
To: dot...@googlegroups.com<mailto:dot...@googlegroups.com>
Subject: Re: [dotcms] No more columns for datatype:text

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
________________________________
I have been using the new Relationships - and they are absolutely wonderful. It seems like every problem I had in the past with them has been resolved.
So I am sorry if I scared you (or other people) off from using them. I'm not sure when they moved to these new ones.
So, I think you can easily extend a structure now with a 1:1 relationship to a different data structure and it will work basically seamlessly.
Structure 1: <hits limits on text fields>
Related Content -> Structure 2 <now has more fields>

You can simply pull from the first entry and do:
$con.extendedfields.mynewfield.

If you need me to explain more, let me know. I'm also guessing that you have hit the maximum number of text fields allowed in a single structure.

Mark Pitely
Marywood University

On Mon, May 10, 2021 at 4:45 PM Mark Orciuch <mark_o...@ngsltd.com<mailto:mark_o...@ngsltd.com><mailto:mark_o...@ngsltd.com<mailto:mark_o...@ngsltd.com>>> wrote:
Hello,

I received this error when attempting to add a new text field in custom content type. I though I saw a reference to workaround for this problem in a post but can't remember where. Many thanks in advance for a tip on resolving this.

[Image 2.png]

--
http://dotcms.com<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,y5SezWJpiwWaLzDzxYtOl2nh_QntBjO6Mexew7WrsRlzNVDIJXndtZVDopuj32qVHsL1WbF4LkUFyvc-NGWqPd1011Z-Omgm_-8v7rg0bvKBa6lUUUYwjzqm5A,,&typo=1><https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,R-7f4q4MphUQprfDHXGKFDVPnS-T6OaMQ1dBMT0GimvKEERyezBl38u1vLAc6ezGdy42s0rirP_DDRMzqHuew919ViGuhAD4uXh2AUKoom_I__aR7A,,&typo=1> - Open Source Java Content Management
---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com<mailto:dotcms%2Bunsu...@googlegroups.com><mailto:dotcms+un...@googlegroups.com<mailto:dotcms%2Bunsu...@googlegroups.com>>.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/07d9c7c1-a7c1-455e-9f48-118f80602065n%40googlegroups.com<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2f07d9c7c1-a7c1-455e-9f48-118f80602065n%2540googlegroups.com&c=E,1,tEC9VMI6-zMEY-Dg3YSVenkF91Hl_x5qj_hZPyduXE41EnQIKkOkA42vE0XcnuBzzY68jriXZIwEVV_1I8IRVTGHbGyT0HqJ_849x7sG81IwEORundzkigvssw,,&typo=1><https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2f07d9c7c1-a7c1-455e-9f48-118f80602065n%2540googlegroups.com%3futm_medium%3demail%26utm_source%3dfooter&c=E,1,sEa8ox4pqO_Z-penI-ey70PqKPUou7emRV__N1diQx23WontwUfyndp0PjSBdhjZmn6OKE56PBZLF_XtrBHVGsLmHfUVUWEOMMBzDMjY5_oZbZ0dxqFRSPCb&typo=1>.

--
http://dotcms.com<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,10-r0H6sV_mmOaK8MDP8Of6vVf87C8NEmX2ibMo6-4bfG6JOFbLrXnYd7wBOx06TTO3U0MMx6FRb7wNrzdufIwcm6urSyPyEa4I0moHY0fEVzg,,&typo=1><https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,BUVsWHfJNAJnHYI8eTca3i6B-AXiH_tu-JWYCszgtFHjC4R8hc25FDzLRp_ZwGDf1_8-7q_ksGj5lc27PkyaFGwr81KQtqZS0d3vb7Ld2k51lA,,&typo=1> - Open Source Java Content Management
---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com<mailto:dotcms%2Bunsu...@googlegroups.com><mailto:dotcms+un...@googlegroups.com<mailto:dotcms%2Bunsu...@googlegroups.com>>.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/CAFeiKqN8gfJPQuqkbZkktpqHLFvZEsogrKd8qX_vH%2BxjpTJszQ%40mail.gmail.com<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2fCAFeiKqN8gfJPQuqkbZkktpqHLFvZEsogrKd8qX_vH%252BxjpTJszQ%2540mail.gmail.com&c=E,1,mN0cNYsBsHmogDCMQcixIjwLNfAH595OOt7lIMuYHmPAjNrOtRTTELLwQV42I2zXo8ATjS8zFcTom3-Z5n0W2DJ-UU4YLpzVqXjqyHJaP9l16bigVrU,&typo=1><https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2fCAFeiKqN8gfJPQuqkbZkktpqHLFvZEsogrKd8qX_vH%252BxjpTJszQ%2540mail.gmail.com%3futm_medium%3demail%26utm_source%3dfooter&c=E,1,8xWAOuEs7_hPALFwXmnPvr-LaAqdcOPOycZcvcIat9r8J2eLuDyxlVKQvDdDjvQjqFDIBZKobAtkmevjiAI0vzSERvdvjkHnoZIWG_cwJUI,&typo=1>.

--
http://dotcms.com<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,CdknWgf5H9fSR2mMNhyvm3-OqWYVINibLJairClJ_fccGTSBFs459jlD5yLo4YzeDtgmgYysvR09DL02mkEUbLqFW_tVey_TrwZetYNMexgXSELY&typo=1> - Open Source Java Content Management
---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com<mailto:dotcms%2Bunsu...@googlegroups.com>.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/1620740289862.63056%40gettysburg.edu<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2f1620740289862.63056%2540gettysburg.edu&c=E,1,Hdyp9HzfhGxBgDsLZjvfoZvGtVEosycMcl4Npe_TDRTMMYy5a8fk1CdjZ181jJ3QqFeQi8Yye_VJEmNcVBgA0kbu4jDmpRUBPdhIsNEAVIHbpw,,&typo=1>.

--
http://dotcms.com<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,DcQ3uEWm8cDeJRPMqnIBdIf591UjYaw_7mfrI9NcFOsB3iXwSS8cs1EoBtT7dcMc_lLjviUmOeUT9_GMHi9G9qDfgqNg9F5SCZVXXlml&typo=1> - Open Source Java Content Management
---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com<mailto:dotcms+un...@googlegroups.com>.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/CAFeiKqPsm2scpTPOAN3e-Za%2BO795Dw%2BAxNG2Vfc7DXQ3qO_4qA%40mail.gmail.com<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2fCAFeiKqPsm2scpTPOAN3e-Za%252BO795Dw%252BAxNG2Vfc7DXQ3qO_4qA%2540mail.gmail.com%3futm_medium%3demail%26utm_source%3dfooter&c=E,1,HnjpcOksTMXuw_lMNEh4ORvnnNNV7njpiuC5C0K7Yn759ywlriabhPOoAz3nC-CxKwUwcs2Ma5qri1-NbiCuxJAIMBpP3QxtF5rUM0iKBsQ-ARyM&typo=1>.

Mark Pitely

unread,
May 11, 2021, 9:58:37 AM5/11/21
to dot...@googlegroups.com
A bug I can live with for the extraordinary power it gives- and with a workaround if I really need it.
Thanks for finding and reporting it.
As a bonus, it looks like we poked Will into upping the severity.

Mark Pitley


--
http://dotcms.com - Open Source Java Content Management

---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/1620741073382.84810%40gettysburg.edu.

Mark Orciuch

unread,
May 11, 2021, 10:24:31 AM5/11/21
to dotCMS User Group
Wow, thanks everyone for the wealth of information! I am also a big fan of the relationship fields although, in this case, I will probably use a textarea field. But it's great to add all these tips and techniques to my dotCMS war chest. Thanks again!

Nathan Keiter

unread,
May 11, 2021, 10:44:29 AM5/11/21
to dot...@googlegroups.com
Yes as Xander mentioned the max limit for any field data type is 25. Switching data-types when possible is probably the easiest option. When creating a new content type it is best to plan it out in advance, but not always possible.


Under the hood this is because the contentlet table is denormalized.


This schema paradigm was probably chosen at the time because checking foreign keys on multiple related tables for field content was slower. I'm sure it makes the indexing scheme easier as well.

Nathan I. Keiter | Lead Network Applications Programmer | I.D.E.A Council Member
Gettysburg College | Information Technology | DataSystems
Campus Box 2453 | 300 North Washington Street | Gettysburg, PA 17325
Phone: 717.337.6993
https://www.gettysburg.edu<https://www.gettysburg.edu/>
________________________________
From: dot...@googlegroups.com <dot...@googlegroups.com> on behalf of Mark Orciuch <mark_o...@ngsltd.com>
Sent: Tuesday, May 11, 2021 10:24 AM
To: dotCMS User Group
Subject: Re: [dotcms] No more columns for datatype:text

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
________________________________
Wow, thanks everyone for the wealth of information! I am also a big fan of the relationship fields although, in this case, I will probably use a textarea field. But it's great to add all these tips and techniques to my dotCMS war chest. Thanks again!

On Tuesday, May 11, 2021 at 8:58:37 AM UTC-5 Mark Pitely wrote:
A bug I can live with for the extraordinary power it gives- and with a workaround if I really need it.
Thanks for finding and reporting it.
As a bonus, it looks like we poked Will into upping the severity.

Mark Pitley


On Tue, May 11, 2021 at 9:51 AM 'Nathan Keiter' via dotCMS User Group <dot...@googlegroups.com> wrote:
Yes Mark,


It's a bug, but until they get it fixed pullRelatedField is the safest approach.

Nathan I. Keiter | Lead Network Applications Programmer | I.D.E.A Council Member
Gettysburg College | Information Technology | DataSystems
Campus Box 2453 | 300 North Washington Street | Gettysburg, PA 17325
Phone: 717.337.6993<tel:(717)%20337-6993>
https://www.gettysburg.edu<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fwww.gettysburg.edu&c=E,1,880yvgFSTPckZ6nEGm1IWaiB7iWjDCBdQIqk-bXvO1oZGzAVGDyyGm3UwKMO5IBnQrCaNtVEGXnIk-xCylsfTYBreXzuFl8xOacI8lMn4gpcksaE2jeNQS94KDc,&typo=1><https://www.gettysburg.edu/<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fwww.gettysburg.edu%2f&c=E,1,rBQw_vb65W3Yoql9L8YTspgQbXdid8EJEL9ONEe6Jwt37bddQzpn051VyxVSc4xf-ddwvIsOnj7MuNsT84Lfq6x1eYlKKIxmT3EEcxdmQzUnQ8CamgUI&typo=1>>
________________________________
From: dot...@googlegroups.com <dot...@googlegroups.com> on behalf of Mark Pitely <pit...@maryu.marywood.edu>
Sent: Tuesday, May 11, 2021 9:43 AM
To: dot...@googlegroups.com
Subject: Re: [dotcms] No more columns for datatype:text

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
________________________________
Oh, wow, thanks for that heads' up!
I was actually going through some code to try to figure out why it failed as a logged in user; I thought it was my fault.
I don't usually test/develop that way. I use an incognito mode window for dotCMS and a plain window for the output (makes it easier to inspect).

Mark Pitely
Marywood University

On Tue, May 11, 2021 at 9:38 AM 'Nathan Keiter' via dotCMS User Group <dot...@googlegroups.com<mailto:dot...@googlegroups.com>> wrote:
The convenient dot notation (.) on the new relationships doesn't work if the user is logged in on the front end. It only works for non-logged-in users.


This would return null if the user is logged in. -> $con.extendedfields


https://github.com/dotCMS/core/issues/20331


If the user is logged, in you have to use pullRelatedField() instead.


#set( $relatedContent = $dotcontent.pullRelatedField( $con.id<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fcon.id&c=E,1,763P6Vowcc38IKho2dX2PCHB6Gog05nHNJ7Plw3pOeQnos2b4WCCJgek2ixO9G1zYoNtA8daN4unvUlqghlLsWnmyYkUXFiZjpIKe1u7pSJFHM_oFh5CdHH_8w,,&typo=1><https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fcon.id&c=E,1,w_xy4p_CWtTrCoUvG6YxQ9VezhKB4Ap8kcaFGDcG__1u-cR1tvkaEBQIKg0_KPmBHv34vwaTPmB-wjeia-UDIUhOYfNMgPQ6CQES_Q0xEvXvF3qoAmE,&typo=1>, "ContentTypeVar.extendedfields", "", 1, $sortOrder))


$relatedContent.mynewfield

Nathan I. Keiter | Lead Network Applications Programmer | I.D.E.A Council Member
Gettysburg College | Information Technology | DataSystems
Campus Box 2453 | 300 North Washington Street | Gettysburg, PA 17325
Phone: 717.337.6993<tel:(717)%20337-6993>
https://www.gettysburg.edu<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fwww.gettysburg.edu&c=E,1,XPlcDdJNmxscRE_ofzM_vXhFgoFToPa3cOvKo7Rp1opQjGzE6gm2kmF582Y3OdUgcqiVASfIQAKl9Ldp7QSiBtKhdTQiEeR-S7EFHKMMOA,,&typo=1><https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fwww.gettysburg.edu&c=E,1,OftsNsKiQXKVcpI25cwcCp5V0gncTyTmZ3HC4l2zZApPXuk-2CKkPYVi-cnKFHu7o0EF4iAkSinqx6Ube35GlHlM4GhV_AaPRpfsgAdaEzuv8a2lviilubbTsQ,,&typo=1><https://www.gettysburg.edu/<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fwww.gettysburg.edu%2f&c=E,1,Xi3LhCmtJy9IgB6SqLpnYDzropGcr7F7J5wL7lv_-6rV-Zarctz1cM37c7F2kIN7OOXo38AVMGBhBKuObnbwd2haDa93aGkFzZG5sK5NSVvqbYLSQqs1bQ,,&typo=1><https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fwww.gettysburg.edu%2f&c=E,1,JOkifu4u4mMy_fUx4dkQyst19JmjogpFf9ZvDSUeEfS6Tv7vIUc6TbvMYS1yw7orqConk6G3FvShIHWI2_DqoYllnfGP3OhNGkVIl2hdEWrWB2iNZT4,&typo=1>>
________________________________
From: dot...@googlegroups.com<mailto:dot...@googlegroups.com> <dot...@googlegroups.com<mailto:dot...@googlegroups.com>> on behalf of Mark Pitely <pit...@maryu.marywood.edu<mailto:pit...@maryu.marywood.edu>>
Sent: Monday, May 10, 2021 5:00 PM
To: dot...@googlegroups.com<mailto:dot...@googlegroups.com>
Subject: Re: [dotcms] No more columns for datatype:text

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
________________________________
I have been using the new Relationships - and they are absolutely wonderful. It seems like every problem I had in the past with them has been resolved.
So I am sorry if I scared you (or other people) off from using them. I'm not sure when they moved to these new ones.
So, I think you can easily extend a structure now with a 1:1 relationship to a different data structure and it will work basically seamlessly.
Structure 1: <hits limits on text fields>
Related Content -> Structure 2 <now has more fields>

You can simply pull from the first entry and do:
$con.extendedfields.mynewfield.

If you need me to explain more, let me know. I'm also guessing that you have hit the maximum number of text fields allowed in a single structure.

Mark Pitely
Marywood University

On Mon, May 10, 2021 at 4:45 PM Mark Orciuch <mark_o...@ngsltd.com<mailto:mark_o...@ngsltd.com><mailto:mark_o...@ngsltd.com<mailto:mark_o...@ngsltd.com>>> wrote:
Hello,

I received this error when attempting to add a new text field in custom content type. I though I saw a reference to workaround for this problem in a post but can't remember where. Many thanks in advance for a tip on resolving this.

[Image 2.png]

--
http://dotcms.com<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,LMIbNRdMYsQoQCh1Gv_eiaWIQDi72XMefd3Kmg9hzr6dQVlISn_sw4OSWUpTPwjlNDk1XBBttHsWGcSUyBFH5y_lP_p2FK0KBUa5u9wekIyJ4tw0ZPxl_hYW1g,,&typo=1><https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,y5SezWJpiwWaLzDzxYtOl2nh_QntBjO6Mexew7WrsRlzNVDIJXndtZVDopuj32qVHsL1WbF4LkUFyvc-NGWqPd1011Z-Omgm_-8v7rg0bvKBa6lUUUYwjzqm5A,,&typo=1><https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,R-7f4q4MphUQprfDHXGKFDVPnS-T6OaMQ1dBMT0GimvKEERyezBl38u1vLAc6ezGdy42s0rirP_DDRMzqHuew919ViGuhAD4uXh2AUKoom_I__aR7A,,&typo=1> - Open Source Java Content Management
---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com<mailto:dotcms%2Bunsu...@googlegroups.com><mailto:dotcms+un...@googlegroups.com<mailto:dotcms%2Bunsu...@googlegroups.com>>.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/07d9c7c1-a7c1-455e-9f48-118f80602065n%40googlegroups.com<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2f07d9c7c1-a7c1-455e-9f48-118f80602065n%2540googlegroups.com&c=E,1,jMfPLOXxmBtl6O2Gdt9WTvS-_SYnmvPqBYTBkkUAyy5bqn7BZJ4xhYFcV9KCWuYCecy6IdZgQtEkta9HtToPMjhDJz78YMvrXrDxMd5wiX3n0xMldz9Sh6bS1zQ,&typo=1><https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2f07d9c7c1-a7c1-455e-9f48-118f80602065n%2540googlegroups.com&c=E,1,tEC9VMI6-zMEY-Dg3YSVenkF91Hl_x5qj_hZPyduXE41EnQIKkOkA42vE0XcnuBzzY68jriXZIwEVV_1I8IRVTGHbGyT0HqJ_849x7sG81IwEORundzkigvssw,,&typo=1><https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2f07d9c7c1-a7c1-455e-9f48-118f80602065n%2540googlegroups.com%3futm_medium%3demail%26utm_source%3dfooter&c=E,1,sEa8ox4pqO_Z-penI-ey70PqKPUou7emRV__N1diQx23WontwUfyndp0PjSBdhjZmn6OKE56PBZLF_XtrBHVGsLmHfUVUWEOMMBzDMjY5_oZbZ0dxqFRSPCb&typo=1>.

--
http://dotcms.com<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,gZNrbs6deOwMdmJ9J3dfq_tf5CPQfwUg-JuCTH8eLh3qjBnHdeytcgiCGXTHK3nQJ851_qM_anw_oZW_DoMEspzqqNUQOlZQkL9PjwJwNdM,&typo=1><https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,10-r0H6sV_mmOaK8MDP8Of6vVf87C8NEmX2ibMo6-4bfG6JOFbLrXnYd7wBOx06TTO3U0MMx6FRb7wNrzdufIwcm6urSyPyEa4I0moHY0fEVzg,,&typo=1><https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,BUVsWHfJNAJnHYI8eTca3i6B-AXiH_tu-JWYCszgtFHjC4R8hc25FDzLRp_ZwGDf1_8-7q_ksGj5lc27PkyaFGwr81KQtqZS0d3vb7Ld2k51lA,,&typo=1> - Open Source Java Content Management
---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com<mailto:dotcms%2Bunsu...@googlegroups.com><mailto:dotcms+un...@googlegroups.com<mailto:dotcms%2Bunsu...@googlegroups.com>>.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/CAFeiKqN8gfJPQuqkbZkktpqHLFvZEsogrKd8qX_vH%2BxjpTJszQ%40mail.gmail.com<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2fCAFeiKqN8gfJPQuqkbZkktpqHLFvZEsogrKd8qX_vH%252BxjpTJszQ%2540mail.gmail.com&c=E,1,zmphyrguukpHdMmn0jP3E1R_2l2d2ZEgyusycKu5LWAXpSZ0J-E5cEyZfuiYge3Rv-cSxPX_uPNhLqDUoNBjhIZqflpHc8GkSPEYounKGNKX&typo=1><https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2fCAFeiKqN8gfJPQuqkbZkktpqHLFvZEsogrKd8qX_vH%252BxjpTJszQ%2540mail.gmail.com&c=E,1,mN0cNYsBsHmogDCMQcixIjwLNfAH595OOt7lIMuYHmPAjNrOtRTTELLwQV42I2zXo8ATjS8zFcTom3-Z5n0W2DJ-UU4YLpzVqXjqyHJaP9l16bigVrU,&typo=1><https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2fCAFeiKqN8gfJPQuqkbZkktpqHLFvZEsogrKd8qX_vH%252BxjpTJszQ%2540mail.gmail.com%3futm_medium%3demail%26utm_source%3dfooter&c=E,1,8xWAOuEs7_hPALFwXmnPvr-LaAqdcOPOycZcvcIat9r8J2eLuDyxlVKQvDdDjvQjqFDIBZKobAtkmevjiAI0vzSERvdvjkHnoZIWG_cwJUI,&typo=1>.

--
http://dotcms.com<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,JQ1P3z4Dia2DDYX-nrP5MSFbHn9p15VbKP6FjHBAAgAa8y2C28ECPW_dHekNb6gT_QLugT0RUkAvvERtmgwvGxIMRLOt5lTvX-6uyiobHJNkdfUojg3syCjh&typo=1><https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,CdknWgf5H9fSR2mMNhyvm3-OqWYVINibLJairClJ_fccGTSBFs459jlD5yLo4YzeDtgmgYysvR09DL02mkEUbLqFW_tVey_TrwZetYNMexgXSELY&typo=1> - Open Source Java Content Management
---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com<mailto:dotcms%2Bunsu...@googlegroups.com>.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/1620740289862.63056%40gettysburg.edu<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2f1620740289862.63056%2540gettysburg.edu&c=E,1,IJkLWQK2RnrRzteViSbjtwhJr3swEXUyXEv4gxCbY0X8aALT1mk-zZAOKYzbs9hLDX5gz4QyvcLG_KhvidAnR5ze57OHs4H41EeZ7043_GMhyhEa&typo=1><https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2f1620740289862.63056%2540gettysburg.edu&c=E,1,Hdyp9HzfhGxBgDsLZjvfoZvGtVEosycMcl4Npe_TDRTMMYy5a8fk1CdjZ181jJ3QqFeQi8Yye_VJEmNcVBgA0kbu4jDmpRUBPdhIsNEAVIHbpw,,&typo=1>.

--
http://dotcms.com<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,Y1jrL_pl4dB-a2VHRdKL6RbAtoT4tAsd4l-8l3t489TfH0-7IyqimyjkqI4PyavTwxvBBd0S930CPSTtfjth8LdaDwvxBMNuTAGEQ2SPo3tVvV7qektDMZ3UDA,,&typo=1><https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,DcQ3uEWm8cDeJRPMqnIBdIf591UjYaw_7mfrI9NcFOsB3iXwSS8cs1EoBtT7dcMc_lLjviUmOeUT9_GMHi9G9qDfgqNg9F5SCZVXXlml&typo=1> - Open Source Java Content Management
---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com<mailto:dotcms+un...@googlegroups.com>.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/CAFeiKqPsm2scpTPOAN3e-Za%2BO795Dw%2BAxNG2Vfc7DXQ3qO_4qA%40mail.gmail.com<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2fCAFeiKqPsm2scpTPOAN3e-Za%252BO795Dw%252BAxNG2Vfc7DXQ3qO_4qA%2540mail.gmail.com&c=E,1,BS4pyH73vIxjgd0cz01XS8-yjR9nIozXxBQ6Ey2h0QDVi8x2w7SJWS8tPDflPmtqn7wSm6JTJfFHF3a-7f4g2TquP_RRl8e58A1AXzZapMNRoLj5hdCWoW9p&typo=1><https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2fCAFeiKqPsm2scpTPOAN3e-Za%252BO795Dw%252BAxNG2Vfc7DXQ3qO_4qA%2540mail.gmail.com%3futm_medium%3demail%26utm_source%3dfooter&c=E,1,HnjpcOksTMXuw_lMNEh4ORvnnNNV7njpiuC5C0K7Yn759ywlriabhPOoAz3nC-CxKwUwcs2Ma5qri1-NbiCuxJAIMBpP3QxtF5rUM0iKBsQ-ARyM&typo=1>.

--
http://dotcms.com<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,wXO1ZdYd_Mk4IrUw-zWU99_vS7b2hQLLXavPcS8dJJ5SRJ5O3fVUUjD3OXcY-AZJeqBfoxrVnNsxXqBa8MxYoir127j4WrWTZkOGu8OxQgw,&typo=1> - Open Source Java Content Management

---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/1620741073382.84810%40gettysburg.edu<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2f1620741073382.84810%2540gettysburg.edu&c=E,1,iqr4IU_etL1_lsc29IpZxREly1eikzGSpU1OZgmy-mLmQZzuddfOqrLGnyFRdDO46Ui1PGVaEGb2cqvamRSvfBlBXxFW6--uAOmEoPT2mgH-WKI3_klhEZVkL30,&typo=1>.

--
http://dotcms.com<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fdotcms.com&c=E,1,f_vET1nMZxHh8a_aNBfTpiu7hDSFGsCBCo8--QE3XDnZHFUqHYrw86CKQTd7ZRYod9mpli9VfNGAY3Z-IUXdx1IsXEXGV4DLRNkItpAl&typo=1> - Open Source Java Content Management
---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com<mailto:dotcms+un...@googlegroups.com>.
To view this discussion on the web visit https://groups.google.com/d/msgid/dotcms/cc32db45-e433-4725-806d-0a8f1f6ab80en%40googlegroups.com<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2fdotcms%2fcc32db45-e433-4725-806d-0a8f1f6ab80en%2540googlegroups.com%3futm_medium%3demail%26utm_source%3dfooter&c=E,1,ln-8QhnSZofnO6u6Lyld5vuD7oxJyWZbpJdrzLKYAkjdPumpqzIJJrfgHgXSwkXzQavPmozVOZyfjZ91Sebw7taxHuN2CLb1-HYZmvZP&typo=1>.

Mark Pitely

unread,
May 11, 2021, 11:04:31 AM5/11/21
to dot...@googlegroups.com
You are officially 'one of us' when you run up against the 25 text field limitation: it means you are really pushing the system.
The second sign is when you can no longer use the 'download zip' feature to backup because you hit the 2gb db limit. (Actually, I have no idea if that limitation is still there, or exactly what the number is, just that after a certain point you have to do manual db dumps)
Mark

--
http://dotcms.com - Open Source Java Content Management

---
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com.

Mark Orciuch

unread,
May 11, 2021, 11:15:39 AM5/11/21
to dotCMS User Group
I am honored to have joined the 25 Text Field Limitation Club! As for the backup zip size, I am halfway there :-)

Falzone, Chris

unread,
May 12, 2021, 9:01:37 AM5/12/21
to dot...@googlegroups.com
Since I didn't see anyone mention it, another way to get around the field limit is to use Key Value Pair fields.  You can stuff a lot of fields into one field that way.  Though the UI is not great for editors.  I use this in a couple of structures where the data is coming in from a json api anyway.  Instead of making individual fields for all of the 300 some data points, I just stuff the json response in the key value pair field and then in the front-end code that is easily parsable.  

Hope it helps!



--

Christopher Falzone

DevOps Engineer

A Q U E N T  /  VITAMIN T

Mark Orciuch

unread,
May 16, 2021, 6:22:05 PM5/16/21
to dotCMS User Group
Hi Chris,

This is a great option. Would you mind sharing a code example on how to initialize this type field in json api? Many thanks in advance.

Falzone, Chris

unread,
May 17, 2021, 7:15:09 AM5/17/21
to dot...@googlegroups.com
I'm afraid that in this case we do this via the Java Contentlet API not the rest api.  In this case it's quite straight forward, you can set it like any other string property on a field and just pass it in the json as a string.

So something like ...

String jsonForField = "{'key':'pair', 'key2':'value'}";
cont.setStringProperty(myKeyValueField, jsonForField);

... and then checkin and all that.  

I don't have an example using the rest api.  But I assume it is the same.  You would just pass the key value pair as a string of JSON, but the encoding would be difficult to achieve by hand.


Mark Orciuch

unread,
May 17, 2021, 11:51:32 AM5/17/21
to dotCMS User Group
Hi Chris,

Thanks for the pointer! I used something like this in JavaScript to initialize key/value field and it worked: 

dataObj.test = "{'key1':'value1', 'key2':'value2'}";

Reply all
Reply to author
Forward
0 new messages