diff options
| author | Joas Schilling <coding@schilljs.com> | 2022-04-22 23:53:53 +0300 |
|---|---|---|
| committer | Joas Schilling <coding@schilljs.com> | 2022-04-22 23:53:53 +0300 |
| commit | 977e98fa511f61763892ae9dfc3eaacf621b4f18 (patch) | |
| tree | 7e7be5183ae69f0538bc101fc5db45ac12e290b1 /lib | |
| parent | 8a89daa6847fc553b0b1b1de94cc40bc3f3a0880 (diff) | |
Fix upgrade with Postgres and Oracle
Exception: Database error when running migration 14000Date20220330141647 for app spreed
An exception occurred while executing a query: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: character varying = bigint
LINE 1: ...LEFT JOIN "oc_filecache" "f" ON "s"."item_source" = "f"."fil...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
Signed-off-by: Joas Schilling <coding@schilljs.com>
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/Migration/Version14000Date20220330141647.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/Migration/Version14000Date20220330141647.php b/lib/Migration/Version14000Date20220330141647.php index 2ac604f44..61681dffd 100644 --- a/lib/Migration/Version14000Date20220330141647.php +++ b/lib/Migration/Version14000Date20220330141647.php @@ -220,7 +220,7 @@ class Version14000Date20220330141647 extends SimpleMigrationStep { $query = $this->connection->getQueryBuilder(); $query->select('s.id', 'm.mimetype') ->from('share', 's') - ->leftJoin('s', 'filecache', 'f', $query->expr()->eq('s.item_source', 'f.fileid')) + ->leftJoin('s', 'filecache', 'f', $query->expr()->eq('s.file_source', 'f.fileid')) ->leftJoin('f', 'mimetypes', 'm', $query->expr()->eq('f.mimetype', 'm.id')) ->where($query->expr()->in('s.id', $query->createNamedParameter($shareIds, IQueryBuilder::PARAM_INT_ARRAY))); $result = $query->executeQuery(); |