App Store not working anymore

Hey guys,

I had a great instance of nextcloud running like a charm until I deleted it by accident. Well, a build script deleted the nc-files, which needed a config-parameter I forgot.

So I reuploaded everything and reinstalled nc with the newest upate (11.0.1), which was already in use before. Thatā€™s why I thought the database should be fine after all. And yes everything is working again except of the app store. It is just showing the ā€œActivatedā€ and ā€œDeactivatedā€ categories.

I tried to find solutions here, but nothing worked for me. For example this:

I tried to repair, ā€œto clean up the databaseā€ with: php occ maintenance:repair (donā€™t need sudo on my hoster)
Found here:
https://docs.nextcloud.com/server/11/admin_manual/configuration_server/occ_command.html#maintenance-commands
Didnā€™t work as wellā€¦

Any ideas what I could do/check?

greetings,
basti

ps: keep on rocking! itā€™s a great piece of software! using it since oc 9.0 (so, not too longā€¦)

Hmm, the issue in your first link should be fixed, It just occurred due to some problems short time after the first nc 11 beta upgrade.

Be sure that all app store related settings inside your config.php are removed, so standard settings are used. But as you already used nc 11 that should not be the problem.

Please provide all nextcloud, webserver and browser log you can find, related to the failure.

I found this line conspicuous:
fopen(/var/www/virtual/ user /html/cloudData/appdata_oc8i5nd6yyyh/appstore/apps.json): failed to open stream: No such file or directory at /var/www/virtual/baasto/html/nextcloud/lib/private/Files/Storage/Local.php#216

When I checked the file(Local.php), it did exist. Might it be a rights-problem?

I canā€™t upload a log file here, because Iā€™m a new userā€¦ Donā€™t know when this might changeā€¦ or what other way do you suggest?

missing file is actually /var/www/virtual/ user /html/cloudData/appdata_oc8i5nd6yyyh/appstore/apps.json which looks like the local cache. So probably somewhere in your database its stored that you already have a local copy which should last X hours while its gone. Investigate into that area :wink:

1 Like

finally everything seems to work again!

@BernhardPosselt: thanks I must have been blind yesterdayā€¦ was way too lateā€¦
I found the entry ā€œapps.jsonā€ in the oc_filecache table and removed it as well as two other entries with the values ā€œappstoreā€ and ā€œcategoriesā€ in their path.

One more info for the app-devs of the app ā€œVideo callsā€ (https://github.com/nextcloud/spreed), when I tried to reactivate it, an exception came up saying: that the tables (oc_spreedme_messages, oc_spreedme_rooms, oc_spreedme_room_participants) the app is using, already exists.
Well normally they shouldnā€™t already exist, but I think if they would check in this case if the table exists they can jump to the next config-step. Because if they donā€™t need to be rebuild, no valuable data in theses three tables is getting lost. I had nothing special in there, but might be different for bigger instancesā€¦

@nickvergessen @ivan

Probably better to start a new thread since this goes off topic and makes it hard for people to find

Hi all, Iā€™m having a similar issue so Iā€™m not opening a new thread. Iā€™ve tried removing from the database (postgres) from oc_filecache the apps.json, appstore and categories.json references but I still see this

{ā€œreqIdā€:ā€œZED9A5MSJtZ3SBKNKHEjā€,ā€œlevelā€:3,ā€œtimeā€:ā€œ2017-09-21T23:31:49+00:00ā€,ā€œremoteAddrā€:ā€œ127.0.0.1ā€,ā€œuserā€:ā€œadminā€,ā€œappā€:ā€œPHPā€,ā€œmethodā€:ā€œGETā€,ā€œurlā€:"/index.php/settings/apps/categories",ā€œmessageā€:ā€œfile_get_contents(/opt/nextcloud/data/appdata_oce6snk0zpug/appstore/categories.json): failed to open stream: No such file or directory at /mnt/wdblue/www/sites/nextcloud/lib/private/Files/Storage/Local.php#209ā€,ā€œuserAgentā€:ā€œMozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0ā€,ā€œversionā€:ā€œ12.0.3.3ā€}

{ā€œreqIdā€:ā€œlJLxoR0zsrWNBkiq1NDtā€,ā€œlevelā€:3,ā€œtimeā€:ā€œ2017-09-21T23:31:49+00:00ā€,ā€œremoteAddrā€:ā€œ127.0.0.1ā€,ā€œuserā€:ā€œadminā€,ā€œappā€:ā€œPHPā€,ā€œmethodā€:ā€œGETā€,ā€œurlā€:"/index.php/settings/apps/list?category=installed",ā€œmessageā€:ā€œfile_get_contents(/opt/nextcloud/data/appdata_oce6snk0zpug/appstore/apps.json): failed to open stream: No such file or directory at /mnt/wdblue/www/sites/nextcloud/lib/private/Files/Storage/Local.php#209ā€,ā€œuserAgentā€:ā€œMozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0ā€,ā€œversionā€:ā€œ12.0.3.3ā€}

Files are there and permissions are fine, Selinux is not enabled.

Hope you got some hints,
Thanks in advance

How to do the remove of the ā€œapps.jsonā€ from the oc_filecache table using the terminal?

I connected via the adminer web access of my hosting-provider and removed the entries with a simple sql-statement.

I donā€™t know if there exist a possibility to change/remove database values with the terminal.

OK thanks. I have to do it in the terminal since I have raspian light

If anyone knows how to do it in the terminal please let me know.