
We have an OTRS 3.2.7 installation on a Fedora machine and MySQL database.
We setted up the enviroment and everything was working fine, until I've restored a database backup.

I must admit that I've created the backup .sql file directly with the mysqldump command and not with the otrs "backup.pl" script.
Then we got the error "Need TicketID!" when saving a new ticket by phone (sorry, I have the system in Italian and I don't know how otrs calls this function).
Somewhere on internet I've found that this error can be caused by some installed package.
In fact the packet manager tells me that the "Support" module was in trouble so I've reinstalled it.
But now we got this error saving a new ticket by phone: "No Lock for lock found!".
I've checked the apache error log, finding something very long (I'll attach this below).
The most interesting part is this:
Code: Select all
Message: Column 'ticket_lock_id' cannot be null, SQL: '
INSERT INTO ticket (tn, title, create_time_unix, type_id, queue_id, ticket_lock_id,
user_id, responsible_user_id, ticket_priority_id, ticket_state_id,
escalation_time, escalation_update_time, escalation_response_time,
escalation_solution_time, timeout, service_id, sla_id, until_time,
valid_id, archive_flag, create_time, create_by, change_time, change_by)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 0, 0, 0, 0, 0, ?, ?, 0, ?, ?,
'2013-10-28 14:54:11'
, ?,
'2013-10-28 14:54:11'
, ?)'

https://www.google.it/search?q=otrs+Nee ... afe=active
Any idea?
Thanks

P.S. : Here is the Apache error log:
Code: Select all
[Mon Oct 28 17:57:32 2013] HeaderMetaFAQSearch.pm: Subroutine new redefined at /opt/otrs//Kernel/Output/HTML/HeaderMetaFAQSearch.pm line 20.
[Mon Oct 28 17:57:32 2013] HeaderMetaFAQSearch.pm: Subroutine Run redefined at /opt/otrs//Kernel/Output/HTML/HeaderMetaFAQSearch.pm line 35.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine GetFAQItemVotingRateColor redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 20.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQListShow redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 62.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQContentShow redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 370.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQPathShow redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 524.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQRatingStarsShow redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 597.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQShowLatestNewsBox redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 676.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQShowTop10 redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 854.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQShowQuickSearch redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 1006.
[Mon Oct 28 17:57:32 2013] LayoutImportExport.pm: Subroutine ImportExportFormInputCreate redefined at /opt/otrs//Kernel/Output/HTML/LayoutImportExport.pm line 31.
[Mon Oct 28 17:57:32 2013] LayoutImportExport.pm: Subroutine ImportExportFormDataGet redefined at /opt/otrs//Kernel/Output/HTML/LayoutImportExport.pm line 66.
[Mon Oct 28 17:57:32 2013] LayoutImportExport.pm: Subroutine _ImportExportLoadLayoutBackend redefined at /opt/otrs//Kernel/Output/HTML/LayoutImportExport.pm line 100.
[Mon Oct 28 17:57:32 2013] OutputFilterFAQ.pm: Subroutine new redefined at /opt/otrs//Kernel/Output/HTML/OutputFilterFAQ.pm line 20.
[Mon Oct 28 17:57:32 2013] OutputFilterFAQ.pm: Subroutine Run redefined at /opt/otrs//Kernel/Output/HTML/OutputFilterFAQ.pm line 35.
[Mon Oct 28 17:57:32 2013] ZZZAAuto.pm: Subroutine Load redefined at /opt/otrs/Kernel/Config/Files/ZZZAAuto.pm line 7.
[Mon Oct 28 17:57:32 2013] HeaderMetaFAQSearch.pm: Subroutine new redefined at /opt/otrs//Kernel/Output/HTML/HeaderMetaFAQSearch.pm line 20.
[Mon Oct 28 17:57:32 2013] HeaderMetaFAQSearch.pm: Subroutine Run redefined at /opt/otrs//Kernel/Output/HTML/HeaderMetaFAQSearch.pm line 35.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine GetFAQItemVotingRateColor redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 20.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQListShow redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 62.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQContentShow redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 370.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQPathShow redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 524.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQRatingStarsShow redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 597.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQShowLatestNewsBox redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 676.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQShowTop10 redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 854.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQShowQuickSearch redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 1006.
[Mon Oct 28 17:57:32 2013] LayoutImportExport.pm: Subroutine ImportExportFormInputCreate redefined at /opt/otrs//Kernel/Output/HTML/LayoutImportExport.pm line 31.
[Mon Oct 28 17:57:32 2013] LayoutImportExport.pm: Subroutine ImportExportFormDataGet redefined at /opt/otrs//Kernel/Output/HTML/LayoutImportExport.pm line 66.
[Mon Oct 28 17:57:32 2013] LayoutImportExport.pm: Subroutine _ImportExportLoadLayoutBackend redefined at /opt/otrs//Kernel/Output/HTML/LayoutImportExport.pm line 100.
[Mon Oct 28 17:57:32 2013] OutputFilterFAQ.pm: Subroutine new redefined at /opt/otrs//Kernel/Output/HTML/OutputFilterFAQ.pm line 20.
[Mon Oct 28 17:57:32 2013] OutputFilterFAQ.pm: Subroutine Run redefined at /opt/otrs//Kernel/Output/HTML/OutputFilterFAQ.pm line 35.
[Mon Oct 28 17:57:32 2013] ZZZAAuto.pm: Subroutine Load redefined at /opt/otrs/Kernel/Config/Files/ZZZAAuto.pm line 7.
ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Oct 28 17:57:32 2013
Message: No Lock for lock found!
RemoteAddress: {REDACTED}
RequestURI: /otrs/index.pl?Action=AgentTicketPhone
Traceback (24704):
Module: Kernel::System::Lock::LockLookup (OTRS 3.2.7) Line: 203
Module: Kernel::System::TicketSearch::TicketSearch (OTRS 3.2.7) Line: 625
Module: Kernel::Output::HTML::ToolBarTicketLocked::Run (OTRS 3.2.7) Line: 41
Module: Kernel::Output::HTML::Layout::Header (OTRS 3.2.7) Line: 1523
Module: Kernel::Modules::AgentTicketPhone::Run (OTRS 3.2.7) Line: 206
Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.7) Line: 863
Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 41
Module: (eval) (v1.99) Line: 204
Module: ModPerl::RegistryCooker::run (v1.99) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31
ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Oct 28 17:57:32 2013
Message: No Lock for lock found!
RemoteAddress: {REDACTED}
RequestURI: /otrs/index.pl?Action=AgentTicketPhone
Traceback (24704):
Module: Kernel::System::Lock::LockLookup (OTRS 3.2.7) Line: 203
Module: Kernel::System::TicketSearch::TicketSearch (OTRS 3.2.7) Line: 625
Module: Kernel::Output::HTML::ToolBarTicketLocked::Run (OTRS 3.2.7) Line: 48
Module: Kernel::Output::HTML::Layout::Header (OTRS 3.2.7) Line: 1523
Module: Kernel::Modules::AgentTicketPhone::Run (OTRS 3.2.7) Line: 206
Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.7) Line: 863
Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 41
Module: (eval) (v1.99) Line: 204
Module: ModPerl::RegistryCooker::run (v1.99) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31
[Mon Oct 28 17:57:32 2013] -e: Use of uninitialized value $CountNew in subtraction (-) at /opt/otrs//Kernel/Output/HTML/ToolBarTicketLocked.pm line 59.
[Mon Oct 28 17:57:32 2013] -e: Use of uninitialized value $Count in subtraction (-) at /opt/otrs//Kernel/Output/HTML/ToolBarTicketLocked.pm line 59.
ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Oct 28 17:57:32 2013
Message: No Lock for lock found!
RemoteAddress: {REDACTED}
RequestURI: /otrs/index.pl?Action=AgentTicketPhone
Traceback (24704):
Module: Kernel::System::Lock::LockLookup (OTRS 3.2.7) Line: 203
Module: Kernel::System::TicketSearch::TicketSearch (OTRS 3.2.7) Line: 625
Module: Kernel::Output::HTML::ToolBarTicketLocked::Run (OTRS 3.2.7) Line: 60
Module: Kernel::Output::HTML::Layout::Header (OTRS 3.2.7) Line: 1523
Module: Kernel::Modules::AgentTicketPhone::Run (OTRS 3.2.7) Line: 206
Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.7) Line: 863
Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 41
Module: (eval) (v1.99) Line: 204
Module: ModPerl::RegistryCooker::run (v1.99) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31
ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Oct 28 17:57:47 2013
Message: No Lock for unlock found!
RemoteAddress: {REDACTED}
RequestURI: /otrs/index.pl
Traceback (22272):
Module: Kernel::System::Lock::LockLookup (OTRS 3.2.7) Line: 203
Module: Kernel::System::Ticket::TicketCreate (OTRS 3.2.7) Line: 430
Module: Kernel::Modules::AgentTicketPhone::Run (OTRS 3.2.7) Line: 1067
Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.7) Line: 863
Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 41
Module: (eval) (v1.99) Line: 204
Module: ModPerl::RegistryCooker::run (v1.99) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31
[Mon Oct 28 17:57:47 2013] -e: DBD::mysql::db do failed: Column 'ticket_lock_id' cannot be null at /opt/otrs//Kernel/System/DB.pm line 475.
ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Oct 28 17:57:47 2013
Message: Column 'ticket_lock_id' cannot be null, SQL: '
INSERT INTO ticket (tn, title, create_time_unix, type_id, queue_id, ticket_lock_id,
user_id, responsible_user_id, ticket_priority_id, ticket_state_id,
escalation_time, escalation_update_time, escalation_response_time,
escalation_solution_time, timeout, service_id, sla_id, until_time,
valid_id, archive_flag, create_time, create_by, change_time, change_by)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 0, 0, 0, 0, 0, ?, ?, 0, ?, ?,
'2013-10-28 17:57:47'
, ?,
'2013-10-28 17:57:47'
, ?)'
RemoteAddress: {REDACTED}
RequestURI: /otrs/index.pl
Traceback (22272):
Module: Kernel::System::Ticket::TicketCreate (OTRS 3.2.7) Line: 500
Module: Kernel::Modules::AgentTicketPhone::Run (OTRS 3.2.7) Line: 1067
Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.7) Line: 863
Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 41
Module: (eval) (v1.99) Line: 204
Module: ModPerl::RegistryCooker::run (v1.99) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31
ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Oct 28 17:57:47 2013
Message: Found no ArticleType(ID) for phone!
RemoteAddress: {REDACTED}
RequestURI: /otrs/index.pl
Traceback (22272):
Module: Kernel::System::Ticket::Article::ArticleTypeLookup (OTRS 3.2.7) Line: 991
Module: Kernel::System::Ticket::Article::ArticleCreate (OTRS 3.2.7) Line: 117
Module: Kernel::Modules::AgentTicketPhone::Run (OTRS 3.2.7) Line: 1150
Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.7) Line: 863
Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 41
Module: (eval) (v1.99) Line: 204
Module: ModPerl::RegistryCooker::run (v1.99) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31
ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Oct 28 17:57:47 2013
Message: Found no SenderType(ID) for customer!
RemoteAddress: {REDACTED}
RequestURI: /otrs/index.pl
Traceback (22272):
Module: Kernel::System::Ticket::Article::ArticleSenderTypeLookup (OTRS 3.2.7) Line: 913
Module: Kernel::System::Ticket::Article::ArticleCreate (OTRS 3.2.7) Line: 120
Module: Kernel::Modules::AgentTicketPhone::Run (OTRS 3.2.7) Line: 1150
Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.7) Line: 863
Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 41
Module: (eval) (v1.99) Line: 204
Module: ModPerl::RegistryCooker::run (v1.99) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31
ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Oct 28 17:57:47 2013
Message: Need TicketID!
RemoteAddress: {REDACTED}
RequestURI: /otrs/index.pl
Traceback (22272):
Module: Kernel::System::Ticket::Article::ArticleCreate (OTRS 3.2.7) Line: 127
Module: Kernel::Modules::AgentTicketPhone::Run (OTRS 3.2.7) Line: 1150
Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.7) Line: 863
Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 41
Module: (eval) (v1.99) Line: 204
Module: ModPerl::RegistryCooker::run (v1.99) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31
ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Oct 28 17:57:47 2013
Message: No Lock for lock found!
RemoteAddress: {REDACTED}
RequestURI: /otrs/index.pl
Traceback (22272):
Module: Kernel::System::Lock::LockLookup (OTRS 3.2.7) Line: 203
Module: Kernel::System::TicketSearch::TicketSearch (OTRS 3.2.7) Line: 625
Module: Kernel::Output::HTML::ToolBarTicketLocked::Run (OTRS 3.2.7) Line: 41
Module: Kernel::Output::HTML::Layout::Header (OTRS 3.2.7) Line: 1523
Module: Kernel::Output::HTML::Layout::ErrorScreen (OTRS 3.2.7) Line: 1217
Module: Kernel::Modules::AgentTicketPhone::Run (OTRS 3.2.7) Line: 1174
Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.7) Line: 863
Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 41
Module: (eval) (v1.99) Line: 204
Module: ModPerl::RegistryCooker::run (v1.99) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31
ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Oct 28 17:57:47 2013
Message: No Lock for lock found!
RemoteAddress: {REDACTED}
RequestURI: /otrs/index.pl
Traceback (22272):
Module: Kernel::System::Lock::LockLookup (OTRS 3.2.7) Line: 203
Module: Kernel::System::TicketSearch::TicketSearch (OTRS 3.2.7) Line: 625
Module: Kernel::Output::HTML::ToolBarTicketLocked::Run (OTRS 3.2.7) Line: 48
Module: Kernel::Output::HTML::Layout::Header (OTRS 3.2.7) Line: 1523
Module: Kernel::Output::HTML::Layout::ErrorScreen (OTRS 3.2.7) Line: 1217
Module: Kernel::Modules::AgentTicketPhone::Run (OTRS 3.2.7) Line: 1174
Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.7) Line: 863
Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 41
Module: (eval) (v1.99) Line: 204
Module: ModPerl::RegistryCooker::run (v1.99) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31
[Mon Oct 28 17:57:47 2013] -e: Use of uninitialized value $CountNew in subtraction (-) at /opt/otrs//Kernel/Output/HTML/ToolBarTicketLocked.pm line 59.
[Mon Oct 28 17:57:47 2013] -e: Use of uninitialized value $Count in subtraction (-) at /opt/otrs//Kernel/Output/HTML/ToolBarTicketLocked.pm line 59.
ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Oct 28 17:57:47 2013
Message: No Lock for lock found!
RemoteAddress: {REDACTED}
RequestURI: /otrs/index.pl
Traceback (22272):
Module: Kernel::System::Lock::LockLookup (OTRS 3.2.7) Line: 203
Module: Kernel::System::TicketSearch::TicketSearch (OTRS 3.2.7) Line: 625
Module: Kernel::Output::HTML::ToolBarTicketLocked::Run (OTRS 3.2.7) Line: 60
Module: Kernel::Output::HTML::Layout::Header (OTRS 3.2.7) Line: 1523
Module: Kernel::Output::HTML::Layout::ErrorScreen (OTRS 3.2.7) Line: 1217
Module: Kernel::Modules::AgentTicketPhone::Run (OTRS 3.2.7) Line: 1174
Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.7) Line: 863
Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 41
Module: (eval) (v1.99) Line: 204
Module: ModPerl::RegistryCooker::run (v1.99) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31