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" <michiel@beefreeit.nl>

Subject: Re: [otrs] Fwd: problem installing packages

To: "User questions and discussions about OTRS." <otrs@otrs.org>

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 <johan.bogema@realworld-systems.com>:

Does anybody have any idea?

From: Johan Bogema <johan.bogema@realworld-systems.com>

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