Hello Nils,
sorry. I totally missed out an error on the previous Update from 2.4.5
to 3.0.12. I copied the otrs Box and i am trying to do the upgrades in
a virtual box where i am able to use snapshots to revert to the
original status.
Here is the error i get when i try to update from 2.4.5 to 3.0.12 (or
3.0.11). Can i go from 2.4.5 to 3.0.12 or do i have to go to 2.4.12
first?
+ su - otrs -c 'cd /opt/otrs/ ; scripts/DBUpdate-to-3.0.pl'
Migration started...
Step 1 of 5: Refresh configuration cache... done.
Step 2 of 5: Migrating theme configuration... done.
Step 3 of 5: Cleaning up the permission table... done.
Step 4 of 5: Cleanup pending time of tickets without pending state-type... done.
DBD::mysql::db do failed: Table 'virtual_fs' already exists at
/var/www/otrs-3.0.11/Kernel/System/DB.pm line 422.
ERROR: OTRS-DBUpdate-to-3.0-10 Perl: 5.10.1 OS: linux Time: Fri May 18
10:23:21 2012
Message: Table 'virtual_fs' already exists, SQL: 'CREATE TABLE virtual_fs (
id BIGINT NOT NULL AUTO_INCREMENT,
filename TEXT NOT NULL,
backend VARCHAR (60) NOT NULL,
backend_key VARCHAR (160) NOT NULL,
create_time DATETIME NOT NULL,
PRIMARY KEY(id),
INDEX virtual_fs_backend (backend(60)),
INDEX virtual_fs_filename (filename(350))
)'
Traceback (1587):
Module: main::CreateVirtualFSTables (v1.5) Line: 350
Module: scripts/DBUpdate-to-3.0.pl (v1.5) Line: 95
ERROR: OTRS-DBUpdate-to-3.0-10 Perl: 5.10.1 OS: linux Time: Fri May 18
10:23:21 2012
Message: Error during table creation!
Traceback (1587):
Module: main::CreateVirtualFSTables (v1.5) Line: 352
Module: scripts/DBUpdate-to-3.0.pl (v1.5) Line: 95
Step 5 of 5: Creating VirtualFS tables (if necessary)... Error!
Migration completed!
On Thu, May 17, 2012 at 10:44 PM, Nils Leideck <nils.leid...@leidex.net> wrote:
> Hi,
>
> you did not follow the UPGRADING file!
>
> Before you can run the perl upgrade script you have to execute a sql file on
> your DB.
>
> Read the UPGRADING file carefully and try again!
>
> On 17.05.2012, at 18:29, ml ml wrote:
>
>> when i try to upgrade from 3.0.12 to 3.1.4 i get:
>>
>> Step 2 of 24: Check framework version... done.
>>
>> DBD::mysql::db do failed: Table 'otrs2_4.dynamic_field' doesn't exist
>> at /var/www/otrs-3.1.5/Kernel/System/DB.pm line 478.
>> ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.10.1 OS: linux Time: Thu May 17
>> 17:10:15 2012
>>
>> Message: Table 'otrs2_4.dynamic_field' doesn't exist, SQL: 'SELECT
>> count(id) FROM dynamic_field'
>>
>> Traceback (2083):
>> Module: main::_CheckDynamicFieldTables (v1.85) Line: 385
>> Module: scripts/DBUpdate-to-3.1.pl (v1.85) Line: 86
>>
>> Check if dynamic_field table exists, failed! at
>> scripts/DBUpdate-to-3.1.pl line 390.
>> Step 3 of 24: Creating DynamicField tables (if necessary)...
>>
>> Is this something to worry about?
>
> Cheers, Nils
> --
> http://webint.cryptonode.de / a Fractal project
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
