Update abuse and support ticket url fields

Description

PAC have been working with Zoho to move the URL field to be an actual URL. As part of that, we need to rename the existing field on the Archive side to cf_ticket_url. Its new limit should be 2083 (or 2080 to be safe). Right now, we don’t truncate at all, so take a look at for an example of how to do that.

Code that needs changing:

This will impact as well, since we’ll want to name the URL field the same thing there.

For consistency, both Abuse and Support tickets with no known URL should be submitted as blank URL fields, instead of the “Unknown URL” placeholder value that was added to Support tickets in 6232.

Testing

Submit tickets to PAC and Support with:

  • URL over the 2080 character limit (use a filter page with a lot of included/excluded tags and search terms?)

  • URL under the 2080 character limit

  • no URL (Support only – open the report page from an email or blank tab)

and confirm that the tickets received have the correct values in the URL field

Deploy notes

Migration:

bundle exec rake db:migrate:up VERSION=20250303154718

Attachments

1

Activity

Show:

Bilka 
April 3, 2025 at 8:04 AM
(edited)

Migration run on production by Brian yesterday around 20:30 UTC.

Bilka 
April 1, 2025 at 7:35 AM

Sent:

Support ticket from manually entered URL

Support and PAC ticket from very very long URL by using a lot of exclusion filters

Support and PAC ticket from the homepage

Lydia confirms that everything worked on the Zoho side of things

The automated “support report” email for the long url to PAC was very wide, but that’s to be expected.

lydia-theda 
April 1, 2025 at 3:20 AM
(edited)

Support ticket filed from new tab and manually entered URL: Both URL fields are blank

Support ticket filed from referral URL under the 2080 character limit: URL field blank; Ticket URL field correctly filled in, I could click on the icon and open the correct page

Support ticket filed from referral URL over the 2080 character limit: Filtered on a 100+ character tag till I got a URL that was 2790 characters long (note for whoever else tests: enter a bunch of nonsense into the Search Within Results field, it’s faster), went to the Support form. Ticket URL field was truncated to exactly 2080 characters (opening it from Zoho produced a “This page isn’t working If the problem continues, contact the site owner. HTTP ERROR 400” error, probably because it truncated in a way that created an invalid AO3 page)

PAC ticket filed from the same 2790 URL: It took longer to submit, I think, but I got the same results – a matching 2080 character URL in the new Ticket URL field. (The email I got looked very weird on mobile though desktop was fine)

PAC ticket filed from a regular AO3 page: URL field blank; Ticket URL field correctly filled in, I could click on the icon and open the correct page

 

Now to go fight with Zoho’s support team to try to initiate the db transfers on their end in a semi-reasonable timeline, wish me luck.

Sarken 
April 1, 2025 at 12:00 AM

Migrated up! Tried to migrate down, was correctly warned (in amongst a bunch of trace barf) that:

So migration checks out and this is ready for testing.

lydia-theda 
February 23, 2025 at 12:44 PM

DeployedToBeta

Details

Assignee

Reporter

Roadmap

Misc

Priority

Affects versions

Fix versions

Components

BackEnd

Difficulty

Milestone

Sentry

1
Created August 20, 2024 at 12:59 AM
Updated April 3, 2025 at 8:05 AM
Resolved April 2, 2025 at 8:49 PM