[otrs] Fwd: Fwd: problem installing packages

13 Nov 2008


      anybody? nobody?

Begin forwarded message:
...
From: Johan Bogema 
Date: 12 november 2008 11:39:30 GMT+01:00
To: otrs@otrs.org
Subject: Re: [otrs] Fwd: problem installing packages
Hi all,
After some communication with Michiel Beijen, I have to come back to  
the mailing list, cause he might have found the reason that it  
doesn't work in my case. When I put out a trace on the mssql server  
during the installation of a package, I have the following entry:
...
...
declare @p1 int
set @p1=15
exec sp_prepare @p1 output,N'@P1 varchar(80),@P2 varchar(80),@P3
varchar(80),@P4 varchar(80),@P5 varchar(80)',N'INSERT INTO
package_repository (name, version, vendor, filename,  content_size,
content_type, content, install_status,  create_time, create_by,
change_time, change_by) VALUES  (@P1, @P2, @P3, @P4, ''213'',  
''text/xml'',
@P5, ''not installed'',  current_timestamp, 1, current_timestamp,
1)',1
select @p1
He thought that the problem might be caused in the following piece  
of code in Kernel/System/Package.pm:
...
# add new package
   my $FileName = $Structure{Name}->{Content} . '-' .
$Structure{Version}->{Content} . '.xml';
   return $Self->{DBObject}->Do(
       SQL => 'INSERT INTO package_repository (name, version, vendor,
filename, '
           . ' content_size, content_type, content, install_status, '
           . ' create_time, create_by, change_time, change_by)'
           . ' VALUES  (?, ?, ?, ?, \'213\', \'text/xml\', ?, \'not
installed\', '
           . ' current_timestamp, 1, current_timestamp, 1)',
       Bind => [
            \$Structure{Name}->{Content}, \$Structure{Version}-
...
{Content},
           \$Structure{Vendor}->{Content}, \$FileName, \ 
$Param{String},
       ],
   );
}
The problem as he told me, is that there are 5 values (the  
questionmarks) in the insert statement, from which only 4 are filled  
in the bind statement. In his database, the last value is a blob  
field with the contents of the module. I however can not check if  
this is the case in my database since I don't have any modules  
installed yet. Does anyone know how to solve this further?
Regards,
Johan Bogema
Systems Administrator
Realworld Systems
Tel:  +31 345 614 406
Mobile: +31 6 509 50804
http://www.realworld-systems.com
johan.bogema@realworld-systems.com
...
...
...
...
Date: Mon, 10 Nov 2008 08:47:11 +0100
From: "Michiel Beijen" 
Subject: Re: [otrs] Fwd: problem installing packages
To: "User questions and discussions about OTRS." 
Message-ID:
<9eda38a40811092347r4fa7295cgb7dca688f9bfc637@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
Johan,
The FAQ you are refering to is for MySQL, not for MS-SQL. Other  
than
that, it lists TWO possible issues.
Can you specify what the exact issue is you are experiencing?  
Error
message, maybe a screen shot?
Regards,
--
Michiel Beijen
Software Consultant
+31 6 - 457 42 418
Bee Free IT + http://beefreeit.nl
2008/11/10 Johan Bogema :
Does anybody have any idea?
From: Johan Bogema 
Date: 7 november 2008 10:58:39 GMT+01:00
To: otrs@otrs.org
Subject: problem installing packages
Hi all,
We've just set up an installation of OTRS using an MSSQL server.  
This due
to
the fact that we want to have just one database engine in our  
company.
However, when I try to install an extra package (fe. the FAQ  
package) it
gives the same error as explained in the FAQ item here:
http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&CategoryID=4&ItemID=50
The problem I have, is that I can't use that hint to configure  
my MSSQL
server. Does anyone know how to overcome this problem using  
MSSQL server?
Regards,
Johan Bogema