Don't throw on SHOW VERSION query

Signed-off-by: Joas Schilling <coding@schilljs.com>

Merge pull request #24106 from nextcloud/backport/24085/stable20

[stable20] Register new command db:add-missing-primary-keys

[tx-robot] updated from transifex

[tx-robot] updated from transifex

[tx-robot] updated from transifex

Register new command db:add-missing-primary-keys

Introduced with: https://github.com/nextcloud/server/commit/d5df033ede1f2b19b87c365b1f808130023edf17

Signed-off-by: MichaIng <micha@dietpi.com>

Merge pull request #24081 from nextcloud/backport/24066/stable20

[stable20] Fix default internal expiration date enforce

Fix default internal expiration date enforce

Signed-off-by: John Molakvoæ (skjnldsv) <skjnldsv@protonmail.com>
Signed-off-by: npmbuildbot-nextcloud[bot] <npmbuildbot-nextcloud[bot]@users.noreply.github.com>

[tx-robot] updated from transifex

Merge pull request #23989 from nextcloud/version/20.0.2/rc1

20.0.2 RC1

20.0.2 RC1

Signed-off-by: Roeland Jago Douma <roeland@famdouma.nl>

Merge pull request #24049 from nextcloud/backport/23882/stable20

[stable20] Run unit tests against oracle

Update psalm-baseline

Signed-off-by: Morris Jobke <hey@morrisjobke.de>

fix migration of oc_credentials table

Signed-off-by: Robin Appelman <robin@icewind.nl>

Update baseline, I'm sorry

Signed-off-by: Joas Schilling <coding@schilljs.com>

Fix unique key in test table

Signed-off-by: Joas Schilling <coding@schilljs.com>

Fix naming of jobs and steps

Signed-off-by: Joas Schilling <coding@schilljs.com>

Fix CS

Signed-off-by: Joas Schilling <coding@schilljs.com>

Create primary keys on all tables and add a command to create the afterwards

Signed-off-by: Joas Schilling <coding@schilljs.com>

Replace the credentials table with one that can have empty user

Primary key columns on Oracle can not have empty strings

Signed-off-by: Joas Schilling <coding@schilljs.com>

Don't try to update on NotNullConstraintViolationException, only on unique or foreign key

Signed-off-by: Joas Schilling <coding@schilljs.com>

Fix comparing the empty string for global credentials

Signed-off-by: Joas Schilling <coding@schilljs.com>

Empty string is returned as null, but empty string in file cache is the root and exists

Signed-off-by: Joas Schilling <coding@schilljs.com>

Fix public calendars as they are stored with null on oracle

Signed-off-by: Joas Schilling <coding@schilljs.com>

Make sure columns with an empty default are nullable for Oracle

Signed-off-by: Joas Schilling <coding@schilljs.com>

Fix "Invalid fetch style: 12" on Oracle

Signed-off-by: Joas Schilling <coding@schilljs.com>

Make the test pass on repeating calls

Signed-off-by: Joas Schilling <coding@schilljs.com>

Skip the insertIfNotExists() tests on Oracle because it doesn't work with clob

Signed-off-by: Joas Schilling <coding@schilljs.com>

Easier debugging and spell fix

Signed-off-by: Joas Schilling <coding@schilljs.com>

Use a different column for the primary key as we can not insert it on oracle

Signed-off-by: Joas Schilling <coding@schilljs.com>

Add github action for oci8

Signed-off-by: Julius Härtl <jus@bitgrid.net>

[tx-robot] updated from transifex

Merge pull request #24058 from nextcloud/backport/24054/stable20

[stable20] Manually iterate over calendardata when oracle is used

Merge pull request #24050 from nextcloud/backport/23915/stable20

[stable20] Use png icons in caldav reminder emails

Manually iterate over calendardata when oracle is used

Signed-off-by: Julius Härtl <jus@bitgrid.net>

Merge pull request #24044 from nextcloud/backport/24042/stable20

[stable20] Fix sharing tab state not matching resharing admin settings

Use png icons in caldav reminder emails

Signed-off-by: Richard Steinmetz <richard@steinmetz.cloud>

Add integration tests for default share permissions

Signed-off-by: Daniel Calviño Sánchez <danxuliu@gmail.com>

Add acceptance tests for reshares by link when resharing is disabled

Signed-off-by: Daniel Calviño Sánchez <danxuliu@gmail.com>

Add acceptance tests for reshares when resharing is disabled

Signed-off-by: Daniel Calviño Sánchez <danxuliu@gmail.com>

Disable share input for a received share if resharing is not allowed

Signed-off-by: Daniel Calviño Sánchez <danxuliu@gmail.com>

Do not show "Can reshare" in the menu if resharing is not allowed

Signed-off-by: Daniel Calviño Sánchez <danxuliu@gmail.com>

Merge pull request #24033 from nextcloud/backport/23993/stable20

[stable20] Don't leave cursors open

[tx-robot] updated from transifex

Don't leave cursors open when tests fail

Signed-off-by: Joas Schilling <coding@schilljs.com>

Merge pull request #23950 from nextcloud/backport/23928/stable20

[stable20] Fix repair mimetype step to not leave stray cursors

Update psalm-baseline.xml to accept new errors

Signed-off-by: Morris Jobke <hey@morrisjobke.de>

Fix repair mimetype step to not leave stray cursors

Signed-off-by: Joas Schilling <coding@schilljs.com>

Merge pull request #23998 from nextcloud/backport/23937/stable20

[stable20] Use query builder instead of OC_DB in OC\Files\*

Merge pull request #23995 from nextcloud/backport/23741/stable20

[stable20] Unlock when promoting to exclusive lock fails

Merge pull request #23955 from nextcloud/backport/23938/stable20

[stable20] Replace some usages of OC_DB in OC\Share\* with query builder

Merge pull request #24012 from nextcloud/backport/23981/stable20

[stable20] Fix js search in undefined ocs response

[tx-robot] updated from transifex

Fix js search in undefined ocs response

Signed-off-by: John Molakvoæ (skjnldsv) <skjnldsv@protonmail.com>
Signed-off-by: npmbuildbot-nextcloud[bot] <npmbuildbot-nextcloud[bot]@users.noreply.github.com>

Merge pull request #24001 from nextcloud/backport/23889/stable20

[stable20] Shortcut to avoid file system setup when generating the logo URL

Merge pull request #24004 from nextcloud/backport/23999/stable20

[stable20] Remove old legacy scripts references

Removed config.js

Remove old legacy search script

Merge pull request #23996 from nextcloud/backport/23982/stable20

[stable20] Make sure root storage is valid before checking its size

Shortcut to avoid file system setup when generating the logo URL

If an SVG is requested and the app config value for logoMime is set then the logo is there. Otherwise we need to check it and maybe also generate a PNG from the SVG (that's done in getImage() which needs to be called then).

Signed-off-by: Morris Jobke <hey@morrisjobke.de>

Merge pull request #23992 from nextcloud/backport/23574/stable20

[stable20] Fix link share label placeholder not showing

Use query builder instead of OC_DB in OC\Files\*

Signed-off-by: Joas Schilling <coding@schilljs.com>

Make sure root storage is valid before checking its size

Signed-off-by: John Molakvoæ (skjnldsv) <skjnldsv@protonmail.com>

Unlock when promoting to exclusive lock fails

In certain cases changeLock to EXCLUSIVE fails
and throws LockedException. This leaves the
file locked as SHARED in file_put_contents,
which prevents retrying (because on second
call file_put_contents takes another SHARED
lock on the same file, and changeLock doesn't
allow more than a single SHARED lock to promote
to EXCLUSIVE).

To avoid this case, we catch the LockedException
and unlock before re-throwing.

Signed-off-by: Ashod Nakashian <ashod.nakashian@collabora.co.uk>

Merge pull request #23971 from nextcloud/backport/23936/stable20

[stable20] Use query builder instead of OC_DB in trashbin

Check in failing psalm checks

Signed-off-by: Morris Jobke <hey@morrisjobke.de>

Merge pull request #23975 from nextcloud/backport/23923/stable20

[stable20] Fix greatest/least order for oracle

Add explicit typecast for $value.

Signed-off-by: Daniel Kesselberg <mail@danielkesselberg.de>

Fix link share label placeholder not showing

Signed-off-by: Gary Kim <gary@garykim.dev>
Signed-off-by: npmbuildbot-nextcloud[bot] <npmbuildbot-nextcloud[bot]@users.noreply.github.com>

[tx-robot] updated from transifex

[tx-robot] updated from transifex

Update parameters

Signed-off-by: Joas Schilling <coding@schilljs.com>

Make sure Oracle always casts everything in the best way

Signed-off-by: Joas Schilling <coding@schilljs.com>

Use Query builder function

Signed-off-by: Joas Schilling <coding@schilljs.com>

Fix order of GREATEST for Oracle

As per https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions060.htm
Oracle uses the first value to cast the rest or the values.
So when the first value is a plain int, instead of doing the math,
it will cast the expression to int and continue with a potential 0.

Signed-off-by: Joas Schilling <coding@schilljs.com>

Merge pull request #23951 from nextcloud/backport/23922/stable20

[stable20] Improve query type detection

Use query builder instead of OC_DB in trashbin

Signed-off-by: Joas Schilling <coding@schilljs.com>

Merge pull request #23954 from nextcloud/backport/23943/stable20

[stable20] Fix iLike() falsely turning escaped % and _ into wildcards

Merge pull request #23948 from nextcloud/backport/23940/stable20

[stable20] Skip already loaded apps in loadApps

[tx-robot] updated from transifex

Replace some usages of OC_DB in OC\Share\* with query builder

Signed-off-by: Joas Schilling <coding@schilljs.com>

Fix iLike() falsely turning escaped % and _ into wildcards

Signed-off-by: Joas Schilling <coding@schilljs.com>

Merge pull request #23935 from nextcloud/backport/23921/stable20

[stable20] Fix casting of integer and boolean on Oracle

Improve query type detection

Signed-off-by: Joas Schilling <coding@schilljs.com>

Merge pull request #23924 from nextcloud/backport/23920/stable20

[stable20] Bearer must be in the start of the auth header

Skip already loaded apps in loadApps

Otherwise you might end up calling a lot of functions unneeded.
And while the individual calls are cheap if you multiply them by 20k
they still get somewhat expensive.

Signed-off-by: Roeland Jago Douma <roeland@famdouma.nl>

Cast bool things to numbers as that is how they are stored in the database

Signed-off-by: Joas Schilling <coding@schilljs.com>

Fix casting to integer on Oracle

Signed-off-by: Joas Schilling <coding@schilljs.com>

Merge pull request #23917 from nextcloud/backport/23887/stable20

[stable20] Do not emit UserCreatedEvent twice

Bearer must be in the start of the auth header

Signed-off-by: Roeland Jago Douma <roeland@famdouma.nl>

[tx-robot] updated from transifex

fix: also remove use statement of UserCreatedEvent

Signed-off-by: Tobias Assmann <tobias.assmann@ecsec.de>

fix: no more translation from postCreateUser hook to UserCreatedEvent anymore, as event is already emitted in user manager

Signed-off-by: Tobias Assmann <tobias.assmann@ecsec.de>

Merge pull request #23902 from nextcloud/backport/23798/stable20

[stable20] Add default font size

Add default font size

Signed-off-by: GretaD <gretadoci@gmail.com>
Signed-off-by: npmbuildbot-nextcloud[bot] <npmbuildbot-nextcloud[bot]@users.noreply.github.com>

[tx-robot] updated from transifex

Merge pull request #23894 from nextcloud/backport/23799/stable20-minimal

[stable20] fix potentially passing null to events where IUser is expected

Merge pull request #23899 from nextcloud/backport/23898/stable20

[stable20] Make user status styles scoped

Merge pull request #23900 from nextcloud/backport/23897/stable20

[stable20] Move help to separate stylesheet

Make user status styles scoped

Signed-off-by: Julius Härtl <jus@bitgrid.net>
Signed-off-by: npmbuildbot-nextcloud[bot] <npmbuildbot-nextcloud[bot]@users.noreply.github.com>