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

[Alex Vandiver]

On Tue, 2014-04-01 at 14:04 +0000, GARCIA PEREZ, Alberto (Alberto)** CTR
** wrote:
> 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

> [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
>