summaryrefslogtreecommitdiff
path: root/rt/etc
diff options
context:
space:
mode:
Diffstat (limited to 'rt/etc')
-rw-r--r--rt/etc/RT_Config.pm.in44
-rw-r--r--rt/etc/initialdata60
-rwxr-xr-xrt/etc/upgrade/3.8-branded-queues-extension.in2
-rw-r--r--rt/etc/upgrade/3.8-ical-extension.in2
-rw-r--r--rt/etc/upgrade/3.9.8/content2
-rw-r--r--rt/etc/upgrade/4.0.12/schema.Oracle1
-rw-r--r--rt/etc/upgrade/4.0.12/schema.Pg1
-rw-r--r--rt/etc/upgrade/4.0.12/schema.mysql1
-rw-r--r--rt/etc/upgrade/4.0.13/schema.Oracle2
-rw-r--r--rt/etc/upgrade/4.0.13/schema.Pg2
-rw-r--r--rt/etc/upgrade/4.0.13/schema.mysql2
-rw-r--r--rt/etc/upgrade/4.0.9/content52
-rw-r--r--rt/etc/upgrade/generate-rtaddressregexp.in2
-rw-r--r--rt/etc/upgrade/sanity-check-stylesheets.pl2
-rw-r--r--rt/etc/upgrade/shrink_cgm_table.pl4
-rw-r--r--rt/etc/upgrade/shrink_transactions_table.pl4
-rw-r--r--rt/etc/upgrade/split-out-cf-categories.in2
-rwxr-xr-xrt/etc/upgrade/upgrade-articles2
-rw-r--r--rt/etc/upgrade/upgrade-articles.in2
-rwxr-xr-xrt/etc/upgrade/upgrade-mysql-schema.pl2
-rwxr-xr-xrt/etc/upgrade/vulnerable-passwords.in2
21 files changed, 159 insertions, 34 deletions
diff --git a/rt/etc/RT_Config.pm.in b/rt/etc/RT_Config.pm.in
index 5edb54c26..36a4c3014 100644
--- a/rt/etc/RT_Config.pm.in
+++ b/rt/etc/RT_Config.pm.in
@@ -479,11 +479,28 @@ accordingly.
=cut
-Set($ExtractSubjectTagMatch, qr/\[.+? #\d+\]/);
+Set($ExtractSubjectTagMatch, qr/\[[^\]]+? #\d+\]/);
Set($ExtractSubjectTagNoMatch, ( ${RT::EmailSubjectTagRegex}
? qr/\[(?:${RT::EmailSubjectTagRegex}) #\d+\]/
: qr/\[\Q$RT::rtname\E #\d+\]/));
+=item C<$CheckMoreMSMailHeaders>
+
+Some email clients create a plain text version of HTML-formatted
+email to help other clients that read only plain text.
+Unfortunately, the plain text parts sometimes end up with
+doubled newlines and these can then end up in RT. This
+is most often seen in MS Outlook.
+
+Enable this option to have RT check for additional mail headers
+and attempt to identify email from MS Outlook. When detected,
+RT will then clean up double newlines. Note that it may
+clean up intentional double newlines as well.
+
+=cut
+
+Set( $CheckMoreMSMailHeaders, 0);
+
=back
@@ -520,6 +537,8 @@ Correspond mail address of the ticket's queue.
Warning: If you use this setting, bounced mails will appear to be
incoming mail to the system, thus creating new tickets.
+This option only works if C<$MailCommand> is set to 'sendmailpipe'.
+
=cut
Set($SetOutgoingMailFrom, 0);
@@ -535,7 +554,8 @@ The option is a hash reference of queue name to email address. If
there is no ticket involved, then the value of the C<Default> key will
be used.
-This option is irrelevant unless C<$SetOutgoingMailFrom> is set.
+This option only works if C<$SetOutgoingMailFrom> is enabled and
+C<$MailCommand> is set to 'sendmailpipe'.
=cut
@@ -903,6 +923,7 @@ Set(@JSFiles, qw/
jquery-ui-1.8.4.custom.min.js
jquery-ui-timepicker-addon.js
jquery-ui-patch-datepicker.js
+ jquery.cookie.js
titlebox-state.js
util.js
userautocomplete.js
@@ -1127,7 +1148,12 @@ user's customized homepage ("RT at a glance").
=cut
-Set($HomepageComponents, [qw(QuickCreate Quicksearch MyCalendar MyAdminQueues MySupportQueues MyReminders RefreshHomepage Dashboards SavedSearches)]);
+Set(
+ $HomepageComponents,
+ [
+ qw(QuickCreate Quicksearch MyCalendar MyAdminQueues MySupportQueues MyReminders RefreshHomepage Dashboards SavedSearches ) # loc_qw
+ ]
+);
=back
@@ -1236,6 +1262,18 @@ Set(%FullTextSearch,
Indexed => 0,
);
+=item C<$DontSearchFileAttachments>
+
+If C<$DontSearchFileAttachments> is set to 1, then uploaded files
+(attachments with file names) are not searched during content
+search.
+
+Note that if you use indexed FTS then named attachments are still
+indexed by default regardless of this option.
+
+=cut
+
+Set($DontSearchFileAttachments, undef);
=item C<$OnlySearchActiveTicketsInSimpleSearch>
diff --git a/rt/etc/initialdata b/rt/etc/initialdata
index 7ab746db1..8b9890550 100644
--- a/rt/etc/initialdata
+++ b/rt/etc/initialdata
@@ -662,23 +662,49 @@ Hour: { $SubscriptionObj->SubValue('Hour') }
OrderBy => 'LastUpdated',
Order => 'DESC' },
},
- { Name => 'HomepageSettings',
- Description => 'HomepageSettings',
- Content =>
- { 'body' => # loc
- [ { type => 'system', name => 'My Tickets' },
- { type => 'system', name => 'Unowned Tickets' },
- { type => 'system', name => 'Bookmarked Tickets' },
- { type => 'component', name => 'QuickCreate' },
- ],
- 'summary' => # loc
- [
- { type => 'component', name => 'MyReminders' },
- { type => 'component', name => 'Quicksearch' },
- { type => 'component', name => 'Dashboards' },
- { type => 'component', name => 'RefreshHomepage' },
- ],
- },
+ {
+ Name => 'HomepageSettings',
+ Description => 'HomepageSettings',
+ Content => {
+ 'body' => # loc
+ [
+ {
+ type => 'system',
+ name => 'My Tickets', # loc
+ },
+ {
+ type => 'system',
+ name => 'Unowned Tickets' # loc
+ },
+ {
+ type => 'system',
+ name => 'Bookmarked Tickets' # loc
+ },
+ {
+ type => 'component',
+ name => 'QuickCreate' # loc
+ },
+ ],
+ 'summary' => # loc
+ [
+ {
+ type => 'component',
+ name => 'MyReminders' # loc
+ },
+ {
+ type => 'component',
+ name => 'Quicksearch' # loc
+ },
+ {
+ type => 'component',
+ name => 'Dashboards' # loc
+ },
+ {
+ type => 'component',
+ name => 'RefreshHomepage' # loc
+ },
+ ],
+ },
},
);
diff --git a/rt/etc/upgrade/3.8-branded-queues-extension.in b/rt/etc/upgrade/3.8-branded-queues-extension.in
index 8c9f58ded..7fb28c56c 100755
--- a/rt/etc/upgrade/3.8-branded-queues-extension.in
+++ b/rt/etc/upgrade/3.8-branded-queues-extension.in
@@ -3,7 +3,7 @@
#
# COPYRIGHT:
#
-# This software is Copyright (c) 1996-2012 Best Practical Solutions, LLC
+# This software is Copyright (c) 1996-2013 Best Practical Solutions, LLC
# <sales@bestpractical.com>
#
# (Except where explicitly superseded by other copyright notices)
diff --git a/rt/etc/upgrade/3.8-ical-extension.in b/rt/etc/upgrade/3.8-ical-extension.in
index af95a96d9..0bbba7b2d 100644
--- a/rt/etc/upgrade/3.8-ical-extension.in
+++ b/rt/etc/upgrade/3.8-ical-extension.in
@@ -3,7 +3,7 @@
#
# COPYRIGHT:
#
-# This software is Copyright (c) 1996-2012 Best Practical Solutions, LLC
+# This software is Copyright (c) 1996-2013 Best Practical Solutions, LLC
# <sales@bestpractical.com>
#
# (Except where explicitly superseded by other copyright notices)
diff --git a/rt/etc/upgrade/3.9.8/content b/rt/etc/upgrade/3.9.8/content
index d759db9cd..db717cd95 100644
--- a/rt/etc/upgrade/3.9.8/content
+++ b/rt/etc/upgrade/3.9.8/content
@@ -19,6 +19,6 @@
my $result = $dbh->selectall_arrayref("SELECT count(*) AS articlecount FROM FM_Articles", { Slice => {} } );
if ($result->[0]{articlecount} > 0) {
- $RT::Logger->error("You appear to have RTFM Articles. You can upgrade using the etc/upgrade/upgrade-articles script. Read more about it in UPGRADING");
+ $RT::Logger->error("You appear to have RTFM Articles. You can upgrade using the etc/upgrade/upgrade-articles script. Read more about it in docs/UPGRADING-4.0");
}
};
diff --git a/rt/etc/upgrade/4.0.12/schema.Oracle b/rt/etc/upgrade/4.0.12/schema.Oracle
new file mode 100644
index 000000000..4d2c375bb
--- /dev/null
+++ b/rt/etc/upgrade/4.0.12/schema.Oracle
@@ -0,0 +1 @@
+UPDATE Tickets SET Type = LOWER(Type) WHERE LOWER(Type) IN ('ticket', 'approval', 'reminder');
diff --git a/rt/etc/upgrade/4.0.12/schema.Pg b/rt/etc/upgrade/4.0.12/schema.Pg
new file mode 100644
index 000000000..4d2c375bb
--- /dev/null
+++ b/rt/etc/upgrade/4.0.12/schema.Pg
@@ -0,0 +1 @@
+UPDATE Tickets SET Type = LOWER(Type) WHERE LOWER(Type) IN ('ticket', 'approval', 'reminder');
diff --git a/rt/etc/upgrade/4.0.12/schema.mysql b/rt/etc/upgrade/4.0.12/schema.mysql
new file mode 100644
index 000000000..4d2c375bb
--- /dev/null
+++ b/rt/etc/upgrade/4.0.12/schema.mysql
@@ -0,0 +1 @@
+UPDATE Tickets SET Type = LOWER(Type) WHERE LOWER(Type) IN ('ticket', 'approval', 'reminder');
diff --git a/rt/etc/upgrade/4.0.13/schema.Oracle b/rt/etc/upgrade/4.0.13/schema.Oracle
new file mode 100644
index 000000000..6ab70204e
--- /dev/null
+++ b/rt/etc/upgrade/4.0.13/schema.Oracle
@@ -0,0 +1,2 @@
+UPDATE Tickets SET Subject = REPLACE(Subject,CHR(10),''), Status = LOWER(Status);
+UPDATE Transactions SET OldValue = LOWER(OldValue), NewValue = LOWER(NewValue) WHERE Type = 'Status' AND Field = 'Status';
diff --git a/rt/etc/upgrade/4.0.13/schema.Pg b/rt/etc/upgrade/4.0.13/schema.Pg
new file mode 100644
index 000000000..8283f5259
--- /dev/null
+++ b/rt/etc/upgrade/4.0.13/schema.Pg
@@ -0,0 +1,2 @@
+UPDATE Tickets SET Subject = REPLACE(Subject,E'\n',''), Status = LOWER(Status);
+UPDATE Transactions SET OldValue = LOWER(OldValue), NewValue = LOWER(NewValue) WHERE Type = 'Status' AND Field = 'Status';
diff --git a/rt/etc/upgrade/4.0.13/schema.mysql b/rt/etc/upgrade/4.0.13/schema.mysql
new file mode 100644
index 000000000..03b54b569
--- /dev/null
+++ b/rt/etc/upgrade/4.0.13/schema.mysql
@@ -0,0 +1,2 @@
+UPDATE Tickets SET Subject = REPLACE(Subject,'\n',''), Status = LOWER(Status);
+UPDATE Transactions SET OldValue = LOWER(OldValue), NewValue = LOWER(NewValue) WHERE Type = 'Status' AND Field = 'Status';
diff --git a/rt/etc/upgrade/4.0.9/content b/rt/etc/upgrade/4.0.9/content
new file mode 100644
index 000000000..f2abf623b
--- /dev/null
+++ b/rt/etc/upgrade/4.0.9/content
@@ -0,0 +1,52 @@
+@Initial = (
+ sub {
+ $RT::Logger->debug(
+ 'Going to update empty Queue Lifecycle column to "default"');
+
+ my $queues = RT::Queues->new( RT->SystemUser );
+ $queues->FindAllRows;
+ $queues->Limit(
+ FIELD => 'Lifecycle',
+ OPERATOR => 'IS',
+ VALUE => 'NULL',
+ );
+
+ $queues->Limit(
+ FIELD => 'Lifecycle',
+ VALUE => '',
+ ENTRYAGGREGATOR => 'OR',
+ );
+
+ $queues->Limit(
+ FIELD => 'Lifecycle',
+ VALUE => 0,
+ ENTRYAGGREGATOR => 'OR',
+ );
+
+ while ( my $q = $queues->Next ) {
+ $q->SetLifecycle('default');
+ }
+ },
+ sub {
+ use strict;
+ my $groups = RT::Groups->new(RT->SystemUser);
+ $groups->Limit( FIELD => 'Domain',
+ OPERATOR => '=',
+ VALUE => 'Personal'
+ );
+ $groups->LimitToDeleted;
+ while ( my $group = $groups->Next ) {
+ my $members = $group->MembersObj();
+ while ( my $member = $members->Next ) {
+ my ( $ok, $msg ) = $group->DeleteMember( $member->MemberId );
+ if ( !$ok ) {
+ $RT::Logger->warn( "Unable to remove group member "
+ . $member->id . ": "
+ . $msg );
+ }
+ }
+ $group->PrincipalObj->Delete;
+ $group->RT::Record::Delete();
+ }
+ },
+);
diff --git a/rt/etc/upgrade/generate-rtaddressregexp.in b/rt/etc/upgrade/generate-rtaddressregexp.in
index 68259ff94..751122a99 100644
--- a/rt/etc/upgrade/generate-rtaddressregexp.in
+++ b/rt/etc/upgrade/generate-rtaddressregexp.in
@@ -3,7 +3,7 @@
#
# COPYRIGHT:
#
-# This software is Copyright (c) 1996-2012 Best Practical Solutions, LLC
+# This software is Copyright (c) 1996-2013 Best Practical Solutions, LLC
# <sales@bestpractical.com>
#
# (Except where explicitly superseded by other copyright notices)
diff --git a/rt/etc/upgrade/sanity-check-stylesheets.pl b/rt/etc/upgrade/sanity-check-stylesheets.pl
index eff469fd6..6ae1cc61c 100644
--- a/rt/etc/upgrade/sanity-check-stylesheets.pl
+++ b/rt/etc/upgrade/sanity-check-stylesheets.pl
@@ -2,7 +2,7 @@
#
# COPYRIGHT:
#
-# This software is Copyright (c) 1996-2012 Best Practical Solutions, LLC
+# This software is Copyright (c) 1996-2013 Best Practical Solutions, LLC
# <sales@bestpractical.com>
#
# (Except where explicitly superseded by other copyright notices)
diff --git a/rt/etc/upgrade/shrink_cgm_table.pl b/rt/etc/upgrade/shrink_cgm_table.pl
index cf39d04d7..bb6c8d487 100644
--- a/rt/etc/upgrade/shrink_cgm_table.pl
+++ b/rt/etc/upgrade/shrink_cgm_table.pl
@@ -3,7 +3,7 @@
#
# COPYRIGHT:
#
-# This software is Copyright (c) 1996-2012 Best Practical Solutions, LLC
+# This software is Copyright (c) 1996-2013 Best Practical Solutions, LLC
# <sales@bestpractical.com>
#
# (Except where explicitly superseded by other copyright notices)
@@ -106,7 +106,7 @@ while ( my $rec = FetchNext( $cgms ) ) {
$RT::Handle->Commit;
}
-use constant PAGE_SIZE => 1000;
+use constant PAGE_SIZE => 10000;
sub FetchNext {
my ($objs, $init) = @_;
if ( $init ) {
diff --git a/rt/etc/upgrade/shrink_transactions_table.pl b/rt/etc/upgrade/shrink_transactions_table.pl
index c23d09188..b4f07f090 100644
--- a/rt/etc/upgrade/shrink_transactions_table.pl
+++ b/rt/etc/upgrade/shrink_transactions_table.pl
@@ -3,7 +3,7 @@
#
# COPYRIGHT:
#
-# This software is Copyright (c) 1996-2012 Best Practical Solutions, LLC
+# This software is Copyright (c) 1996-2013 Best Practical Solutions, LLC
# <sales@bestpractical.com>
#
# (Except where explicitly superseded by other copyright notices)
@@ -106,7 +106,7 @@ while ( my $rec = FetchNext( $txns ) ) {
$RT::Handle->Commit;
}
-use constant PAGE_SIZE => 1000;
+use constant PAGE_SIZE => 10000;
sub FetchNext {
my ($objs, $init) = @_;
if ( $init ) {
diff --git a/rt/etc/upgrade/split-out-cf-categories.in b/rt/etc/upgrade/split-out-cf-categories.in
index 28ea309de..dcb56d08d 100644
--- a/rt/etc/upgrade/split-out-cf-categories.in
+++ b/rt/etc/upgrade/split-out-cf-categories.in
@@ -3,7 +3,7 @@
#
# COPYRIGHT:
#
-# This software is Copyright (c) 1996-2012 Best Practical Solutions, LLC
+# This software is Copyright (c) 1996-2013 Best Practical Solutions, LLC
# <sales@bestpractical.com>
#
# (Except where explicitly superseded by other copyright notices)
diff --git a/rt/etc/upgrade/upgrade-articles b/rt/etc/upgrade/upgrade-articles
index eef00aa67..0b4663213 100755
--- a/rt/etc/upgrade/upgrade-articles
+++ b/rt/etc/upgrade/upgrade-articles
@@ -3,7 +3,7 @@
#
# COPYRIGHT:
#
-# This software is Copyright (c) 1996-2012 Best Practical Solutions, LLC
+# This software is Copyright (c) 1996-2013 Best Practical Solutions, LLC
# <sales@bestpractical.com>
#
# (Except where explicitly superseded by other copyright notices)
diff --git a/rt/etc/upgrade/upgrade-articles.in b/rt/etc/upgrade/upgrade-articles.in
index b0f13d674..6e8d1d7c8 100644
--- a/rt/etc/upgrade/upgrade-articles.in
+++ b/rt/etc/upgrade/upgrade-articles.in
@@ -3,7 +3,7 @@
#
# COPYRIGHT:
#
-# This software is Copyright (c) 1996-2012 Best Practical Solutions, LLC
+# This software is Copyright (c) 1996-2013 Best Practical Solutions, LLC
# <sales@bestpractical.com>
#
# (Except where explicitly superseded by other copyright notices)
diff --git a/rt/etc/upgrade/upgrade-mysql-schema.pl b/rt/etc/upgrade/upgrade-mysql-schema.pl
index 310a6a826..98eb7b4e3 100755
--- a/rt/etc/upgrade/upgrade-mysql-schema.pl
+++ b/rt/etc/upgrade/upgrade-mysql-schema.pl
@@ -3,7 +3,7 @@
#
# COPYRIGHT:
#
-# This software is Copyright (c) 1996-2012 Best Practical Solutions, LLC
+# This software is Copyright (c) 1996-2013 Best Practical Solutions, LLC
# <sales@bestpractical.com>
#
# (Except where explicitly superseded by other copyright notices)
diff --git a/rt/etc/upgrade/vulnerable-passwords.in b/rt/etc/upgrade/vulnerable-passwords.in
index a3d719c31..22c56fd23 100755
--- a/rt/etc/upgrade/vulnerable-passwords.in
+++ b/rt/etc/upgrade/vulnerable-passwords.in
@@ -3,7 +3,7 @@
#
# COPYRIGHT:
#
-# This software is Copyright (c) 1996-2012 Best Practical Solutions, LLC
+# This software is Copyright (c) 1996-2013 Best Practical Solutions, LLC
# <sales@bestpractical.com>
#
# (Except where explicitly superseded by other copyright notices)
generated by cgit v1.2.1 (git 2.18.0) at 2025-01-10 22:58:16 +0000