Skip to content

bug: BCP 47 numeric region subtags cause keyboard build to crash #244

@mcdurdin

Description

@mcdurdin
Running /var/www/html/.data/keyboards.sql
Array
(
    [0] => 42000
    [1] => 2628
    [2] => [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]String or binary data would be truncated in table 'keyboards.k0.t_keyboard_language', column 'region_id'. Truncated value: '03'.
    [3] => 01000
    [4] => 3621
    [5] => [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]The statement has been terminated.
)
Failure: PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]String or binary data would be truncated in table 'keyboards.k0.t_keyboard_language', column 'region_id'. Truncated value: '03'. in /var/www/html/tools/db/build/build.inc.php:153
Stack trace:
#0 /var/www/html/tools/db/build/build.inc.php(153): PDO->exec()
keymanapp/keyman#1 /var/www/html/tools/db/build/build.inc.php(68): BuildDatabaseClass->sqlrun()
keymanapp/keyman#2 /var/www/html/tools/db/build/build_cli.php(30): BuildDatabaseClass->BuildDatabase()
keymanapp/keyman#3 {main}

From https://downloads.keyman.com/keyboards/nguphing/1.0/nguphing.keyboard_info:

{
  "license": "mit",
  "description": "Nguphing for ng\u016B-ng\u00E8i (Goetian) pi\u0101u-ci\u00F9n-ng\u016B-ng\u00E8i.",
  "id": "nguphing",
  "languages": {
    "wuu-Latn-030": {
      "displayName": "Wu Chinese (Latin, Eastern Asia)",
      "languageName": "Wu Chinese",
      "scriptName": "Latin",
      "regionName": "Eastern Asia"
    }
  },
  "name": "nguphing",
  "authorName": "cathaylab",
  "authorEmail": "goetiansoc@proton.me",
  "lastModifiedDate": "2024-03-28T14:07:02Z",
  "sourcePath": "release/n/nguphing",
  "version": "1.0",
  "packageFilename": "nguphing.kmp",
  "jsFilename": "nguphing.js",
  "encodings": [
    "unicode"
  ],
  "jsFileSize": 32034,
  "packageFileSize": 34509,
  "packageIncludes": [
    "documentation",
    "welcome",
    "visualKeyboard"
  ],
  "minKeymanVersion": "10.0",
  "helpLink": "https://help.keyman.com/keyboard/nguphing",
  "platformSupport": {
    "windows": "full",
    "macos": "full",
    "linux": "full",
    "android": "full",
    "ios": "full",
    "desktopWeb": "full",
    "mobileWeb": "full"
  }
}

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions