[otrs] DBUpdate-to-3.2 errors during upgrade from 3.1.12 - 3.2.2

2013-03-18 Thread Ralf Hildebrandt
otrs:/opt/otrs# bin/otrs.CheckDB.pl Trying to connect to database DSN: DBI:mysql:database=otrs;host=localhost; DatabaseUser: otrs Connected. otrs:/opt/otrs# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql -p -f -u root otrs Enter password: ERROR 1091 (42000) at line 20: Can't DROP

[otrs] How to see total,open,close ticket on Dashboard

2013-03-18 Thread Darshak Modi
On DashBoard, We need Counter of Total, Open, Close, New tickets. And list of New/Open ticket may 15-20 per page. Is it possible? How to do? Also: When we create search template, is it possible to have a menu and list inside that, that's visible to some Agent, or Admin.

Re: [otrs] DBUpdate-to-3.2 errors during upgrade from 3.1.12 - 3.2.2

2013-03-18 Thread Michiel Beijen
Hi Ralf, On Mon, Mar 18, 2013 at 2:25 PM, Ralf Hildebrandt ralf.hildebra...@charite.de wrote: otrs:/opt/otrs# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql -p -f -u root otrs Enter password: ERROR 1091 (42000) at line 20: Can't DROP 'ticket_answered'; check that column/key exists the

Re: [otrs] DBUpdate-to-3.2 errors during upgrade from 3.1.12 - 3.2.2

2013-03-18 Thread Ralf Hildebrandt
* Michiel Beijen michiel.bei...@gmail.com: otrs:/opt/otrs# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql -p -f -u root otrs Enter password: ERROR 1091 (42000) at line 20: Can't DROP 'ticket_answered'; check that column/key exists the ticket_answered column does exist in OTRS 3.1

Re: [otrs] DBUpdate-to-3.2 errors during upgrade from 3.1.12 - 3.2.2

2013-03-18 Thread Ralf Hildebrandt
* Michiel Beijen michiel.bei...@gmail.com: the ticket_answered column does exist in OTRS 3.1 databases (otherwise the ticket API would not work); so if it's not there when you run the DBUpdate SQL this is probably because this is the second time you ran it? Only ran it once, BTW. I cutpasted

Re: [otrs] Is OTRS Helpdesk ITIL Compliant?

2013-03-18 Thread Jignesh Kakka (jkakka)
Thanks to all for your reply. My question was only regarding ITIL compliant, meaning features that can be used for ITIL process. I was not looking for an certification. I saw ITSM providing these features , so just wanted to check how easy it would be to migrate and what would be impact of