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