-
Notifications
You must be signed in to change notification settings - Fork 65
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
Database table seems broken after consecutive upgrades #309
Comments
Well this happened for some people if the app was disabled between nextcloud 9 and 10 or an earlier step I think. but we can add a workaround to ensure the column is created |
That was quick! Is there any chance to this fix coming also as a possible update for the current 13 and 14 versions of nextcloud ? I haven't updated to 14 yet, but I plan to do so. I can also add manually the column is this fixes the issue, but with what properties ? Thanks for quick reaction again guys! |
I will backport it to 14, so it will come with the next release of 14 |
what about 13 ? although I know it will soon be in "end of life" |
The columns are: ALTER TABLE `oc_activity` ADD `object_type` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL;
ALTER TABLE `oc_activity` ADD `object_id` bigint(20) NOT NULL DEFAULT '0'; I'm not sure about 13, people had the app disabled for a long time already. So they can also just leave it disabled until the 14 update ;) |
Steps to reproduce
Expected behaviour
Functionnalities should not be broken
Actual behaviour
unable to run occ db:convert-filecache-bigint: it throws an exception:
[Doctrine\DBAL\Schema\SchemaException]
There is no column with name ‘object_id’ on table ‘oc_activity’.
-> there is indeed no such column in the database table
unable to remove events from calendar because of the same reason
calendar throws error code 500 because of that every once in a while
the table looks like this:
Server configuration
Operating system: debian 8
Web server: apache
Database: MySQL
PHP version: 5.6
Nextcloud version: 13
Where did you install Nextcloud from: upgrade from 12 on same server
Signing status:
List of activated apps:
Nextcloud configuration:
What should I do to fix the database ?
The text was updated successfully, but these errors were encountered: