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 2 days ago









      CCR

      43115




      43115
























          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 πφ
              yesterday











            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 yesterday









                Bernd Wilke πφ

                4,5961724




                4,5961724
























                    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 πφ
                      yesterday















                    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 πφ
                      yesterday













                    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 yesterday









                    CCR

                    43115




                    43115












                    • 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 πφ
                      yesterday


















                    • 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 πφ
                      yesterday
















                    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 πφ
                    yesterday




                    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 πφ
                    yesterday


















                     

                    draft saved


                    draft discarded



















































                     


                    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

                    android studio warns about leanback feature tag usage required on manifest while using Unity exported app?

                    SQL update select statement

                    WPF add header to Image with URL pettitions [duplicate]