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

Upgrade to 10.0.1 fails on Remove shares of a users root folder #1569

Closed
compuguy opened this Issue Sep 29, 2016 · 6 comments

Comments

Projects
None yet
4 participants
@compuguy

compuguy commented Sep 29, 2016

This is a similar error to owncloud/core#25621

Steps to reproduce

Steps to reproduce

  1. ran dist upgrade on server
  2. ran php occ upgrade as www-data in a screen session
  3. fails on Remove shares of a users root folder with this error:

7/283 percentage bar InvalidArgumentException: Invalid recipient
Update failed
Maintenance mode is kept active
Reset log level

Expected behaviour

Upgrade succeeds

Actual behaviour

Errors out with InvalidArgumentException (see step 3 for exact error).

Server configuration

Operating System: Ubuntu 14.04.5
Web server: apache 2.4.7 (Ubuntu)
Database: Mysql 5.5.52
nextcloud version: 10.0.1
Attempted update/upgrade from 9.0.53
Originally upgraded from owncloud 9.0.3 ---> nextcloud 9.0.53
Installed using zip from nextcloud site

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

The content of config/config.php:

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

or 

Insert your config.php content here
(Without the database password, passwordsalt and secret)

Are you using external storage, if yes which one: local/smb/sftp/...
Yes, local (openstack attached disks)

Are you using encryption: yes/no
No

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...
LDAP - will need to sanitize that

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) ...
@nickvergessen

This comment has been minimized.

Show comment
Hide comment
@nickvergessen
Member

nickvergessen commented Sep 29, 2016

@compuguy

This comment has been minimized.

Show comment
Hide comment
@compuguy

compuguy Dec 1, 2016

@nickvergessen I'm no longer working for the company for which the nextcloud/owncloud instance had a issue with. You can try to contact @JamesonFinney about this issue for more information.

compuguy commented Dec 1, 2016

@nickvergessen I'm no longer working for the company for which the nextcloud/owncloud instance had a issue with. You can try to contact @JamesonFinney about this issue for more information.

@mr-bolle

This comment has been minimized.

Show comment
Hide comment
@mr-bolle

mr-bolle Dec 17, 2016

Hi,

today i upgrade from 10.0.1 to 10.0.2 with the Nextcloud Updater. After the successful update, inow recognize that all shared Files / Folder to some Nextcloud User / Groups disappear.

I have a look into the sql database from Nextcloud an into the table oc_share all entrys still exist.
How i can recover, or refresh this shared files / folders with the current stable Server installation.

The publish Shared Folder / Files still exist.

MySQL-MariaDB v10.0.28

update 17.12. 15:00
Since I have created a backup of the nextcloud database tables. I was able to restore the oc_share table, so the shared folders with users / groups were available again. I used the app OwnBackup for it.

update 20.01.2017
After the Update to 10.0.3 i see the same issue. And i can only fix it after restore oc_share table.

update 20.02.2017
After the Update to 11.0.1 only the above solution helps to restore the oc_share table.

thanks Raiko

mr-bolle commented Dec 17, 2016

Hi,

today i upgrade from 10.0.1 to 10.0.2 with the Nextcloud Updater. After the successful update, inow recognize that all shared Files / Folder to some Nextcloud User / Groups disappear.

I have a look into the sql database from Nextcloud an into the table oc_share all entrys still exist.
How i can recover, or refresh this shared files / folders with the current stable Server installation.

The publish Shared Folder / Files still exist.

MySQL-MariaDB v10.0.28

update 17.12. 15:00
Since I have created a backup of the nextcloud database tables. I was able to restore the oc_share table, so the shared folders with users / groups were available again. I used the app OwnBackup for it.

update 20.01.2017
After the Update to 10.0.3 i see the same issue. And i can only fix it after restore oc_share table.

update 20.02.2017
After the Update to 11.0.1 only the above solution helps to restore the oc_share table.

thanks Raiko

@mr-bolle

This comment has been minimized.

Show comment
Hide comment
@mr-bolle

mr-bolle Jun 9, 2017

Hi,

unfortunately after the update to Nextcloud 12, i had to find again that all shared order / files with groups / users had disappeared again. Since I restored the backup (with OwnBackup) of the oc_share from the Nextcloud 11 installation, I had to find errors when sharing links with an expiration date or with a password.

An exception occurred while executing 'UPDATE oc_share SET password = ?, uid_owner = ?, uid_initiator = ?, permissions = ?, item_source = ?, file_source = ?, token = ?, expiration = ? WHERE id = ?' with params [null, "Raiko", "Raiko", 1, 73774, 73774, "dt5b2raoH02oGZj", null, "25"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'password' in 'field list'

share link with expiration date

Solution: After I restored the oc_share backup, i add a new field in the table.
Field name: password
DataType: varchar
Type with: 255

nextcloud_oc_share additional db field

mr-bolle commented Jun 9, 2017

Hi,

unfortunately after the update to Nextcloud 12, i had to find again that all shared order / files with groups / users had disappeared again. Since I restored the backup (with OwnBackup) of the oc_share from the Nextcloud 11 installation, I had to find errors when sharing links with an expiration date or with a password.

An exception occurred while executing 'UPDATE oc_share SET password = ?, uid_owner = ?, uid_initiator = ?, permissions = ?, item_source = ?, file_source = ?, token = ?, expiration = ? WHERE id = ?' with params [null, "Raiko", "Raiko", 1, 73774, 73774, "dt5b2raoH02oGZj", null, "25"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'password' in 'field list'

share link with expiration date

Solution: After I restored the oc_share backup, i add a new field in the table.
Field name: password
DataType: varchar
Type with: 255

nextcloud_oc_share additional db field

@nickvergessen

This comment has been minimized.

Show comment
Hide comment
@nickvergessen

nickvergessen Jun 12, 2017

Member

Well of course if you restore a backup from before an update, the structure and data needs to be updated again.

Member

nickvergessen commented Jun 12, 2017

Well of course if you restore a backup from before an update, the structure and data needs to be updated again.

@mr-bolle

This comment has been minimized.

Show comment
Hide comment
@mr-bolle

mr-bolle Jun 12, 2017

Hi @nickvergessen, the post should only be as info for other users. Is it possible after the update to have the shared folders / files with users / groups available. Or am I the only one who has this error?

Update History

mr-bolle commented Jun 12, 2017

Hi @nickvergessen, the post should only be as info for other users. Is it possible after the update to have the shared folders / files with users / groups available. Or am I the only one who has this error?

Update History

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment