feat(db): remove workaround for pqsql 9.4 and older

The workaround was required because "ON CONFLICT DO NOTHING" was added with pqsql 9.5.

PostgreSQL 9.4 is eol since 2020-02-13 and thus everyone should use a version with upsert support nowadays.

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

Merge pull request #45623 from nextcloud/feat/workflow-auto-update-pr-feedback.yml

chore(CI): Updating pr-feedback.yml workflow from template

Merge pull request #45627 from nextcloud/chore/noid/spdx-batch11

Add SPDX header - batch 11

chore(assets): Recompile assets

Signed-off-by: nextcloud-command <nextcloud-command@users.noreply.github.com>

chore: Add SPDX header

Signed-off-by: Andy Scherzinger <info@andy-scherzinger.de>

chore(CI): Updating pr-feedback.yml workflow from template

Signed-off-by: Nextcloud bot <bot@nextcloud.com>

Merge pull request #45494 from nextcloud/fix/unsupported-redirect

Merge pull request #45612 from nextcloud/dependabot/github_actions/github-actions-cf104570f3

fix(core): unsupported browser `getRootUrl` import

Signed-off-by: John Molakvoæ <skjnldsv@users.noreply.github.com>

fix(core): unsupported browser redirect url

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

Merge pull request #45615 from nextcloud/dependabot/npm_and_yarn/cypress-split-1.23.4

chore(deps-dev): Bump cypress-split from 1.23.0 to 1.23.4

Bumps [cypress-split](https://github.com/bahmutov/cypress-split) from 1.23.0 to 1.23.4.
- [Release notes](https://github.com/bahmutov/cypress-split/releases)
- [Commits](https://github.com/bahmutov/cypress-split/compare/v1.23.0...v1.23.4)

---
updated-dependencies:
- dependency-name: cypress-split
  dependency-type: direct:development
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>

chore(deps): Bump cypress-io/github-action in the github-actions group

Bumps the github-actions group with 1 update: [cypress-io/github-action](https://github.com/cypress-io/github-action).

Updates `cypress-io/github-action` from 6.6.1 to 6.7.0
- [Release notes](https://github.com/cypress-io/github-action/releases)
- [Changelog](https://github.com/cypress-io/github-action/blob/master/CHANGELOG.md)
- [Commits](https://github.com/cypress-io/github-action/compare/1b70233146622b69e789ccdd4f9452adc638d25a...f88a151c986cab2e339cdbede6a5c4468bb62c17)

---
updated-dependencies:
- dependency-name: cypress-io/github-action
  dependency-type: direct:production
  update-type: version-update:semver-minor
  dependency-group: github-actions
...

Signed-off-by: dependabot[bot] <support@github.com>

Merge pull request #40147 from summersab/refactor/OC-Server-getNotificationManager

Merge pull request #40124 from summersab/refactor/OC-Server-getSecureRandom

Merge pull request #45609 from nextcloud/backport/45577/master

fix(theming): replace standard generic package icon by material design

Merge pull request #45585 from nextcloud/fix/files-filelist-table

refactor(files): Adjust some Typescript code in virtual files list

chore: Compile assets

Signed-off-by: Ferdinand Thiessen <opensource@fthiessen.de>

refactor(files): Make `currentView` a prop of `FilesListTableFooter`

We already have this as a required prop in `FilesListVirtual`,
so passing it to the footer is straight forward and removed need of computed
value.

Signed-off-by: Ferdinand Thiessen <opensource@fthiessen.de>

refactor(files): Properly add type information to FilesListTableFooter

- Add correct type for `nodes` prop.
- Use `defineComponent` to properly infer Typescript information
- Correct usage of nullish coalescing operator

Signed-off-by: Ferdinand Thiessen <opensource@fthiessen.de>

refactor(files): Fix Typescript issues in filesListWidth mixin

Use `defineComponent` to properly inherit typings.
Expect TS errors for the `$resizeOberserver` as we attach it directly on the component instance.
`filesListWidth` is now a number which defaults to 0,
making compares like `this.fileListWidth < 768` valid in Typescript.

Signed-off-by: Ferdinand Thiessen <opensource@fthiessen.de>

refactor(files): Correctly cast table ref to fix TypeScript errors

Signed-off-by: Ferdinand Thiessen <opensource@fthiessen.de>

fix(core): package-x-generic svg width and height

Signed-off-by: John Molakvoæ <skjnldsv@users.noreply.github.com>

Merge pull request #45538 from nextcloud/fix/update-nextcloud-files

fix: Update `@nextcloud/files` to fix public link shares

chore: Compile assets

Signed-off-by: Ferdinand Thiessen <opensource@fthiessen.de>

fix(deps): Update `@nextcloud/event-bus` to version 3.3.1

Signed-off-by: Ferdinand Thiessen <opensource@fthiessen.de>

fix: Update `@nextcloud/files` to 3.4.0 to fix public link shares

Signed-off-by: Ferdinand Thiessen <opensource@fthiessen.de>

Merge pull request #45594 from nextcloud/fix/files-active-entry

fix(files): Ensure active file list entry is highlighted

chore(assets): Recompile assets

Signed-off-by: nextcloud-command <nextcloud-command@users.noreply.github.com>

refactor(files): Consistently sort imports of FileEntryMixin

Signed-off-by: Ferdinand Thiessen <opensource@fthiessen.de>

fix(files): Ensure entry with `fileid` is marked as active

Signed-off-by: Ferdinand Thiessen <opensource@fthiessen.de>

Merge pull request #45592 from nextcloud/chore/noid/spdx-batch10

Add SPDX header - batch 10

chore(assets): Recompile assets

Signed-off-by: nextcloud-command <nextcloud-command@users.noreply.github.com>

chore: Add SPDX header

Signed-off-by: Andy Scherzinger <info@andy-scherzinger.de>

Merge pull request #40120 from summersab/refactor/OC-Server-getCsrfTokenManager

Merge pull request #45315 from nextcloud/fix/new-user-dialog

fix(settings): Move new user modal to dialog + minor refactoring

test(cypress): Fix tests

Signed-off-by: Christopher Ng <chrng8@gmail.com>

chore(assets): Recompile assets

Signed-off-by: nextcloud-command <nextcloud-command@users.noreply.github.com>

chore: Change more "user" strings to "account"

Signed-off-by: Christopher Ng <chrng8@gmail.com>

refactor: Shorten input focus calls

Signed-off-by: Christopher Ng <chrng8@gmail.com>

fix: Autofocus username input

Signed-off-by: Christopher Ng <chrng8@gmail.com>

refactor: Migrate to built-in NcSelect input label

Signed-off-by: Christopher Ng <chrng8@gmail.com>

chore: Change some "user" strings to "account"

Signed-off-by: Christopher Ng <chrng8@gmail.com>

fix(settings): Move user creation modal to dialog

Signed-off-by: Christopher Ng <chrng8@gmail.com>

Merge pull request #45413 from nextcloud/createIfNotExists

fix(files): Try to create dir only if it not exists

Merge pull request #45573 from nextcloud/chore/noid/spdx-batch9

Add SPDX header - batch 9

Merge branch 'master' into refactor/OC-Server-getSecureRandom

Signed-off-by: John Molakvoæ <skjnldsv@users.noreply.github.com>

Merge branch 'master' into refactor/OC-Server-getCsrfTokenManager

Signed-off-by: John Molakvoæ <skjnldsv@users.noreply.github.com>

Merge pull request #40141 from summersab/refactor/OC-Server-getL10NFactory

chore: php lint fix import

Signed-off-by: John Molakvoæ <skjnldsv@users.noreply.github.com>

chore: remove unnecessary php import during refactor

Signed-off-by: John Molakvoæ <skjnldsv@users.noreply.github.com>

Merge pull request #36942 from nextcloud/unmark-login-date

Merge pull request #45572 from nextcloud/fix/update-email-validator

Merge branch 'master' into refactor/OC-Server-getL10NFactory

Signed-off-by: John Molakvoæ <skjnldsv@users.noreply.github.com>

Merge branch 'master' into refactor/OC-Server-getCsrfTokenManager

Signed-off-by: John Molakvoæ <skjnldsv@users.noreply.github.com>

Merge pull request #40206 from summersab/refactor/apps/user_ldap/OC-Server-getAvatarManager

Merge pull request #40151 from summersab/refactor/OC-Server-getMailer

Merge pull request #40119 from summersab/refactor/OC-Server-getContactsManager

chore(assets): Recompile assets

Signed-off-by: nextcloud-command <nextcloud-command@users.noreply.github.com>

fix(deps): Update `egulias/email-validator` to version 4.0.2

Signed-off-by: Ferdinand Thiessen <opensource@fthiessen.de>

chore: run "composer run cs:fix" in user_ldap/templates

Not ideal output for part.wizard-server.php but this is legacy code anyway.

Signed-off-by: Côme Chilliet <come.chilliet@nextcloud.com>

chore: Add SPDX header

Signed-off-by: Andy Scherzinger <info@andy-scherzinger.de>

Merge pull request #40137 from summersab/refactor/OC-Server-getHTTPClientService

Refactor `OC\Server::getHTTPClientService`

Merge pull request #40207 from summersab/refactor/apps/dav/OC-Server-getAvatarManager

Refactor `OC\Server::getAvatarManager` in dav app

chore: adjust php comment usage hint

Co-authored-by: Côme Chilliet <91878298+come-nc@users.noreply.github.com>
Signed-off-by: John Molakvoæ <skjnldsv@users.noreply.github.com>

chore: refactor remove unused php imports

Co-authored-by: Côme Chilliet <91878298+come-nc@users.noreply.github.com>
Signed-off-by: John Molakvoæ <skjnldsv@users.noreply.github.com>

chore: fix missing semi-colon in refactor

Signed-off-by: John Molakvoæ <skjnldsv@users.noreply.github.com>

Merge branch 'master' into refactor/OC-Server-getNotificationManager

Signed-off-by: John Molakvoæ <skjnldsv@users.noreply.github.com>

Merge branch 'master' into refactor/OC-Server-getContactsManager

Signed-off-by: John Molakvoæ <skjnldsv@users.noreply.github.com>

Merge branch 'master' into refactor/OC-Server-getCsrfTokenManager

Signed-off-by: John Molakvoæ <skjnldsv@users.noreply.github.com>

Try create folder first and check if it exists after

Co-authored-by: Benjamin Gaussorgues <benjamin.gaussorgues@nextcloud.com>
Signed-off-by: Git'Fellow <12234510+solracsf@users.noreply.github.com>

chore: fix duplicate php import

Signed-off-by: John Molakvoæ <skjnldsv@users.noreply.github.com>

fix(files): Try to create dir only if it not exists

Signed-off-by: Git'Fellow <12234510+solracsf@users.noreply.github.com>

Merge branch 'master' into refactor/OC-Server-getSecureRandom

Signed-off-by: John Molakvoæ <skjnldsv@users.noreply.github.com>

Merge branch 'master' into refactor/OC-Server-getHTTPClientService

Signed-off-by: John Molakvoæ <skjnldsv@users.noreply.github.com>

Merge branch 'master' into refactor/OC-Server-getL10NFactory

Signed-off-by: John Molakvoæ <skjnldsv@users.noreply.github.com>

Merge branch 'master' into refactor/OC-Server-getMailer

Signed-off-by: John Molakvoæ <skjnldsv@users.noreply.github.com>

Refactor `OC\Server::getAvatarManager` in user_ldap app

Refactor `OC\Server::getAvatarManager` in user_ldap app (missed one)

Signed-off-by: Andrew Summers <18727110+summersab@users.noreply.github.com>

Refactor `OC\Server::getAvatarManager` in dav app

Signed-off-by: Andrew Summers <18727110+summersab@users.noreply.github.com>

Merge pull request #45512 from nextcloud/feat/ldap/additional-attributes

feat(ldap): sync additional properties to profile and SAB

feat(ldap): sync additional properties to profile and SAB

Synced from LDAP to profile:
- Date of birth

Synced from LDAP to SAB (via the profile):
- Biography
- Date of birth

Original code by Jake Nabasny (GitHub: @slapcat)

Co-authored-by: Jake Nabasny <jake@nabasny.com>
Co-authored-by: Richard Steinmetz <richard@steinmetz.cloud>
Signed-off-by: Richard Steinmetz <richard@steinmetz.cloud>

Merge pull request #44906 from nextcloud/feat/localized-ownership-transfer-target

feat(files): Use receiving users language for the ownership transfer target folder

Merge pull request #45480 from nextcloud/fix/archive-grey-color

fix(theming): replace standard generic package icon by material design

feat(files): Use receiving users language for the ownership transfer target folder

Signed-off-by: Ferdinand Thiessen <opensource@fthiessen.de>

Merge pull request #45508 from Agnibaan/issue-42611-security-txt-fix

fix:Ensure security.txt file ends with a newline character

Merge pull request #44272 from nextcloud/feature/40205/show-add-menu-in-emptycontent

Show upload menu in folders' emptycontent

Merge pull request #45428 from nextcloud/fix/update-archive-tar

chore(deps): Bump pear/archive_tar from 1.4.14 to 1.5.0

Merge pull request #45222 from nextcloud/bug/noid/caldav-search-limit-and-timerange

CalDAV fix search with limit and time range

Merge pull request #45247 from nextcloud/add-border-width

Add variable for inputs border width

chore(deps): Bump pear/archive_tar from 1.4.14 to 1.5.0

Signed-off-by: Ferdinand Thiessen <opensource@fthiessen.de>

fix(files): Keep 'back'-button for not found directories or if user can not upload

Signed-off-by: Ferdinand Thiessen <opensource@fthiessen.de>

feat(files): Show upload menu in folders' emptycontent

Signed-off-by: Marco <marcoambrosini@icloud.com>

Merge pull request #45562 from nextcloud/fix-maintain-share-client-behaviour

fix(ShareApiClients): Maintain meaning of `''` and null for share api cli…

Merge pull request #45559 from nextcloud/bug/noid/add-reason-lock-wait-timeout

add mapping for lock wait timeout

fix(ShareApiClients): Maintain meaning of `''` and null for share api clients

Signed-off-by: fenn-cs <fenn25.fn@gmail.com>

Merge pull request #45411 from nextcloud/fix/auth/selective-token-activity-update

fix(auth): Update authtoken activity selectively

feat(db): add mapping for lock wait timeout

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

Merge pull request #45295 from nextcloud/add-temporary-border-radius-variable

Add temporary variable for border radius

Merge pull request #45554 from nextcloud/chore/noid/spdx-batch8

Add SPDX header - batch 8

Feat: Update apps/theming/css/default.css

Co-authored-by: Grigorii K. Shartsev <me@shgk.me>
Signed-off-by: Marco <marcoambrosini@proton.me>