Menu
Mildly Disturbed.
  • Arma3
  • Technology
  • random nonsense
  • NextDoor
  • About me
Mildly Disturbed.
zanata

Zanata-docker sql error.

Posted on September 26, 2019September 26, 2019 by jerryhopper

Zanata is a open source web-based translation platform for translators, content creators and developers.

If you are trying the docker-files from zanata you will eventually hit the following error when creating a translation project – or – open the glossary page.

ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-6) Unknown column ‘hglossaryt0_.glossaryEntryId’ in ‘field list’

Zanata error log

The Problem

The database seems to have missing column ‘glossaryEntryId’.

The Cause

This is caused by the database engine version used in the docker rundb.sh script.

The Solution

Update the mariadb version in the rundb.sh script to 10.3

    ## Create new container if zanatadb does not exist
    docker run --name zanatadb \
        -e MYSQL_USER=${ZANATA_MYSQL_USER} -e MYSQL_PASSWORD=${ZANATA_MYSQL_PASSWORD} \
        -e MYSQL_DATABASE=${ZANATA_MYSQL_DATABASE} -e MYSQL_RANDOM_ROOT_PASSWORD=yes \
        -v zanata-db:/var/lib/mysql:Z \
        -p 3306:3306 \
        --net ${ZANATA_DOCKER_NETWORK} \
        -d mariadb:10.3 \
        --character-set-server=utf8 --collation-server=utf8_general_ci

Make sure that your previous zanata volumes are removed, and run the rundb.sh / runapp.sh script again.

Happy translating!

  • docker
  • english
  • stuck@installation
  • Leave a Reply Cancel reply

    You must be logged in to post a comment.

    Categories

    • Casefiles (10)
      • Bamboe verkeersborden (1)
      • NextDoor (9)
    • debugging (5)
    • e-smoking (1)
    • gaming (5)
      • Arma3 (4)
        • Real vs Arma (4)
      • Ingress (1)
    • random nonsense (5)
    • Technology (17)
      • Privacy (10)
    • Uncategorized (7)

    Archives

    • October 2020 (1)
    • September 2020 (1)
    • August 2020 (1)
    • June 2020 (1)
    • May 2020 (1)
    • February 2020 (1)
    • January 2020 (1)
    • December 2019 (2)
    • October 2019 (3)
    • September 2019 (5)
    • August 2019 (3)
    • July 2019 (12)
    • April 2019 (1)

    Tags

    arm arm64 arma3 armhf biomassa c-130 c130 docker dutch elastic english fusionauth identitymanagement ingress kvm lol nederlands oauth2 photo privacy proxmox qemu realvsarma stuck@installation tools virtualisation
    ©2021 Mildly Disturbed. | Powered by WordPress & Superb Themes