New subject: Fwd: Fwd: problem installing packages

12 Nov 2008


      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

Re: [otrs] Fwd: problem installing packages

Johan Bogema

Johan Bogema

tags

participants (1)