http://localhost:8080/trac/ticket/519 <p> This page: </p> <ul><li><a class="ext-link" href="http://transitionnetwork.org/support/what-transition-initiative"><span class="icon">​</span>http://transitionnetwork.org/support/what-transition-initiative</a> </li></ul><p> Contains this HTML: </p> <pre class="wiki">&lt;p&gt;&lt;img alt="TransitionSantaCruz" src="http://transitionsc.org/sites/www.transitionnetwork.org/files/pixture_reloaded_logo.png" align="right" height="69" width="150"&gt;&lt;/p&gt; </pre><p> The image is a 404: </p> <ul><li><a class="ext-link" href="http://transitionsc.org/sites/www.transitionnetwork.org/files/pixture_reloaded_logo.png"><span class="icon">​</span>http://transitionsc.org/sites/www.transitionnetwork.org/files/pixture_reloaded_logo.png</a> </li></ul><p> The correct location for the image is: </p> <ul><li><a class="ext-link" href="http://transitionsc.org/sites/default/files/pixture_reloaded_logo.png"><span class="icon">​</span>http://transitionsc.org/sites/default/files/pixture_reloaded_logo.png</a> </li></ul><p> Looking at the Internet Archive this was correct back in October 2012, </p> <ul><li><a class="ext-link" href="http://web.archive.org/web/20121022030350/http://www.transitionnetwork.org/support/what-transition-initiative"><span class="icon">​</span>http://web.archive.org/web/20121022030350/http://www.transitionnetwork.org/support/what-transition-initiative</a> </li></ul><p> Their munged HTML contains the correct URL: </p> <pre class="wiki">&lt;p&gt;&lt;a href="/web/20121022030350/http://transitionsc.org/sites/default/files/pixture_reloaded_logo.png" class="colorbox initColorbox-processed cboxElement"&gt; </pre><p> It appears to me that an edit must have been done on the database something like: </p> <pre class="wiki">s;/sites/default/files/;/sites/www.transitionnetwork.org/files/; </pre><p> There might well be other URLs to other Drupal sites that were changed when they shouldn't have been? </p> <p> I have had a quick look at the database dump and couldn't find any examples of this problem, but there are 113 lines to check: </p> <pre class="wiki">grep "sites/www.transitionnetwork.org/files" /var/backups/mysql/sqldump/transitionnetwor.sql | wc -l 113 </pre><p> I did notice that there are a lot of URLs in the database like this: </p> <pre class="wiki">src=\"http://www.transitionnetwork.org/sites/www.transitionnetwork.org/files/uploaded/u5857/Map-TransitionNetworkOffice.jpg\" </pre><p> And </p> <pre class="wiki">src=\"https://www.transitionnetwork.org/sites/www.transitionnetwork.org/files/uploaded/u4/transition%20companion%20cover.jpg\" </pre><p> Both the above links would be better starting with <tt>/</tt> or <tt>//www.transitionnetwork.org/</tt> as this would avoid people getting HTTPS content when using HTTP and also getting HTTP content when using HTTPS. </p> <p> I think it would be worth putting the site into maintenance mode, doing a dump of the database, checking these 113 lines for issues like those above, correcting them all and then reinserting the data, however this would need to be done at a suitable time. </p> <p> I'd be happy to do this task. Ed, Jim, any thoughts about when would be a good time to do it? </p> en-us /trac/chrome/site/TransitionNetwork-Logo-Web-Small.jpg http://localhost:8080/trac/ticket/519 Trac 0.12.5 ed Tue, 19 Mar 2013 17:06:16 GMT http://localhost:8080/trac/ticket/519#comment:1 http://localhost:8080/trac/ticket/519#comment:1 <p> Jim's going to wrap the PSE and BOA work then take a break and come back as someone less frequent, but deeper. So there will be a period of no Jim for a bit. Therefore I suspect that this will stay on the backburner and could be part of a backend tidy up, so to speak. There are some other database integrity <a class="new ticket" href="http://localhost:8080/trac/ticket/523" title="defect: Database intergrity (new)">#523</a> </p> Ticket ed Wed, 08 May 2013 16:43:29 GMT http://localhost:8080/trac/ticket/519#comment:2 http://localhost:8080/trac/ticket/519#comment:2 <ul> <li><strong>milestone</strong> set to <em>Maintenance</em> </li> </ul> <p> moving to maintenance out of no milestone </p> Ticket