(Solved) Missing tables error in OTRS 4

Moderator: crythias

Post Reply
pituca
Znuny advanced
Posts: 131
Joined: 09 Jan 2013, 02:50
Znuny Version: 5.0.9
Company: OmniRedes

(Solved) Missing tables error in OTRS 4

Post by pituca »

Hello team,

After migrating to OTRS 4.0.2 I keep seeing in my system log the following errors:
Table 'otrs.system_maintenance' doesn't exist, SQL: '
AND
Table 'otrs.personal_services' doesn't exist, SQL: '
Thank you so much for your support.
Last edited by pituca on 08 Dec 2014, 02:04, edited 1 time in total.
OTRS 5.0.9, , ITSM 5.0.9, MySQL, Ubuntu 14.04, Apache2
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Missing tables error in OTRS 4

Post by jojo »

your migration did not succeed. Please check again the SQL and Perl scripts you have to run
"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
pituca
Znuny advanced
Posts: 131
Joined: 09 Jan 2013, 02:50
Znuny Version: 5.0.9
Company: OmniRedes

Re: Missing tables error in OTRS 4

Post by pituca »

Thank you so much I ran the .sql and .pl scripts and the error seems to be gone.
OTRS 5.0.9, , ITSM 5.0.9, MySQL, Ubuntu 14.04, Apache2
anonymos10
Znuny newbie
Posts: 6
Joined: 01 Jul 2014, 10:46
Znuny Version: 3.0.6

Re: (Solved) Missing tables error in OTRS 4

Post by anonymos10 »

Hello pituca

Which Scripts exactly do you run? I got the same problem. I ran the scripts/DBUpdate-to-4.pl script but nothing happenend.

Thank you for your support!
bobpitt
Znuny newbie
Posts: 1
Joined: 03 Feb 2015, 01:05
Znuny Version: 3.3.9
Real Name: Bob Pitt
Company: NCI

Re: (Solved) Missing tables error in OTRS 4

Post by bobpitt »

Hello pituca

I have the same problem, tables 'otrs.personal_services' and 'otrs.system_maintenance' do not exist. Which scripts do I need to run?

Thanks for your help.

Bob
Post Reply