| • AGueyte | |
| Aug 28 2023, 6:40 PM |
| F37641066: 2023-08-29_11-07-59.png | |
| Aug 29 2023, 6:12 PM |
In the previous ticket, getTunnels() validated 2 values: "VPN" and "PROXY".
Then "UNKNOWN" was introduced as a valid ENUM in Tunnels Type array. The Schema needs to be updated as the original error reappears: "Data too long for column 'type' at row 1".
Request
Update Schema.sql to let Tunnels Type value accept up to 7 characters in order to let "UNKNOWN" be saved into the database
Expect behavior:
No "Data too long for column 'type' at row 1"" when importing files.
| Title | Reference | Author | Source Branch | Dest Branch | |
|---|---|---|---|---|---|
| Update Tunnels Type varbinary value to include 'UNKNOWN' as valid entry | repos/mediawiki/services/ipoid!53 | agueyte | updateSchemaTunnelsType | main |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Restricted Task | |||||
| Resolved | kostajh | T294511 2021 Security Team wikireplicas audit | |||
| Declined | None | T284948 Raw IPs of logged-out users disclosed in wiki-replicas | |||
| Resolved | Niharika | T324492 Temporary accounts - MVP | |||
| Resolved | kostajh | T340895 [Epic] IP Info accommodations for temporary accounts | |||
| Resolved | STran | T341395 Display Spur data on IPInfo infobox | |||
| Resolved | kostajh | T339284 Deploy ipoid | |||
| Resolved | kostajh | T340984 Fix problems with data import | |||
| Invalid | BUG REPORT | None | T339324 "Data too long for column 'type' at row 1" | ||
| Invalid | None | T345107 Update Tunnels Type schema VARBINARY value |
agueyte opened https://gitlab.wikimedia.org/repos/mediawiki/services/ipoid/-/merge_requests/53
Update Tunnels Type varbinary value to include 'UNKNOWN' as valid entry
tsepothoabala merged https://gitlab.wikimedia.org/repos/mediawiki/services/ipoid/-/merge_requests/53
Update Tunnels Type varbinary value to include 'UNKNOWN' as valid entry
@AGueyte When getting the reproduction data from https://phabricator.wikimedia.org/T339324. I am not getting the error of Data too long but now code: 'ER_TRUNCATED_WRONG_VALUE_FOR_FIELD'
@AGueyte No longer getting ER Data too long but getting once mentioned above. I created https://phabricator.wikimedia.org/T345201 and will close this task as we talked about. Thanks again for your work!