I don't have a test system, so the only database I have is the live one.
FYI, when I did the upgrade, the system did create a ZZZAuto.pm file. It still
exists, so perhaps it didn't get processed. Interestingly, it contains all the
extra lines I had to manually add. There's on other line I didn't add though,
so I tried adding it manually:
$Self->{'Ticket::Frontend::AgentTicketQueue'}->{'ViewAllPossibleTickets'} =
'1';
But I still get the same error when I click on Ticket.
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Martin
Edenhofer
Sent: 28 July 2009 11:32
To: User questions and discussions about OTRS.
Subject: Re: [otrs] upgrade problems with 2.4.1
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: [email protected] [mailto:[email protected]] 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/
---------------------------------------------------------------------
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/
