I am a first time user of OTRS and have just finished setting it up on IIS / Microsoft SQL Server 2000. After I submit the username and password from the login page, I get the following error:
Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ';'. (SQL-42000) [Microsoft][ODBC SQL Server Driver][SQL Server]The label 'WWVz' has already been declared. Label names must be unique within a query batch or stored procedure. (SQL-42000) [Microsoft][ODBC SQL Server Driver][SQL Server]The label 'WWVz' has already been declared. Label names must be unique within a query batch or stored procedure. (SQL-42000) [Microsoft][ODBC SQL Server Driver][SQL Server]The label 'WWVz' has already been declared. Label names must be unique within a query batch or stored procedure. (SQL-42000)(DBD: Execute immediate failed err=-1), SQL: 'INSERT INTO session (session_id, value) VALUES ('1059c9b91a8860e7c891225c6ae92c7a48', 'UserIsGroupRo[admin]:WWVz:';UserLastLogin:MTA4MDY2MjQ3NQ==:';UserLogin:cm9v dEBsb2NhbGhvc3Q=:';UserIsGroup[stats]:WWVz:';UserIsGroupRo[users]:WWVz:';Use rID:MQ==:';UserEmail:cm9vdEBsb2NhbGhvc3Q=:';UserPw:cm9LMjBYR2JXRXNTTQ==:';Va lidID:MQ==:';UserIsGroup[admin]:WWVz:';UserFirstname:QWRtaW4=:';UserIsGroupR o[stats]:WWVz:';UserLastname:T1RSUw==:';UserIsGroup[users]:WWVz:';UserType:V XNlcg==:';UserSessionStart:MTA4MDY2MjQ5Mw==:';UserRemoteAddr:MTAuMS4zLjE4:'; UserRemoteUserAgent:TW96aWxsYS81LjAgKFdpbmRvd3M7IFU7IFdpbmRvd3MgTlQgNS4xOyBl bi1VUzsgcnY6MS42KSBHZWNrby8yMDA0MDIwNiBGaXJlZm94LzAuOA==:';')' Traceback (1336): Module: Kernel::System::AuthSession::DB::CreateSessionID (v1.14) Line: 179 Module: Kernel::System::AuthSession::CreateSessionID (v1.20) Line: 67 Module: c:\inetpub\wwwroot\otrs\bin\cgi-bin\index.pl (v1.66) Line: 276 [Tue Mar 30 09:01:33 2004] index.pl: Can't insert session id! at c:/inetpub/wwwroot/otrs/bin/cgi-bin/../../Kernel/System/AuthSession/DB.pm line 179. at c:/inetpub/wwwroot/otrs/bin/cgi-bin/../../Kernel/cpan-lib/CGI/Carp.pm line 301. Content-type: text/html <h1>Software error:</h1> <pre>Can't insert session id! at c:/inetpub/wwwroot/otrs/bin/cgi-bin/../../Kernel/System/AuthSession/DB.pm line 179.</pre> <p> For help, please send mail to this site's webmaster, giving this error message and the time and date of the error. </p> I believe it has to do with the way items are being quoted in the SQL string, but I do not know where to begin troubleshooting it? Any suggestions? Do you need more information from me? Thanks, Tyler Hepworth _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/