hours, status, totalhours changed; resolution set

chris — Tue, 01 Apr 2014 12:15:53 GMT

hours changed from 0.0 to 0.25
status changed from new to closed
resolution set to fixed
totalhours changed from 0.0 to 0.25

Replying to chris:

samrossiter@…

Unrouteable address

The error is caused by a typo in the domain name.

I was intending to update Sam's address in the user table, but he doesn't have an account:

sudo -i
su-user tc
cd sites/default/
wp user list

And there are no matches in the database when using the wp command line tool:

wp search-replace "samrossiter@transitionentwork.org" "samrossiter@transitionnetwork.org" --dry-run
wp search-replace "transitionentwork.org" "transitionnetwork.org" --dry-run

So grepping the files:

grep -rl transitionentwork.org .

No match, grepping the database dump:

sudo -i
grep transitionentwork.org /var/backups/mysql/sqldump/tc.sql
... INSERT INTO ... ('alertEmails','samrossiter@transitionentwork.org'), ...

This isn't seralized so it's easy to update on the !MySQL command line:

sudo -i
mysql tc
mysql> describe r0bh_wfConfig;
+-------+--------------+------+-----+---------+-------+
| Field | Type         | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| name  | varchar(100) | NO   | PRI | NULL    |       |
| val   | longblob     | YES  |     | NULL    |       |
+-------+--------------+------+-----+---------+-------+
mysql> update r0bh_wfConfig set val="samrossiter@transitionnetwork.org" where name="alertEmails";
mysql> select * from r0bh_wfConfig where name="alertEmails";
+-------------+-----------------------------------+
| name        | val                               |
+-------------+-----------------------------------+
| alertEmails | samrossiter@transitionnetwork.org |
+-------------+-----------------------------------+

That should have fixed it.

Transition Technology: Ticket #710: Incorrect email address for Sam on Transition Culture

hours, status, totalhours changed; resolution set