Update abuse and support ticket url fields
Description
Attachments
Activity
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.
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