No news? ________________________________ Da: Lucarelli Roberto Inviato: Thursday, May 13, 2010 3:53 PM A: otrs@otrs.org Oggetto: Incomplete installation of any package with DB support 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