Skip to content
This repository has been archived by the owner on Aug 10, 2023. It is now read-only.

avatarUrl migration error #431

Closed
And0r- opened this issue Sep 8, 2021 · 0 comments
Closed

avatarUrl migration error #431

And0r- opened this issue Sep 8, 2021 · 0 comments

Comments

@And0r-
Copy link

And0r- commented Sep 8, 2021

Dimensions docker will not start in the newest version because of a migration error.

I think the problem is not quoting "avatarUrl" so postgress will use it as "avatarurl" and will not find the column

matrix_dimension=# UPDATE dimension_widgets SET avatarUrl = REPLACE(avatarUrl, '/img/', '/assets/img/');
ERROR:  column "avatarurl" does not exist
LINE 1: UPDATE dimension_widgets SET avatarUrl = REPLACE(avatarUrl, ...
                                                         ^
HINT:  Perhaps you meant to reference the column "dimension_widgets.avatarUrl".
matrix_dimension=# 
matrix_dimension=# 
matrix_dimension=# 
matrix_dimension=# UPDATE dimension_widgets SET "avatarUrl" = REPLACE("avatarUrl", '/img/', '/assets/img/');
UPDATE 12

I use
PostgreSQL 13.4 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20210424) 10.3.1 20210424, 64-bit
with matrix-docker-ansible-deploy

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

No branches or pull requests

1 participant