Code: Select all
ERROR: OTRS-otrs.Console.pl-Admin::User::SetPassword-10 Perl: 5.24.1 OS: linux Time: Sun Mar 4 16:41:12 2018
Message: No Valid for valid found!
Traceback (11786):
Module: Kernel::System::Valid::ValidLookup Line: 139
Module: Kernel::System::Valid::ValidIDsGet Line: 160
Module: Kernel::System::User::UserSearch Line: 728
Module: Kernel::System::Console::Command::Admin::User::SetPassword::Run Line: 47
Module: (eval) Line: 460
Module: Kernel::System::Console::BaseCommand::Execute Line: 454
Module: Kernel::System::Console::InterfaceConsole::Run Line: 80
Module: /opt/otrs/bin/otrs.Console.pl Line: 38
[Sun Mar 4 16:41:12 2018] otrs.Console.pl: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 2 at /opt/otrs/Kernel/System/DB.pm line 694.
ERROR: OTRS-otrs.Console.pl-Admin::User::SetPassword-10 Perl: 5.24.1 OS: linux Time: Sun Mar 4 16:41:12 2018
Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 2, SQL: 'SELECT id, login
FROM users WHERE (login) LIKE ? AND valid_id IN ()'
Traceback (11786):
Module: Kernel::System::User::UserSearch Line: 737
Module: Kernel::System::Console::Command::Admin::User::SetPassword::Run Line: 47
Module: (eval) Line: 460
Module: Kernel::System::Console::BaseCommand::Execute Line: 454
Module: Kernel::System::Console::InterfaceConsole::Run Line: 80
Module: /opt/otrs/bin/otrs.Console.pl Line: 38
Error: No user found with login 'admin@localhost'!
In my MySQL database i see all users so they are exist. Some help?