Re: [otrs]Wow it works Re: [dev] How to make Email field in the add user page to take null value.

9 May 2005

      Hi Victor,

Its working. You are genius :)

Thanks and Regards,
Sumeet

Victor Rodriguez Cortes  wrote:
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 way 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 UserEmail 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
Valoraciones 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/