Hi Adam, On Wed, Apr 30, 2003 at 03:28:23PM -0400, Adam Denenberg wrote:

i am getting this on my first login.. DBD::mysql installed successfully and so did the mysql db's.. however getting this in the error log

running 1.0.2 on redhat 7.3

thanks

[Wed Apr 30 15:51:00 2003] index.pl: DBD::mysql::st execute failed: You have an error in your SQL syntax near ') AND login = 'root@localhost'' at line 1 at /usr/local/otrs/bin/cgi-bin/../../Kernel/System/DB.pm line 192. ERROR: OTRS-CGI-10 Perl: 5.6.1 OS: linux Time: Wed Apr 30 15:51:00 2003

Message: You have an error in your SQL syntax near ') AND login = 'root@localhost'' at line 1, SQL: 'SELECT pw, id FROM system_user WHERE valid_id in ( ) AND login = 'root@localhost''

Traceback (7394): Module: Kernel::System::Auth::DB::Auth Line: 88 Module: Kernel::System::Auth::Auth Line: 60 Module: /opt/otrs/bin/cgi-bin/index.pl Line: 183

[Wed Apr 30 15:51:00 2003] index.pl: DBD::mysql::st fetchrow_array failed: fetch() without execute() at /usr/local/otrs/bin/cgi-bin/../../Kernel/System/DB.pm line 205.

Your database setup is corrupt (missing entries!). Try to set it up again (see: README.database).

thanks adam

Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "There are two major products that come out of Berkeley: LSD and Unix. We don't believe this to be a coincidence." -- Jeremy S. Anderson