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
Incomplete installation of any package with DB support
Moderator: crythias
-
- Znuny newbie
- Posts: 3
- Joined: 13 May 2010, 15:37
- Znuny Version: 2.4.7
-
- Znuny newbie
- Posts: 3
- Joined: 13 May 2010, 15:37
- Znuny Version: 2.4.7
Re: Incomplete installation of any package with DB support
It seems that your setup is broken, as the FAQ installs without any problems on other systems
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com