Transition Technology: Ticket Query

#519: Fixing various URL in the Database

chris — Fri, 15 Mar 2013 13:47:21 GMT

This page:

http://transitionnetwork.org/support/what-transition-initiative

Contains this HTML:

<p><img alt="TransitionSantaCruz" src="http://transitionsc.org/sites/www.transitionnetwork.org/files/pixture_reloaded_logo.png" align="right" height="69" width="150"></p>

The image is a 404:

http://transitionsc.org/sites/www.transitionnetwork.org/files/pixture_reloaded_logo.png

The correct location for the image is:

http://transitionsc.org/sites/default/files/pixture_reloaded_logo.png

Looking at the Internet Archive this was correct back in October 2012,

http://web.archive.org/web/20121022030350/http://www.transitionnetwork.org/support/what-transition-initiative

Their munged HTML contains the correct URL:

<p><a href="/web/20121022030350/http://transitionsc.org/sites/default/files/pixture_reloaded_logo.png" class="colorbox initColorbox-processed cboxElement">

It appears to me that an edit must have been done on the database something like:

s;/sites/default/files/;/sites/www.transitionnetwork.org/files/;

There might well be other URLs to other Drupal sites that were changed when they shouldn't have been?

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:

grep "sites/www.transitionnetwork.org/files" /var/backups/mysql/sqldump/transitionnetwor.sql | wc -l
113

I did notice that there are a lot of URLs in the database like this:

src=\"http://www.transitionnetwork.org/sites/www.transitionnetwork.org/files/uploaded/u5857/Map-TransitionNetworkOffice.jpg\"

And

src=\"https://www.transitionnetwork.org/sites/www.transitionnetwork.org/files/uploaded/u4/transition%20companion%20cover.jpg\"

Both the above links would be better starting with / or //www.transitionnetwork.org/ as this would avoid people getting HTTPS content when using HTTP and also getting HTTP content when using HTTPS.

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.

I'd be happy to do this task. Ed, Jim, any thoughts about when would be a good time to do it?

#541: Documentation of the WordPress sites

chris — Wed, 01 May 2013 20:25:57 GMT

These pages have been created for the documentation of the wiki:WordPress sites running on wiki:PenguinServer:

So far they only have a listing on the plugins for each site.

Ideally they would document all the plugins, the theme and the steps that need to be taken to upgrade each site and also any other things that need documenting.

Laura is this something you might be able to help with? I'm happy doing some work on it but you know your way around these sites far better than anyone else.

#590: Drupal performance improvements

jim — Fri, 06 Sep 2013 10:27:27 GMT

This ticket is to track the work and changes done within the Drupal sphere in relation to performance enhancements done since #585.

More information is needed and will come when ticket:586 New Relic Monitoring for BOA is completed.

I also note that many of these cleanup operations will also help make the move to D7 smoother and better.

Summary of actions and status

TODO

O) Stop making so many URL aliases for non-relevant pages, clean up url_alias table -- 1/4-1/2 hour, medium reward, only risk is that some already broken links might break... Per chat with Ed, only these will be removed (plus releated tweaks to Pathauto settings):

3,579 entries where src = node/%/feed
1,856 entries where src = user/%/contact
= 5,435 or ~11% of entries in url_alias

L) Review slow query log, explain queries, tweak as necessary/flag poorly behaving modules. 2-4 hours, high reward, low risk... Keep looking at the slow query log and adjust Drupal or find patches as necessary. ALSO related Reduce your server's resource usage by moving MySQL temporary directory to tmpfs... Have opened ticket for this: #591 for Chris.

Done

A) Remove spam taxonomy entries ~~1/2 hour, Low risk, low reward -- See item 8 below. A simple delete from taxo term table where length > 50 is worth doing IMHO, and nothing I saw that would be clobbered is not spam.~~

B) Try a Taxonomy Cleanup: 3 hours, Medium risk, medium reward -- style module to try to merge terms with the same names and clean up the link tables back to nodes. Further, we can remove any taxonomies or relations to certain CTs that don't really add value.

D) Review Views caching ~~1 hour, low risk, high reward -- Utilise Views Content Cache this was done a while back but I think -- done (task 12) in comment 21.~~

F) Force blocks caches to cached appropriately (and be rendered/included only as needed) 1-2 hours, medium reward, low risk -- BOA packages the Block Cache Alter, which makes sure Drupal only renders blocks when needed. Potential small but nice boost quickly in whole site. -- per comment 22, block caching is disabled by other modules so this will have to go on hold for now.

H) Remove CustomError? module all together 1/2 hour, low risk, low reward -- We should take out the PHP code from the 403 section of CustomError? and put it into a simple page entry. See comment 6 below as this has happened for 404s (which need no PHP). We can then remove the CustomError? module all together, saving lots of sessions. I would go ahead and do this but since the 403 page has various displays depending on user type, I wanted to raise it here as it *may* have side effects. Or not...

I) Re-enable block caching. 2-6 hours, high risk, high reward -- Per comment 24, a module (probably Content Access) is stopping Drupal caching blocks, which for some of them means a fair amount of pointless overhead. We need to somehow get around this and get blocks cached if possible. R&D mainly, perhaps with some hacking/patching - but I'd stop short of doing this if so.

K) Add & enable Views Lite Pager on big views. ~~1 hour, low risk, low reward -- Using this module stops a heavy count query on views with pagers -- recommended for large sites.~~

M) Take control of Cron, and maximise time pages are cached for. .25h, high reward, low risk -- Cron is wiping the page cache, so we need to install https://drupal.org/project/elysia_cron so we can clear the page less often, and run other things when we want and the site is quieter. Now need per minute resolution set to get the best, see comment 33 and 34 for more...

N) Replace Admin Menu 1.x with 3.x -- will happen when #590 occurs, marking complete here -- ~~5 mins, high reward, low risk -- done when #582 happens, could be the cause of some load spikes as it occasionally goes made and does 2000-5000 queries~~~~

#596: Captions issue

benj — Mon, 16 Sep 2013 16:58:04 GMT

basically captions are appearing on body inline images and featured images on STG but not PROD and I can't see where the difference is...

The following code addition to the bottom of template.php should be (but isn't) adding the caption class to images such as the one at the top of this page:

https://www.transitionnetwork.org/blogs/ed-mitchell/2013-06/test-blog-test-caption-and-featured-image

Any reason you can think of why not? Or do you know of another easy way of adding the class caption to featured image fields? (I guess the module https://drupal.org/project/semantic_cck - but maybe overkill...)

Adds caption css class to featured images */

function transition2_imagecache_formatter_featured_image_default($element) {

Inside a view $element may contain NULL data. In that case, just return. if (empty($element#item fid?)) {

return ;

}

Extract the preset name from the formatter name. $presetname = substr($element#formatter, 0, strrpos($element#formatter, '_')); $style = 'linked'; $style = 'default';

$item = $element#item; $itemdata?alt? = isset($itemdata?alt?) ? $itemdata?alt? : ; $itemdata?title? = isset($itemdata?title?) ? $itemdata?title? : NULL;

$class = "imagecache imagecache-$presetname imagecache-$style imagecache-{$element#formatter} caption"; return theme('imagecache', $presetname, $itemfilepath?, $itemdata?alt?, $itemdata?title?, array('class' => $class));

}

#598: Redirect reconomyproject.org to reconomy.org

chris — Fri, 20 Sep 2013 12:16:56 GMT

Request from Shane:

I've noticed that the domain www.reconomyproject.org is still live and running. i.e. can surf around it. I think you set it up so that it would auto redirect to reconomy.org - not 100% sure about the technical spec behind how you did this but is it still working? I noticed this because a lot of the referrals on to our fb page our coming from reconomyproject.org rather than reconomy.org

#636: Changes to Space.transitionnetwork.org homepage to facilitate user registration

ed — Wed, 27 Nov 2013 17:30:19 GMT

Space currently does not give users who aren't already registered a way in. Anon users can see some of the spaces but when they try to apply for membership, they hit a login page, which they can't complete as they are not registered.

RTFM for OA as to OA best practice - this is billable time. Then leave notes about it in wiki for later developers.

The homepage needs editing to sort this out. Here are some first changes:

2.1. Remove the 'Need the pros' pane (RHS) 2.2 Remove the 'Just getting started' pane (LHS) 2.3 Add a 'Request membership' pane which is basically a user registration form. Make registration 'approval only' for now, approval to be by a site admin (webproject@…)

The /spaces listings view shows the spaces that are publicly viewable, and there is a 'request group membership' button for each of them.

Can you make this into a registration form as well?

#644: AWstats Nginx config breaks aegir

jim — Mon, 09 Dec 2013 16:46:05 GMT

Since the last update we've had a silent ngnix error that means http://tn.puffin.webarch.net was not available.

I restarted nginx and got:

[  ok  ] Stopping Nginx Server...:
[ .... ] Starting Nginx Server...:nginx: [emerg] "log_format" directive is not allowed here in /etc/nginx/nginx.conf:28

Which equates to the AWstats entry which is now commented out per:

# log for awstats
#log_format apache '$remote_addr - $remote_user [$time_local] "$request" '
#                   '$status $body_bytes_sent "$http_referer" '
#                   '"$http_user_agent"';
#access_log         /var/log/nginx/awstats.log apache;

I/we need access to aegir more than AWStats, so I've commented out the lines above and restarted nginx. Aegir is back and working well.

This ticket is to find the correct log_format for modern nginx versions and reinstate AWstats -- assigning to Chris as a low priority thing.

#645: APC Tuning on Parrot and Penguin

chris — Tue, 10 Dec 2013 10:52:31 GMT

As part of the upgrade from Squeeze to Wheezy, see ticket:535, Munin graphs for APC were added:

There is also more APC info here:

The documentation for the variables which can be set in /etc/php5/mods-available/apc.ini can be found here:

http://php.net/manual/en/apc.configuration.php

This monitoring is generating quite a high volume of warnings about fragmentation and purges and this ticket has been created to try to sort this issue out.

#675: Piwik Geolocation

chris — Tue, 14 Jan 2014 12:16:36 GMT

We have this warning in the Piwik admin interface:

Geolocation works, but you are not using one of the recommended providers. If you have to import log files or do something else that requires setting IP addresses, use the PECL GeoIP implementation (recommended) or the PHP GeoIP implementation.

We currently do Geolocation at a Nginx level, it is possible that it would now be better to switch to do it at a Piwik level, see the documentation here: http://piwik.org/docs/geo-locate/

#676: Alternative to Skype for TTech Meetings

chris — Tue, 14 Jan 2014 13:33:51 GMT

Jim has pointed out that:

Skype costs us 15-30 minutes of grinding pain every time we do this!

So what are the alternatives and what are our requirements?

#681: Submitting Transition event overseas: An illegal choice has been detected. Please contact the site administrator.

sam — Wed, 22 Jan 2014 12:31:29 GMT

Hi I'm using https://www.transitionnetwork.org/node/add/event

To create a Transition Training event in Belgium in the 'Limburg' region.

On submission I get the following error;

"An illegal choice has been detected. Please contact the site administrator."

It works for UK events.

I had a look at the fields in the event content type, but couldn't spot any problems

#689: Duplicate comments

sam — Fri, 14 Feb 2014 12:21:23 GMT

Hi I got the below message from Mike. Paul could you take a look if you have a minute?

Thanks

Sam

I am noticing that many of the comments are being duplicated quite often - sometimes once and Rob's last comments was added twice. I've been deleting them but will be offline from now over the weekend.

This article is getting lots of comments https://www.transitionnetwork.org/blogs/rob-hopkins/2014-02/open-letter-bbc-lord-lawsons-today-programme-appearance

#737: SPF / Emails rejected from the website contact form

sam — Thu, 05 Jun 2014 15:46:13 GMT

We had a user report that they could not send a message via our contact form:

"Yesterday I sent a message to you via the contact form on the website. But obviously something went wrong: for I got a failure notice saying my message could not be delivered. Therefore I'm sending it directly via email (see below) hoping that you're receiving my message this way."

<info@…>: host mx1.spamfiltering.com[72.249.150.158] said:

550 81.95.XX.XX is not allowed to send mail from gmx.de. Please see http://www.openspf.net/Why?scope=mfrom;identity=userXX@gmx.de;ip=81.95.XX.XX (in reply to end of DATA command)

(User details edited as this is publicly archived)

I'm not sure I quite understand what's going on here. Chris indicated in email that this would affect other users whose email provider has set this kind of SPF record.

Can we make an educated guess as to what proportion of email providers set this kind of SPF?

How many messages do we never get to see? Is it a problem? Or a small enough number of users that we just don't worry about it?

Thanks

Sam

#740: Add 'class button block' to Soundcloud block

sam — Thu, 12 Jun 2014 09:55:05 GMT

Hi Ben

Could you add 'class button block' to the block class settings for this block:

https://www.transitionnetwork.org/admin/build/block/configure/block/98?destination=blogs%2Frob-hopkins

Or shall I give myself 'developer' permissions so I can add these myself?

Thanks

Sam

#746: New comment notifications not being sent to content owners.

sam — Tue, 24 Jun 2014 09:27:11 GMT

Hi Paul, Annesley, Chris

Ed hasn't been getting notifications for new comments.

"Please check if new comment notifications are being sent to content owners. I don’t think I am receiving email alerts for my blog posts."

I'll email Rob to see if he's getting any.

Could you investigate?

Thanks

Sam

#763: Server Backups

chris — Mon, 21 Jul 2014 17:09:21 GMT

Two weeks ago annesley asked:

what off-site data storage, file backup and quick setup do we have?

I answered:

The 3 virtual servers have their file system mounted off a BSD/NFS/ZFS file server and the whole file system is backed up and stored onto another BSD/ZFS server in the same data centre. We did have backups also being copied to a server in Manchester but this is currently off-line as the Manchester server needs a disk swapping and rebuilding as a BSD/ZFS server.

A problem with this is that it's only me and Alan that have access to these backups, so I'd like to suggest I set up a new account for backups on our backup server and sort out cron jobs to rsync data to this account and document how people can access these backups.

The result would be that everybody would have SFTP access to 60 days worth of snapshots of backups from all three servers whenever needed without any need for my or Alan's intervention.

I expect this would take abount an hour to set up and another hour to document and help people understand it.

There would be no additional cost to the TN because backup space is already paid for.

#768: Piwik Archive Cron Error

chris — Fri, 01 Aug 2014 17:14:59 GMT

Have been getting these emails from PiwikServer:

From: root@penguin.webarch.net (Cron Daemon)
Date: Fri,  1 Aug 2014 14:06:48 +0100 (BST)
To: root@localhost
Subject: Cron <www-data@penguin> /web/stats.transitionnetwork.org/piwik/console core:archive --url=http://stats.transitionnetwork.org/ > /var/log/piwik-archive.log
ERROR CoreConsole[2014-08-01 13:05:18] [3e5ac] Got invalid response from API request:
+http://stats.transitionnetwork.org/index.php?module=API&method=API.get&idSite=1&period=week&date=last2&format=php&token_auth=XXXXXXXXXXXX&trigger=archivephp. Response was ' <div style='word-wrap: break-word; border: 3px solid red; padding:4px; width:70%;
+background-color:#FFFF96;'>         <strong>There is an error. Please report the message (Piwik 2.4.1)         and full backtrace in the <a
+href='?module=Proxy&action=redirect&url=http://forum.piwik.org' target='_blank'>Piwik forums</a> (please do a Search first as it might have
+been reported already!).<br /><br/>         Warning:</strong>
+<em>file_get_contents(http://api.piwik.org/1.0/getLatestVersion/?piwik_version=2.4.1&php_version=5.4.4-14%2Bdeb7u12&url=https%3A%2F%2Fstats.
+transitionnetwork.org%2Fweb%2Fstats.transitionnetwork.org%2Fpiwik%2Fconsole&trigger=API&timezone=Europe%2FLondon): failed to open stream:
+HTTP requ
 est fail
 ed! </em> in <strong>/web/stats.transitionnetwork.org/piwik/core/Http.php</strong> on line <strong>406</strong> <br /><br />Backtrace
+--&gt;<div style="font-family:Courier;font-size:10pt"><br /> #0  Piwik\Error::errorHandler(...) called at [:]<br /> #1
+file_get_contents(...) called at [/web/stats.transitionnetwork.org/piwik/core/Http.php:406]<br /> #2  Piwik\Http::sendHttpRequestBy(...)
+called at [/web/stats.transitionnetwork.org/piwik/core/Http.php:94]<br /> #3  Piwik\Http::sendHttpRequest(...) called at
+[/web/stats.transitionnetwork.org/piwik/core/UpdateCheck.php:72]<br /> #4  Piwik\UpdateCheck::check(...) called at
+[/web/stats.transitionnetwork.org/piwik/plugins/CoreUpdater/CoreUpdater.php:142]<br /> #5
+Piwik\Plugins\CoreUpdater\CoreUpdater->updateCheck(...) called at [:]<br /> #6  call_user_func_array(...) called at
+[/web/stats.transitionnetwork.org/piwik/core/EventDispatcher.php:98]<br /> #7  Piwik\EventDispatcher->postEvent(...) called at
+[/web/stats.transitionnetwor
 k.org/pi
 wik/core/Piwik.php:766]<br /> #8  Piwik\Piwik::postEvent(...) called at
+[/web/stats.transitionnetwork.org/piwik/core/FrontController.php:391]<br /> #9  Piwik\FrontController->init(...) called at
+[/web/stats.transitionnetwork.org/piwik/core/dispatch.php:33]<br /> #10  require_once(...) called at
+[/web/stats.transitionnetwork.org/piwik/index.php:47]<br /> #11  require_once(...) called at
+[/web/stats.transitionnetwork.org/piwik/core/CliMulti/RequestCommand.php:53]<br /> #12  Piwik\CliMulti\RequestCommand->execute(...) called
+at [/web/stats.transitionnetwork.org/piwik/vendor/symfony/console/Symfony/Component/Console/Command/Command.php:252]<br /> #13
+Symfony\Component\Console\Command\Command->run(...) called at
+[/web/stats.transitionnetwork.org/piwik/vendor/symfony/console/Symfony/Component/Console/Application.php:887]<br /> #14
+Symfony\Component\Console\Application->doRunCommand(...) called at
+[/web/stats.transitionnetwork.org/piwik/vendor/symfony/console/Symfony/Component/Co
 nsole/Ap
 plication.php:193]<br /> #15  Symfony\Component\Console\Application->doRun(...) called at
+[/web/stats.transitionnetwork.org/piwik/core/Console.php:64]<br /> #16  Piwik\Console->doRun(...) called at
+[/web/stats.transitionnetwork.org/piwik/vendor/symfony/console/Symfony/Component/Console/Application.php:124]<br /> #17
+Symfony\Component\Console\Application->run(...) called at [/web/stats.transitionnetwork.org/piwik/console:31]<br /> </div><br />
+</pre></div><br />  <div style='word-wrap: break-word; border: 3px solid red; padding:4px; width:70%; background-color:#FFFF96;'>
+<strong>There is an error. Please report the message (Piwik 2.4.1)         and full backtrace in the <a
+href='?module=Proxy&action=redirect&url=http://forum.piwik.org' target='_blank'>Piwik forums</a> (please do a Search first as it might have
+been reported already!).<br /><br/>         Warning:</strong>
+<em>file_get_contents(http://api.piwik.org/1.0/getLatestVersion/?piwik_version=2.4.1&php_version
 =5.4.4-1

#772: new TIs not appearing on staging until caches flushed

annesley — Tue, 05 Aug 2014 09:26:32 GMT

i added a new Mulling transition initiative on staging in Afghanistan and it did not appear on the map... i flushed caches and then it started appearing on the main initiatives map. is this intended? is it a known?

#787: Access to Parrot

annesley — Mon, 15 Sep 2014 07:21:51 GMT

is it ok for me to send through my normal, non-passphrase protected public key to you Chris for parrot?

the documentation wants a passphrase protected key. however this may be what is causing the access issues from my laptop. i certainly could find a way around it but would suggest that the passphrase is not a great improvement to security anyway in this instance so it would be ok to use my normal public key. note that i can access all my other servers with the normal key without problems.

#814: Higher that usual loads on PuffinServer since early September

chris — Wed, 03 Dec 2014 17:12:35 GMT

The following load graph from PuffinServer shows that the load increased substantially in early September 2014, does anyone know why?

When I found I went to Drupal 7.33 and all I got was a slow site I thought that perhaps a Drupal 7 site on the server could be the cause but 7.33 came out on 7th November 2014.

Anyone have any ideas?

#824: Analysis of the 2014 maintenance ticket time

chris — Wed, 07 Jan 2015 15:48:14 GMT

Ed has ask that I spend up to 2 hours on an analysis of the 2014 maintenance ticket time for our meeting tomorrow in Bristol.

#836: "Date is invalid" on film content type

sam — Thu, 05 Mar 2015 14:30:22 GMT

Hi Paul

Don't spend more than half an hour on this, if it takes longer I'll just remove the date field instead.

If I edit: https://www.transitionnetwork.org/node/35510/edit

Or add https://www.transitionnetwork.org/node/add/films

A film, the website it returns a "Year is invalid." error.

In the settings it's set to 'Y' https://www.transitionnetwork.org/admin/content/node-type/films/fields/field_film_year

I'm entering a four digit date, eg 2010

Any ideas?

Thanks

Sam

#870: MediaWiki 1.23.10

chris — Mon, 24 Aug 2015 12:18:48 GMT

The announcement contains:

Bug Fixes in 1.23.10

(bug 67644) Make AutoLoaderTest handle namespaces
(T91653) Minimal PSR-3 debug logger to support backports from 1.25+.
(T102562) Fix InstantCommons parameters to handle the new HTTPS-only policy of Wikimedia Commons.

#887: Lot's of failed logins on conference15.transitionnetwork.org

sam — Fri, 04 Dec 2015 11:39:10 GMT

Hi all

Overnight I had 150 notifications of failed login attempts and subsequent IP address bans from the https://en-gb.wordpress.org/plugins/wordfence/ security plugin I installed.

It's coming from multiple IP addresses in multiple countries.

It seems like Wordfence is doing it's job and blocking IP's. I only mention it as I'm wondering if it could be related to the recent downtime.

Feel free to close this ticket, just thought it was worth sticking in here.

Thanks

Sam

#892: MediWiki Security Release: 1.26.1, 1.25.4, 1.24.5 and 1.23.12

chris — Fri, 18 Dec 2015 10:46:18 GMT

Email to the announcements list:

I would like to announce the release of MediaWiki 1.26.1, 1.25.4, 1.24.5,
and
1.23.12.
These releases fix five security issues in core, in addition to other bug
fixes. Download links are given at the end of this email
== Security fixes ==
(T117899) SECURITY: $wgArticlePath can no longer be set to relative paths
that
do not begin with a slash. This enabled trivial XSS attacks. Configuration
values such as "http://my.wiki.com/wiki/$1" are fine, as are "/wiki/$1". A
value such as "$1" or "wiki/$1" is not and will now throw an error
(T119309) SECURITY: Use hash_compare() for edit token comparison
(T118032) SECURITY: Don't allow cURL to interpret POST parameters starting
with
'@' as file uploads
(T115522) SECURITY: Passwords generated by User::randomPassword() can no
longer
be shorter than $wgMinimalPasswordLength
(T97897) SECURITY: Improve IP parsing and trimming. Previous behavior could
result in improper blocks being issued
(T109724) SECURITY: Special:MyPage, Special:MyTalk, Special:MyContributions
and
related pages no longer use HTTP redirects and are now redirected by
MediaWiki
== Note about EOL of 1.24.x ==
Please note that 1.24.5 marks the end of support for the 1.24.x series of
releases. Technically this ended a few weeks ago with the release of 1.26.0
but
we dropped one final release of 1.24.x here to give it a nicer send off for
those who have not yet upgraded.
== Release notes ==
Full release notes for 1.26.1:
<https://www.mediawiki.org/wiki/Release_notes/1.26>
Full release notes for 1.25.4:
<https://www.mediawiki.org/wiki/Release_notes/1.25>
Full release notes for 1.24.5:
<https://www.mediawiki.org/wiki/Release_notes/1.24>
Full release notes for 1.23.12:
<https://www.mediawiki.org/wiki/Release_notes/1.23>
For information about how to upgrade, see
<https://www.mediawiki.org/wiki/Manual:Upgrading>

#912: Stats for TTT

chris — Tue, 21 Jun 2016 10:29:02 GMT

Nicola at TTT has asked:

Could you let me know the size of the TTT and Transition Streets sites please? I have Google Analytics for TTT but not for Transition Streets, and I wonder if you could also tell me how many visitors it gets annually?

#917: Any misc files in Transition Culture web root?

sam — Thu, 14 Jul 2016 11:54:50 GMT

Hi Chris

Simon from Lumpy lemon has migrated Transition Culture.

We only have WP admin access & he was wondering:

"Just one small question: can you check in the webroot folder on your server and let me know if there are any non-WordPress files in there? e.g. Google verification files, that sort of thing. I don't think there should be, but best to check. If there are, can you send them over."

Thanks

Sam

#262: US users adding Ini profiles through the US site

ed — Fri, 17 Jun 2011 12:10:40 GMT

This is *the* big job for phase 4. The US is a pilot for other countries, and other content types. The aim is for TN to be able to publish project directory on TI sites, and enable anyone to add a project via the TI sites in the long term.

US user can add an ini profile to the US site which is also added to the TN directory
US site has a special map and directory view of US inis only (both muller and official)
US user can edit the ini profile via the US site (possibly not on TN site)
US user account: with TN or TUS? tbd
Creation of a 'slimline' user acct showing only 'critical data'?
Creation of a 'slimline' ini profile showing only'critical data'?
This is a pilot for other countries in the future
This process will be used in some way to enable anyone to add project information from and through TI sites
Fiddle with slimline user accounts and/or use third party process a la facebook/google/yahoo accts?
US has a US-only map view of users who are speakers

#469: PSE project submission submitter cannot then edit their own project

ed — Tue, 04 Dec 2012 19:33:46 GMT

The user who has added a pse submission which has been approved cannot then edit the project profile when it has been approved. The webmaster who approved it can edit it.

This is not right - the user who added the pse submission which then got turned into a project needs to be the project owner.

The new project is set to the correct author. But that author doesn't have edit rights.

Project (unpublished): https://www.transitionnetwork.org/projects/test-user-3-test-project

#504: Images missing from widget and site in general

ed — Fri, 01 Mar 2013 16:00:39 GMT

Submit button missing from widget (see bottom right here: http://www.edmitchell.co.uk/blog/).

Quite a few images are missing from the site - profile pictures of people who don't have pictures as well.

Please have a look.

#61: Directory search by postcode

ed — Thu, 13 May 2010 16:11:30 GMT

Searching initiatives and people and projects: Add postcode search function to filter (adam herriott)

(Ed hears that the .paf is now freely available from OS/Royal Mail (?)

#100: Show users' profiles on their personal profile page

ed — Mon, 21 Jun 2010 16:36:55 GMT

show a list of the projects and intiatives that users are involved with on their personal profile page

#123: City name in personal profiles

ed — Tue, 20 Jul 2010 10:38:47 GMT

Please either:

add city name into the personal profiles as it is in initiative profiles

OR:

if it's a straightforward replicate from the initiative profile, tell ed this and he will do it

#127: Link checker module

ed — Fri, 23 Jul 2010 09:12:15 GMT

It would be very very handy to have a link checker of some form to check for internal and external links. Site editors are adding pages, navigation is changing etc. If possible, the link module would update links as they move internally, but that's a nice to have. Please install one and Ed can manage it.

Putting to critical to get it on, shouldn't take long...

#257: Path aliases not being created for non-English nodes - i18n issues

ed — Wed, 15 Jun 2011 13:24:21 GMT

WAS: "one resource not rendering URL"

can't make this puppy render a human URL: http://www.transitionnetwork.org/node/17135

#304: Make the five star ratings filter-able in the resources directory view

ed — Thu, 18 Aug 2011 16:55:00 GMT

#320: Add sitemap for site

ed — Mon, 12 Sep 2011 09:26:57 GMT

...

#384: Enhance Project Profile Content Type and directory

ed — Tue, 20 Dec 2011 23:25:32 GMT

Laura to re-design IA and interface for admin and public profiles for project profile CT and directory.

Considered as part of PSE Project, hence design in Jan, build in Feb 2012

#457: Projects form - Enhance form entry

laura — Thu, 08 Nov 2012 18:15:44 GMT

1 - Entry Form:

Set up new fields and permissions and groupings
Enhance ‘helper’ texts and any links to other parts of TN listed on form to enhance usability and context.
CSS and potential of custom templating/panels if needed for style and layouts

#461: Spam account war

ed — Wed, 21 Nov 2012 16:19:10 GMT

Aim:

tell drupal (and server level stuff?) to sniff out and destroy spam accounts without them knowing we did it, and ban them from doing it again

Wiki page:

https://wiki.transitionnetwork.org/Spam_accounts

#485: transitionnetwork.org is tablet/phone/touch unfriendly

mark — Tue, 29 Jan 2013 09:24:15 GMT

Don't know how much of a priority this is, but transitionnetwork.org seems tablet/phone/touch unfriendly - and I'm just raising this ticket to capture this thought.

Core issue is the drop-down menus that are only accessible if you can "hover" over them with a mouse pointer - and of course no such thing exists on a touch-screen phone or tablet.

An easy workaround would be sub-menus or section menus in the sidebar, though I guess that would need some thought so as not to over-clutter the user interface. I often use the menu_block module to make "section" menus easy.

Anyway - thought captured - back to Real Work now :)

#514: Spam issues - users not being able to comment

ed — Tue, 12 Mar 2013 17:25:29 GMT

Ed is receiving a selection of users not being allowed to post since the spam changes. We are seeing a pattern now. Setting this ticket up - will add user details tomorrow.

#516: Search: not showing events or initiatives

ed — Thu, 14 Mar 2013 10:16:41 GMT

Search for Woking from homepage. I know that there are two events and two initaitives with Woking in them. Neither are shown: https://www.transitionnetwork.org/search/node/woking

Advanced search does not bring them up either (ticking the initiatives box).

If I am in the initiatives section it returns the TIs though.

General search used to show TIs and events. Now it's only showing results of word searches.

General search needs to show TIs and events, and other nodes.

Please look into this.

#523: Database intergrity

ed — Tue, 19 Mar 2013 11:33:38 GMT

Following on from comment 4 of ticket 516 (https://tech.transitionnetwork.org/trac/ticket/516#comment:4) , I wanted to check the integrity of the field tables, so I crafted and ran this query:

SELECT count(cck.nid) FROM content_field_region cck LEFT JOIN node node on cck.nid = node.nid WHERE node.nid IS NULL

Which returned 1,173 rows. I then replaced the 'content_field_region' with other fields found on the user profile nodes (which have their own database table) so the full breakdown is:

content_field_region = 1173 content_field_initiative = 1165 content_field_themes = 6256 content_field_training_attended = 1165 content_field_roles_offered = 1285 content_field_other_websites = 1181 content_field_user_types = 1165

So what this means is there are around 1200 entries in field database storage for the above tables that do not have an associated node. This means the data is not properly referentially integral, and ideally these should be cleaned up one day.

The risk is low but it's worth doing a the rest of the audit (with the other fields that have tables of their own) and then cleaning these up at some point. These will have been caused by manual deletes and imports over the years. Drupal would normally keep these sorted but we've had to bypass Drupal a few times.

Or we can leave it as is and let the migration to Drupal 8 resolve this. The cost is a bit more database space and a slightly slower site... Though this *may* cause a bug or two.

#860: More details on Server provision

annesley — Fri, 19 Jun 2015 10:29:09 GMT

we would like the following details on all servers provided by WebArchitects? (Penguin, Puffin and Parrot):

CPU type, speed, and characteristics Disk Space RAID type Traffic limits and characteristics Bandwidth limits and characteristics

Thanks!

#882: Login to PiWik stats

annesley — Tue, 03 Nov 2015 10:52:30 GMT

hi Chris! could i have a login to PiWik? stats please?

#924: Sheffield Server Shutdown Timetable?

chris — Mon, 05 Sep 2016 08:46:27 GMT

Since www.transitionnetwork.org is now running on dedi2835.your-server.de there seems little point in the Transition Network continuing to pay for the PuffinServer and my time doing sysadmin updates on it?

If the Transition Network would like Webarchitects to shutdown and delete this server and all it's backups could you please let me know when you would like it doing?

I guess the same goes for PenguinServer and ParrotServer, though these servers still have live sites on them, including this Trac site that I use to keep track of time worked -- when PenguinServer is shutdown I will no longer have a public place to document the time I work for the Transition Network and all the server and site documentation from the last six years will be lost.