DBUpdate-to-4.pl

[spiderpig]

im migrateing to 4 via DBUpdate-to-4.pl

i get error in step 4 (see below)
any ideas how i can fix this?

Migration started...

Step 1 of 15: Refresh configuration cache...
If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry!
done.

Step 2 of 15: Check framework version... done.

Step 3 of 15: Migrate FontAwesome icons... done.

Step 4 of 15: Migrate ProcessManagement EntityIDs... [Sun Nov 30 19:51:14 2014] DBUpdate-to-4.pl: DBD::mysql::st execute failed: Table 'otrs.acl' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 584.
ERROR: OTRS-DBUpdate-to-4.pl-03 Perl: 5.10.1 OS: linux Time: Sun Nov 30 19:51:14 2014

Message: Table 'otrs.acl' doesn't exist, SQL: '
SELECT id
FROM acl ORDER BY id'

Traceback (3670):
Module: Kernel::System::ACL::DB::ACL::ACLListGet Line: 743
Module: main::_MigrateProcessManagementEntityIDs Line: 690
Module: DBUpdate-to-4.pl Line: 121

[Sun Nov 30 19:51:14 2014] DBUpdate-to-4.pl: DBD::mysql::st execute failed: Table 'otrs.acl_sync' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 584.
ERROR: OTRS-DBUpdate-to-4.pl-03 Perl: 5.10.1 OS: linux Time: Sun Nov 30 19:51:14 2014

Message: Table 'otrs.acl_sync' doesn't exist, SQL: '
SELECT COUNT(*)
FROM acl_sync'

Traceback (3670):
Module: Kernel::System::ACL::DB::ACL::ACLsNeedSync Line: 794
Module: main::_MigrateProcessManagementEntityIDs Line: 935
Module: DBUpdate-to-4.pl Line: 121

[Sun Nov 30 19:51:14 2014] DBUpdate-to-4.pl: DBD::mysql::st execute failed: Table 'otrs.acl' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 584.
ERROR: OTRS-DBUpdate-to-4.pl-03 Perl: 5.10.1 OS: linux Time: Sun Nov 30 19:51:14 2014

Message: Table 'otrs.acl' doesn't exist, SQL: '
SELECT id
FROM acl WHERE valid_id IN (1)ORDER BY id'

Traceback (3670):
Module: Kernel::System::ACL::DB::ACL::ACLListGet Line: 743
Module: Kernel::System::ACL::DB::ACL::ACLDump Line: 860
Module: main::_MigrateProcessManagementEntityIDs Line: 1003
Module: DBUpdate-to-4.pl Line: 121

[Sun Nov 30 19:51:14 2014] DBUpdate-to-4.pl: DBD::mysql::db do failed: Table 'otrs.acl_sync' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 442.
ERROR: OTRS-DBUpdate-to-4.pl-03 Perl: 5.10.1 OS: linux Time: Sun Nov 30 19:51:14 2014

Message: Table 'otrs.acl_sync' doesn't exist, SQL: 'DELETE FROM acl_sync'

Traceback (3670):
Module: Kernel::System::ACL::DB::ACL::ACLsNeedSyncReset Line: 813
Module: main::_MigrateProcessManagementEntityIDs Line: 1011
Module: DBUpdate-to-4.pl Line: 121

Not a CODE reference at DBUpdate-to-4.pl line 1014

[jojo]

the database scheme you try to migrate is not 3.3. as some tables are missing

[vinesh]

I do had same issue..but issue resolved by removing process management entityids.. Before doing this please take backup of process management entityids if any.

[spiderpig]

ok,

where can i remove them?

i'm updateing from 3.0 ->3.1->3.2 -> 3.3 -> 4 , and we havent be using process management.
But we are going to use them after the upgrade.

one another thing, i'm using mysam as a db engine, do i have to change it to innodb before i migrate?

[spiderpig]

i did all the migration again, this it work.