Could someone give me a work-around to this issue?
I tried to create manually the table and it’s works
but I’m not sure to have created all the necessary items.
PROBLEM DESCRIPTION
===================
Any installed package with DB Support doesn't
works. Probably it depends
on the incorrect syntax used to create tables
on DB (I have MySQL but
the installation scripts uses the MSSQL
syntax).
STEP-BY-STEP DESCRIPTION TO REPRODUCE THE PROBLEM
=================================================
1) Install via Packet Manager FAQ Package
ACTUAL RESULTS
==============
The package FAQ is installed but doesn't works
properly. You view
the FAQ icon on menu but if you select it you
will get an error
ADDITIONAL INFORMATION
======================
This issue is only reproducible on my
installation. I have a system that
started with OTRS version 2.4.3 and has been
upgraded to OTRS version 2.4.7.
In otrs log after installation of FAQ package
you view this error:
[Wed May 12 14:34:37
2010][Notice][Kernel::System::Package::RepositoryGet] No such package
FAQ-1.6.5!
[Wed May 12 14:34:46
2010][Error][Kernel::System::Package::_Database][1765] You have an error in
your SQL syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near 'IDENTITY(1,1) ,
name VARCHAR (200) NOT NULL,
PRIMARY KEY(id),
CONSTR' at line 2, SQL: 'CREATE
TABLE faq_language (
id SMALLINT NOT NULL IDENTITY(1,1)
,
name VARCHAR (200) NOT NULL,
PRIMARY KEY(id),
CONSTRAINT faq_language_name
UNIQUE (name)
)'
[Wed May 12 14:34:46
2010][Error][Kernel::System::Package::_Database][1765] Table
'otrs.faq_language' doesn't exist, SQL: 'INSERT INTO faq_language (name)
VALUES
('en')'
[Wed May 12 14:34:46 2010][Error][Kernel::Syste