OTRS 6.0.10 - Survey - Missing parameter Year

Moderator: crythias

Post Reply
salzstreuer
Znuny newbie
Posts: 6
Joined: 08 Aug 2018, 10:04
Znuny Version: 6.0.10

OTRS 6.0.10 - Survey - Missing parameter Year

Post by salzstreuer »

Hello,

after I successfully migrated from OTRS 5.0.23 to OTRS 6.0.10, I also upgraded the ITSM and the Survey module to the latest versions.

All needed perl modules are fine and properly installed.

Now I receive the following errors:

Code: Select all

Subject: OTRS Scheduler Daemon Cron: SurveyRequestsSend

ERROR: OTRS-otrs.Console.pl-Maint::Survey::RequestsSend-10 Perl: 5.20.2 OS:
linux Time: Tue Aug  7 19:20:07 2018

 Message: Missing parameter Year.

 Traceback (30907):
   Module: Kernel::System::DateTime::_CPANDateTimeObjectCreate Line: 1846
   Module: Kernel::System::DateTime::new Line: 151
   Module: Kernel::System::ObjectManager::_ObjectBuild Line: 306
   Module: Kernel::System::ObjectManager::Create Line: 241
   Module: Kernel::System::Survey::Request::RequestSend Line: 470
   Module:
Kernel::System::Console::Command::Maint::Survey::RequestsSend::Run Line: 136
   Module: (eval) Line: 460
   Module: Kernel::System::Console::BaseCommand::Execute Line: 454
   Module: (eval) Line: 144
   Module:
Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker::Cron::Run Line:
123
   Module: Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker::Run
Line: 232
   Module: (eval) Line: 316
   Module: main::Start Line: 316
   Module: bin/otrs.Daemon.pl Line: 137

ERROR: OTRS-otrs.Console.pl-Maint::Survey::RequestsSend-10 Perl: 5.20.2 OS:
linux Time: Tue Aug  7 19:20:07 2018

 Message: Error creating DateTime object.

 Traceback (30907):
   Module: Kernel::System::DateTime::new Line: 154
   Module: Kernel::System::ObjectManager::_ObjectBuild Line: 306
   Module: Kernel::System::ObjectManager::Create Line: 241
   Module: Kernel::System::Survey::Request::RequestSend Line: 470
   Module:
Kernel::System::Console::Command::Maint::Survey::RequestsSend::Run Line: 136
   Module: (eval) Line: 460
   Module: Kernel::System::Console::BaseCommand::Execute Line: 454
   Module: (eval) Line: 144
   Module:
Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker::Cron::Run Line:
123
   Module: Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker::Run
Line: 232
   Module: (eval) Line: 316
   Module: main::Start Line: 316
   Module: bin/otrs.Daemon.pl Line: 137
It seems like the Survey Module can't determine the Year to use?


Did anyone ever run into the same problem?



Thanks in advance.


Cheerio
SDYWD
Znuny newbie
Posts: 3
Joined: 25 Sep 2013, 15:58
Znuny Version: 6.0.10
Real Name: Alex
Company: Telecamera
Contact:

Re: OTRS 6.0.10 - Survey - Missing parameter Year

Post by SDYWD »

Hello,

I have the same problem since updated to version 6. Have not fixed yet.
SDYWD
Znuny newbie
Posts: 3
Joined: 25 Sep 2013, 15:58
Znuny Version: 6.0.10
Real Name: Alex
Company: Telecamera
Contact:

Re: OTRS 6.0.10 - Survey - Missing parameter Year

Post by SDYWD »

Fixed with workaround:

In file:

/opt/otrs/Kernel/System/Survey/Request.pm

below line 457 there is SQL query in which I added clause:

Code: Select all

AND send_time IS NOT NULL
so the query looked like:

Code: Select all

        # get send time
        return if !$DBObject->Prepare(
            SQL => '
                SELECT send_time
                FROM survey_request
                WHERE LOWER(send_to) = ?
                AND send_time IS NOT NULL
                ORDER BY send_time DESC',
            Bind  => [ \$To ],
            Limit => 1,
        );
kropek
Znuny newbie
Posts: 14
Joined: 11 Jul 2019, 10:39
Znuny Version: 6.0.22
Real Name: Filip
Company: Best-IT

Re: OTRS 6.0.10 - Survey - Missing parameter Year

Post by kropek »

On 6.0.22 fix make it worse with error 500 after closing ticket and thin in log:
[Tue Dec 22 13:20:12 2020] otrs.Daemon.pl: DBD::mysql::st execute failed: called with 1 bind variables when 0 are needed at /opt/otrs/Kernel/System/DB.pm line 693.
ERROR: OTRS-otrs.Console.pl-Maint::Survey::RequestsSend-79 Perl: 5.26.1 OS: linux Time: Tue Dec 22 13:20:12 2020

Message: called with 1 bind variables when 0 are needed, SQL: '
SELECT send_time
FROM survey_request
AND send_time IS NOT NULL
ORDER BY send_time DESC LIMIT 1'

Traceback (17807):
Module: Kernel::System::Survey::Request::RequestSend Line: 458
Module: Kernel::System::Console::Command::Maint::Survey::RequestsSend::Run Line: 136
Module: (eval) Line: 460
Module: Kernel::System::Console::BaseCommand::Execute Line: 454
Module: (eval) Line: 144
Module: Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker::Cron::Run Line: 123
Module: Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker::Run Line: 235
Module: (eval) Line: 314
Module: main::Start Line: 314
Module: /opt/otrs/bin/otrs.Daemon.pl Line: 135
Post Reply