List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 14 2000 6:44pm
Subject:Re: may have found a horrible bug .....
View as plain text  
At 2:06 PM -0800 02-14-2000, Adam Powell wrote:
>Apologies if this bug has already been found, or if Im talking rubbish, but
>I think I have found a bug with the GRANT command (and the mysql.user
>table).  I am using version 3.23.10-alpha.
>
>Basically, sometimes when I GRANT access to a site, it doesnt appear in the
>list when I do SELECT * FROM User;.  When I try to delete it I cant, and
>when I try to update the password it doesnt work.

I don't see any SELECT statement below.  What is the statement, and what
is the result?


>
>Here is an example...
>
>mysql> insert into user values ( 'www3.neopets.com', 'neopets',
>'somepassword', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y',
>'Y', 'Y'  );
>ERROR 1062: Duplicate entry 'www3.neopets.com-neopets' for key 1
>mysql> delete from user where host='www3.neopets.com';
>Query OK, 0 rows affected (0.00 sec)
>
>mysql> insert into user values ( 'www3.neopets.com', 'neopets',
>'somepassword', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y',
>'Y', 'Y'  );
>ERROR 1062: Duplicate entry 'www3.neopets.com-neopets' for key 1
>mysql>
>
>Any ideas why this is happening?
>
>Thanks,
>Adam

-- 
Paul DuBois, paul@stripped
Thread
may have found a horrible bug .....Adam Powell14 Feb
  • Re: may have found a horrible bug .....Ondrej Sury14 Feb
  • Re: may have found a horrible bug .....Adam Powell14 Feb
    • Re: may have found a horrible bug .....Thimble Smith14 Feb
  • Re: may have found a horrible bug .....sinisa14 Feb
  • Re: may have found a horrible bug .....Adam Powell14 Feb
  • Re: may have found a horrible bug .....Paul DuBois14 Feb
  • Re: may have found a horrible bug .....Adam Powell14 Feb