[SOLVED]Error with otrs.SetPassword.pl

[simoneVr]

Hi,
after the installation i've problems with the first login.

Otrs version is 4.1
SO ubuntu 12.04
perl 5.14.2
Mysql 5.5.43

I tried to do reset root's password with :
/opt/otrs/bin/otrs.SetPassword.pl root@localhost NewPassword123

what happens:

ERROR: OTRS-otrs.SetPassword.pl-36 Perl: 5.14.2 OS: linux Time: Wed May 13 15:20:04 2015

Message: No Valid for valid found!

Traceback (2640):
Module: Kernel::System::Valid::ValidLookup Line: 146
Module: Kernel::System::Valid::ValidIDsGet Line: 167
Module: Kernel::System::User::UserSearch Line: 655
Module: /opt/otrs/bin/otrs.SetPassword.pl Line: 71

[Wed May 13 15:20:04 2015] otrs.SetPassword.pl: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2 at /opt/otrs/Kernel/System/DB.pm line 574.
ERROR: OTRS-otrs.SetPassword.pl-36 Perl: 5.14.2 OS: linux Time: Wed May 13 15:20:04 2015

Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL 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 (2640):
Module: Kernel::System::User::UserSearch Line: 660
Module: /opt/otrs/bin/otrs.SetPassword.pl Line: 71

No user found with login 'root@localhost'!

thanks,
Simone

[crythias]

can't set password on user that doesn't exist/is invalid.

[simoneVr]

User is root@localhos and it exists in the table 'users',
how test is it valid?

[crythias]

Code: Select all

SELECT login,valid_id FROM users WHERE login='root@localhost';

[simoneVr]

Result :
login: root@localhost
valid_id: 1

My software version
perl : 5.14.2
mysql : 5.5.43
OS: ubuntu0.12.04.1

[jojo]

please update to latest patchlevel of OTRS (4.0.

[simoneVr]

Thanks very much !!

Now it's work

[simoneVr]

The solution is the installation of patch level 8