Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
mboudet opened this issue Mar 28, 2022 · 1 comment

Comments

@mboudet
Copy link
Contributor

mboudet commented Mar 28, 2022

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
Copy link
Contributor Author

mboudet commented Mar 28, 2022

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)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant