<?xml version="1.0"?>
<rss xmlns:dc="http://purl.org/dc/elements/1.1/" version="2.0">
  <channel>
    <title>Transition Technology: Ticket #307: Spam account sweep</title>
    <link>http://localhost:8080/trac/ticket/307</link>
    <description>&lt;p&gt;
As discussed - we need to do a sweep through the user tables and remove the spam accounts if possible. My first guess would be any names that aren't names. Or names with numbers in them. There will be other ways of isolating them.
&lt;/p&gt;
&lt;p&gt;
Also to do this in such a way as to be able to do it quickly and easily in the future.
&lt;/p&gt;
</description>
    <language>en-us</language>
    <image>
      <title>Transition Technology</title>
      <url>/trac/chrome/site/TransitionNetwork-Logo-Web-Small.jpg</url>
      <link>http://localhost:8080/trac/ticket/307</link>
    </image>
    <generator>Trac 0.12.5</generator>
    <item>
      
        <dc:creator>ed</dc:creator>

      <pubDate>Tue, 13 Sep 2011 11:53:49 GMT</pubDate>
      <title></title>
      <link>http://localhost:8080/trac/ticket/307#comment:1</link>
      <guid isPermaLink="false">http://localhost:8080/trac/ticket/307#comment:1</guid>
      <description>
        &lt;p&gt;
JK: log error - bunch of user profile nodes that are broken or missing - result of the import in 2010 - approx 350 obsolete - opportutnity for mopping them up
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>ed</dc:creator>

      <pubDate>Thu, 06 Oct 2011 13:36:13 GMT</pubDate>
      <title></title>
      <link>http://localhost:8080/trac/ticket/307#comment:2</link>
      <guid isPermaLink="false">http://localhost:8080/trac/ticket/307#comment:2</guid>
      <description>
        &lt;ol&gt;&lt;li&gt;there is wonky old data that could be tidied up
&lt;/li&gt;&lt;li&gt;spam accounts could be identified with various criteria
&lt;/li&gt;&lt;/ol&gt;&lt;p&gt;
JK do some work on it then
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>jim</dc:creator>

      <pubDate>Thu, 13 Oct 2011 18:51:49 GMT</pubDate>
      <title>hours, totalhours changed</title>
      <link>http://localhost:8080/trac/ticket/307#comment:3</link>
      <guid isPermaLink="false">http://localhost:8080/trac/ticket/307#comment:3</guid>
      <description>
          &lt;ul&gt;
            &lt;li&gt;&lt;strong&gt;hours&lt;/strong&gt;
                changed from &lt;em&gt;0.0&lt;/em&gt; to &lt;em&gt;0.15&lt;/em&gt;
            &lt;/li&gt;
            &lt;li&gt;&lt;strong&gt;totalhours&lt;/strong&gt;
                changed from &lt;em&gt;0.0&lt;/em&gt; to &lt;em&gt;0.15&lt;/em&gt;
            &lt;/li&gt;
          &lt;/ul&gt;
        &lt;ol&gt;&lt;li&gt;Ran &lt;tt&gt; delete from node where uid not in ( select uid from users) and node.type= 'profile'; &lt;/tt&gt; which has cleared the broken nodes appearing at &lt;a class="ext-link" href="https://www.transitionnetwork.org/tags/renewables"&gt;&lt;span class="icon"&gt;​&lt;/span&gt;https://www.transitionnetwork.org/tags/renewables&lt;/a&gt;
&lt;/li&gt;&lt;/ol&gt;&lt;p&gt;
Just leaves spam account sweep... Will think and make some views.
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>jim</dc:creator>

      <pubDate>Thu, 13 Oct 2011 19:02:44 GMT</pubDate>
      <title>hours, status, totalhours changed</title>
      <link>http://localhost:8080/trac/ticket/307#comment:4</link>
      <guid isPermaLink="false">http://localhost:8080/trac/ticket/307#comment:4</guid>
      <description>
          &lt;ul&gt;
            &lt;li&gt;&lt;strong&gt;hours&lt;/strong&gt;
                changed from &lt;em&gt;0.0&lt;/em&gt; to &lt;em&gt;0.25&lt;/em&gt;
            &lt;/li&gt;
            &lt;li&gt;&lt;strong&gt;status&lt;/strong&gt;
                changed from &lt;em&gt;new&lt;/em&gt; to &lt;em&gt;accepted&lt;/em&gt;
            &lt;/li&gt;
            &lt;li&gt;&lt;strong&gt;totalhours&lt;/strong&gt;
                changed from &lt;em&gt;0.15&lt;/em&gt; to &lt;em&gt;0.4&lt;/em&gt;
            &lt;/li&gt;
          &lt;/ul&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>ed</dc:creator>

      <pubDate>Thu, 27 Oct 2011 13:49:02 GMT</pubDate>
      <title>milestone deleted</title>
      <link>http://localhost:8080/trac/ticket/307#comment:5</link>
      <guid isPermaLink="false">http://localhost:8080/trac/ticket/307#comment:5</guid>
      <description>
          &lt;ul&gt;
            &lt;li&gt;&lt;strong&gt;milestone&lt;/strong&gt;
                &lt;em&gt;Phase 5&lt;/em&gt; deleted
            &lt;/li&gt;
          &lt;/ul&gt;
        &lt;p&gt;
moving out of phase 5 as phase 5 is over - going into normal maintenance
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>ed</dc:creator>

      <pubDate>Mon, 18 Feb 2013 10:48:31 GMT</pubDate>
      <title>description changed</title>
      <link>http://localhost:8080/trac/ticket/307#comment:6</link>
      <guid isPermaLink="false">http://localhost:8080/trac/ticket/307#comment:6</guid>
      <description>
          &lt;ul&gt;
            &lt;li&gt;&lt;strong&gt;description&lt;/strong&gt;
              modified (&lt;a href="/trac/ticket/307?action=diff&amp;amp;version=6"&gt;diff&lt;/a&gt;)
            &lt;/li&gt;
          &lt;/ul&gt;
        &lt;p&gt;
goes hand in hand with &lt;a class="assigned ticket" href="http://localhost:8080/trac/ticket/461" title="enhancement: Spam account war (assigned)"&gt;#461&lt;/a&gt; - getting to be a bigger issue every day...
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>jim</dc:creator>

      <pubDate>Mon, 25 Feb 2013 01:09:35 GMT</pubDate>
      <title>status changed; resolution set</title>
      <link>http://localhost:8080/trac/ticket/307#comment:7</link>
      <guid isPermaLink="false">http://localhost:8080/trac/ticket/307#comment:7</guid>
      <description>
          &lt;ul&gt;
            &lt;li&gt;&lt;strong&gt;status&lt;/strong&gt;
                changed from &lt;em&gt;accepted&lt;/em&gt; to &lt;em&gt;closed&lt;/em&gt;
            &lt;/li&gt;
            &lt;li&gt;&lt;strong&gt;resolution&lt;/strong&gt;
                set to &lt;em&gt;duplicate&lt;/em&gt;
            &lt;/li&gt;
          &lt;/ul&gt;
        &lt;p&gt;
Now dupe of &lt;a class="assigned ticket" href="http://localhost:8080/trac/ticket/461" title="enhancement: Spam account war (assigned)"&gt;#461&lt;/a&gt;... That ticket has all the tools, updates, modules and goodies required to meet these needs.
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item>
 </channel>
</rss>