Skip to content

Silent SQL failures when there is no root folder #11

@npirlot

Description

@npirlot

Error: Executing action method EJ2APIServices.Controllers.SQLProviderController.SQLFileOperations (EJ2SQLDataBaseProvider) - Validation state: Valid
System.Data.SqlClient.SqlException (0x80131904): The parameterized query '(@name nvarchar(8),@ParentID nvarchar(4000),@SiZe int,@IsFile bi' expects the parameter '@ParentID', which was not supplied.

Steps to reproduce:

  • cloned Git Repo, and built + ran project in VS2019.
  • opened mdf file in VS2019, and executed query to DELETE all entries in the Product table.
  • in File Manager (showing empty info), tried to create a new folder.

Expected behaviour:

  • create a directory in the root of the virtual file system
  • alternatively: SQL error is "silent" as there is no feedback to user, but result of action yields same as initial load of the File Manager. An error is however visible in the Output log in VS2019 for the web-server (i.e. the error handling should be improved to feedback to end user).

I will have to focus on my project's integration to work for now, but if I have a shareable solution to suggest, I'll add them here with a PR.
Note that similarly, trying to upload a file in the context of having no root directory also fails (silently, with no error details in either user feedback or output console).

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions