RT.Articles table doesn't exist

Hi,

After upgrading my RT from 3.6.6 to 4.0.4 the rt.log displays the next warning:

[Tue Apr 1 13:43:24 2014] [warning]: DBD::mysql::st execute failed: Table ‘rt4.Articles’ doesn’t exist at /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 589. (/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm:589)

[Tue Apr 1 13:43:24 2014] [warning]: RT::Handle=HASH(0x7fc31873b970) couldn’t execute the query 'SELECT COUNT(DISTINCT main.id) FROM Articles main JOIN Classes Classes_1 ON ( Classes_1.id = main.Class ) JOIN ObjectClasses ObjectClasses_2 ON ( ObjectClasses_2.Class = main.Class ) WHERE (Classes_1.HotList = ‘1’) AND ( ( ObjectClasses_2.ObjectId = ‘21’ AND ObjectClasses_2.ObjectType = ‘RT::Queue’ ) OR ( ObjectClasses_2.ObjectId = ‘0’ AND ObjectClasses_2.ObjectType = ‘RT::System’ ) ) ’ at /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 602.

I have searched for the Articles table in the DB but it doesn’t exist.
Can anybody help me with this issue? How can I create this table?

Regards.

Alberto García Pérez
alberto.garcia_perez@alcatel-lucent.com
UCM TEAM

After upgrading my RT from 3.6.6 to 4.0.4 the rt.log displays the next
warning:

Why upgrade to 4.0.4, which has published security vulnerabilities,
rather than 4.0.19?

[Tue Apr 1 13:43:24 2014] [warning]: DBD::mysql::st execute failed:
Table ‘rt4.Articles’ doesn’t exist at
/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 589.
(/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm:589)

This implies you didn’t run the database upgrade steps like the README
tells you to. You will have much bigger problems than merely missing
the Articles table; since you’re on MySQL and coming up from before 3.8,
by skipping upgade steps, your Attachments table may be corrupted.
Please re-read step 6b of the README [1], as well as UPGRADING.mysql
[2].

  • Alex

[1] http://bestpractical.com/docs/rt/4.0/README.html
[2] http://bestpractical.com/docs/rt/4.0/UPGRADING.mysql.html