OTRS:/opt/otrs# cat scripts/DBUpdate-to-3.0.mysql.sql | mysql -p -f -u root otrs

Enter password:

ERROR 1060 (42S21) at line 7: Duplicate column name 'archive_flag'

ERROR 1061 (42000) at line 10: Duplicate key name 'ticket_create_time_unix'

ERROR 1061 (42000) at line 11: Duplicate key name 'ticket_create_time'

ERROR 1061 (42000) at line 12: Duplicate key name 'ticket_archive_flag'

ERROR 1062 (23000) at line 16: Duplicate entry 'ArchiveFlagUpdate' for key 2

ERROR 1050 (42S01) at line 22: Table 'ticket_flag' already exists

ERROR 1054 (42S22) at line 35: Unknown column 'article_flag' in 'article_flag'

ERROR 1060 (42S21) at line 42: Duplicate column name 'article_value'

ERROR 1061 (42000) at line 43: Duplicate key name 'article_flag_article_id_create_by'

ERROR 1061 (42000) at line 44: Duplicate key name 'article_flag_article_id_article_key'

ERROR 1091 (42000) at line 47: Can't DROP 'article_flag_create_by'; check that column/key exists

ERROR 1050 (42S01) at line 53: Table 'virtual_fs' already exists

ERROR 1050 (42S01) at line 66: Table 'virtual_fs_preferences' already exists

ERROR 1050 (42S01) at line 76: Table 'virtual_fs_db' already exists

ERROR 1054 (42S22) at line 87: Unknown column 'salutation' in 'customer_user'

ERROR 1054 (42S22) at line 126: Unknown column 'salutation' in 'users'

ERROR 1060 (42S21) at line 344: Duplicate column name 'comments'

OTRS:/opt/otrs# scripts/DBUpdate-to-3.0.pl

Migration started...

Step 1 of 4: Refresh configuration cache... done.

DBD::mysql::st execute failed: Table 'otrs.theme' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 553.

ERROR: OTRS-DBUpdate-to-3.0-10 Perl: 5.10.0 OS: linux Time: Tue Nov 15 10:03:59 2011

Message: Table 'otrs.theme' doesn't exist, SQL: 'SELECT theme, valid_id FROM theme '

Traceback (1570):

   Module: Kernel::System::DB::GetTableData (v1.127) Line: 868

   Module: main::MigrateThemes (v1.4) Line: 149

   Module: scripts/DBUpdate-to-3.0.pl (v1.4) Line: 77

DBD::mysql::st fetchrow_array failed: fetch() without execute() at /opt/otrs/Kernel/System/DB.pm line 616.

ERROR: reading themes from database. Migration halted.

# fetch first not used rows

    if ( $Self->{LimitStart} ) {

        for ( 1 .. $Self->{LimitStart} ) {

            if ( !$Self->{Cursor}->fetchrow_array() ) {

                $Self->{LimitStart} = 0;

                return ();

            }

            $Self->{LimitCounter}++;

        }

        $Self->{LimitStart} = 0;

    }

    # return

    my @Row = $Self->{Cursor}->fetchrow_array(); [Zeile 616 ist hier]

    if ( !$Self->{Backend}->{'DB::Encode'} ) {

        return @Row;

    }

    # e. g. set utf-8 flag

    my $Counter = 0;

    ELEMENT:

    for my $Element (@Row) {

        if ( !$Element ) {

            next ELEMENT;

        }