<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<oembed><type>rich</type><version>1.0</version><provider_name>phorkie</provider_name><provider_url>https://p.cweiske.de/</provider_url><title>typo3 cleanup stale flexform data</title><author_name>Christian Weiske</author_name><cache_age>86400</cache_age><width>900</width><height>900</height><html>&lt;!-- embedding all files of https://p.cweiske.de/79 --&gt;
&lt;link rel="stylesheet" href="https://p.cweiske.de/css/embed.css"/&gt;
&lt;div class="phork" id="79"&gt;
    &lt;div class="phork-file"&gt;
 &lt;div class="phork-content"&gt;
  
&lt;div class="document"&gt;


&lt;p&gt;When modifying TYPO3 flexform definitions by e.g. renaming fields, stale data pile up in the &lt;tt class="docutils literal"&gt;tt_content&lt;/tt&gt; flexform data fields.&lt;/p&gt;
&lt;p&gt;You can clean them up with the CLI cleaner.&lt;/p&gt;
&lt;/div&gt;

 &lt;/div&gt;
 &lt;div class="phork-meta"&gt;
  &lt;a href="https://p.cweiske.de/79/rev-raw/7c8a4fe8c1beb53182d0561529bfbd1cbbfc98db/README.rst" style="float: right"&gt;view raw source&lt;/a&gt;
  &lt;a href="https://p.cweiske.de/79#README.rst"&gt;README.rst&lt;/a&gt;
 &lt;/div&gt;
&lt;/div&gt;
    &lt;div class="phork-file"&gt;
 &lt;div class="phork-content"&gt;
  &lt;style type="text/css"&gt;/**
 * GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2008 Benny Baumann
 * (http://qbnz.com/highlighter/ and http://geshi.org/)
 */
.bash .de1, .bash .de2 {font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;}
.bash  {font-family:monospace;}
.bash .imp {font-weight: bold; color: red;}
.bash li, .bash .li1 {color: #DDD;}
.bash .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}
.bash .kw1 {color: #000000; font-weight: bold;}
.bash .kw2 {color: #c20cb9; font-weight: bold;}
.bash .kw3 {color: #7a0874; font-weight: bold;}
.bash .co0 {color: #666666; font-style: italic;}
.bash .co1 {color: #800000;}
.bash .co2 {color: #cc0000; font-style: italic;}
.bash .co3 {color: #000000; font-weight: bold;}
.bash .es1 {color: #000099; font-weight: bold;}
.bash .es2 {color: #007800;}
.bash .es3 {color: #007800;}
.bash .es4 {color: #007800;}
.bash .es5 {color: #780078;}
.bash .es_h {color: #000099; font-weight: bold;}
.bash .br0 {color: #7a0874; font-weight: bold;}
.bash .sy0 {color: #000000; font-weight: bold;}
.bash .st0 {color: #ff0000;}
.bash .st_h {color: #ff0000;}
.bash .nu0 {color: #000000;}
.bash .re0 {color: #007800;}
.bash .re1 {color: #007800;}
.bash .re2 {color: #007800;}
.bash .re4 {color: #007800;}
.bash .re5 {color: #660033;}
.bash span.xtra { display:block; }
&lt;/style&gt;&lt;div class="code"&gt;&lt;table class="bash"&gt;&lt;tbody&gt;&lt;tr class="li1"&gt;&lt;td class="ln"&gt;&lt;pre class="de1"&gt;1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
&lt;/pre&gt;&lt;/td&gt;&lt;td class="de1"&gt;&lt;pre class="de1"&gt;$ .&lt;span class="sy0"&gt;/&lt;/span&gt;typo3&lt;span class="sy0"&gt;/&lt;/span&gt;cli_dispatch.phpsh lowlevel_cleaner cleanflexform &lt;span class="re5"&gt;-v&lt;/span&gt; &lt;span class="nu0"&gt;0&lt;/span&gt; &lt;span class="re5"&gt;-r&lt;/span&gt;
&lt;span class="sy0"&gt;*********************************************&lt;/span&gt;
cleanflexform
&lt;span class="sy0"&gt;*********************************************&lt;/span&gt;
cleanflexform &lt;span class="re5"&gt;--&lt;/span&gt; Find flexform fields with unclean XML
&amp;#160;
Traversing page &lt;span class="kw2"&gt;tree&lt;/span&gt; and finding records with FlexForm fields with XML that
could be cleaned up. This will just remove obsolete data garbage.
&amp;#160;
Automatic Repair:
Cleaning XML &lt;span class="kw1"&gt;for&lt;/span&gt; FlexForm fields.
&amp;#160;
&lt;span class="re5"&gt;---------------------------------------------&lt;/span&gt;
&lt;span class="br0"&gt;&amp;#91;&lt;/span&gt;cleanflexform&lt;span class="br0"&gt;&amp;#93;&lt;/span&gt;
&amp;#160;&lt;span class="br0"&gt;&amp;#91;&lt;/span&gt;WARNING&lt;span class="br0"&gt;&amp;#93;&lt;/span&gt;
&lt;span class="re5"&gt;---------------------------------------------&lt;/span&gt;
Array
&lt;span class="br0"&gt;&amp;#40;&lt;/span&gt;
&amp;#160; &amp;#160; &lt;span class="br0"&gt;&amp;#91;&lt;/span&gt;ddd2ee5283&lt;span class="br0"&gt;&amp;#93;&lt;/span&gt; =&lt;span class="sy0"&gt;&amp;gt;&lt;/span&gt; tt_content:&lt;span class="nu0"&gt;10&lt;/span&gt;:pi_flexform
&lt;span class="br0"&gt;&amp;#41;&lt;/span&gt;
&amp;#160;
&amp;#160;
$ .&lt;span class="sy0"&gt;/&lt;/span&gt;typo3&lt;span class="sy0"&gt;/&lt;/span&gt;cli_dispatch.phpsh lowlevel_cleaner cleanflexform &lt;span class="re5"&gt;-v&lt;/span&gt; &lt;span class="nu0"&gt;0&lt;/span&gt; &lt;span class="re5"&gt;-r&lt;/span&gt; &lt;span class="re5"&gt;--AUTOFIX&lt;/span&gt;
&lt;span class="sy0"&gt;*********************************************&lt;/span&gt;
cleanflexform
&lt;span class="sy0"&gt;*********************************************&lt;/span&gt;
cleanflexform &lt;span class="re5"&gt;--&lt;/span&gt; Find flexform fields with unclean XML
&amp;#160;
Traversing page &lt;span class="kw2"&gt;tree&lt;/span&gt; and finding records with FlexForm fields with XML that
could be cleaned up. This will just remove obsolete data garbage.
&amp;#160;
Automatic Repair:
Cleaning XML &lt;span class="kw1"&gt;for&lt;/span&gt; FlexForm fields.
&amp;#160;
&lt;span class="re5"&gt;---------------------------------------------&lt;/span&gt;
&lt;span class="br0"&gt;&amp;#91;&lt;/span&gt;cleanflexform&lt;span class="br0"&gt;&amp;#93;&lt;/span&gt;
&amp;#160;&lt;span class="br0"&gt;&amp;#91;&lt;/span&gt;WARNING&lt;span class="br0"&gt;&amp;#93;&lt;/span&gt;
&lt;span class="re5"&gt;---------------------------------------------&lt;/span&gt;
Array
&lt;span class="br0"&gt;&amp;#40;&lt;/span&gt;
&amp;#160; &amp;#160; &lt;span class="br0"&gt;&amp;#91;&lt;/span&gt;ddd2ee5283&lt;span class="br0"&gt;&amp;#93;&lt;/span&gt; =&lt;span class="sy0"&gt;&amp;gt;&lt;/span&gt; tt_content:&lt;span class="nu0"&gt;10&lt;/span&gt;:pi_flexform
&lt;span class="br0"&gt;&amp;#41;&lt;/span&gt;
&amp;#160;
&amp;#160;
NOW Running &lt;span class="re5"&gt;--AUTOFIX&lt;/span&gt; on result. OK? &lt;span class="br0"&gt;&amp;#40;&lt;/span&gt;Yes&lt;span class="sy0"&gt;/&lt;/span&gt;No + &lt;span class="kw3"&gt;return&lt;/span&gt;&lt;span class="br0"&gt;&amp;#41;&lt;/span&gt;: Yes
Cleaning XML &lt;span class="kw1"&gt;in&lt;/span&gt; &lt;span class="st0"&gt;&amp;quot;tt_content:10:pi_flexform&amp;quot;&lt;/span&gt;: DONE
&amp;#160;
&amp;#160;
$ .&lt;span class="sy0"&gt;/&lt;/span&gt;typo3&lt;span class="sy0"&gt;/&lt;/span&gt;cli_dispatch.phpsh lowlevel_cleaner cleanflexform &lt;span class="re5"&gt;-v&lt;/span&gt; &lt;span class="nu0"&gt;0&lt;/span&gt; &lt;span class="re5"&gt;-r&lt;/span&gt;
&lt;span class="sy0"&gt;*********************************************&lt;/span&gt;
cleanflexform
&lt;span class="sy0"&gt;*********************************************&lt;/span&gt;
cleanflexform &lt;span class="re5"&gt;--&lt;/span&gt; Find flexform fields with unclean XML
&amp;#160;
Traversing page &lt;span class="kw2"&gt;tree&lt;/span&gt; and finding records with FlexForm fields with XML that
could be cleaned up. This will just remove obsolete data garbage.
&amp;#160;
Automatic Repair:
Cleaning XML &lt;span class="kw1"&gt;for&lt;/span&gt; FlexForm fields.
&amp;#160;
&lt;span class="re5"&gt;---------------------------------------------&lt;/span&gt;
&lt;span class="br0"&gt;&amp;#91;&lt;/span&gt;cleanflexform&lt;span class="br0"&gt;&amp;#93;&lt;/span&gt;
&amp;#160;&lt;span class="br0"&gt;&amp;#91;&lt;/span&gt;WARNING&lt;span class="br0"&gt;&amp;#93;&lt;/span&gt;
&lt;span class="re5"&gt;---------------------------------------------&lt;/span&gt;
&lt;span class="br0"&gt;&amp;#40;&lt;/span&gt;None&lt;span class="br0"&gt;&amp;#41;&lt;/span&gt;
&amp;#160;&lt;/pre&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;&lt;/div&gt;
 &lt;/div&gt;
 &lt;div class="phork-meta"&gt;
  &lt;a href="https://p.cweiske.de/79/rev-raw/7c8a4fe8c1beb53182d0561529bfbd1cbbfc98db/cleanup.sh" style="float: right"&gt;view raw source&lt;/a&gt;
  &lt;a href="https://p.cweiske.de/79#cleanup.sh"&gt;cleanup.sh&lt;/a&gt;
 &lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;
</html></oembed>
