OCP\AppFramework\Db\DoesNotExistException

[Jeff4Success]

Describe the bug Adding new job or restarting existintg job results in "spinning" run but refreshing/changing pages shows job does not exist and did not run. There is an error in the logs, added below.

To Reproduce Steps to reproduce the behavior:

1. Add or restart a scan job
2. Refresh and/or change pages

Expected behavior Job should be added to the task list.

Screenshots If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

{
  "nextcloud-version": "25.0.2.3",
  "app-versions": {
    "cloud_py_api-version": "0.1.0",
    "mediadc-version": "0.3.1"
  },
  "is-videos-supported": true,
  "is-snap": false,
  "arch": "amd64",
  "webserver": "Apache/2.4.52 (Ubuntu)",
  "database": {
    "type": "mysql",
    "version": "10.6.11",
    "size": "90636288"
  },
  "php-version": "8.1.13",
  "php-interpreter": "/usr/bin/php8.1",
  "python-interpretter-setting": "/usr/bin/python3",
  "os": "Linux",
  "os-release": "5.15.0-56-generic",
  "machine-type": "x86_64"
}

Additional context

[index] Error: OCP\AppFramework\Db\DoesNotExistException: Did expect one result but found none when executing: query "SELECT * FROM `*PREFIX*mediadc_settings` WHERE `name` = :dcValue1";  at <<closure>>

0. /var/www/kvms.ats4all.com/public_html/lib/public/AppFramework/Db/QBMapper.php line 362
   OCP\AppFramework\Db\QBMapper->findOneQuery()
1. /var/www/kvms.ats4all.com/public_html/apps/mediadc/lib/Db/SettingMapper.php line 85
   OCP\AppFramework\Db\QBMapper->findEntity()
2. /var/www/kvms.ats4all.com/public_html/apps/mediadc/lib/Service/CollectorService.php line 142
   OCA\MediaDC\Db\SettingMapper->findByName()
3. /var/www/kvms.ats4all.com/public_html/apps/mediadc/lib/Controller/CollectorController.php line 105
   OCA\MediaDC\Service\CollectorService->runTask()
4. /var/www/kvms.ats4all.com/public_html/lib/private/AppFramework/Http/Dispatcher.php line 225
   OCA\MediaDC\Controller\CollectorController->runTask()
5. /var/www/kvms.ats4all.com/public_html/lib/private/AppFramework/Http/Dispatcher.php line 133
   OC\AppFramework\Http\Dispatcher->executeController()
6. /var/www/kvms.ats4all.com/public_html/lib/private/AppFramework/App.php line 172
   OC\AppFramework\Http\Dispatcher->dispatch()
7. /var/www/kvms.ats4all.com/public_html/lib/private/Route/Router.php line 298
   OC\AppFramework\App::main()
8. /var/www/kvms.ats4all.com/public_html/lib/base.php line 1047
   OC\Route\Router->match()
9. /var/www/kvms.ats4all.com/public_html/index.php line 36
   OC::handleRequest()

POST /apps/mediadc/api/v1/tasks/run from 108.169.181.50 by jeff at 2022-12-21T15:56:56+00:00

[andrey18106]

@Jeff4Success This might be because of incorrect order of installation. Since MediaDC 0.3.0 version cloud_py_api must be installed and enabled first, then install MediaDC and all settings updates in database should be done, as well as pre-compiled binary should be downloaded.

[Jeff4Success]

incorrect order of installation.

Yes, I think that might be it. I did update MediaDC then realized I needed the cloud_py_api. I will try again. Thanks!

[Jeff4Success]

Yes, that was indeed my issue. Sorry for bugging you and opening an issue. Thanks again.