[SOLVED] problem upgrading from 3.0.10 to 3.1.18

[eandrex]

updgrading from source otrs 3.0.10 to otrs 3.1.18 and when i run DBUpdate-to-3.1.pl at step 9 im getting this

i have set my mysql default engine to myisam and icreased its timeout

running perl 5.16 (strawberry -yes, im on windows-)

log says almost same:

Code: Select all

Sat Dec 21 21:39:02 2013][Error][Kernel::System::DynamicField::DynamicFieldUpdate][424] , SQL: 'UPDATE dynamic_field SET name = ?, label = ?, field_order =?, field_type = ?, object_type = ?, config = ?, valid_id = ?, change_time = 
        '2013-12-21 21:39:02'
    ,  change_by = ? WHERE id = ?'

i must say, the otrs system was running before on a linux environment(centos) and im trying to updgrade using windows..

any help is appreciate. Thank you

Solution:
1) Edit DBUpdate-to-3.1.pl and comment line 139

Code: Select all

print "Step 9 of $Steps: Migrate free fields configuration... ";
    #_MigrateFreeFieldsConfiguration($CommonObject);
    print "done.\n\n";

2) Run DBUpdate-to-3.1.pl and make sure it finishes with no errors
3) rebuild config and delete cache.. make sure u can log in in your new system as agent as well as customer
4) Edit DBUpdate-to-3.1.pl and comment from steps 1 to 8
5) uncomment the line you commented on step 1
6) add a die; instruction before step 10(so your scripts wont continue with setps it already made)
7) if your step 9 finishes with no errors, congrats..
rebuild config and delete cache
9) go use your migrates ticketfreetext

[eandrex]

Quick update:

i have commented out line 139 of the update script

Code: Select all

print "Step 9 of $Steps: Migrate free fields configuration... ";
    #_MigrateFreeFieldsConfiguration($CommonObject);
    print "done.\n\n";

does anyone know what is the step 9 supposed to do? something that i can do manually? im asking this because "lucky" me when i commented out that line, the script finished with no errors and i am being able to log in the admin area (havent tested customer)...

Edit:

from migration script

=item _MigrateFreeFieldsConfiguration($CommonObject)

migrates the configuration of the free fields from SysConfig to the
new dynamic_fields table.

_MigrateFreeFieldsConfiguration($CommonObject);

=cut

does anyone know how to do this?

UPDATE 3:

from the first image i posted, i can i see what this "does" is change de name ("key") the label ("value")..i can do this manually by seeing my old otrs 3.0 installation, but im worried about "field_type", "object_type" and "config"...any ideas?