Ghost field in Templavoilà











up vote
0
down vote

favorite












I'm using this bit of Typoscript to generate some text.
field_test is created via TemplavoilàPlus.



# If field_test is filled in by the redactor,
# its content will be displayed in the frontend.

10 = TEXT
10.if.isTrue.field = field_test
10.value.field = field_test


I'm using several FCE from TV+ and I have many more fields handled via Typoscript. For some FCE, I didn't set field_test in TV+ and thus, it is not displayed in the frontend at all since the redactor can't fill it in in the backend. This is the normal behaviour.



However, for one the FCE, field_test is displayed anyway. This field is not set in TV+ and I can't find it in the XML. It is not displayed in the backend and then can't be filled in.



But it has existed at some point, and has been filled before it was removed from the TV+ FCE.



Now I have its ghost displayed in the frontend. How can I find it and delete it for good?










share|improve this question


























    up vote
    0
    down vote

    favorite












    I'm using this bit of Typoscript to generate some text.
    field_test is created via TemplavoilàPlus.



    # If field_test is filled in by the redactor,
    # its content will be displayed in the frontend.

    10 = TEXT
    10.if.isTrue.field = field_test
    10.value.field = field_test


    I'm using several FCE from TV+ and I have many more fields handled via Typoscript. For some FCE, I didn't set field_test in TV+ and thus, it is not displayed in the frontend at all since the redactor can't fill it in in the backend. This is the normal behaviour.



    However, for one the FCE, field_test is displayed anyway. This field is not set in TV+ and I can't find it in the XML. It is not displayed in the backend and then can't be filled in.



    But it has existed at some point, and has been filled before it was removed from the TV+ FCE.



    Now I have its ghost displayed in the frontend. How can I find it and delete it for good?










    share|improve this question
























      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      I'm using this bit of Typoscript to generate some text.
      field_test is created via TemplavoilàPlus.



      # If field_test is filled in by the redactor,
      # its content will be displayed in the frontend.

      10 = TEXT
      10.if.isTrue.field = field_test
      10.value.field = field_test


      I'm using several FCE from TV+ and I have many more fields handled via Typoscript. For some FCE, I didn't set field_test in TV+ and thus, it is not displayed in the frontend at all since the redactor can't fill it in in the backend. This is the normal behaviour.



      However, for one the FCE, field_test is displayed anyway. This field is not set in TV+ and I can't find it in the XML. It is not displayed in the backend and then can't be filled in.



      But it has existed at some point, and has been filled before it was removed from the TV+ FCE.



      Now I have its ghost displayed in the frontend. How can I find it and delete it for good?










      share|improve this question













      I'm using this bit of Typoscript to generate some text.
      field_test is created via TemplavoilàPlus.



      # If field_test is filled in by the redactor,
      # its content will be displayed in the frontend.

      10 = TEXT
      10.if.isTrue.field = field_test
      10.value.field = field_test


      I'm using several FCE from TV+ and I have many more fields handled via Typoscript. For some FCE, I didn't set field_test in TV+ and thus, it is not displayed in the frontend at all since the redactor can't fill it in in the backend. This is the normal behaviour.



      However, for one the FCE, field_test is displayed anyway. This field is not set in TV+ and I can't find it in the XML. It is not displayed in the backend and then can't be filled in.



      But it has existed at some point, and has been filled before it was removed from the TV+ FCE.



      Now I have its ghost displayed in the frontend. How can I find it and delete it for good?







      typo3 typoscript typo3-7.6.x templavoila






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 19 at 11:01









      CCR

      45115




      45115
























          2 Answers
          2






          active

          oldest

          votes

















          up vote
          0
          down vote













          you need to identify those CEs which have set field_test and where this field should be empty.



          You could edit every CE, change it's type to a type where the field id visible, check for empty and change type back to origin.



          or you do some immediate SQL queries in a tool like phpmyadmin:



          select * from tt_content where field_test!='' and (CType = ...)





          share|improve this answer




























            up vote
            0
            down vote



            accepted










            I've found a workaround for my problem.



            I simply recreated field_test in TV+, went to the backend to empty the content of that field (which was filled even though the field had been deleted).



            Conclusion: When you delete a field in TV+, the content of that field still exist somewhere…






            share|improve this answer





















            • that is 'usual' behaviour of flexform data in TYPO3 as the data is stored as XML in one database field. The XML is extracted as an array, data is modified/added and stored back as XML. in this way no XML field gets deleted. If you write new data (array) to the field the array is merged with the existing. to clean up the XML (delete unused fields) you need to explicit clean up the `pi_flexform' field (overwrite with empty string) and then write the array with active data.
              – Bernd Wilke πφ
              Nov 20 at 6:43











            Your Answer






            StackExchange.ifUsing("editor", function () {
            StackExchange.using("externalEditor", function () {
            StackExchange.using("snippets", function () {
            StackExchange.snippets.init();
            });
            });
            }, "code-snippets");

            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "1"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














            draft saved

            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53373193%2fghost-field-in-templavoil%25c3%25a0%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            2 Answers
            2






            active

            oldest

            votes








            2 Answers
            2






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes








            up vote
            0
            down vote













            you need to identify those CEs which have set field_test and where this field should be empty.



            You could edit every CE, change it's type to a type where the field id visible, check for empty and change type back to origin.



            or you do some immediate SQL queries in a tool like phpmyadmin:



            select * from tt_content where field_test!='' and (CType = ...)





            share|improve this answer

























              up vote
              0
              down vote













              you need to identify those CEs which have set field_test and where this field should be empty.



              You could edit every CE, change it's type to a type where the field id visible, check for empty and change type back to origin.



              or you do some immediate SQL queries in a tool like phpmyadmin:



              select * from tt_content where field_test!='' and (CType = ...)





              share|improve this answer























                up vote
                0
                down vote










                up vote
                0
                down vote









                you need to identify those CEs which have set field_test and where this field should be empty.



                You could edit every CE, change it's type to a type where the field id visible, check for empty and change type back to origin.



                or you do some immediate SQL queries in a tool like phpmyadmin:



                select * from tt_content where field_test!='' and (CType = ...)





                share|improve this answer












                you need to identify those CEs which have set field_test and where this field should be empty.



                You could edit every CE, change it's type to a type where the field id visible, check for empty and change type back to origin.



                or you do some immediate SQL queries in a tool like phpmyadmin:



                select * from tt_content where field_test!='' and (CType = ...)






                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 19 at 14:52









                Bernd Wilke πφ

                4,6611724




                4,6611724
























                    up vote
                    0
                    down vote



                    accepted










                    I've found a workaround for my problem.



                    I simply recreated field_test in TV+, went to the backend to empty the content of that field (which was filled even though the field had been deleted).



                    Conclusion: When you delete a field in TV+, the content of that field still exist somewhere…






                    share|improve this answer





















                    • that is 'usual' behaviour of flexform data in TYPO3 as the data is stored as XML in one database field. The XML is extracted as an array, data is modified/added and stored back as XML. in this way no XML field gets deleted. If you write new data (array) to the field the array is merged with the existing. to clean up the XML (delete unused fields) you need to explicit clean up the `pi_flexform' field (overwrite with empty string) and then write the array with active data.
                      – Bernd Wilke πφ
                      Nov 20 at 6:43















                    up vote
                    0
                    down vote



                    accepted










                    I've found a workaround for my problem.



                    I simply recreated field_test in TV+, went to the backend to empty the content of that field (which was filled even though the field had been deleted).



                    Conclusion: When you delete a field in TV+, the content of that field still exist somewhere…






                    share|improve this answer





















                    • that is 'usual' behaviour of flexform data in TYPO3 as the data is stored as XML in one database field. The XML is extracted as an array, data is modified/added and stored back as XML. in this way no XML field gets deleted. If you write new data (array) to the field the array is merged with the existing. to clean up the XML (delete unused fields) you need to explicit clean up the `pi_flexform' field (overwrite with empty string) and then write the array with active data.
                      – Bernd Wilke πφ
                      Nov 20 at 6:43













                    up vote
                    0
                    down vote



                    accepted







                    up vote
                    0
                    down vote



                    accepted






                    I've found a workaround for my problem.



                    I simply recreated field_test in TV+, went to the backend to empty the content of that field (which was filled even though the field had been deleted).



                    Conclusion: When you delete a field in TV+, the content of that field still exist somewhere…






                    share|improve this answer












                    I've found a workaround for my problem.



                    I simply recreated field_test in TV+, went to the backend to empty the content of that field (which was filled even though the field had been deleted).



                    Conclusion: When you delete a field in TV+, the content of that field still exist somewhere…







                    share|improve this answer












                    share|improve this answer



                    share|improve this answer










                    answered Nov 19 at 15:03









                    CCR

                    45115




                    45115












                    • that is 'usual' behaviour of flexform data in TYPO3 as the data is stored as XML in one database field. The XML is extracted as an array, data is modified/added and stored back as XML. in this way no XML field gets deleted. If you write new data (array) to the field the array is merged with the existing. to clean up the XML (delete unused fields) you need to explicit clean up the `pi_flexform' field (overwrite with empty string) and then write the array with active data.
                      – Bernd Wilke πφ
                      Nov 20 at 6:43


















                    • that is 'usual' behaviour of flexform data in TYPO3 as the data is stored as XML in one database field. The XML is extracted as an array, data is modified/added and stored back as XML. in this way no XML field gets deleted. If you write new data (array) to the field the array is merged with the existing. to clean up the XML (delete unused fields) you need to explicit clean up the `pi_flexform' field (overwrite with empty string) and then write the array with active data.
                      – Bernd Wilke πφ
                      Nov 20 at 6:43
















                    that is 'usual' behaviour of flexform data in TYPO3 as the data is stored as XML in one database field. The XML is extracted as an array, data is modified/added and stored back as XML. in this way no XML field gets deleted. If you write new data (array) to the field the array is merged with the existing. to clean up the XML (delete unused fields) you need to explicit clean up the `pi_flexform' field (overwrite with empty string) and then write the array with active data.
                    – Bernd Wilke πφ
                    Nov 20 at 6:43




                    that is 'usual' behaviour of flexform data in TYPO3 as the data is stored as XML in one database field. The XML is extracted as an array, data is modified/added and stored back as XML. in this way no XML field gets deleted. If you write new data (array) to the field the array is merged with the existing. to clean up the XML (delete unused fields) you need to explicit clean up the `pi_flexform' field (overwrite with empty string) and then write the array with active data.
                    – Bernd Wilke πφ
                    Nov 20 at 6:43


















                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Stack Overflow!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.





                    Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


                    Please pay close attention to the following guidance:


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53373193%2fghost-field-in-templavoil%25c3%25a0%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    "Incorrect syntax near the keyword 'ON'. (on update cascade, on delete cascade,)

                    Alcedinidae

                    RAC Tourist Trophy