FUDforum: Bug Reports » Minor Admin CP suggestion

Home » FUDforum Development » Bug Reports » Minor Admin CP suggestion

Show: Today's Messages :: Polls :: Message Navigator

Re: Minor Admin CP suggestion [message #15546 is a reply to message #15517]

Thu, 18 December 2003 15:03

Gribnif

Messages: 82
Registered: December 2003

Karma:

Member

This is the result I just got when I tried it again:

Add User
Error Has Occured
Register a new forum user.
Login: Login (lkjglj) is already in use.

Where lkjglj is just a random set of characters I banged on the keyboard, and only the email address was the same as another account.

I just pulled the code out of admadduser.php and substituted what seemed like good values:

INSERT INTO fud_users
 (login, alias, passwd, name, email, time_zone, join_date, theme, users_opt, last_read) VALUES (
 'lkdjfgl', 'kjhertk', 'junk',
 'ldfglnkre', '[duplicate email address]', 'timezone',
 'stamp', 'default', 0, 'stamp');

This produced the MySQL error:

ERROR 1062: Duplicate entry '[duplicate email address]' for key 2

Note that it says key 2. According to the code in admadduser, this gives the (wrong) error message I'm seeing. If I instead change the SQL code so that the "login" field is the duplicate, MySQL says this is key 3.

A "SHOW CREATE TABLE fud_users" lists the keys in this order:

  PRIMARY KEY  (`id`),
  UNIQUE KEY `fud_users_i_e` (`email`),
  UNIQUE KEY `fud_users_i_l` (`login`),
  UNIQUE KEY `fud_users_i_a` (`alias`),
  KEY `fud_users_i_rk` (`reset_key`),
  KEY `fud_users_i_lv` (`last_visit`),
  KEY `fud_users_i_ck` (`conf_key`),
  KEY `fud_users_i_ri` (`referer_id`),
  KEY `fud_users_i_uo` (`users_opt`)
) TYPE=MyISAM |

Report message to a moderator

[Message index]

		Minor Admin CP suggestion By: Gribnif on Wed, 17 December 2003 18:21
		Re: Minor Admin CP suggestion By: Ilia on Wed, 17 December 2003 21:30
		Re: Minor Admin CP suggestion By: Gribnif on Wed, 17 December 2003 22:09
		Re: Minor Admin CP suggestion By: Ilia on Wed, 17 December 2003 22:12
		Re: Minor Admin CP suggestion By: Gribnif on Thu, 18 December 2003 14:02
		Re: Minor Admin CP suggestion By: Ilia on Thu, 18 December 2003 14:04
		Re: Minor Admin CP suggestion By: Gribnif on Thu, 18 December 2003 15:03
		Re: Minor Admin CP suggestion By: Ilia on Thu, 18 December 2003 15:25

Previous Topic:	index.php problem
Next Topic:	Case-sensitivity problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 09 18:00:53 GMT 2024

Total time taken to generate the page: 0.07452 seconds