[rt-users] 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_pe...@alcatel-lucent.com UCM TEAM -- RT Training - Dallas May 20-21 http://bestpractical.com/training
Re: [rt-users] RT.Articles table doesn't exist
On Tue, 2014-04-01 at 14:04 +, 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_pe...@alcatel-lucent.com UCM TEAM -- RT Training - Dallas May 20-21 http://bestpractical.com/training
Re: [rt-users] User email accounts
On Fri, Mar 28, 2014 at 10:10:25PM -0400, Steven Hopps wrote: I've recently changed the domain name of my server from pride-techs.com to pridetechdesign.com and I started getting errors in RT because of the mismatch with the emails in the user accounts. So I edited the users to update the email addresses, but 24 hours later they were changed back automatically.. Could someone help me understand why this would be happening? I've changed them like 3 times now and they keep being reset to the previous email addresses. No internal RT process is going to rewrite your users table like that. Go look for cron jobs that are syncing from a bad user source. -kevin pgpNTq5XBNydV.pgp Description: PGP signature -- RT Training - Dallas May 20-21 http://bestpractical.com/training
Re: [rt-users] Predefined search for tickets referring to article | Group rights
On Fri, Mar 28, 2014 at 02:24:44AM -0700, rt4 wrote: Kevin Falcone-2 wrote What RT version. What rights do Privileged users have on the Admin Class. RT version 4.2.3. After some more feedback from the privileged users, it's likely that the search stopped working in October or November (i.e. either when we moved over from 4.0 to 4.2, or updated to 4.2.1). There has been no altering of permissions during this period. Privileged users have no rights on the Admin Class. Run the attached script on your box as perl -I/opt/rt4/lib testlinks (or wherever RT's libraries are) both with no arguments and again with the first argument being the name of one of the users who cannot see the articles. I suspect the problem is in normalization of a:4 into fsck.com-article://example.com/article/1 and you may just want to hardcode the longer link for your permissionless users. -kevin use RT -init; my $username = shift||'root'; my $currentuser = RT::CurrentUser-new(); my ($id,$msg) = $currentuser-Load($username); unless ($id) { die Unable to load $currentuser: $msg } my $tickets = RT::Tickets-new($currentuser); $tickets-FromSQL(RefersTo = 'a:4'); print $tickets-BuildSelectQuery; pgpYWxUUPE4xo.pgp Description: PGP signature -- RT Training - Dallas May 20-21 http://bestpractical.com/training
[rt-users] Notify ticket owner when updated by email
When a user replies to RT's email about a ticket, the ticket is updated. But on my installation (RT 4.2), the owner is not notified. How can the owner become quickly aware of such an update? Am I missing a configuration variable or do I need to add or modify a scrip? -- Dave Close -- RT Training - Dallas May 20-21 http://bestpractical.com/training
Re: [rt-users] Notify ticket owner when updated by email
On Apr 1, 2014, at 5:27 PM, CLOSE Dave dave.cl...@us.thalesgroup.com wrote: When a user replies to RT's email about a ticket, the ticket is updated. But on my installation (RT 4.2), the owner is not notified. How can the owner become quickly aware of such an update? Am I missing a configuration variable or do I need to add or modify a scrip? There should already be a 'notify owner on correspondence' scrip. First check to make sure you have it setup (either globally, it for the queue you're interested in). If you already have it, the next thing is to look at the template being used by that scrip and see if a) it's been modified to mail someone specific (and breaking the intended behavior)or b) if it's being overloaded from the global template. I hope this gets you there... Thanks, Jok -- RT Training - Dallas May 20-21 http://bestpractical.com/training