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
---------------------------------------------------------------------
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
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
