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 > [email protected] > UCM TEAM > -- RT Training - Dallas May 20-21 http://bestpractical.com/training
