-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
It's this one:
- -----------------------------------------------------------------
Map => [
[ 'UserTitle','Title','title',1, 0, 'var', '', 0 ],
[ 'UserFirstname','Firstname', 'first_name', 1, 1, 'var', '', 0 ],
[ 'UserLastname','Lastname', 'last_name', 1, 1, 'var', '', 0 ],
[ 'UserLogin','Username', 'login', 1, 1, 'var', '', 0 ],
[ 'UserPassword','Password', 'pw', 1, 1, 'var', '', 0 ],
[ 'UserEmail','Email','email',1, 1, 'var', '', 0 ],
[ 'UserCustomerID','CustomerID','customer_id', 0, 1, 'var','', 0 ],
[ 'UserPhone', 'Phone', 'phone', 1, 0, 'var', '', 0 ],
[ 'UserFax', 'Fax', 'fax', 1, 0, 'var', '', 0 ],
[ 'UserMobile', 'Mobile','mobile', 1, 0, 'var', '', 0 ],
[ 'UserStreet', 'Street','street', 1, 0, 'var', '', 0 ],
[ 'UserZip', 'Zip', 'zip', 1, 0, 'var', '', 0 ],
[ 'UserCity', 'City', 'city', 1, 0, 'var', '', 0 ],
[ 'UserCountry','Country', 'country',1, 0, 'var', '', 0 ],
[ 'UserComment','Comment', 'comments', 1, 0, 'var', '', 0 ],
[ 'ValidID', 'Valid', 'valid_id', 0, 1, 'int', '', 0 ],
]
- -----------------------------------------------------------------
On 09/24/2014 01:41 PM, Gerald Young wrote:
> The error message says it's trying to insert without a password
> (pw) which fails because pw can't be null.
>
> So what's your CustomerUser Map in Config.pm?
>
> On Wed, Sep 24, 2014 at 6:27 AM, Maila Fatticcioni
> <mfatticci...@mbigroup.it <mailto:mfatticci...@mbigroup.it>>
> wrote:
>
> Hello. We have installed and configured OTRS 3.3.8 on an Ubuntu
> 12.04.02 LTS, using Postgres 8.4 as database backend.
>
> Each time we try to create a new customer user we get this kind of
> error:
> -----------------------------------------------------------------
> otrs ERROR: null value in column "pw" violates not-null constraint
> -----------------------------------------------------------------
>
> I checked the column of the table customer_user and, indeed, the
> pw value must be not null.
>
> Following the suggestion found at this url:
> http://lists.otrs.org/pipermail/otrs/2010-November/033772.html I
> changed the Kernel/Config.pm file and declare the password field
> as mandatory.
>
> This changes the password attribute as I can see from the
> generated source page:
> -----------------------------------------------------------------
> <label class="Mandatory" for="UserPassword"><span
> class="Marker">*</span> Password:</label> <div class="Field"><input
> type="password" id="UserPassword" name="UserPassword" class="W50pc
> Validate_Required " value="" maxlength="100" /> <div
> id="UserPasswordError" class="TooltipErrorMessage"><p>This field is
> required.</p></div> <div id="UserPasswordServerError"
> class="TooltipErrorMessage"><p>This field is required.</p></div>
> </div> <div class="Clear"></div>
> -----------------------------------------------------------------
>
> But this trick doesn't resolve our problem because the password
> field is still missing in the insert statement as I can see in the
> database log:
> -----------------------------------------------------------------
> ERROR: null value in column "pw" violates not-null constraint
> STATEMENT: INSERT INTO customer_user ( title, first_name,
> last_name, login, email, customer_id, phone, fax, mobile,
> street, zip, city, country, comments, valid_id, create_time,
> create_by, change_time, change_by) VALUES ( '', 'a', 'b',
> 'TESTNAME', 'd...@example.com <mailto:d...@example.com>', 'sd324',
> '', '', '', '', '', '', '', '', 1, '2014-09-24 10:42:01', 3,
> '2014-09-24 10:42:01', 3)
> -----------------------------------------------------------------
>
> How can we fix this problem? Did I miss some steps of the previous
> solution?
>
> Could it help if I change the attribute of the pw column of the
> table allowing to insert empty password?
>
> Thank you in advance for any help you could give me.
>
> Best regards, Maila Fatticcioni
>
>
>
> ---------------------------------------------------------------------
>
>
OTRS mailing list: otrs - Webpage: http://otrs.org/
> Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe:
> http://lists.otrs.org/cgi-bin/listinfo/otrs
>
>
- --
______________________________________________________________
Maila Fatticcioni
______________________________________________________________
Mediterranean Broadband Infrastructure s.r.l.
via Francesco Squartini n°7
56121 Ospedaletto (PI) - ITALY
______________________________________________________________
Phone: +39(050)3870851 Fax: +39(050)3870809
______________________________________________________________
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
iEYEARECAAYFAlQisRwACgkQi2q3wPb3FcNXSwCfQ/7P4vpaJrQwyC6NVjqOltf7
+NIAoN/DbQzQwMDgv15/+hdsqlUoBpSJ
=pEw5
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
