Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Fixing manually in database or finding file attachments with unknown extensionunsupported file type:

  1. Execute next script to find which file attachment has unknown file extension:

    Code Block
    languagesql
    SELECT 
        a.oid,
        a.filepath,
        a.display_name,
        a.concept_oid,
        a.term_oid,
        d.name AS dictionary
    FROM
        tw_attachment a,
        tw_dictionaries d
    WHERE
        a.type = 0 AND a.dictionary_oid = d.oid;
  2. If you want to fix that files manually, you can open each concept or term where file attached by using next URLs:
    1) For TermWeb 3 installation:
    https://example.termweb.eu/termweb/view/${concept_oid} or https://example.termweb.eu/termweb/view/${concept_oid}/${term_oid}
    2) For TermWeb 4 installation:
    https://example.termweb.eu/view/${concept_oid} or https://example.termweb.eu/view/${concept_oid}/${term_oid}

  3. If you see in column “filepath” that file is in supported file types you can update it’s type by specifying right DB value.
    See below of this article list of supported file types.

  4. Most of changes should be applied automatically, in case of cached value, try to restart TermWeb.

...