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
[EMAIL PROTECTED]
Date: Mon, 10 Nov 2008 08:47:11 +0100
From: "Michiel Beijen" <[EMAIL PROTECTED]>
Subject: Re: [otrs] Fwd: problem installing packages
To: "User questions and discussions about OTRS." <[email protected]>
Message-ID:
<[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>:
Does anybody have any idea?
From: Johan Bogema <[EMAIL PROTECTED]>
Date: 7 november 2008 10:58:39 GMT+01:00
To: [email protected]
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
_______________________________________________
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
