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.
New Issue Reporting Issue Number Incrementing by 10
Moderators: Developer, Contributor
Re: New Issue Reporting Issue Number Incrementing by 10
Perhaps there is a setting defined on the database like "SET @@auto_increment_increment=10;"
Re: New Issue Reporting Issue Number Incrementing by 10
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
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....
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
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
Strange response from your provider, actually bullshit since that can be set set on table level
Here is the command to change it via for example phpmyadmin:
https://stackoverflow.com/questions/970 ... ing-number
Here is the command to change it via for example phpmyadmin:
https://stackoverflow.com/questions/970 ... ing-number