Page 1 of 1

New Issue Reporting Issue Number Incrementing by 10

Posted: 11 Mar 2020, 07:22
by wdolson
We had a problem with our old Mantis installation and had to move severs. I upgraded us to 2.16.0 while I was at it. It sat there for a while unused while my manager talked about moving it back to the old server, but we ended up putting this installation into service yesterday.

When I added the first few issues I found that the issue numbers are now incrementing by 10 with each new issue instead of 1. Is there a setting for this anywhere? I can't imagine why anyone would want to increment by 10.

Re: New Issue Reporting Issue Number Incrementing by 10

Posted: 12 Mar 2020, 10:48
by cas
Perhaps there is a setting defined on the database like "SET @@auto_increment_increment=10;" :mrgreen:

Re: New Issue Reporting Issue Number Incrementing by 10

Posted: 13 Mar 2020, 00:31
by wdolson
I've combed through the database and didn't find any field that could be that. I think it's in a php field somewhere. We didn't make any changes to the database except upgrade it to the new version, but we did jump from a 1.x to 2.16, which is a fairly major upgrade.

Re: New Issue Reporting Issue Number Incrementing by 10

Posted: 13 Mar 2020, 09:37
by cas
best way to verify is the following steps:
Create test database
Create test table which has one auto incrementa field
Add a record, check that field
Add another record, check the field again

In case there is a DB setting, the field has increased with "10", if not something else is happening....

Re: New Issue Reporting Issue Number Incrementing by 10

Posted: 10 Aug 2020, 08:29
by wdolson
I contacted my web host provider. They set their database server to increment ids by 10 and they aren't going to change it. Is there any way to override the use of the auto index done by the database server?

Re: New Issue Reporting Issue Number Incrementing by 10

Posted: 10 Aug 2020, 09:23
by cas
Strange response from your provider, actually bullshit since that can be set set on table level :mrgreen:
Here is the command to change it via for example phpmyadmin:
https://stackoverflow.com/questions/970 ... ing-number