February 2012 - dev - OTRS mailing lists

Re: [dev] Language Code and ISO 639
by Juan Manuel Clavero Almirón 29 Feb '12

29 Feb '12

Hey, thanks! I didn't saw the change in 3.1. I'm afraid we have some development done in 3.0 and we still have to study the upgrade requirements, but I've upgraded 'ca' language files and Framework->Core->DefaultLanguages in DEV environment and it solved our problems. And about the translation, I will gladly work on it and I'll try to do my best, although I myself am more a catalan listener than a speaker. Juan Clavero Almirón -----Mensaje original----- Date: Tue, 28 Feb 2012 14:37:18 +0100 From: Michiel Beijen <michiel.beijen(a)otrs.com> Subject: Re: [dev] Language Code and ISO 639 To: Development community of OTRS <dev(a)otrs.org> Message-ID: <CABD0r10Jn-av+MB1ZHXMBGDjk=_ZwCJmXVJcEq8jfGmAniM5SQ(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Hi, We actually do follow ISO 639-1, otherwise also the language auto-detection feature does not work. And yes indeed, for Catalan we picked the wrong code (or rather, the person submitting the original Catalan translation picked the wrong code and we failed to notice this when we added the translation). We already corrected this, see http://source.otrs.org/viewvc.cgi/otrs/Kernel/Language/ca.pm?view=log so if you would run OTRS 3.1 you'll no longer have the issue. By the way, since you obviously have interest in running OTRS in Catalan, would you be able to provide updated translation files for OTRS 3.0 or 3.1? Right now the last update was from 2.3. Thanks! -- Mike 2012/2/28 Juan Manuel Clavero Almir?n <juanm.clavero(a)ibsalut.es>: > Hello, > > Some weeks ago, a customer complained that OTRS rich text editor didn?t > work, it didn?t load. > > I realized that it happened to all the user with catalan as their language. > I decided to remove the language while I studied what was happening. > > I found a bug which was, more or less, what was happening to us: > http://bugs.otrs.org/show_bug.cgi?id=8024 > > Doing some tests (), I realized that CKEditor didn?t load with some > UserLanguage. Comparing CKEditr and OTRS lang dirs, I realized that it > failed when the language name was different between OTRS and CKEditor. In > our case, catalan was ?ca? in CKEditor but ?ct? in OTRS. > > I discovered, googling for language codes, the standard ISO 639, a > standardized nomenclature used to classify all known languages. CKEditor was > following this code, but OTRS not. > > > > So, here?s my question: Is OTRS following any language code? If not, why it > is not following ISO 639? > > > > Juan Clavero Almir?n > > > > > _______________________________________________ > OTRS mailing list: dev - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/dev > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev ------------------------------ _______________________________________________ dev mailing list dev(a)otrs.org http://lists.otrs.org/cgi-bin/listinfo/dev

1 0

Language Code and ISO 639
by Juan Manuel Clavero Almirón 28 Feb '12

28 Feb '12

Hello, Some weeks ago, a customer complained that OTRS rich text editor didn’t work, it didn’t load. I realized that it happened to all the user with catalan as their language. I decided to remove the language while I studied what was happening. I found a bug which was, more or less, what was happening to us: http://bugs.otrs.org/show_bug.cgi?id=8024 Doing some tests (), I realized that CKEditor didn’t load with some UserLanguage. Comparing CKEditr and OTRS lang dirs, I realized that it failed when the language name was different between OTRS and CKEditor. In our case, catalan was ‘ca’ in CKEditor but ‘ct’ in OTRS. I discovered, googling for language codes, the standard ISO 639, a standardized nomenclature used to classify all known languages. CKEditor was following this code, but OTRS not. So, here’s my question: Is OTRS following any language code? If not, why it is not following ISO 639? Juan Clavero Almirón

2 1

Fwd: ora-24817 error
by Anselm Strauss 22 Feb '12

22 Feb '12

maybe any developer has some ideas on this … thanks, anselm Begin forwarded message: > From: Anselm Strauss <strauss(a)puzzle.ch> > Subject: ora-24817 error > Date: February 16, 2012 11:06:40 AM GMT+01:00 > To: "User questions and discussions about OTRS." <otrs(a)otrs.org> > > hi, > > i have a otrs 3.0.11 running on redhat linux 5.3 with a oracle 10 database. i upgraded the thing from otrs 2.4. now, in one of the last steps in the upgrade, i want to reinstall packages. somehow it messed up, and now i have the new itsm packages installed, but the do not show up in the packages list. in the httpd log i get tons of the following messages: > > -e: DBD::Oracle::st fetchrow_array failed: ORA-24817: Unable to allocate the given chunk for current lob operation (DBD ERROR: OCILobRead) [for Statement "SELECT name, version, install_status, content FROM package_repository ORDER BY name, create_time"] at /opt/otrs//Kernel/System/DB.pm line 616. > > i guess this error comes when trying to display the list of installed packages. oracle says the only option is to change the code to use smaller chunks. is there any tuning i can do in otrs without changing the code? > > during the migration i had the following errors when running OTRS-DBUpdate-to-3.0-10: > > Message: ORA-02289: sequence does not exist (DBD ERROR: error possibly near <*> indicator at char 14 in 'DROP SEQUENCE <*>SE_virtual_fs') [for Statement "DROP SEQUENCE SE_virtual_fs"] at /opt/otrs/Kernel/System/DB.pm line 422. > > Message: Error during table creation! > > Traceback (1641): > Module: main::CreateVirtualFSTables (v1.5) Line: 350 > > Step 5 of 5: Creating VirtualFS tables (if necessary)… Error! > > Migration completed! > > but in the end the migration was complete … > > when i try to install the packages again, it says it can't upgrade the packages because they are not installed. > > thanks for any help, > anselm strauss

1 0

Help me, and guide me
by Ali Umair 02 Feb '12

02 Feb '12

i want to update my OTRS, 2.2 to 3.0, but when i run script of 2.3 then in alter statements i found this error 0 66 12:04:13 ALTER TABLE queue_preferences ADD CONSTRAINT FK_queue_preferences_queue_id_id FOREIGN KEY (queue_id) REFERENCES queue (id) Error Code: 1005 Can't create table 'otrs.#sql-223f_49' (errno: 150) 0.031 sec i am working on mysql workbench and i install otrs on red hat linux, please guide me as soon as possible. Thanks -- -- *Best Regards* *Ali Umair | Software Engineer * *i**2**c**Pakistan*| 04-Old FCC, Ferozepur Road, Lahore, PAKISTAN Ph: 0092-42-111 000 911 X 171 | Cell: +92-334-4556898

3 3