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.
Error 1146: Table otrs.dynamic_field doesn't exist
Moderator: crythias
Re: Error 1146: Table otrs.dynamic_field doesn't exist
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
It's complaining that it can't find dynamic fields, because these are created in the upgrade from 3.0 to 3.1
Backend: OTRS 3.0.11 RedHat Enterprise Linux 6.2, Apache, MySQL with replication
Frontend: OTRS 3.0.11 RedHat Enterprise Linux 6.2 with SELinux, Apache SSL
Frontend: OTRS 3.0.11 RedHat Enterprise Linux 6.2 with SELinux, Apache SSL
-
- Znuny newbie
- Posts: 6
- Joined: 12 Mar 2013, 20:11
- Znuny Version: 3.2.2
- Real Name: Support
- Company: ST
Re: Error 1146: Table otrs.dynamic_field doesn't exist
Thanks for your quick response.
Let me check it....
Regards,
ST Support
Let me check it....
Regards,
ST Support
-
- Znuny newbie
- Posts: 6
- Joined: 12 Mar 2013, 20:11
- Znuny Version: 3.2.2
- Real Name: Support
- Company: ST
Re: Error 1146: Table otrs.dynamic_field doesn't exist
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.
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.
You do not have the required permissions to view the files attached to this post.
Re: Error 1146: Table otrs.dynamic_field doesn't exist
please always use the latest versions for update, which is 3.1.13
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com