Error 1146: Table otrs.dynamic_field doesn't exist

[stsupport]

Hi,


I faced the issue (Error 1146: Table otrs.dynamic_field doesn't exist) while trying to upgrade the OTRS version from 3.0.10 to 3.2.3.

I've followed these steps:

1. Took a backup of OTRS 3.0.10 folder.

2. set Path=%PATH%;C:\OTRS\mysql\bin

3. mysqldump -uroot otrs > otrs_dump.sql

4. Uninstalled OTRS 3.0.10 and installed OTRS 3.2.3.

5. Copied the config file from old OTRS to new one.

6. set Path=%PATH%;C:\Program Files\OTRS\Strawberry Perl\perl\bin;C:\Program Files\OTRS\mysql\bin

7. Created DB using 'CREATE DATABASE otrs CHARACTER SET utf8;

8. GRANT ALL ON otrs. * TO 'otrs'@localhost'

9. mysql -uroot otrs < otrs_dump.sql


10. mysql -uroot otrs < DBUpdate-to-3.2.mysql.sql


When I performed the 10th step I got the error: Error 1146: Table "otrs.dynamic_field" doesn't exist.

Need help to fix this issue and proceed further with the upgrading to new version.

[CSL]

You need to upgrade from 3.0.x to 3.1.x first. The upgrades are incremental and need to be performed like: 3.0 -> 3.1 -> 3.2 etc. I think it says so in the UPGRADING file inside the otrs directory.

It's complaining that it can't find dynamic fields, because these are created in the upgrade from 3.0 to 3.1

[stsupport]

Thanks for your quick response.

Let me check it....

Regards,

ST Support

[stsupport]

As you said I tried to perform the same steps...till step 10 it worked fine...

1. Took a backup of OTRS 3.0.10 folder.

2. set Path=%PATH%;C:\OTRS\mysql\bin

3. mysqldump -uroot otrs > otrs_dump.sql

4. Uninstalled OTRS 3.0.10 and installed OTRS 3.1.0.

5. Copied the config file from old OTRS to new one.

6. set Path=%PATH%;C:\Program Files\OTRS\Strawberry Perl\perl\bin;C:\Program Files\OTRS\mysql\bin

7. Created DB using 'CREATE DATABASE otrs CHARACTER SET utf8;

8. GRANT ALL ON otrs. * TO 'otrs'@localhost'

9. mysql -uroot otrs < otrs_dump.sql

10. mysql -uroot otrs < DBUpdate-to-3.1.mysql.sql

11. perl DBUpdate-to-3.1.pl

I got error message at step 11. Snapshot attached with this mail.

[jojo]

please always use the latest versions for update, which is 3.1.13