# App Store not working anymore **URL:** \ **Category:** ℹ️ Support\ **Created:** [February 9, 2017, 9:27pm UTC](https://help.nextcloud.com/t/app-store-not-working-anymore/8726 "2017-02-09T21:27:57Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![bastoGrande](https://help.nextcloud.com/letter_avatar/bastogrande/32/6_22734026db12803ebb3e059622ac3534.png) [@bastoGrande](https://help.nextcloud.com/u/bastoGrande)\ **Post date:** [February 9, 2017, 9:27pm UTC](https://help.nextcloud.com/t/app-store-not-working-anymore/8726/1 "2017-02-09T21:27:58Z")
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: > [@How to install/activate Apps like Mail, Contacts and Calendar?](https://help.nextcloud.com/t/how-to-install-activate-apps-like-mail-contacts-and-calendar/5378/10): > > Same error here with ’appstore.experimental.enabled’ =\> true, ‘appstoreurl’ =\> ‘[https://apps.nextcloud.com/api/v0](https://apps.nextcloud.com/api/v0)’, just added. First I thought that something broke due to my apache2 package upgrade, because upgrade time and first sight of error were quite close. But as the error occurred half an hour earlier, needed to be something else. Good to know that the error is handles here now. Related issue on git-hub: [Update to 0.3.4 fails](https://help.nextcloud.com/t/update-to-0-3-4-fails/5364) 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](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…) ---
**Author:** ![MichaIng](https://help.nextcloud.com/user_avatar/help.nextcloud.com/michaing/32/2125_2.png) [@MichaIng](https://help.nextcloud.com/u/MichaIng)\ **Post date:** [February 10, 2017, 12:29am UTC](https://help.nextcloud.com/t/app-store-not-working-anymore/8726/2 "2017-02-10T00:29:08Z")
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. ---
**Author:** ![bastoGrande](https://help.nextcloud.com/letter_avatar/bastogrande/32/6_22734026db12803ebb3e059622ac3534.png) [@bastoGrande](https://help.nextcloud.com/u/bastoGrande)\ **Post date:** [February 10, 2017, 2:36am UTC](https://help.nextcloud.com/t/app-store-not-working-anymore/8726/3 "2017-02-10T02:36:03Z")
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? ---
**Author:** ![BernhardPosselt](https://help.nextcloud.com/user_avatar/help.nextcloud.com/bernhardposselt/32/82_2.png) [@BernhardPosselt](https://help.nextcloud.com/u/BernhardPosselt)\ **Post date:** [February 10, 2017, 9:44am UTC](https://help.nextcloud.com/t/app-store-not-working-anymore/8726/4 "2017-02-10T09:44:27Z")
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 😉 ---
**Author:** ![bastoGrande](https://help.nextcloud.com/letter_avatar/bastogrande/32/6_22734026db12803ebb3e059622ac3534.png) [@bastoGrande](https://help.nextcloud.com/u/bastoGrande)\ **Post date:** [February 10, 2017, 10:41am UTC](https://help.nextcloud.com/t/app-store-not-working-anymore/8726/5 "2017-02-10T10:41:27Z")
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](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… ---
**Author:** ![MichaIng](https://help.nextcloud.com/user_avatar/help.nextcloud.com/michaing/32/2125_2.png) [@MichaIng](https://help.nextcloud.com/u/MichaIng)\ **Post date:** [February 10, 2017, 8:55pm UTC](https://help.nextcloud.com/t/app-store-not-working-anymore/8726/6 "2017-02-10T20:55:55Z")
> [@bastoGrande](#): > > One more info for the app-devs of the app “Video calls” ([https://github.com/nextcloud/spreed](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 ---
**Author:** ![BernhardPosselt](https://help.nextcloud.com/user_avatar/help.nextcloud.com/bernhardposselt/32/82_2.png) [@BernhardPosselt](https://help.nextcloud.com/u/BernhardPosselt)\ **Post date:** [February 11, 2017, 10:47am UTC](https://help.nextcloud.com/t/app-store-not-working-anymore/8726/7 "2017-02-11T10:47:57Z")
Probably better to start a new thread since this goes off topic and makes it hard for people to find ---
**Author:** ![iwkse](https://help.nextcloud.com/user_avatar/help.nextcloud.com/iwkse/32/5898_2.png) [@iwkse](https://help.nextcloud.com/u/iwkse)\ **Post date:** [September 22, 2017, 12:22am UTC](https://help.nextcloud.com/t/app-store-not-working-anymore/8726/8 "2017-09-22T00:22:42Z")
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 ---
**Author:** ![Ricardo\_Santos](https://help.nextcloud.com/user_avatar/help.nextcloud.com/ricardo_santos/32/4999_2.png) [@Ricardo\_Santos](https://help.nextcloud.com/u/Ricardo_Santos)\ **Post date:** [October 24, 2017, 6:34pm UTC](https://help.nextcloud.com/t/app-store-not-working-anymore/8726/9 "2017-10-24T18:34:10Z")
How to do the remove of the “apps.json” from the oc\_filecache table using the terminal? ---
**Author:** ![bastoGrande](https://help.nextcloud.com/letter_avatar/bastogrande/32/6_22734026db12803ebb3e059622ac3534.png) [@bastoGrande](https://help.nextcloud.com/u/bastoGrande)\ **Post date:** [October 24, 2017, 6:49pm UTC](https://help.nextcloud.com/t/app-store-not-working-anymore/8726/10 "2017-10-24T18:49:06Z")
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. ---
**Author:** ![Ricardo\_Santos](https://help.nextcloud.com/user_avatar/help.nextcloud.com/ricardo_santos/32/4999_2.png) [@Ricardo\_Santos](https://help.nextcloud.com/u/Ricardo_Santos)\ **Post date:** [October 24, 2017, 10:02pm UTC](https://help.nextcloud.com/t/app-store-not-working-anymore/8726/11 "2017-10-24T22:02:23Z")
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. ---
**Author:** ![wwe](https://help.nextcloud.com/user_avatar/help.nextcloud.com/wwe/32/72963_2.png) [@wwe](https://help.nextcloud.com/u/wwe)\ **Post date:** [December 2, 2024, 2:41pm UTC](https://help.nextcloud.com/t/app-store-not-working-anymore/8726/12 "2024-12-02T14:41:34Z")
---
**Author:** ![wwe](https://help.nextcloud.com/user_avatar/help.nextcloud.com/wwe/32/72963_2.png) [@wwe](https://help.nextcloud.com/u/wwe)\ **Post date:** [December 4, 2024, 1:57pm UTC](https://help.nextcloud.com/t/app-store-not-working-anymore/8726/13 "2024-12-04T13:57:47Z")