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
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