BUG ID

General discussion of Mantis.

Moderators: Developer, Contributor

Post Reply
arjunmohan
Posts: 5
Joined: 16 Mar 2017, 05:47

BUG ID

Post by arjunmohan »

In my Mantis bug sheet the "BUG ID" increment by '2',how to make it increment by '1'...please help with the issue
Attachments
View Issues   Leniko Bug Tracker.png
View Issues Leniko Bug Tracker.png (131.22 KiB) Viewed 8311 times
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: BUG ID

Post by atrol »

I am not able to reproduce this behaviour.

Which database version do you use?
Please use Search before posting and read the Manual
arjunmohan
Posts: 5
Joined: 16 Mar 2017, 05:47

Re: BUG ID

Post by arjunmohan »

atrol wrote:I am not able to reproduce this behaviour.

Which database version do you use?

Version information: 4.0.10.18
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: BUG ID

Post by atrol »

arjunmohan wrote: Version information: 4.0.10.18
Assuming you are talking about MySQL, you have to use at least 5.5.35
https://www.mantisbt.org/docs/master/en ... e.versions
Please use Search before posting and read the Manual
arjunmohan
Posts: 5
Joined: 16 Mar 2017, 05:47

Re: BUG ID

Post by arjunmohan »

atrol wrote:
arjunmohan wrote: Version information: 4.0.10.18
Assuming you are talking about MySQL, you have to use at least 5.5.35
https://www.mantisbt.org/docs/master/en ... e.versions

Sorry i wil attach the screenshot,i refered above is php my admin version
Attachments
server.leniko.in   localhost   phpMyAdmin 4.0.10.18.png
server.leniko.in localhost phpMyAdmin 4.0.10.18.png (46.3 KiB) Viewed 8285 times
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: BUG ID

Post by atrol »

Whats the output when running the following statements

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%' ;
Please use Search before posting and read the Manual
arjunmohan
Posts: 5
Joined: 16 Mar 2017, 05:47

Re: BUG ID

Post by arjunmohan »

atrol wrote:Whats the output when running the following statements

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%' ;
Attachments
2.png
2.png (58.92 KiB) Viewed 8284 times
1.png
1.png (27.63 KiB) Viewed 8284 times
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: BUG ID

Post by atrol »

You have to change your database setting auto_increment_increment from 2 to 1.
Please use Search before posting and read the Manual
arjunmohan
Posts: 5
Joined: 16 Mar 2017, 05:47

Re: BUG ID

Post by arjunmohan »

atrol wrote:You have to change your database setting auto_increment_increment from 2 to 1.
Thank u for your valuable help !!!
I did that ,but it asking for root privileges !!
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: BUG ID

Post by atrol »

arjunmohan wrote:asking for root privileges !!
There is no other way than asking your administrator to change the setting.
Please use Search before posting and read the Manual
Post Reply