setting usernick from new_account.html

I've added to new_account.html in the strap demo

[set new_usernick]
&fatal=1
&set=usernick [cgi mv_usernick]
[/set]

And below the email address

<div class="form-group">
        <label for="mv_usernick" class="control-label col-sm-2">[error std_label="[L]usernick[/L]"]:</label>
                <div class="col-sm-10 col-md-7 col-lg-5">
                        [calc]
                        $Scratch->{usernick} [new_usernick]
                        [/calc]
                        [display usernick]

                </div>
        </div>

So


New Account
Your email:
(please double-check)
usernick:
Password:
Verify Password:

I put in my email address for email and usernick
click on create account
I still get

/cgi-bin/ic510/process set_row error as called by Vend::Table::DBI: DBD::mysql::db do failed: Field 'usernick' doesn't have a default value at /usr/local/interchange-5.10/lib/Vend/Table/DBI.pm

new_account.html
----------------------------------------------------------------------------------
[tmp page_title]__COMPANY__ -- [L]New Account[/L][/
[tmp display_class]noleft[/tmp]

@_TOP_@
<!-- BEGIN CONTENT -->

<div class="col-md-11 col-md-offset-1">

<div class="page-header">
<h1>[L]New Account[/L]</h1>
</div>

[if session logged_in][bounce href="[area member/account]"][/if]
[if !scratch new]
        [if session failure]<div class="alert alert-danger">[calc] delete $Session->{failure}[/calc]</div>[/if]
        [edisplay show_var=0]
[else]
[set new][/set]
[/else]
[/if]

[set NewAccount]
[calc]delete $Scratch->{usernick};[/calc]
[if type=explicit compare="[userdb new_account]"]
mv_nextpage=[either][cgi destination][or]member/account[/either]
[else]
mv_nextpage=new_account
[/else]
[/if]
[/set]

[set new_emailcheck]
&fatal=1
mv_username=email_only
&set=email [cgi mv_username]
[/set]
<!--
[set new_usernick]
&set=new_usernick [cgi mv_username]
[/set]
-->
[set new_usernick]
&fatal=1
&set=usernick [cgi mv_usernick]
[/set]

<form action="[process]" method="POST" class="form-horizontal">
<fieldset>
[form-session-id]
<input type="hidden" name="mv_form_profile" value="new_emailcheck">
<input type="hidden" name="mv_click" value="NewAccount">
<input type="hidden" name="mv_doit" value="return">
<input type="hidden" name="function" value="new_account">
<input type="hidden" name="mv_nextpage" value="@@MV_PAGE@@">
<input type="hidden" name="destination" value="[cgi destination]">

        <div class="form-group">
        <label for="mv_username" class="control-label col-sm-2">[error filter=e name=mv_username std_label="[L]Your email[/L]"]:</label>
                <div class="col-sm-10 col-md-7 col-lg-5">
                        <input type="email" class="form-control" name="mv_username" id="mv_username" value="[value-extended name=mv_username]">
                        <small class="help-block">(please double-check)</small>
                </div>
        </div>
        <div class="form-group">
        <label for="mv_usernick" class="control-label col-sm-2">[error std_label="[L]usernick[/L]"]:</label>
                <div class="col-sm-10 col-md-7 col-lg-5">
<!--
[calc]delete $Scratch->{usernick};[/calc]
        <label for="mv_usernick" class="control-label col-sm-2">[error filter=usernick=mv_usernick std_label="[L]usernick[/L]"]:</label>
                        <input type="hidden" name="usernick" value="mv_username">
                        [display scratch new_usernick]
                        [display usernick]
-->
                        [calc]
                        $Scratch->{usernick} [new_usernick]
                        [/calc]
                        [display usernick]
<!--
                        [display scratch usernick]
-->
                </div>
        </div>
        <div class="form-group">
        <label for="mv_password" class="control-label col-sm-2">[error for=mv_password std_label="[L]Password[/L]"]:</label>
                <div class="col-sm-10 col-md-7 col-lg-5">
                        <input type="password" class="form-control" name="mv_password" id="mv_password" value="">
                </div>
        </div>
        <div class="form-group">
        <label for="mv_verify" class="control-label col-sm-2">[error for=mv_verify std_label="[L]Verify Password[/L]"]:</label>
                <div class="col-sm-10 col-md-7 col-lg-5">
                        <input type="password" class="form-control" name="mv_verify" id="mv_verify" value="" autocomplete="off" oncopy="return false" onpaste="return false" oncut="return false">
                </div>
        </div>
[if config CookieLogin]
        <div class="form-group">
                <div class="col-sm-10 col-sm-offset-2">
                        <div class="checkbox">
                                <label>
                                        <input type="checkbox" name="mv_cookie_password" value="1" checked=checked>
                                        [L]Remember me (uncheck if public terminal)[/L]
                                </label>
                        </div>
                </div>
        </div>
[/if]
        <div class="form-group">
                <div class="col-sm-offset-2 col-sm-10">
                        <input type="submit" value="[L]Create Account[/L]" class="btn btn-primary">
                </div>
        </div>
</fieldset>
</form>

</div>

[tmp clear_errors][error all=1 comment="Clear errors"][/tmp]

<!-- END CONTENT -->
@_BOTTOM_@