{exp:user:edit dynamic="off" }
          <h2>{screen_name}</h2>
        <p><strong>Ministry role: </strong><br /> <input name="role" size="25" value="{role}" /></p>
        <p><strong>Parish: </strong><br /> <select name="parish" style="width:250px">
{select_parish}
<option value="{value}" {selected}>{value}</option>
{/select_parish} <br />or <input name="parish-other" size="20" value="{parish-other}" /></p>
        <p><strong>Region: </strong><br /> <input name="region" size="30" value="{region}" /></p>
        <p><strong>Bio: </strong><br /> <textarea cols="35" rows="5" name="bio" value="{bio}" />{bio}</textarea></p>
        <p><input type="submit" value="Update" /></p>
{/exp:user:edit}
<hr />
            <h2>Avatar</h2>
        <p>{exp:user:stats dynamic="off"}<img src="{if avatar_filename}/images/avatars/{avatar_filename}{if:else}/images/avatar.png{/if}" alt="Current avatar" style="float:none;margin:0;" />{/exp:user:stats}</p>

{exp:user:edit dynamic="off" }
        <p>File format: JPG, GIF or PNG.<br />
        <input type="file" name="avatar_filename" id="browse" size="10" /></p>
        <p><input type="submit" value="Update" /></p>
{/exp:user:edit}
<hr />
           <h2>Email and Password</h2>
    {exp:user:edit dynamic="off" }
        <p>Email Address:<br /><input type="text" name="email" id="email" value="{email}"  /></p>
        <p>New Password:<br /><input type="password" name="password" id="password" /></p>
        <p>Confirm New Password:<br /><input type="password" name="password_confirm" id="password_confirm" /></p>
        <p>Current Password:<br /><input type="password" name="current_password" id="current_password" /></p>
<select name="parish" style="display:none">
{select_parish}
<option value="{value}" {selected}>{value}</option>
{/select_parish}
        <p><input type="submit" value="Update" /></p>
    {/exp:user:edit}
<hr />
           <h2>Your Account Statistics</h2>{exp:user:stats}
        <p><strong>Join Date: </strong> {join_date format="%F %j, %Y"} <br />
        <strong>Last Visit: </strong> {last_visit format="%F %j, %Y"} <br />
        <strong>Most Recent Comment: </strong> {if last_comment_date}{last_comment_date format="%F %j, %Y"}{if:else}-{/if}<br />
        <strong>Total Comments: </strong> {total_comments}</p>{/exp:user:stats}

SQLSTATE[HY000]: General error: 1364 Field 'hash' doesn't have a default value:
INSERT INTO `exp_user_params` (`entry_date`, `data`) VALUES (1508476350, '{"use_channel_sync":false,"member_id":891,"checks":"","custom_checks":"role|parish|region|","username":"xxxx","return":"","username_override":"","exclude_username":"","required":"","group_id":"","password_required":"","secure_action":"no","screen_name_password_required":"y","user_assigned_roles":"n","assign_roles":[]}')

ee/legacy/database/drivers/mysqli/mysqli_connection.php:122