Ghost field in Templavoilà












0















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



























    0















    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

























      0












      0








      0








      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 '18 at 11:01









      CCRCCR

      45115




      45115
























          2 Answers
          2






          active

          oldest

          votes


















          0














          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































            0














            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 '18 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',
            autoActivateHeartbeat: false,
            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









            0














            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




























              0














              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


























                0












                0








                0







                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 '18 at 14:52









                Bernd Wilke πφBernd Wilke πφ

                4,9411724




                4,9411724

























                    0














                    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 '18 at 6:43
















                    0














                    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 '18 at 6:43














                    0












                    0








                    0







                    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 '18 at 15:03









                    CCRCCR

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




                    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

                    mysqli_query(): Empty query in /home/lucindabrummitt/public_html/blog/wp-includes/wp-db.php on line 1924

                    How to change which sound is reproduced for terminal bell?

                    Can I use Tabulator js library in my java Spring + Thymeleaf project?