Activity App can't be updated after upgrade to OC10 - no column with name 'object_id' on table 'oc_activity'

Server
1

Hi everyone,

After having performed an upgrade of owncloud server to the latest 10 (8.0.? -> 8.0.16 -> 8.1.12 -> 8.2.11 -> 9.0.11 -> 9.1.8 -> 10.0.10), everything seems to be ok, but the Activity App can’t be installed or upgraded.

I have an error which says:
Doctrine\DBAL\Schema\SchemaException: There is no column with name 'object_id' on table 'oc_activity'.
And after, when I try to activate the App, the same message is displayed and another message says that the App needs to be updated. And the OC is kept in mantenance mode unless I force it to desactivate the Activity App and force it to quit the maintenance mode.

I had a look into the database and there is indeed no column object_id in the oc_activity table.

Has anyone a solution for that?

Thanks in advance for your help.

PB

2

There is an issue about this problem in GitHub. https://github.com/owncloud/activity/issues/652 . The severity of the problem was labeled as High. I believe, it will be fixed soon. If you have any feedback please join the issue discussions in Github. Thanks.

1 Like
3

Thanks a lot for your prompt reply.
I will ask on the Github issue if there is a quick fix available before the issue is solved.
Thanks again.

4

You are welcome :slight_smile:

5

Hi @karakayasemi ,
have you seem some fix about this problem Doctrine\DBAL\Schema\SchemaException: There is no colu mn with name ‘object_id’ on table ‘oc_activity’?
ust I change some value into Db like this?
set type to “longtext” for “subjectparams” and “messageparams” by increasing length
add index “activity_time” on column “timestamp”
add index “activity_object” on columns “object_type” and “object_id”
There are any automatic fix?
Thanks,