[rt-users] RT.Articles table doesn't exist

[GARCIA PEREZ, Alberto (Alberto)** CTR **]

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 at alcatel-lucent.com
UCM TEAM