Duplicate Key when Adding new Products

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Duplicate Key when Adding new Products

Damon Hill
This is a new post of a previous post from two weeks ago.

Running Bugzilla 2.18.3 on Apache 2.0.52 and MySQL 4.1.10a.
I have been able to successfully add products since upgrading but now something
has changed causing all sorts of hell to happen on the server.
The error I receive is the following:

DBD::mysql::st execute failed: Duplicate entry '9-18-0' for key 1 [for Statement
"INSERT INTO group_group_map (member_id, grantor_id, isbless)
                  VALUES (9, 18, 1)"] at Bugzilla/DB.pm line 62
     Bugzilla::DB::SendSQL('INSERT INTO group_group_map (member_id, grantor_id,
isbless)\x{a}...') called at /var/www/bugzilla/editproducts.cgi line 385

I have ran the checksetup.pl and the Sanity Check with no errors.

At this point I am not sure if this is a bug with 2.18.3 or not since I did not
see the error until I upgraded to that version via the CVS update.

Any help would be appreciated.

Thanks,
~damon
_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Duplicate Key when Adding new Products

Marc Schumann
Damon,

2005/8/2, Damon Hill <[hidden email]>:
> DBD::mysql::st execute failed: Duplicate entry '9-18-0' for key 1 [for Statement
> "INSERT INTO group_group_map (member_id, grantor_id, isbless)
>                   VALUES (9, 18, 1)"] at Bugzilla/DB.pm line 62

this looks like a broken index on the group_group_map table to me.
What does |SHOW INDEX FROM group_group_map;| give you?

   Regards
      Marc

--
http://wurblzap.net/
Bugzilla hosting and professional support

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Duplicate Key when Adding new Products

Damon Hill
In reply to this post by Damon Hill
Marc Schumann wrote:

> Damon,
>
> 2005/8/2, Damon Hill <[hidden email]>:
>
>>DBD::mysql::st execute failed: Duplicate entry '9-18-0' for key 1 [for Statement
>>"INSERT INTO group_group_map (member_id, grantor_id, isbless)
>>                  VALUES (9, 18, 1)"] at Bugzilla/DB.pm line 62
>
>
> this looks like a broken index on the group_group_map table to me.
> What does |SHOW INDEX FROM group_group_map;| give you?
>
>    Regards
>       Marc
>
This is the results of my SHOW INDEX FROM group_group_map;

mysql> SHOW INDEX FROM group_group_map;
+-----------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table           | Non_unique | Key_name  | Seq_in_index | Column_name |
Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-----------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| group_group_map |          0 | member_id |            1 | member_id   | A
     |        NULL |     NULL | NULL   |      | BTREE      |         |
| group_group_map |          0 | member_id |            2 | grantor_id  | A
     |        NULL |     NULL | NULL   |      | BTREE      |         |
| group_group_map |          0 | member_id |            3 | grant_type  | A
     |          41 |     NULL | NULL   |      | BTREE      |         |
+-----------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
3 rows in set (0.03 sec)

Thanks,
~damon
_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Duplicate Key when Adding new Products

Marc Schumann
So your indexes are all right.

> > 2005/8/2, Damon Hill <[hidden email]>:
> >
> >>DBD::mysql::st execute failed: Duplicate entry '9-18-0' for key 1 [for Statement
> >>"INSERT INTO group_group_map (member_id, grantor_id, isbless)
> >>                  VALUES (9, 18, 1)"] at Bugzilla/DB.pm line 62

Sorry, I'm stumped then :(
No idea why the database would complain 9-18-0 would be a duplicate
entry when you're trying to insert 9-18-1.

   Good luck
      Marc

--
http://wurblzap.net/
Bugzilla hosting and professional support

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools