Upgrade to 15.0.0 alpha failed with Undefined column: 7 ERROR: column "uid" does not exist

[1div0]

Steps to reproduce

1. git pull
2. occ upgrade
   Checking for update of app workflowengine in appstore
   Checked for update of app "workflowengine" in appstore
   Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT "id", "carddata" FROM "oc_cards" WHERE "uid" IS NULL LIMIT 1000':

SQLSTATE[42703]: Undefined column: 7 ERROR: column "uid" does not exist
LINE 1: SELECT "id", "carddata" FROM "oc_cards" WHERE "uid" IS NULL ...
^
HINT: Perhaps you meant to reference the column "oc_cards.id".
Update failed

Operating system:
F28

Web server:
httpd-2.4.34-10.fc28.x86_64

Database:
postgresql-10.5-3.fc28.x86_64

PHP version:
php-7.2.11-1.fc28.x86_64

Nextcloud version: (see Nextcloud admin page)

Updated from an older Nextcloud/ownCloud or fresh install:

Where did you install Nextcloud from:
Git

Signing status:

Signing status

Login as admin user into your Nextcloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results here.

List of activated apps:

App list

If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your Nextcloud installation folder

Nextcloud configuration:

Config report

If you have access to your command line run e.g.:
sudo -u www-data php occ config:list system
from within your Nextcloud installation folder
{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "cloud.reflexion.tv"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "pgsql",
        "version": "15.0.0.1",
        "overwrite.cli.url": "https:\/\/cloud.reflexion.tv\/nextcloud",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "mail_smtpmode": "sendmail",
        "theme": "",
        "loglevel": 2,
        "maintenance": true
    }
}

or 

Insert your config.php content here. 
Make sure to remove all sensitive content such as passwords. (e.g. database password, passwordsalt, secret, smtp password, …)

Are you using external storage, if yes which one: local/smb/sftp/...

Are you using encryption: yes/no

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...

LDAP configuration (delete this part if not used)

LDAP config

With access to your command line run e.g.:
sudo -u www-data php occ ldap:show-config
from within your Nextcloud installation folder

Without access to your command line download the data/owncloud.db to your local
computer or access your SQL server remotely and run the select query:
SELECT * FROM `oc_appconfig` WHERE `appid` = 'user_ldap';


Eventually replace sensitive data as the name/IP-address of your LDAP server or groups.

Client configuration

Browser:

Operating system:

Logs

Web server error log

Web server error log

Insert your webserver log here

Nextcloud log (data/nextcloud.log)

Nextcloud log

Insert your Nextcloud log here

Browser log

Browser log

Insert your browser log here, this could for example include:

a) The javascript console log
b) The network log
c) ...

[nextcloud-bot]

GitMate.io thinks possibly related issues are #9795 (Upgrade error), #7552 (Upgrade to 12.0.4 failed ), #3242 (Upgrade from 10.0.3 to 11.0.1 fails with database error), #9170 (redirect), and #8241 (image).

[trendzetter]

exactly same here! First upgrade on a very recent master 410bd9d..b978399.

[trendzetter]

Maybe something is wrong with the versioncheck in shouldRun() ?
lib/private/Repair/NC15/SetVcardDatabaseUID.php

[skjnldsv]

As the version of the software you've reported this for has reached end of life, I will close this ticket. If this is still happening after an upgrade to the latest version, feel free to reopen