Hi Andrew,
ok, the error regarding column 'state_notify' are normal, because on
this system the Upgrade* scripts already used for this database?
Can you try the new "scripts/DBUpdate-to-2.4.pl" on a initial upgrade
(database where no Upgrade* scripts has been used)?
Thx!
-Martin
On Jul 28, 2009, at 12:27 , Glossop, Andrew wrote:
I tried the new file (DBUpdate-to-2.4.pl) from bugzilla.
I get lots of errors regarding column 'state_notify'
DBD::mysql::st execute failed: Unknown column 'state_notify' in 'field
list' at
D:/OTRS/otrs/Kernel/System/DB.pm line 559.
ERROR: OTRS-DBUpdate-to-2.4-69 Perl: 5.8.8 OS: MSWin32 Time: Tue Jul
28
11:23:12
2009
Does this mean the previous DB update didn't work correctly?
-----Original Message-----
From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf
Of
Martin Edenhofer
Sent: 28 July 2009 10:46
To: User questions and discussions about OTRS.
Subject: Re: [otrs] upgrade problems with 2.4.1
Hi Swen,
many thanks for this detail info (reply in text).
On Jul 27, 2009, at 22:37 , Swen Wulf wrote:
I seem to have the exact same problem that Andrew has. I am running
a test copy of my producton otrs on Ubuntu. I tested the upgrade
from 2.2 -> 2.3.4 -> 2.4.1 on my test system and had the same issue.
Going to 2.3.4 was without errors or problems (Well, permission
problems on a folder called Files, nothing major thing).
Then the 2.4.1 upgrade. I normally rename my existing otrs folder to
something, then rename the new version to otrs, then copy the
Config.pm and the GenericAgent.pm into place. Then I did the first
database update and got this:
ERROR 1060 (42S21) at line 90: Duplicate column name 'phone'
I checked the sql file and after line 90 are multiple ALTER
statements, and I guess because of the "-f" when I executed "flag
that they were executed even so line 90 wasn't (some phone coloum
gets renamed there I guess).
OTRS 2.4 comes with more customer attributes as default. So in this
case it looks you already added customer attributes by your self. This
is no problem, scripts/DBUpdate-to-2.4.*.sql is trying the same with
no success because it's already done. So you can ignore this. :)
Then I started the migration script as otrs user. It complaint about
permissions so I ran the Setpermission.pl script. Then it complaints
about:
Need Ticket::ViewableStateType in Kernel/Config.pm!
There is already a bug report for this:
http://bugs.otrs.org/show_bug.cgi?id=3987
And the bug is solved (will be available in 2.4.2). :)
Could you try to use "scripts/DBUpdate-to-2.4.pl" for upgrading like
in http://bugs.otrs.org/show_bug.cgi?id=3987 mentored?
Feedback would be very fine!!!
-Martin
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
--
-Martin
OTRS AG
Europaring 4
94315 Straubing
Deutschland
T: +49 (0) 9421 56818 0
F: +49 (0) 9421 56818 18
I: http://www.otrs.com/
Address of record: Bad Homburg
Local Court: Bad Homburg, HRB 10751
Tax number: 003/240/97505
Chairman of the Supervisory Board: Burchard Steinbild
Executive Board: André Mindermann (CEO), Martin Edenhofer
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
