[Forum] Domain missing from registration emails

[Computer Guru]

I'm not sure when this happened, but new user confirmation emails look like this:

To complete your registration, please visit this URL:
/register.php?a=act&u=109983&i=c9b9670002f5f85ce09ec67146cc60d68a1d557b

The domain part is missing. The forum url is set correctly:

[Matthew Gordon]

Has your activateaccount phrase (under the Email Body Text Phrases group) been modified at all?

This is what it should be (in 4.2.0 anyway):

Dear $username,

Thank you for registering at the $vboptions[bbtitle]. Before we can activate your account one last step must be taken to complete your registration.

Please note - you must complete this last step to become a registered member. You will only need to visit this URL once to activate your account.

To complete your registration, please visit this URL:
$vboptions[bburl]/register.php?a=act&u=$userid&i=$activateid

**** Does The Above URL Not Work? ****
If the above URL does not work, please use your Web browser to go to:
$vboptions[bburl]/register.php?a=ver

Please be sure not to add extra spaces. You will need to type in your username and activation number on the page that appears when you visit the URL.

Your Username is: $username
Your Activation ID is: $activateid

If you are still having problems signing up please contact a member of our support staff at $vboptions[webmasteremail]

All the best,
$vboptions[bbtitle]


--------------------
To stop receiving this email, please visit this URL:
$vboptions[bburl]/register.php?do=deleteactivation&u=$userid&i=$activateid

[Computer Guru]

Hi Matt, thanks for the quick response!

But, no, I guess that would have been too easy.

http://imgur.com/aYwEf

EDIT

I also tried (no idea if it actually would matter) rebuilding the language, but no change.

[Matthew Gordon]

Run this query. If it returns that it affected 1 row, see if it fixes it. If it doesn't, then report back so we can try to figure this out.

UPDATE phrasetype SET special = 1 WHERE fieldname = 'emailbody' AND special <> 1;

[Computer Guru]

Thanks - That did the trick! Any idea what caused it (i.e. is there anything else that could have broken that needs to be fixed?)?

[Matthew Gordon]

I don't. Someone else might have a better idea, but this is the first time I've seen this particular issue.

[Computer Guru]

Alright, thanks. I really appreciate the speedy turnaround on this.