January 2012 - dev - OTRS mailing lists

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

Patchfiles
by Jeff Snider 20 Jan '12

20 Jan '12

I just recently upgraded from 2.4 to 3.0 (yes, yes, way behind) at our university and I made a few very small changes while doing so. Some of them may be of interest to others so I've outlined the whys below and attached patch files. reply-dropdown-click.patch I changed the event that is used on the reply dropdown from change to click to play nicer with popup blockers. I found that it didn't make any difference in IE7 and 8 but in all of the others I tested (FF3.6, FF8, Safari, Chrome, IE9) it didn't trip the popup blocker anymore. widget-overflow-hidden.patch Our CustomerUser widget showed a horizontal scrollbar for about three pixels and it didn't seem to impact our set up anywhere else, so I turned it off. I realize this may have been a conscious decision to accommodate some configurations but it worked better for us this way. ldap-split-on-whitespace.patch We are using Kernel::System::CustomerUser::LDAP for our CustomerUser module and I found it was not splitting up the search string as I would expect. I added whitespace to the split since that seemed to me to be the intent given what it was already splitting on. Thanks! Everybody here is glowing about the "new" (to them) version. We appreciate all the hard work! -Jeff

3 3

Please help me
by Ali Umair 20 Jan '12

20 Jan '12

Hi, I am new in OTRS and want to upgrade 2.2 to 3.0. but i am confused what i take first step to ahead. I read only developer guide of OTRS. I know this is step by step up gradation like 2.2 to 2.3 and then 2.4 then 3.0. but suggest me in detail what step i follow. and if i customize (Add new column and remove some colum or concate some column) in the reports of OTRS then what files are changed and what should i take first step. kindly guide me about it. I really thankful to you.... !!! -- -- *Best Regards* *Ali Umair | Software Engineer * *i**2**c**Pakistan*| 04-Old FCC, Ferozepur Road, Lahore, PAKISTAN

2 1

Convert a SQL script to SOPM DatabaseInstall
by Juan Manuel Clavero Almirón 19 Jan '12

19 Jan '12

Hi, I’m developing an OTRS Module which creates a database table and modifies some others (a custom statistics module, just adding some control information and data so I don’t have to redo every calculation). I’ve developed it in my DEVELOPMENT environment and now I want to make a package to test install it in my PREPRODUCTION environment. And now I face the challenge of converting my SQL script to XML and insert into my SOPM file. Anyone has a custom tool or script that makes this conversion? If not, is there any Backus-Naur style notation for the grammar needed in the SOPM file? Juan Clavero Almirón Gestiò d’Identitats, Firma i Custòdia Oficina de Tecnologies, Informació i Comunicacions (OTIC) Servei de Salut de les Illes Balears C/ de les Escoles, s/n - 07181 Bendinat - Mallorca Telf. +34 971.42.65.30

2 1

Check out my photos on Facebook
by Dananjaya Kumar 17 Jan '12

17 Jan '12

Hi Dev, I set up a Facebook profile where I can post my pictures, videos and events and I want to add you as a friend so you can see it. First, you need to join Facebook! Once you join, you can also create your own profile. Thanks, Dananjaya To sign up for Facebook, follow the link below: http://www.facebook.com/p.php?i=100000218278569&k=AQBqFBJw6JQf4fP1GGKGpyJru… Already have an account? Add this email address to your account: http://www.facebook.com/n/?merge_accounts.php&e=dev%40otrs.org&c=AQANhZq0pK… ======================================= This message was sent to dev(a)otrs.org. If you don't want to receive these emails from Facebook in the future, please follow the link below to unsubscribe. http://www.facebook.com/o.php?k=b5e4c2&u=100003401017541&mid=57f47dfG5af3db… Facebook, Inc. Attention: Department 415 P.O Box 10005 Palo Alto CA 94303

1 0

Copy and slighty modify the move DropDown Field
by ml ml 03 Jan '12

03 Jan '12

Hello List, i would like to copy and slighty modify the move ticket feature (Dropdown in AgentTicketZoom) and i could need a little help. First of all i placed a copy here: Kernel/Output/HTML/Standard/AgentTicketZoom.dtl Then i copied the MoveLink2 Block and changed it a little: http://pastebin.com/WeC1xKM7 Line1, 4, 7, 12, 20 And i simply pasted the Lines 8-11: http://pastebin.com/ND1PDfam (Custom/Kernel/Modules/AgentTicketZoom.pm) The DropDown Field now appears, however, the onclick function does not work. The Error Console of my FireFox browser does not show any error either. Any idea what i did wrong? Thanks, Mario

1 0