Not working after update to version 1.0

[CHazz]

hi after update to 1.0.0 on nextcloud 18 have only blank screen with new destination and not working settings ... any tip for fix up ?

not see any errors in log

[e-alfred]

You have to select "new destination" on the left pane to select the folder where you want to upload your files to. You can select multiple folders now and they will be saved into the database of your Nextcloud installation. The settings are empty for now, but will be filled later on with options (especially #50 and #75).

@JonathanTreffler Maybe we should put some information into the right pane to tell users how they have to use the app.

[CHazz]

hi, i ofcourse select destination ... but still nothing work :( maybe not working save to db ? i dont known

[e-alfred]

Did you empty your browser cache? Can you open the browser console to see if any error is shown there?

[CHazz]

yes, this error is in all browsers and have all my users.. i check errors

[CHazz]

i get this error
jquery.js:8630 GET https://cloud.mydomain.xxx/apps/flowupload/directories 400

from source

8630 : // Do send the request (this may raise an exception)
xhr.send( options.hasContent && options.data || null );

[e-alfred]

Can you tell us a bit more about your environment? Do you have your data on external storage?

[CHazz]

data is on local storage
debian 10, MariaDB 10.5.3, Nginx 1.19+security mod, PHP7.4-FPM

nextcloud 18.0.4
`

• accessibility: 1.4.0
• activity: 2.11.0
• admin_audit: 1.8.0
• apporder: 0.10.0
• caniupdate: 0.2.0
• cloud_federation_api: 1.1.0
• comments: 1.8.0
• dav: 1.14.0
• drawio: 0.9.5
• end_to_end_encryption: 1.4.0
• extract: 1.2.4
• federatedfilesharing: 1.8.0
• federation: 1.8.0
• files: 1.13.1
• files_accesscontrol: 1.8.1
• files_clipboard: 0.7.1
• files_downloadactivity: 1.7.0
• files_external: 1.9.0
• files_external_gdrive: 0.4.0
• files_pdfviewer: 1.7.0
• files_photospheres: 1.0.9
• files_rightclick: 0.15.2
• files_sharing: 1.10.1
• files_trackdownloads: 1.7.0
• files_trashbin: 1.8.0
• files_videoplayer: 1.7.0
• flowupload: 1.0.0
• groupfolders: 6.0.6
• impersonate: 1.5.1
• logreader: 2.3.0
• lookup_server_connector: 1.6.0
• mail: 1.3.5
• nextcloud_announcements: 1.7.0
• notifications: 2.6.0
• oauth2: 1.6.0
• ocdownloader: 1.7.7
• ocr: 6.0.42
• onlyoffice: 4.1.4
• password_policy: 1.8.0
• photos: 1.0.0
• previewgenerator: 2.3.0
• printer: 0.0.2
• privacy: 1.2.0
• provisioning_api: 1.8.0
• radio: 0.6.6
• ransomware_protection: 1.6.1
• recommendations: 0.6.0
• scanner: 0.1.8
• serverinfo: 1.8.0
• settings: 1.0.0
• sharebymail: 1.8.0
• sharerenamer: 2.7.3
• socialsharing_email: 2.0.0
• systemtags: 1.8.0
• text: 2.0.0
• theming: 1.9.0
• twofactor_backupcodes: 1.7.0
• unsplash: 1.1.5
• updatenotification: 1.8.0
• uploaddetails: 0.1.3
• viewer: 1.2.0
• weather: 1.7.2
• workflow_pdf_converter: 1.3.2
• workflowengine: 2.0.0
  `

[JonathanTreffler]

It seems like the database migration didn't work. Can you try to remove flowupload and reinstall it ?

[CHazz]

yes .. maybe 3x addon and try reinstall complete on backup system and same problem

[e-alfred]

Nginx 1.19+security mod

As it is returning a 400 bad request it might have to do with any additional security modules (mod_evasive with Apache is somewhat problematic), can you test it without this module? Does it log any error in the NGINX log or any other security log?

[CHazz]

i not see any new errors :) but i try on pure stable nginx now

[CHazz]

so i try clean nginx/1.14.2 and default php-fpm config and still same :(
but some new in nextcloud log :

{"reqId":"FPvLziWbDWW95q2nKVQn","level":3,"time":"2020-06-02T20:36:55+02:00","remoteAddr":"IP.IP.IP.IP","user":"user","app":"index","method":"GET","url":"/apps/flowupload/directories","message":{"Exception":"Doctrine\DBAL\Exception\TableNotFoundException","Message":"An exception occurred while executing 'SELECT * FROM oc_flowupload_directories WHERE user_id = ?' with params ["user"]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloudDB.oc_flowupload_directories' doesn't exist","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":169,"function":"convertException","class":"Doctrine\DBAL\Driver\AbstractMySQLDriver","type":"->"},{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":145,"function":"wrapException","class":"Doctrine\DBAL\DBALException","type":"::"},{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":911,"function":"driverExceptionDuringQuery","class":"Doctrine\DBAL\DBALException","type":"::"},{"file":"/var/www/html/lib/private/DB/Connection.php","line":199,"function":"executeQuery","class":"Doctrine\DBAL\Connection","type":"->"},{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":200,"function":"executeQuery","class":"OC\DB\Connection","type":"->"},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":215,"function":"execute","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->"},{"file":"/var/www/html/lib/public/AppFramework/Db/QBMapper.php","line":301,"function":"execute","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->"},{"file":"/var/www/html/apps/flowupload/lib/Db/DirectoryMapper.php","line":43,"function":"findEntities","class":"OCP\AppFramework\Db\QBMapper","type":"->"},{"file":"/var/www/html/apps/flowupload/lib/Service/DirectoryService.php","line":23,"function":"findAll","class":"OCA\flowupload\Db\DirectoryMapper","type":"->"},{"file":"/var/www/html/apps/flowupload/lib/Controller/DirectoryController.php","line":34,"function":"findAll","class":"OCA\flowupload\Service\DirectoryService","type":"->"},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":170,"function":"index","class":"OCA\flowupload\Controller\DirectoryController","type":"->"},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":99,"function":"executeController","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":125,"function":"dispatch","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/html/lib/private/AppFramework/Routing/RouteActionHandler.php","line":47,"function":"main","class":"OC\AppFramework\App","type":"::"},{"function":"__invoke","class":"OC\AppFramework\Routing\RouteActionHandler","type":"->"},{"file":"/var/www/html/lib/private/Route/Router.php","line":299,"function":"call_user_func"},{"file":"/var/www/html/lib/base.php","line":1008,"function":"match","class":"OC\Route\Router","type":"->"},{"file":"/var/www/html/index.php","line":38,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php","Line":42,"Previous":{"Exception":"Doctrine\DBAL\Driver\PDOException","Message":"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloudDB.oc_flowupload_directories' doesn't exist","Code":"42S02","Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":903,"function":"execute","class":"Doctrine\DBAL\Driver\PDOStatement","type":"->"},{"file":"/var/www/html/lib/private/DB/Connection.php","line":199,"function":"executeQuery","class":"Doctrine\DBAL\Connection","type":"->"},{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":200,"function":"executeQuery","class":"OC\DB\Connection","type":"->"},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":215,"function":"execute","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->"},{"file":"/var/www/html/lib/public/AppFramework/Db/QBMapper.php","line":301,"function":"execute","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->"},{"file":"/var/www/html/apps/flowupload/lib/Db/DirectoryMapper.php","line":43,"function":"findEntities","class":"OCP\AppFramework\Db\QBMapper","type":"->"},{"file":"/var/www/html/apps/flowupload/lib/Service/DirectoryService.php","line":23,"function":"findAll","class":"OCA\flowupload\Db\DirectoryMapper","type":"->"},{"file":"/var/www/html/apps/flowupload/lib/Controller/DirectoryController.php","line":34,"function":"findAll","class":"OCA\flowupload\Service\DirectoryService","type":"->"},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":170,"function":"index","class":"OCA\flowupload\Controller\DirectoryController","type":"->"},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":99,"function":"executeController","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":125,"function":"dispatch","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/html/lib/private/AppFramework/Routing/RouteActionHandler.php","line":47,"function":"main","class":"OC\AppFramework\App","type":"::"},{"function":"__invoke","class":"OC\AppFramework\Routing\RouteActionHandler","type":"->"},{"file":"/var/www/html/lib/private/Route/Router.php","line":299,"function":"call_user_func"},{"file":"/var/www/html/lib/base.php","line":1008,"function":"match","class":"OC\Route\Router","type":"->"},{"file":"/var/www/html/index.php","line":38,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":119,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloudDB.oc_flowupload_directories' doesn't exist","Code":"42S02","Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","line":117,"function":"execute","class":"PDOStatement","type":"->"},{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":903,"function":"execute","class":"Doctrine\DBAL\Driver\PDOStatement","type":"->"},{"file":"/var/www/html/lib/private/DB/Connection.php","line":199,"function":"executeQuery","class":"Doctrine\DBAL\Connection","type":"->"},{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":200,"function":"executeQuery","class":"OC\DB\Connection","type":"->"},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":215,"function":"execute","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->"},{"file":"/var/www/html/lib/public/AppFramework/Db/QBMapper.php","line":301,"function":"execute","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->"},{"file":"/var/www/html/apps/flowupload/lib/Db/DirectoryMapper.php","line":43,"function":"findEntities","class":"OCP\AppFramework\Db\QBMapper","type":"->"},{"file":"/var/www/html/apps/flowupload/lib/Service/DirectoryService.php","line":23,"function":"findAll","class":"OCA\flowupload\Db\DirectoryMapper","type":"->"},{"file":"/var/www/html/apps/flowupload/lib/Controller/DirectoryController.php","line":34,"function":"findAll","class":"OCA\flowupload\Service\DirectoryService","type":"->"},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":170,"function":"index","class":"OCA\flowupload\Controller\DirectoryController","type":"->"},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":99,"function":"executeController","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":125,"function":"dispatch","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/html/lib/private/AppFramework/Routing/RouteActionHandler.php","line":47,"function":"main","class":"OC\AppFramework\App","type":"::"},{"function":"__invoke","class":"OC\AppFramework\Routing\RouteActionHandler","type":"->"},{"file":"/var/www/html/lib/private/Route/Router.php","line":299,"function":"call_user_func"},{"file":"/var/www/html/lib/base.php","line":1008,"function":"match","class":"OC\Route\Router","type":"->"},{"file":"/var/www/html/index.php","line":38,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":117}},"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (Windows NT 10.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.102 Safari/537.36 Edge/18.18363","version":"18.0.4.2","id":"5ed69c79aa21e"}

[JonathanTreffler]

Can you browse the nextcloud databse (with phpmyadmin or such) and find out if the table oc_flowupload_directories exists ? It should automatically created at the install, but according to the log it doesn't exist.

If it exists try removing this app, removing the oc_flowupload_directories table manually and reinstalling flowupload.

[JonathanTreffler]

I really hope this is no problem in the DB Migration file i wrote 😬

[JonathanTreffler]

On my server it worked and my setup is relatively similar to yours. So i am not sure what could go wrong

[CHazz]

This table really not exist .. but reinstall dont create this table .. send me please structure of this db table :-) thanks .. i try delete all flowupload records from oc_appconfig for pure reinstall..but still nothing .. something Is wrong in installer :-(

[JonathanTreffler]

Thats weird. The Structure can be seen in the code here:

[JonathanTreffler]

i will try if this will happen on a fresh 18.0.4 server.
I only use docker, but i would be extremely surprised if that would make a difference.
I i cannot reproduce this error something has to be messed up with your instance / database @CHazz

[JonathanTreffler]

nobody else in our call for testing for the current release on the forum had this problem, so i guess you are the only one facing this problem. Could it be a permissions issue with you database ?

[JonathanTreffler]

i will try if this will happen on a fresh 18.0.4 server.
I only use docker, but i would be extremely surprised if that would make a difference.

No issues on my fresh test instance.
We didn't test the current release on Nextcloud 16 and 17, but 18 should definitely run fine (16 and 17 should work too)

[JonathanTreffler]

Could you post if any errors occur at the app install ?

[CHazz]

i try create table manualy..now no have any one error (after choice directory. Table in db is still empty without records) .. in nextcloud, php, nginx .. nothing .. after reinstal nothing .. and still not working :/ old version working perfect, but after update to 1.0.0 this :( i try gran to mysql user "nextcloudDB" grant root privilegies .. no change

[CHazz]

hi, i try complete reintall with database ,, and have new error .. maybe this help us

[no app in context] Error: Symfony\Component\Routing\Exception\RouteNotFoundException: Unable to generate a URL for the named route "flowupload.page.index" as such route does not exist. at <>

0. /var/www/html/lib/private/Route/Router.php line 339
   Symfony\Component\Routing\Generator\UrlGenerator->generate("flowupload.page.index", [], 1)
1. /var/www/html/lib/private/Route/CachingRouter.php line 59
   OC\Route\Router->generate("flowupload.page.index", [], false)
2. /var/www/html/lib/private/URLGenerator.php line 82
   OC\Route\CachingRouter->generate("flowupload.page.index", [])
3. /var/www/html/lib/private/NavigationManager.php line 293
   OC\URLGenerator->linkToRoute("flowupload.page.index")
4. /var/www/html/lib/private/NavigationManager.php line 114
   OC\NavigationManager->init()
5. /var/www/html/lib/private/TemplateLayout.php line 87
   OC\NavigationManager->getAll()
6. /var/www/html/lib/private/legacy/template.php line 184
   OC\TemplateLayout->__construct("user", "settings")
7. /var/www/html/lib/public/AppFramework/Http/TemplateResponse.php line 167
   OC_Template->fetchPage({serverData: {ap ... }})
8. /var/www/html/lib/private/AppFramework/Http/Dispatcher.php line 123
   OCP\AppFramework\Http\TemplateResponse->render()
9. /var/www/html/lib/private/AppFramework/App.php line 125
   OC\AppFramework\Http\Dispatcher->dispatch(OCA\Settings\Con ... {}, "viewApps")
10. /var/www/html/lib/private/AppFramework/Routing/RouteActionHandler.php line 47
    OC\AppFramework\App::main("OCA\Settings\ ... r", "viewApps", OC\AppFramework\ ... {}, {category: "",id ... "})
11. <>
    OC\AppFramework\Routing\RouteActionHandler->__invoke({category: "",id ... "})
12. /var/www/html/lib/private/Route/Router.php line 299
    call_user_func(OC\AppFramework\ ... {}, {category: "",id ... "})
13. /var/www/html/lib/base.php line 1008
    OC\Route\Router->match("/settings/apps")
14. /var/www/html/index.php line 38
    OC::handleRequest()

GET /settings/apps