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