BUG ID
Moderators: Developer, Contributor
-
- Posts: 5
- Joined: 16 Mar 2017, 05:47
BUG ID
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 (131.22 KiB) Viewed 8328 times
-
- Posts: 5
- Joined: 16 Mar 2017, 05:47
Re: BUG ID
atrol wrote:I am not able to reproduce this behaviour.
Which database version do you use?
Version information: 4.0.10.18
Re: BUG ID
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
-
- Posts: 5
- Joined: 16 Mar 2017, 05:47
Re: BUG ID
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
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 (46.3 KiB) Viewed 8302 times
Re: BUG ID
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%' ;
-
- Posts: 5
- Joined: 16 Mar 2017, 05:47
Re: BUG ID
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%' ;
- Attachments
-
- 2.png (58.92 KiB) Viewed 8301 times
-
- 1.png (27.63 KiB) Viewed 8301 times
-
- Posts: 5
- Joined: 16 Mar 2017, 05:47
Re: BUG ID
Thank u for your valuable help !!!atrol wrote:You have to change your database setting auto_increment_increment from 2 to 1.
I did that ,but it asking for root privileges !!