BUG ID

General discussion of Mantis.

Moderators: Contributor, Developer

BUG ID

Postby arjunmohan » Mar 16, 2017 1:06 am

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 754 times
arjunmohan
 
Posts: 5
Joined: Mar 16, 2017 12:47 am

Re: BUG ID

Postby atrol » Mar 16, 2017 7:58 am

I am not able to reproduce this behaviour.

Which database version do you use?
Please use Search before posting and read the Manual
Use Mantis2Go to try MantisBT on Windows or to reproduce issues
atrol
Site Admin
 
Posts: 6249
Joined: Mar 26, 2008 4:37 pm
Location: Germany

Re: BUG ID

Postby arjunmohan » Mar 17, 2017 2:22 am

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

Which database version do you use?



Version information: 4.0.10.18
arjunmohan
 
Posts: 5
Joined: Mar 16, 2017 12:47 am

Re: BUG ID

Postby atrol » Mar 17, 2017 2:35 am

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
Use Mantis2Go to try MantisBT on Windows or to reproduce issues
atrol
Site Admin
 
Posts: 6249
Joined: Mar 26, 2008 4:37 pm
Location: Germany

Re: BUG ID

Postby arjunmohan » Mar 17, 2017 3:23 am

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 728 times
arjunmohan
 
Posts: 5
Joined: Mar 16, 2017 12:47 am

Re: BUG ID

Postby atrol » Mar 17, 2017 3:41 am

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
Use Mantis2Go to try MantisBT on Windows or to reproduce issues
atrol
Site Admin
 
Posts: 6249
Joined: Mar 26, 2008 4:37 pm
Location: Germany

Re: BUG ID

Postby arjunmohan » Mar 17, 2017 4:14 am

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 727 times
1.png
1.png (27.63 KiB) Viewed 727 times
arjunmohan
 
Posts: 5
Joined: Mar 16, 2017 12:47 am

Re: BUG ID

Postby atrol » Mar 17, 2017 4:33 am

You have to change your database setting auto_increment_increment from 2 to 1.
Please use Search before posting and read the Manual
Use Mantis2Go to try MantisBT on Windows or to reproduce issues
atrol
Site Admin
 
Posts: 6249
Joined: Mar 26, 2008 4:37 pm
Location: Germany

Re: BUG ID

Postby arjunmohan » Mar 17, 2017 5:27 am

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 !!
arjunmohan
 
Posts: 5
Joined: Mar 16, 2017 12:47 am

Re: BUG ID

Postby atrol » Mar 17, 2017 9:03 am

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
Use Mantis2Go to try MantisBT on Windows or to reproduce issues
atrol
Site Admin
 
Posts: 6249
Joined: Mar 26, 2008 4:37 pm
Location: Germany


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 13 guests