So I know I must be overlooking this setting but I can't find it. I was able to find where I can change it from autoincrement or date or datechecksum but I can not find where I can change where I can start ticketing from a specific number. I can set how many digits I want which is currently default at 5.
I am running OTRS 6.0.17 on Centos7 and MySQL/MariaDB as by backend. There is not an error just looking for help if it is even possible to change
Change Ticket numbering
Moderator: crythias
-
root
- Administrator
- Posts: 4251
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Change Ticket numbering
Hi Robert,
There is no "official" way to set the ticket counter to a specific number.
May I ask why you want to do this?
- Roy
There is no "official" way to set the ticket counter to a specific number.
May I ask why you want to do this?
- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
cottonr
- Znuny newbie
- Posts: 4
- Joined: 02 Apr 2019, 07:13
- Znuny Version: 6.0.16
- Real Name: Robert
- Company: N/a
Re: Change Ticket numbering
I just didn't want it to start with small numbers. No reason really. I thought it would be easy to run a query on the db but that didn't work when I did that. I was able to update the table but OTRS didn't see the number change.
-
root
- Administrator
- Posts: 4251
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Change Ticket numbering
Which table did you changed? Did you deleted the cache after this?
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
cottonr
- Znuny newbie
- Posts: 4
- Joined: 02 Apr 2019, 07:13
- Znuny Version: 6.0.16
- Real Name: Robert
- Company: N/a
Re: Change Ticket numbering
I changed ticket_number_counter but which cache would I need to change?
-
root
- Administrator
- Posts: 4251
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Change Ticket numbering
Hi,
to delete the ORS cache run as OTRS user from /opt/otrs:
- Roy
to delete the ORS cache run as OTRS user from /opt/otrs:
Code: Select all
bin/otrs.Console.pl Maint::Cache::Delete
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
cottonr
- Znuny newbie
- Posts: 4
- Joined: 02 Apr 2019, 07:13
- Znuny Version: 6.0.16
- Real Name: Robert
- Company: N/a
Re: Change Ticket numbering
Thank you very much that worked like a charm.