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

occ upgrade complains about missing field name on sequences with postgres 10 #6559

Closed
subzero01 opened this issue Sep 18, 2017 · 1 comment
Closed

Comments

@subzero01
Copy link

Steps to reproduce

  1. install postgresql 10 beta 4
  2. update nextcloud to version 12.0.2
  3. occ upgrade

Expected behaviour

upgrade should not complain about missing fields.

select should be rewritten as "select ... from pg_sequences where sequencename = ''

Actual behaviour

upgrade tries to read min_value and increment by of sequences by using a select ... from seqencename

Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT min_value, increment_by FROM "oc_addressbookchanges_id_seq"':

SQLSTATE[42703]: Undefined column: 7 FEHLER: Spalte »min_value« existiert nicht
LINE 1: SELECT min_value, increment_by FROM "oc_addressbookchanges_i...

Server configuration

Operating system: gentoo linux

Web server: apache 2.4

Database: postgresql 10

PHP version: 5.6

Nextcloud version: 12.0.2

Updated from an older Nextcloud/ownCloud or fresh install: 10.0.1

Where did you install Nextcloud from: gentoo portage tree

@blizzz
Copy link
Member

blizzz commented Sep 18, 2017

Duplicate of #5930

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

2 participants