Error 1146: Table otrs.dynamic_field doesn't exist

Moderator: crythias

Post Reply
stsupport
OTRS newbie
Posts: 6
Joined: 12 Mar 2013, 20:11
OTRS Version?: 3.2.2
Real Name: Support
Company: ST

Error 1146: Table otrs.dynamic_field doesn't exist

Post by 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
OTRS wizard
Posts: 159
Joined: 11 Nov 2011, 19:27
OTRS Version?: 3.0.11

Re: Error 1146: Table otrs.dynamic_field doesn't exist

Post by 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
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

stsupport
OTRS newbie
Posts: 6
Joined: 12 Mar 2013, 20:11
OTRS Version?: 3.2.2
Real Name: Support
Company: ST

Re: Error 1146: Table otrs.dynamic_field doesn't exist

Post by stsupport »

Thanks for your quick response.

Let me check it....

Regards,

ST Support

stsupport
OTRS newbie
Posts: 6
Joined: 12 Mar 2013, 20:11
OTRS Version?: 3.2.2
Real Name: Support
Company: ST

Re: Error 1146: Table otrs.dynamic_field doesn't exist

Post by 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.
You do not have the required permissions to view the files attached to this post.

jojo
Moderator
Posts: 14635
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

Re: Error 1146: Table otrs.dynamic_field doesn't exist

Post by jojo »

please always use the latest versions for update, which is 3.1.13
"Production": 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 :: Share your ideas

Post Reply