OTRS 2.2.4 -> 2.3 Errors

[RyanGrob]

Hi,

I'm trying to follow the upgrade path from 2.2 -> 2.3 -> 2.4 -> 3.0 but cannot successfully do so. Errors seem to occur during step 1/2 of the database migration (pre and post MySQL scripts) which the upgrading guide mentions is OK. When trying to do the migration script, the entire screen fills with errors which follow the same direction as the ones below:

ERROR: OTRS-DBUpdate-to-2.3-10 Perl: 5.10.1 OS: linux Time: Fri Jan 21 15:31:27 2011

Message: Invalid SourceObject is given!

Traceback (9724):
Module: main::LinkAdd (v1.20) Line: 455
Module: main::MigrateLinkObject (v1.20) Line: 389
Module: DBUpdate-to-2.3.pl (v1.20) Line: 100

DBD::mysql::st execute failed: Table 'otrs.link_object' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 560.
ERROR: OTRS-DBUpdate-to-2.3-10 Perl: 5.10.1 OS: linux Time: Fri Jan 21 15:31:27 2011

Message: Table 'otrs.link_object' doesn't exist, SQL: 'SELECT id FROM link_object WHERE name = ? LIMIT 1'

Traceback (9724):
Module: main::ObjectLookup (v1.20) Line: 582
Module: main::LinkAdd (v1.20) Line: 448
Module: main::MigrateLinkObject (v1.20) Line: 389
Module: DBUpdate-to-2.3.pl (v1.20) Line: 100

DBD::mysql::st fetchrow_array failed: fetch() without execute() at /opt/otrs/Kernel/System/DB.pm line 623.
DBD::mysql::st execute failed: Table 'otrs.link_object' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 560.
ERROR: OTRS-DBUpdate-to-2.3-10 Perl: 5.10.1 OS: linux Time: Fri Jan 21 15:31:27 2011

Message: Table 'otrs.link_object' doesn't exist, SQL: 'SELECT id FROM link_object WHERE name = ? LIMIT 1'

Traceback (9724):
Module: main::ObjectLookup (v1.20) Line: 582
Module: main::LinkAdd (v1.20) Line: 448
Module: main::MigrateLinkObject (v1.20) Line: 389
Module: DBUpdate-to-2.3.pl (v1.20) Line: 100

DBD::mysql::st fetchrow_array failed: fetch() without execute() at /opt/otrs/Kernel/System/DB.pm line 623.
DBD::mysql::db do failed: Table 'otrs.link_object' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 428.
ERROR: OTRS-DBUpdate-to-2.3-10 Perl: 5.10.1 OS: linux Time: Fri Jan 21 15:31:27 2011

Message: Table 'otrs.link_object' doesn't exist, SQL: 'INSERT INTO link_object (name) VALUES (?)'

Traceback (9724):
Module: main::ObjectLookup (v1.20) Line: 612
Module: main::LinkAdd (v1.20) Line: 448
Module: main::MigrateLinkObject (v1.20) Line: 389
Module: DBUpdate-to-2.3.pl (v1.20) Line: 100

ERROR: OTRS-DBUpdate-to-2.3-10 Perl: 5.10.1 OS: linux Time: Fri Jan 21 15:31:27 2011

Message: Invalid SourceObject is given!

Traceback (9724):
Module: main::LinkAdd (v1.20) Line: 455
Module: main::MigrateLinkObject (v1.20) Line: 389
Module: DBUpdate-to-2.3.pl (v1.20) Line: 100

DBD::mysql::st execute failed: Table 'otrs.link_object' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 560.
ERROR: OTRS-DBUpdate-to-2.3-10 Perl: 5.10.1 OS: linux Time: Fri Jan 21 15:31:27 2011

Message: Table 'otrs.link_object' doesn't exist, SQL: 'SELECT id FROM link_object WHERE name = ? LIMIT 1'

Traceback (9724):
Module: main::ObjectLookup (v1.20) Line: 582
Module: main::LinkAdd (v1.20) Line: 448
Module: main::MigrateLinkObject (v1.20) Line: 389
Module: DBUpdate-to-2.3.pl (v1.20) Line: 100

DBD::mysql::st fetchrow_array failed: fetch() without execute() at /opt/otrs/Kernel/System/DB.pm line 623.
DBD::mysql::st execute failed: Table 'otrs.link_object' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 560.
ERROR: OTRS-DBUpdate-to-2.3-10 Perl: 5.10.1 OS: linux Time: Fri Jan 21 15:31:27 2011

Message: Table 'otrs.link_object' doesn't exist, SQL: 'SELECT id FROM link_object WHERE name = ? LIMIT 1'

Traceback (9724):
Module: main::ObjectLookup (v1.20) Line: 582
Module: main::LinkAdd (v1.20) Line: 448
Module: main::MigrateLinkObject (v1.20) Line: 389
Module: DBUpdate-to-2.3.pl (v1.20) Line: 100

DBD::mysql::st fetchrow_array failed: fetch() without execute() at /opt/otrs/Kernel/System/DB.pm line 623.
DBD::mysql::db do failed: Table 'otrs.link_object' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 428.
ERROR: OTRS-DBUpdate-to-2.3-10 Perl: 5.10.1 OS: linux Time: Fri Jan 21 15:31:27 2011

Message: Table 'otrs.link_object' doesn't exist, SQL: 'INSERT INTO link_object (name) VALUES (?)'

Traceback (9724):
Module: main::ObjectLookup (v1.20) Line: 612
Module: main::LinkAdd (v1.20) Line: 448
Module: main::MigrateLinkObject (v1.20) Line: 389
Module: DBUpdate-to-2.3.pl (v1.20) Line: 100

ERROR: OTRS-DBUpdate-to-2.3-10 Perl: 5.10.1 OS: linux Time: Fri Jan 21 15:31:27 2011

Message: Invalid SourceObject is given!

Traceback (9724):
Module: main::LinkAdd (v1.20) Line: 455
Module: main::MigrateLinkObject (v1.20) Line: 389
Module: DBUpdate-to-2.3.pl (v1.20) Line: 100

Screen is completely filled with these... The post MySQL portion of course fails and although database items are there, the structure isn't compatible with 2.3. Any ideas?

[Wolfgangf]

it seams, you're missing a table 'link_object' like the errormessages say

this table should be created in this script;

you can try to add this table manually :

Code: Select all

mysql otrs
mysql>CREATE TABLE link_object (
    id SMALLINT NOT NULL AUTO_INCREMENT,
    name VARCHAR (100) NOT NULL,
    PRIMARY KEY(id),
    UNIQUE INDEX link_object_name (name)
);

see if there are any error messages and try to run the dbupdate-to3 scripts once again

[RyanGrob]

Thanks for the reply Wolfgangf. I will be trying your fix later this morning and will post results

[RyanGrob]

No such luck. Executed your command correctly then ran first script. Here is what I received:

Bareword found where operator expected at DBUpdate-to-2.3.mysql.sql line 14, near ") NOT"
(Missing operator before NOT?)
Bareword found where operator expected at DBUpdate-to-2.3.mysql.sql line 15, near ") NULL"
(Missing operator before NULL?)
Bareword found where operator expected at DBUpdate-to-2.3.mysql.sql line 31, near ") NOT"
(Missing operator before NOT?)
Bareword found where operator expected at DBUpdate-to-2.3.mysql.sql line 45, near ") NOT"
(Missing operator before NOT?)
Bareword found where operator expected at DBUpdate-to-2.3.mysql.sql line 59, near ") NOT"
(Missing operator before NOT?)
Bareword found where operator expected at DBUpdate-to-2.3.mysql.sql line 68, near ") NOT"
(Missing operator before NOT?)
Bareword found where operator expected at DBUpdate-to-2.3.mysql.sql line 70, near ") NOT"
(Missing operator before NOT?)
Bareword found where operator expected at DBUpdate-to-2.3.mysql.sql line 106, near "0 WHERE"
(Missing operator before WHERE?)
Bareword found where operator expected at DBUpdate-to-2.3.mysql.sql line 112, near "0 WHERE"
(Missing operator before WHERE?)
Bareword found where operator expected at DBUpdate-to-2.3.mysql.sql line 113, near "0 NOT"
(Missing operator before NOT?)
Bareword found where operator expected at DBUpdate-to-2.3.mysql.sql line 166, near ") NULL"
(Missing operator before NULL?)
Bareword found where operator expected at DBUpdate-to-2.3.mysql.sql line 167, near ") NULL"
(Missing operator before NULL?)
Bareword found where operator expected at DBUpdate-to-2.3.mysql.sql line 168, near ") NULL"
(Missing operator before NULL?)
Bareword found where operator expected at DBUpdate-to-2.3.mysql.sql line 169, near ") NULL"
(Missing operator before NULL?)
Bareword found where operator expected at DBUpdate-to-2.3.mysql.sql line 170, near ") NULL"
(Missing operator before NULL?)
Bareword found where operator expected at DBUpdate-to-2.3.mysql.sql line 171, near ") NULL"
(Missing operator before NULL?)
Bareword found where operator expected at DBUpdate-to-2.3.mysql.sql line 179, near ") REFERENCES"
(Missing operator before REFERENCES?)
syntax error at DBUpdate-to-2.3.mysql.sql line 14, near ") NOT NULL"
syntax error at DBUpdate-to-2.3.mysql.sql line 31, near ") NOT NULL"
syntax error at DBUpdate-to-2.3.mysql.sql line 45, near ") NOT NULL"
syntax error at DBUpdate-to-2.3.mysql.sql line 59, near ") NOT NULL"
syntax error at DBUpdate-to-2.3.mysql.sql line 68, near ") NOT NULL"
syntax error at DBUpdate-to-2.3.mysql.sql line 106, near "0 WHERE escalation_update_time "
syntax error at DBUpdate-to-2.3.mysql.sql line 112, near "0 WHERE escalation_time "
syntax error at DBUpdate-to-2.3.mysql.sql line 113, near "0 NOT NULL"
syntax error at DBUpdate-to-2.3.mysql.sql line 166, near ") NULL"
syntax error at DBUpdate-to-2.3.mysql.sql line 179, near ") REFERENCES ticket "
DBUpdate-to-2.3.mysql.sql has too many errors.

Migration script (as OTRS user) resulted in the same errors I posted in my first post.

Last script resulted in this:

Can't locate object method "sla" via package "DROP" (perhaps you forgot to load "DROP"?) at DBUpdate-to-2.3-post.mysql.sql line 7.

Not sure why this isn't working...I did the same procedure over the summer and it worked flawlessly.

[jojo]

it seems that you tried to run the SQL Script at the shell and not in the database!

[RyanGrob]

it seems that you tried to run the SQL Script at the shell and not in the database!

*facepalm*

You are completely correct. I need to look more closely at commands. All is fixed. Thank you both tremendously for your help!