BUG ID
Posted: 16 Mar 2017, 06:06
In my Mantis bug sheet the "BUG ID" increment by '2',how to make it increment by '1'...please help with the issue
atrol wrote:I am not able to reproduce this behaviour.
Which database version do you use?
Assuming you are talking about MySQL, you have to use at least 5.5.35arjunmohan wrote: Version information: 4.0.10.18
atrol wrote:Assuming you are talking about MySQL, you have to use at least 5.5.35arjunmohan wrote: Version information: 4.0.10.18
https://www.mantisbt.org/docs/master/en ... e.versions
Code: Select all
CREATE TABLE mantis_test (
id INT NOT NULL AUTO_INCREMENT,
value CHAR(30) NOT NULL,
PRIMARY KEY (id)
);
INSERT INTO mantis_test (value) VALUES ('val1'),('val2'),('val3');
SELECT * FROM mantis_test;
Code: Select all
SHOW VARIABLES LIKE 'auto_inc%' ;
atrol wrote:Whats the output when running the following statementsCode: Select all
CREATE TABLE mantis_test ( id INT NOT NULL AUTO_INCREMENT, value CHAR(30) NOT NULL, PRIMARY KEY (id) ); INSERT INTO mantis_test (value) VALUES ('val1'),('val2'),('val3'); SELECT * FROM mantis_test;
Code: Select all
SHOW VARIABLES LIKE 'auto_inc%' ;
Thank u for your valuable help !!!atrol wrote:You have to change your database setting auto_increment_increment from 2 to 1.
There is no other way than asking your administrator to change the setting.arjunmohan wrote:asking for root privileges !!