Uploaded image for project: 'H5P'
  1. HFP-778

WP: tmpfiles table invalid in some dbs

    Details

    • Type: Task
    • Status: Backlog (View workflow)
    • Priority: High
    • Resolution: Unresolved
    • Affects versions: None
    • Fix versions: None
    • Labels:
    • Sprint:
    • Acceptance Criteria:
      - Database definition for tmpfiles must be valid for all wordpress supported databases.

      Description

      The tmpfiles table that was introduced recently is invalid in Mariadb 10.1.14 (and perhaps in other setups as well).
      The "path" field is used as a primary key, but it is too large, resulting in a db error:
      WordPress database error: [Index column size too large. The maximum column size is 767 bytes.]
      CREATE TABLE wp_h5p_tmpfiles ( path VARCHAR(255) NOT NULL, created_at INT UNSIGNED NOT NULL, PRIMARY KEY (path), KEY created_at (created_at) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

      See https://github.com/h5p/h5p-wordpress-plugin/commit/f1da08a1816cdf8428647b8dc174bd27789ee94e for comments

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              thomasmars Thomas Marstrander
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: