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
Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT id
, carddata
FROM oc_cards
WHERE uid
IS NULL LIMIT 1000': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'uid' in 'where clause'
#13004
Comments
Hsa anybody some ideas, what went wrong and what to do for fixing the error? |
Made the update in a second cloud, this time a RaspberryPi and the update fucked up again. Same problems as before in my server: App-Store auf Aktualisierung für die App "workflowengine" geprüft Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT id, carddata FROM oc_cards WHERE uid IS NULL LIMIT 1000': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'uid' in 'where clause' Are there in the meanwhile solutions to safe the Nextcloud or can I start over again? |
Добрый день! Таже самая проблема, подскажите с решением |
You are missing this migration https://github.com/nextcloud/server/blob/dcddccb004cd776edd6bd8242f3c1267cbc39341/apps/dav/lib/Migration/Version1008Date20181030113700.php I'm not sure why but you could create the column and try the upgrade again. |
подскажите пожалуйста, как провести этот скрипт, просто еще не очень силен |
@danielkesselberg thanks for the feedback. I reinstalled the Nextcloud new, therefore I cannot test it anymore. |
вот что выдал при выполнении скрипта |
@s-rodger please try to write your questions in english. @nextcloud/server-triage any idea why the migration is missing on some instances? |
I'm trying to figure out what's going on, so far nothing comes to mind |
I just took a look at that php file and I did it manually. Assuming you're running mariadb/mysql and your nextcloud database is called "nextcloud", log into your nextcloud database and run: USE nextcloud; Afterwards, you should have a "uid" column. You can confirm by running: Afterwards, run the nextcloud upgrade again. The error should no longer appear. Btw, I have extremely little experience working with databases. |
Thank you so much, now it's working!
Please tell me, did you manage to configure Carddav and Caldav?
…Понедельник, 14 января 2019, 4:04 +03:00 от sleepee ***@***.***>:
>>@ s-роджер, пожалуйста, попробуйте написать свои вопросы на английском языке.
>>@ nextcloud / server-triage есть идеи, почему в некоторых случаях миграция отсутствует?
>I'm trying to figure out what's going on, so far nothing comes to mind
I just took a look at that php file and I did it manually.
Basically, I just added a "uid" column in the "oc_cards" table in the nextcloud database.
Assuming you're running mariadb/mysql and your nextcloud database is called "nextcloud", log into your nextcloud database and run:
USE nextcloud;
ALTER TABLE oc_cards ADD COLUMN uid VARCHAR(255);
Afterwards, you should have a "uid" column. You can confirm by running:
DESCRIBE oc_cards;
Afterwards, run the nextcloud upgrade again. The error should no longer appear.
At least this is what worked for me.
Btw, I have extremely little experience working with databases.
Just letting everybody know what worked for me in hopes that it helps others.
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub , or mute the thread .
--
Денис Коновалов
|
I can confirm this is an issue migrating from latest 14.x to latest 15.x version. However, the cause for this could very well be that we possibly extracted version 15 over existing version 14 files, rather than just copying the While these are all old versions, there are still people taking the long migration path from Owncloud 10.x ;) |
Fixed since 16 iirc |
Steps to reproduce
trying to update from version 14 to 15
Expected behaviour
Update should be perfomred automatically
Actual behaviour
it is stoppping the update process and throws an error
Server configuration
Operating system:
centos
Web server:
apache
Database:
mysql
PHP version:
7.2.13
Nextcloud version: (see Nextcloud admin page)
14.0.4.2
Updated from an older Nextcloud/ownCloud or fresh install:
update
Where did you install Nextcloud from:
downloaded the zip file from nextcloud.com and uploaded to the server
Signing status:
Signing status
List of activated apps:
App list
Nextcloud configuration:
Config report
Are you using external storage, if yes which one: local/smb/sftp/...
no
Are you using encryption: yes/no
no
Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...
no
Client configuration
Firefox
Operating system:
Windows
Logs
Web server error log
Web server error log
Nextcloud log (data/nextcloud.log)
Nextcloud log
Browser log
Browser log
The text was updated successfully, but these errors were encountered: