Hi!

Well, I'm not an expert, but it seems that the check to verify that email is not
null isn't in the database, but on the code itself. In my DB, user_preferences looks like:

user_id,preferences_key,preferences_value

2, 'UserEmail', 'an-email-address@valmesa.es'
2, 'UserLanguage', 'es'
2, 'UserTheme', 'Neo'
2, 'UserQueueViewShowTickets', '15'
2, 'UserQueueView', 'TicketView'
2, 'UserRefreshTime', '5'
2, 'UserCreateNextMask', 'AgentZoom'
2, 'UserSendNewTicketNotification', ''
2, 'UserSendFollowUpNotification', ''
2, 'UserSendLockTimeoutNotification', ''
2, 'UserSendMoveNotification', ''
2, 'UserSpellDict', 'spanish'
2, 'UserComment', ''

"preferences_key" can't be null, but it is any kind of "preference". It's something
like pairs of properties asociated with the agent by it's user_id, so I don't see any wa y to
control if it's null or not directly from the DB.

Given the error traceback that you get if you try to setup an agent without a
password, I would start looking in $OTRSHOME/Kernel/System/User.pm, them for
function UserAdd and... yes, there you have it!:

[...]
foreach (qw(Firstname Lastname Login Pw ValidID UserID Email)) {
if (!$Param{$_}) {
$Self->{LogObject}->Log(Priority => 'error', Message => "Need $_!");
return;
}
[...]

Remove "Email" from that "foreach" and try it... and let me know if it works,
please! My system is currently in production and I can't take it down to test this.

Regards,


Ps: I've just discovered what you where asking for, sorry for the big and dissordered
mail!



On 9 May 2005 at 1:40, sumeet prasad wrote:

>
> Victor, Peter,
>
> Thanks for the pointers. Its works.
>
> Some inside stuff of the problem.
> The schema where I am able to finduser emailis in user_preferences
> table. Schema is: #
> ----------------------------------------------------------------------
> - # user_preferences #
> ----------------------------------------------------------------------
> - drop table if exists user_preferences;CREATE TABLE user_preferences
> (
> user_id INTEGER NOT NULL,
> preferences_key VARCHAR (150) NOT NULL,
> preferences_value VARCHAR (250),
> INDEX index_user_preferences_user_id (user_id)
> );
> I am able to see UserEmail field at the mysql command line output of
> user_preference table. Preference key column has the "UserEmail" and
> the email address is under preferences_value.
>
> Can any one tell me how this field can be made null. First time i have
> come across INDEX index_user_preferences_user_id. Could any one tell
> me more on this schema. And how to make the UserEm ail field null.
>
> Regards,
> Sumeet
>
>
> Victor Rodriguez Cortes wrote:
> Hello!
>
> As a workaround, you can use a non existent mail address like
> "thisdoesntexist@yourdomain.org". It's important that the domain
> part of the mail address exists to pass the automatic MX check in
> DNS.
>
> Regards,
>
>
>
> On 8 May 2005 at 23:50, sumeet prasad wrote:
>
> >
> > Hi OTRS Team,
> >
> > I don't want to give email address in the field Email: while
> creating > user(agents). Its not creating user when email id not
> given. > > How could I give null value in email field andcreate
> users ? > > Its urgent. Could any one please give inputs. > >
> Regards, > Sumeet
>



---
Victor R. Rodriguez
Departamento de Sistemas
Valor aciones del Mediterraneo, S.A.
---


_______________________________________________
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/