Closed keithzg closed 8 years ago
From which new s version did you upgrade? You need 8.8.0 or higher because database issues
If this is not possible for you anymore you need to drop the last_modified columns
The reason this happens is that the previous last_modified column contained a string with a http last modified date. That has been moved to the column http_last_modified in 8.6.0 or so. In 9.0.0 the last_modified column was added again as bigint. If you don't follow the instructions in the changelog and skip these released owncloud tries to cast the existing strings in that column to bigints which fails.
Because you can't do database migrations yet there was no other way. Hope that explanation helps ;)
Ah, so merely dropping the last_modified columns from ocnews* will be sufficient? Apologies, I didn't see any notes in the README and so assumed there wouldn't be any problems, but I was indeed on a significantly older version of the News app due to the lack of support for my older PHP version in later News versions (alongside my upgrade to Nextcloud 10.0 RC1 I upgraded from Ubuntu 14.04 to 16.04, and so have gone over to PHP 7.0 now).
The first two were quick, running ALTER TABLE oc_news_items DROP last_modified;
now which seems unsurprisingly to be taking much longer!
That seems to have done it, the News app activated successfully and I can see my feeds again. Thank you :)
Explain the Problem
What problem did you encounter?
Upon attempting to enable/install the News app after an upgrade from ownCloud 9.1 to Nextcloud 10.0 RC1 (backed by a local MySQL database), I got the following error message:
I tried again a minute or two later, which triggered Nextcloud to attempt an update. However, that too failed, this time with:
Explain what you did to encounter the issue
System Information
Contents of nextcloud/data/nextcloud.log
Contents of Browser Error Console
No errors reported by Chrome's console.