The Add User Mod for PHPBB is an excellent addition, letting admins add users directly, like when moving from an email list or alternate board.

However with PHPBB 3.0.7 you will encounter the problem that new users do not receive their automatically generated password in the signup email. Likewise, users who create a new account for themselves will not receive the password in email; perhaps this is desirable from a security standpoint, but it increases "Help me!" calls to admins like me to an unusable level.

• Edit language/en/email/user_welcome.txt and update as follows:

  ----------------------------
  Username: {USERNAME}
  
  
  Password: {PASSWORD}
  
  
  Board URL: {U_BOARD}
  ----------------------------
  
  
  Your password has been securely stored in our database and cannot be retrieved. In the event that it is forgotten, you will be able to reset it using the email address associated with your account.
  
  
  Thank you for registering.
  
  
  If you wish to change your new password to something you will more easily remember, the location to do so is...
  
  
  - User Control Panel link
  - Profile
  - Edit Account settings
  - then enter your New password
  - Confirm your New password
  - below that enter your Current password (just provided in this email)
  - click on the Submit button
  ...and you're done.
  
  
  * For your own security please also get accustomed to using a secure password - which is at least 7 characters, and which should include: Capital and lowercase letters, a number, and a punctuation mark. And preferably something not resembling an entry in your desktop dictionary!
  
  
  {EMAIL_SIG}  
  

• Purge the PHPBB cache: Right on the ACP General tab, in the first box is:

  Purge the cache
  Purge all cache related items, this includes any cached template files or queries.
  

  Click the Run Now button.

  Problem solved!

Encountered this whilst attempting to upgrade phpBB using svn:

SQL ERROR [ mysql4 ]

Unknown column 'g.group_skip_auth' in 'where clause' [1054]

SQL

SELECT a.forum_id, a.auth_option_id, a.auth_role_id, a.auth_setting
FROM acl_groups a, user_group ug, groups g
WHERE a.group_id = ug.group_idAND g.group_id = ug.group_id
  AND ug.user_pending = 0
  AND NOT (ug.group_leader = 1 AND g.group_skip_auth = 1)
  AND ug.user_id = 22

BACKTRACE

The solution took awhile to determine but it's quite simple. Go to your board's database update module at:

http://example.com/install/database_update.php

which will add the requisite columns to the tables.