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 > 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', '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 >
--------------------------------------------------------------------- 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
