Skip to content

Database crashs when importing any type of text #247

Description

@MrSalehSalem

Describe the bug
A database error when adding / importing ant text:
Internal Server Error

To Reproduce

  1. open LWT
  2. new text
  3. upload file (all the options results in the same error in the end)
  4. after selecting a file click review
  5. import
  6. ERROR (Internal Server Error)

Expected behavior
It should import the text normally without any crashes.

Screenshots

Image
  • LWT version: 3.2.1

Desktop:

  • OS: Windows 11
  • Browser: Zen Browser (Firefox)
  • Version: 1.21.4b (Firefox 152.0.3) (64-bit)

Smartphone (if necessary):

Additional context

Debug Information

Exception: Lwt\Shared\Infrastructure\Exception\DatabaseException

Message: Query failed: Got error 194 "Tablespace is missing for a table" from storage engine InnoDB

File: /var/www/html/src/Shared/Infrastructure/Exception/DatabaseException.php:138

Debug Information

Exception: Lwt\Shared\Infrastructure\Exception\DatabaseException

Message: Query failed: Got error 194 "Tablespace is missing for a table" from storage engine InnoDB

File: /var/www/html/src/Shared/Infrastructure/Exception/DatabaseException.php:138

Stack Trace

#0 /var/www/html/src/Shared/Infrastructure/Database/Connection.php(104): Lwt\Shared\Infrastructure\Exception\DatabaseException::queryFailed()
#1 /var/www/html/src/Shared/Infrastructure/Database/Connection.php(222): Lwt\Shared\Infrastructure\Database\Connection::query()
#2 /var/www/html/src/Shared/Infrastructure/Database/QueryBuilder.php(897): Lwt\Shared\Infrastructure\Database\Connection::execute()
#3 /var/www/html/src/Shared/Infrastructure/Database/TextParsing.php(258): Lwt\Shared\Infrastructure\Database\QueryBuilder->truncate()
#4 /var/www/html/src/Shared/Infrastructure/Database/TextParsing.php(127): Lwt\Shared\Infrastructure\Database\TextParsing::prepare()
#5 /var/www/html/src/Modules/Text/Application/TextFacade.php(877): Lwt\Shared\Infrastructure\Database\TextParsing::parseAndSave()
#6 /var/www/html/src/Modules/Text/Http/TextCrudController.php(426): Lwt\Modules\Text\Application\TextFacade->saveTextAndReparse()
#7 /var/www/html/src/Modules/Text/Http/TextCrudController.php(81): Lwt\Modules\Text\Http\TextCrudController->handleTextOperation()
#8 /var/www/html/src/Modules/Text/Http/TextController.php(84): Lwt\Modules\Text\Http\TextCrudController->new()
#9 [internal function]: Lwt\Modules\Text\Http\TextController->new()
#10 /var/www/html/src/Shared/Infrastructure/Routing/Router.php(1001): call_user_func_array()
#11 /var/www/html/src/Shared/Infrastructure/Routing/Router.php(942): Lwt\Shared\Infrastructure\Routing\Router->executeController()
#12 /var/www/html/src/Shared/Infrastructure/Routing/Router.php(801): Lwt\Shared\Infrastructure\Routing\Router->executeHandler()
#13 /var/www/html/src/backend/Application.php(318): Lwt\Shared\Infrastructure\Routing\Router->execute()
#14 /var/www/html/index.php(30): Lwt\Application->run()
#15 {main}

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions