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

Upgrade to 19.0.10 from web tools fails. #26570

Closed
MootoolsSoftware opened this issue Apr 15, 2021 · 2 comments
Closed

Upgrade to 19.0.10 from web tools fails. #26570

MootoolsSoftware opened this issue Apr 15, 2021 · 2 comments
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap bug

Comments

@MootoolsSoftware
Copy link

Hello,

I was upgrading nextcloud using web upgrader from 19.0.2 to 19.0.10 and it fails.
Here is the error reported.

Étape de réparation : Repair MySQL collation
Informations de réparation : Change row format for oc_addressbooks ...
Informations de réparation : Change collation for oc_addressbooks ...
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'ALTER TABLE oc_addressbooks CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

I am now stuck with this bug and don't know what to do.

How can I go further and finish the upgrade.

Thanks
Manuel

@MootoolsSoftware MootoolsSoftware added 0. Needs triage Pending check for reproducibility or if it fits our roadmap bug labels Apr 15, 2021
@kesselb
Copy link
Contributor

kesselb commented Apr 15, 2021

Thank you for reporting this issue 👍 Please check #15058 for more details.

Usually there are two ways to fix this:

A) Configure your database server to support utf8mb4 (https://docs.nextcloud.com/server/latest/admin_manual/configuration_database/mysql_4byte_support.html).

B) If the database server does not support utf8mb4 disable it by setting 'mysql.utf8mb4' => false in your config.php (emojis in filename, calendar events, etc. are not possible than and you have to accept the warning).

@kesselb kesselb closed this as completed Apr 15, 2021
@MootoolsSoftware
Copy link
Author

I have no access to the conf file.

So I applied :
ALTER TABLE oc_addressbooks MODIFY COLUMN principaluri VARCHAR (191);
ALTER TABLE oc_addressbooks MODIFY COLUMN displayname VARCHAR (191);
ALTER TABLE oc_addressbooks MODIFY COLUMN uri VARCHAR (191);
ALTER TABLE oc_addressbooks MODIFY COLUMN description VARCHAR (191);

But now the error is

Informations de réparation : Change row format for oc_authtoken ...
Informations de réparation : Change collation for oc_authtoken ...

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'ALTER TABLE oc_authtoken CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap bug
Projects
None yet
Development

No branches or pull requests

2 participants