Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » ldap user login (SQL error with ldap plugin - duplicate key)
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
ldap user login [message #162421] Fri, 07 May 2010 19:12 Go to next message
lbrigman124 is currently offline  lbrigman124   United States
Messages: 26
Registered: March 2010
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I am getting a user error on auto registration with the
ldap plugin. I have updated to the 4953 svn version.

) : ERROR: duplicate key violates unique constraint "fud30_users_i_e"
Query: INSERT INTO fud30_users ( login, alias, passwd, salt, name, email, icq, aim, yahoo, msnm, jabber, affero, google, skype, twitter, posts_ppg, time_zone, bday, last_visit, conf_key, user_image, join_date, location, theme, occupation, interests, referer_id, last_read, sig, home_page, bio, users_opt, reg_ip, topics_per_page, flag_cc, flag_country ) VALUES ( 'dromrell', 'dromrell', 'f673f90518cb8c45df5c1b29d209b0b99253eb06', '007307c68', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 40, 'America/Los_Angeles', 0, 1273273025, '', NULL, 1273273025, NULL, 1, NULL, NULL, 0, 1273273025, NULL, NULL, NULL, 4357012, 2130706433, 40, NULL, NULL )
_GET: array ( 't' => 'login', )
_POST: array ( 'login' => 'dromrell', 'password' => 'xxxxxxxx', 'use_cookie' => 'Y', 'S' => '1f1dbe2e5b2be2eeb4dcef9f0a2f734f', 'SQ' => '0', 'adm' => '', )
Database Version: PostgreSQL 8.1.18 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-46)
[Referring Page] http://xfiles/forums/index.php?t=login&S=1f1dbe2e5b2be2eeb4dcef9f0a2f73 4f
Re: ldap user login [message #162422 is a reply to message #162421] Fri, 07 May 2010 22:11 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3687
Registered: December 2004
Karma: 19
Senior Member
Core Developer
add to buddy list
ignore all messages by this user
It fails on a duplicate e-mail address '' (empty string). Try to assign a NULL or dummy e-mail address in the plugin. For example:

$uent->email = $login .'@'. $ini['LDAP_HOST'];
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: NNTP Syncing :: Header for Reply from Email Notification Doesn't Contain Reference in Header
Next Topic: log files and external scripts problem
Goto Forum:

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 11 18:13:24 EST 2018

Total time taken to generate the page: 0.00561 seconds