Just upgraded from 3.0.10 to 3.3.10. I can update tickets but can not create new ones. I also notice that when I select a queue all the entries are RED. I get the following error message:
Error Message: Need TicketID!
Backend ERROR: OTRS-CGI-67 Perl: 5.20.1 OS: linux Time: Wed Nov 26 10:14:01 2014 Message: Need TicketID! RemoteAddress: 10.95.100.247 RequestURI: /otrs/bin/cgi-bin/index.pl Traceback (20430): Module: Kernel::System::Ticket::Article::ArticleCreate (OTRS 3.3.10) Line: 127 Module: Kernel::Modules::AgentTicketPhone::Run (OTRS 3.3.10) Line: 1285 Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.3.10) Line: 871 Module: /opt/eif/web/common/synced/www-home/virtual/wwwin-nacmci/otrs/bin/cgi-bin/index.pl (unknown version) Line: 41
Need TicketID!
Moderator: crythias
-
nanotowers
- Znuny expert
- Posts: 204
- Joined: 19 Aug 2014, 17:27
- Znuny Version: 3.1.18
- Real Name: Vlad
- Location: Bogotá (Colombia)
- Contact:
Re: Need TicketID!
I had the same problem a couple of days ago, I resolved tickets repairing the tickets table in the database
OTRS: 3.1.18, OTRS::ITSM 3.1.10
Apache2/MySQL 5+
NanoTowerS
"Try not to become a man of success, but rather try to become a man of value." - Albert Einstein
Apache2/MySQL 5+
NanoTowerS
"Try not to become a man of success, but rather try to become a man of value." - Albert Einstein
-
mibrowni
- Znuny newbie
- Posts: 13
- Joined: 24 Nov 2014, 20:50
- Znuny Version: 3.3.10
- Real Name: Michael Browning
- Company: Cisco
Re: Need TicketID!
How did you repair the tickets table?
-
nanotowers
- Znuny expert
- Posts: 204
- Joined: 19 Aug 2014, 17:27
- Znuny Version: 3.1.18
- Real Name: Vlad
- Location: Bogotá (Colombia)
- Contact:
Re: Need TicketID!
in my case i use MySQL
1. generate a back-up.
2. log in... $ mysql -u[user] -p[password]
3. Select the database.... mysql> use otrs;
4. Check the table... mysql> check table ticket
5. Repair the table... mysql> repair table ticket; (only if when you check the table this show a error message).
this is how I resolved my problem.
1. generate a back-up.
2. log in... $ mysql -u[user] -p[password]
3. Select the database.... mysql> use otrs;
4. Check the table... mysql> check table ticket
5. Repair the table... mysql> repair table ticket; (only if when you check the table this show a error message).
this is how I resolved my problem.
OTRS: 3.1.18, OTRS::ITSM 3.1.10
Apache2/MySQL 5+
NanoTowerS
"Try not to become a man of success, but rather try to become a man of value." - Albert Einstein
Apache2/MySQL 5+
NanoTowerS
"Try not to become a man of success, but rather try to become a man of value." - Albert Einstein
-
mibrowni
- Znuny newbie
- Posts: 13
- Joined: 24 Nov 2014, 20:50
- Znuny Version: 3.3.10
- Real Name: Michael Browning
- Company: Cisco
Re: Need TicketID!
No problem reported, so I guess that is not the problem? Any other ideas?
Database changed
mysql> check table ticket;
+-------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------+-------+----------+----------+
| otrs.ticket | check | status | OK |
+-------------+-------+----------+----------+
1 row in set (0.04 sec)
Database changed
mysql> check table ticket;
+-------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------+-------+----------+----------+
| otrs.ticket | check | status | OK |
+-------------+-------+----------+----------+
1 row in set (0.04 sec)
-
nanotowers
- Znuny expert
- Posts: 204
- Joined: 19 Aug 2014, 17:27
- Znuny Version: 3.1.18
- Real Name: Vlad
- Location: Bogotá (Colombia)
- Contact:
Re: Need TicketID!
maybe the next ID_Ticket is locked, in my case i take a hard decision , first i did take the database and create a ticket directly in database , before this process y repair the tables, my Ticket system right now work
OTRS: 3.1.18, OTRS::ITSM 3.1.10
Apache2/MySQL 5+
NanoTowerS
"Try not to become a man of success, but rather try to become a man of value." - Albert Einstein
Apache2/MySQL 5+
NanoTowerS
"Try not to become a man of success, but rather try to become a man of value." - Albert Einstein
-
mibrowni
- Znuny newbie
- Posts: 13
- Joined: 24 Nov 2014, 20:50
- Znuny Version: 3.3.10
- Real Name: Michael Browning
- Company: Cisco
Re: Need TicketID!
How do you determine if the next ID_Ticket is locked?
-
mibrowni
- Znuny newbie
- Posts: 13
- Joined: 24 Nov 2014, 20:50
- Znuny Version: 3.3.10
- Real Name: Michael Browning
- Company: Cisco
Re: Need TicketID!
Looked in OTRS System Log and getting the following message: Unknown column 'valid_id' in 'field list', SQL: '