Cannot create flags. Receive error "DBD::mysql::db do failed: Duplicate entry '0' for key 1 "

RESOLVED WORKSFORME

Status

()

--
major
RESOLVED WORKSFORME
8 years ago
8 years ago

People

(Reporter: brennx0r, Unassigned)

Tracking

3.4.6
x86
Linux

Details

(Reporter)

Description

8 years ago
User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.8) Gecko/20100722 Firefox/3.6.8 ( .NET CLR 3.5.30729)
Build Identifier: Bugzilla 3.4.6

With my company's installation of Bugzilla, we've found that we cannot create new flags.  Below describes the behavior that is experienced.  My IT team has looked into the issue but cannot resolve it, and suggested that I file a bug with you.  Any help or information about this issue would be much appreciated.



Reproducible: Always

Steps to Reproduce:

1.  Log in with Admin account
2.  Click the Administration link
3.  Click the Flags link
4.  Click the link for adding a new flag
5.  For the form flag name, submit the following value (any simple string value appears to make this issue occur):

TestCaseCreated



6.  Leave all other values at defaults.
7.  Submit the form




Actual Results:  
This error is given:

DBD::mysql::db do failed: Duplicate entry '0' for key 1 [for Statement "INSERT INTO flagtypes
                          (name, description, cc_list, target_type,
                           sortkey, is_active, is_requestable, 
                           is_requesteeble, is_multiplicable, 
                           grant_group_id, request_group_id) 
                   VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"] at /opt/bugzilla/editflagtypes.cgi line 324
	main::insert('t79Wgo9ts6') called at /opt/bugzilla/editflagtypes.cgi line 83


Expected Results:  
The flag is created without issue (no errors)

We don't use any themes.
(Reporter)

Updated

8 years ago
OS: Windows XP → Linux
Version: unspecified → 3.4.6

Comment 1

8 years ago
I don't see how you can trigger a duplicate entry error as the flagtypes table has no UNIQUE key. Something must be wrong with your DB schema. Ask your IT team to look at what "desc flagtypes" returns.
Assignee: general → administration
Status: UNCONFIRMED → RESOLVED
Last Resolved: 8 years ago
Component: Bugzilla-General → Administration
Resolution: --- → WORKSFORME
(Reporter)

Comment 2

8 years ago
mysql> desc flagtypes 
-> ; 
+------------------+--------------+------+-----+---------+-------+ 
| Field | Type | Null | Key | Default | Extra | 
+------------------+--------------+------+-----+---------+-------+ 
| id | smallint(6) | NO | PRI | NULL | | 
| name | varchar(50) | NO | | NULL | | 
| description | mediumtext | NO | | NULL | | 
| cc_list | varchar(200) | YES | | NULL | | 
| target_type | char(1) | NO | | b | | 
| is_active | tinyint(4) | NO | | 1 | | 
| is_requestable | tinyint(4) | NO | | 0 | | 
| is_requesteeble | tinyint(4) | NO | | 0 | | 
| is_multiplicable | tinyint(4) | NO | | 0 | | 
| sortkey | smallint(6) | NO | | 0 | | 
| grant_group_id | mediumint(9) | YES | MUL | NULL | | 
| request_group_id | mediumint(9) | YES | MUL | NULL | | 
+------------------+--------------+------+-----+---------+-------+ 
12 rows in set (0.00 sec) 



SET character_set_client = utf8; 
CREATE TABLE `flagtypes` ( 
`id` smallint(6) NOT NULL, 
`name` varchar(50) NOT NULL, 
`description` mediumtext NOT NULL, 
`cc_list` varchar(200) default NULL, 
`target_type` char(1) NOT NULL default 'b', 
`is_active` tinyint(4) NOT NULL default '1', 
`is_requestable` tinyint(4) NOT NULL default '0', 
`is_requesteeble` tinyint(4) NOT NULL default '0', 
`is_multiplicable` tinyint(4) NOT NULL default '0', 
`sortkey` smallint(6) NOT NULL default '0', 
`grant_group_id` mediumint(9) default NULL, 
`request_group_id` mediumint(9) default NULL, 
PRIMARY KEY (`id`), 
KEY `fk_flagtypes_grant_group_id_groups_id` (`grant_group_id`), 
KEY `fk_flagtypes_request_group_id_groups_id` (`request_group_id`), 
CONSTRAINT `fk_flagtypes_grant_group_id_groups_id` FOREIGN KEY (`grant_group_id`) REFERENCES `groups` (`id`) ON UPDATE CASCADE, 
CONSTRAINT `fk_flagtypes_request_group_id_groups_id` FOREIGN KEY (`request_group_id`) REFERENCES `groups` (`id`) ON UPDATE CASCADE 
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
(Reporter)

Comment 3

8 years ago
(In reply to comment #2)
> mysql> desc flagtypes 
> -> ; 
> +------------------+--------------+------+-----+---------+-------+ 
> | Field | Type | Null | Key | Default | Extra | 
> +------------------+--------------+------+-----+---------+-------+ 
> | id | smallint(6) | NO | PRI | NULL | | 
> | name | varchar(50) | NO | | NULL | | 
> | description | mediumtext | NO | | NULL | | 
> | cc_list | varchar(200) | YES | | NULL | | 
> | target_type | char(1) | NO | | b | | 
> | is_active | tinyint(4) | NO | | 1 | | 
> | is_requestable | tinyint(4) | NO | | 0 | | 
> | is_requesteeble | tinyint(4) | NO | | 0 | | 
> | is_multiplicable | tinyint(4) | NO | | 0 | | 
> | sortkey | smallint(6) | NO | | 0 | | 
> | grant_group_id | mediumint(9) | YES | MUL | NULL | | 
> | request_group_id | mediumint(9) | YES | MUL | NULL | | 
> +------------------+--------------+------+-----+---------+-------+ 
> 12 rows in set (0.00 sec) 
> 
> 
> 
> SET character_set_client = utf8; 
> CREATE TABLE `flagtypes` ( 
> `id` smallint(6) NOT NULL, 
> `name` varchar(50) NOT NULL, 
> `description` mediumtext NOT NULL, 
> `cc_list` varchar(200) default NULL, 
> `target_type` char(1) NOT NULL default 'b', 
> `is_active` tinyint(4) NOT NULL default '1', 
> `is_requestable` tinyint(4) NOT NULL default '0', 
> `is_requesteeble` tinyint(4) NOT NULL default '0', 
> `is_multiplicable` tinyint(4) NOT NULL default '0', 
> `sortkey` smallint(6) NOT NULL default '0', 
> `grant_group_id` mediumint(9) default NULL, 
> `request_group_id` mediumint(9) default NULL, 
> PRIMARY KEY (`id`), 
> KEY `fk_flagtypes_grant_group_id_groups_id` (`grant_group_id`), 
> KEY `fk_flagtypes_request_group_id_groups_id` (`request_group_id`), 
> CONSTRAINT `fk_flagtypes_grant_group_id_groups_id` FOREIGN KEY
> (`grant_group_id`) REFERENCES `groups` (`id`) ON UPDATE CASCADE, 
> CONSTRAINT `fk_flagtypes_request_group_id_groups_id` FOREIGN KEY
> (`request_group_id`) REFERENCES `groups` (`id`) ON UPDATE CASCADE 
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Does this show any obvious issue or anomaly?
(Reporter)

Comment 4

8 years ago
We are still having this issue and are still in need of assistance.
Status: RESOLVED → UNCONFIRMED
Resolution: WORKSFORME → ---

Comment 5

8 years ago
This is a support question. Please visit http://www.bugzilla.org/support for help.
Status: UNCONFIRMED → RESOLVED
Last Resolved: 8 years ago8 years ago
Resolution: --- → INVALID

Updated

8 years ago
Resolution: INVALID → WORKSFORME
You need to log in before you can comment on or make changes to this bug.