hoo created this task. hoo added subscribers: hoo, daniel, aude, Lydia_Pintscher, Springle, jcrespo. hoo added projects: MediaWiki-extensions-WikibaseRepository, Wikidata, database, Schema-change. Restricted Application added a subscriber: Aklapper.
TASK DESCRIPTION Today I discovered that our `ips_site_page` field is to small to store all page titles out there (eg. https://www.wikidata.org/wiki/Q6703647 is affected by that). The field is defined as `varbinary(255) NOT NULL` which would be enough for the page titles (page_title is varbinary(255) everywhere), but it's not large enough to hold the page titles plus their namespaces (that's how we store the titles, unlike the `page` table which has a separate int field for them). To make that field fit for all pages on every Wikimedia wiki we should go for a length of at very least 300, as the longest page title I could find has 255 chars and the longest non-talk namespace has a length of 39 (The longest talk namespace has a length of 67!), also we need to store the colon. I'd suggest to go for a bit more than that, just to play it safe. TASK DETAIL https://phabricator.wikimedia.org/T99459 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: hoo Cc: jcrespo, Springle, Lydia_Pintscher, aude, daniel, Aklapper, hoo, Wikidata-bugs _______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs