Settings list is empty & Internal Server Error

[kevinkuan1969]

Nextcloud 22.2.3
Python 3.8.10
Ubuntu 20.14
MySQL 8.0.28
PHP 7.43

An unhandled exception has been thrown:
OCP\AppFramework\Db\DoesNotExistException: Did expect one result but found none when executing: query "SELECT * FROM *PREFIX*mediadc_settings WHERE name = :dcValue1"; in /var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php:283

[ibib]

Is for me reproducible under a fresh nextcloud installation.
Error occurs after trying to log on after installing mediadc.

[andrey18106]

@kevinkuan1969 @ibib Hi! Yea, it's my flaw.

To fix it follow the next steps, before waiting for the next update (I'll re-release 0.1.9 soon):

1. Disable MediaDC via GUI or CLI (occ app:disable mediadc)
2. Update file /lib/Service/UtilsService.php like in the commit.
3. Connect to your database via GUI or CLI and execute some queries to the Nextcloud database:
   • drop database table *prefix*_mediadc_settings (DROP TABLE oc_mediadc_settings;)
   • delete mediadc migration from *prefix*_migrations (DELETE FROM oc_migrations WHERE app='mediadc';)
4. Enable MediaDC via GUI or CLI (occ app:enable mediadc)

The problem should be resolved and the mediadc_settings table should be filled with data now.

Let us know if it helps or not.

[daufveila]

I had the same issue and could solve it with the steps, from @andrey18106

[kevinkuan1969]

Thanks @andrey18106 and it works.

[DasGreff]

I have the same issue here with the v0.1.9, even on fresh install and database cleanup

I'm on Nextcloud 22.2.5
Python 3.8.10
Ubuntu 20.04.4 LTS
PHP : 7.4.25
MariaDB : 10.5.12

Here's a pastebin with the error i get when launching occ with mediadc enabled https://pastebin.com/mD2j0gnm

[andrey18106]

@DasGreff Yea, it seems like something another causing an issue. Unfortunately, because of the war in Ukraine, I could investigate this later, as soon as it is possible, but for now, as for a quick view - looks like Dependency Injection not working for some reason. Are you using Nextcloud Docker or manual installation?

Try to install MediaDC manually by cloning this repository into your Nextcloud apps folder:

0. Delete mediadc (installed from store).
1. git clone https://github.com/andrey18106/mediadc.git --depth 1 -b main /path/to/nextcloud/apps/mediadc
2. php -f /path/to/nextcloud/occ app:enable mediadc

[DasGreff]

It's a manual instalation of Nextcloud inside an LXC caontainer

I had the same issue instaling mediadc by cloning it, i rolled back to v 0.1.8

@andrey18106 hope you are safe, take care of yourself first, this can wait

[andrey18106]

@DasGreff Thanks, I'm safe for now.

Just a little question, why in your error logs, collectorService written from the small letter - of course, it can't find it, because there is CollectorService in a capital case.

Can you describe your configuration in more detail, to have an overall understanding, of why it could happen?

With MediaDC v0.1.8 it works fine?

[DasGreff]

Yes it works fine with v0.1.8

I installed Nextcloud with the archive file downloadable on nextcloud site on my ubuntu which is a lxd container
I then installed MediaDC app with the appstore within the nextcloud app

If you'll need more info, i will provide them

[PAStheLoD]

Hi, just one more datapoint, I get a similar error on version 0.1.9 on Hetzner's Storage Share 24.0.5 (which is their branded nextcloud [fork?]). Unfortunately it seems there's no way to access the server logs.