On Wed, 2005-09-21 at 16:48 +0100, Stephen Jones wrote:
> Hi, I'm attempting to modify an existing OTRS install so as to enable
> the customer frontend. We have an MySQL db for holding customer data
> which I'm attempting to add passwords to so customers can use it. I've
> added "['UserPassword','Password','CT_ACCOUNT',0,1,'var']" to
> $Self->{CustomerUser}->{Map}, and added the line "$Self->{'AuthModule'}
> = 'Kernel::System::Auth::DB';" in Config.pm. However when I try to set a
> password through the Admin interface I get this error:
>
> Sep 21 14:49:02 xtr2 OTRS-CGI-1[16325]:
> [Error][Kernel::System::CustomerUser::DB::CustomerUserUpdate][Line:431]:
> Unknown column 'change_time' in 'field list', SQL: 'UPDATE CONTACT SET
> CT_FNAME = 'Stephen', CT_LNAME = 'Jones', CT_CONAME = '****', CT_EMAL
> = '****', CT_EMAL = '****', CT_IDNO = '2445', CT_BPHN = '****',
> CT_BPHN2 = '', CT_BMAINPHN = '', CT_MOB = '****', CT_APHN = '',
> CT_HPHN = '****', change_time = current_timestamp, change_by = 1
> WHERE CT_EMAL = '****''
>
> As far as I can tell change_time and change_by are used by OTRS for
> Tickets, so does anyone know why they're turning up in this statement?
It seems that the fields change_time and change_by are hardcoded into
the CustomerUserUpdate function, does anyone know why? Has anyone
successfully enabled the customer frontend for an existing SQL customer
database? Anyone know if I can remove the lines:
$SQL .= " change_time = current_timestamp, ";
$SQL .= " change_by = $Param{UserID} ";
>From Kernel/System/CustomerUser/DB.pm?
_______________________________________________
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
Support oder Consulting für Ihr OTRS System?
=> http://www.otrs.de/
