galaxy-genome-annotation / docker-tripal

Docker container for Tripal
10 stars 11 forks source link

Crash after update to drupal 7.89 on tripal V2 (column base.changed does not exist) #46

Open mboudet opened 2 years ago

mboudet commented 2 years ago

It seems that the column 'users.changed' does not exists, so the linked chado DB does not start.

(https://www.drupal.org/project/drupal/issues/1835754#comment-14327942)

ERROR:  column base.changed does not exist at character 200
brassica_oleracea_hdem_tripal-db.1.vnazxps9gs8n@dogogepp6    | STATEMENT:  SELECT base.uid AS uid, base.name AS name, base.pass AS pass, base.mail AS mail, base.theme AS theme, base.signature AS signature, base.signature_format AS signature_format, base.created AS created, base.changed AS changed, base.access AS access, base.login AS login, base.status AS status, base.timezone AS timezone, base.language AS language, base.picture AS picture, base.init AS init, base.data AS data
brassica_oleracea_hdem_tripal-db.1.vnazxps9gs8n@dogogepp6    |  FROM
brassica_oleracea_hdem_tripal-db.1.vnazxps9gs8n@dogogepp6    |  users base
brassica_oleracea_hdem_tripal-db.1.vnazxps9gs8n@dogogepp6    |  WHERE  (base.uid IN  ('0'))

I fixed it by manually creating it

ALTER TABLE users ADD COLUMN changed int NOT NULL DEFAULT '0'

It might be fixed by running drush updb, but since the container crashes at launch due to the lack of DB, it's not practical.

mboudet commented 2 years ago

Managed to fix it by adding a drush updb command in the entrypoint, before the DRUSH_OK=`export ENABLE_MEMCACHE=0 && drush pm-list > /dev/null 2>&1; echo "$?" command.

(The drush pm-list breaks because the DB is not updated)