Failed to import from hellofresh.com

[peterge1998]

Description
I can not import https://www.hellofresh.de/recipes/buntes-ofengemuse-mit-grillkase-avocado-thermomix-63b6f7106000b3457b0f8088,
while this recepie worked flawless just a second before:
https://www.hellofresh.de/recipes/wildreis-bowl-mit-scharfem-brokkoli-suszkartoffel-thermomix-62bb045eb512c6afca076b8d

Reproduction
Steps to reproduce the behavior:

1. Go to import recipe
2. 2. Paste link: https://www.hellofresh.de/recipes/buntes-ofengemuse-mit-grillkase-avocado-thermomix-63b6f7106000b3457b0f8088
3. Click on ->
4. See error

Expected behavior
Import the r just fine

Actual behavior
This error shows up:

Browser
Which browser are you using?

Firefox
Mobile

Versions
Nextcloud server version: 25.0.3
Cookbook version: 0.10.1
Database system: i am using https://github.com/truenas/charts

[christianlupus]

This might be solvable together with #1463.

[chribre]

Hi,
I probably have a similar error and am not able to access the app anymore . Reinstalling the app will not delete the database entries and is therefore no solution or at least it's not working in my case. It first appeared in 25.0.4

I would be happy if there would be a solution/workaround for that because I love the app!

log

Fehler: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'name' at row 1 at <>

0. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1814
   Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
1. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1749
   Doctrine\DBAL\Connection->handleDriverException()
2. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1163
   Doctrine\DBAL\Connection->convertExceptionDuringQuery()
3. /var/www/nextcloud/lib/private/DB/Connection.php line 297
   Doctrine\DBAL\Connection->executeStatement()
4. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
   OC\DB\Connection->executeStatement()
5. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
   Doctrine\DBAL\Query\QueryBuilder->execute()
6. /var/www/nextcloud/apps/cookbook/lib/Db/RecipeDb.php line 518
   OC\DB\QueryBuilder\QueryBuilder->execute()
7. /var/www/nextcloud/apps/cookbook/lib/Service/DbCacheService.php line 253
   OCA\Cookbook\Db\RecipeDb->insertRecipes()
8. /var/www/nextcloud/apps/cookbook/lib/Service/DbCacheService.php line 102
   OCA\Cookbook\Service\DbCacheService->applyDbReceipeChanges()
9. /var/www/nextcloud/apps/cookbook/lib/Service/DbCacheService.php line 69
   OCA\Cookbook\Service\DbCacheService->carryOutUpdate()
10. /var/www/nextcloud/apps/cookbook/lib/Service/DbCacheService.php line 403
    OCA\Cookbook\Service\DbCacheService->updateCache("*** sensitive parameters replaced ***")
11. /var/www/nextcloud/apps/cookbook/lib/Service/DbCacheService.php line 392
    OCA\Cookbook\Service\DbCacheService->checkSearchIndexUpdate()
12. /var/www/nextcloud/apps/cookbook/lib/Controller/MainController.php line 56
    OCA\Cookbook\Service\DbCacheService->triggerCheck()
13. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 230
    OCA\Cookbook\Controller\MainController->index()
14. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 137
    OC\AppFramework\Http\Dispatcher->executeController()
15. /var/www/nextcloud/lib/private/AppFramework/App.php line 183
    OC\AppFramework\Http\Dispatcher->dispatch()
16. /var/www/nextcloud/lib/private/Route/Router.php line 315
    OC\AppFramework\App::main()
17. /var/www/nextcloud/lib/base.php line 1055
    OC\Route\Router->match()
18. /var/www/nextcloud/index.php line 36
    OC::handleRequest()

Caused by:

Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'name' at row 1 at <>

0. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php line 103
   Doctrine\DBAL\Driver\PDO\Exception::new()
1. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1153
   Doctrine\DBAL\Driver\PDO\Statement->execute()
2. /var/www/nextcloud/lib/private/DB/Connection.php line 297
   Doctrine\DBAL\Connection->executeStatement()
3. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
   OC\DB\Connection->executeStatement()
4. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
   Doctrine\DBAL\Query\QueryBuilder->execute()
5. /var/www/nextcloud/apps/cookbook/lib/Db/RecipeDb.php line 518
   OC\DB\QueryBuilder\QueryBuilder->execute()
6. /var/www/nextcloud/apps/cookbook/lib/Service/DbCacheService.php line 253
   OCA\Cookbook\Db\RecipeDb->insertRecipes()
7. /var/www/nextcloud/apps/cookbook/lib/Service/DbCacheService.php line 102
   OCA\Cookbook\Service\DbCacheService->applyDbReceipeChanges()
8. /var/www/nextcloud/apps/cookbook/lib/Service/DbCacheService.php line 69
   OCA\Cookbook\Service\DbCacheService->carryOutUpdate()
9. /var/www/nextcloud/apps/cookbook/lib/Service/DbCacheService.php line 403
   OCA\Cookbook\Service\DbCacheService->updateCache("*** sensitive parameters replaced ***")
10. /var/www/nextcloud/apps/cookbook/lib/Service/DbCacheService.php line 392
    OCA\Cookbook\Service\DbCacheService->checkSearchIndexUpdate()
11. /var/www/nextcloud/apps/cookbook/lib/Controller/MainController.php line 56
    OCA\Cookbook\Service\DbCacheService->triggerCheck()
12. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 230
    OCA\Cookbook\Controller\MainController->index()
13. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 137
    OC\AppFramework\Http\Dispatcher->executeController()
14. /var/www/nextcloud/lib/private/AppFramework/App.php line 183
    OC\AppFramework\Http\Dispatcher->dispatch()
15. /var/www/nextcloud/lib/private/Route/Router.php line 315
    OC\AppFramework\App::main()
16. /var/www/nextcloud/lib/base.php line 1055
    OC\Route\Router->match()
17. /var/www/nextcloud/index.php line 36
    OC::handleRequest()

Caused by:

PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'name' at row 1 at <>

0. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php line 101
   PDOStatement->execute()
1. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1153
   Doctrine\DBAL\Driver\PDO\Statement->execute()
2. /var/www/nextcloud/lib/private/DB/Connection.php line 297
   Doctrine\DBAL\Connection->executeStatement()
3. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
   OC\DB\Connection->executeStatement()
4. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
   Doctrine\DBAL\Query\QueryBuilder->execute()
5. /var/www/nextcloud/apps/cookbook/lib/Db/RecipeDb.php line 518
   OC\DB\QueryBuilder\QueryBuilder->execute()
6. /var/www/nextcloud/apps/cookbook/lib/Service/DbCacheService.php line 253
   OCA\Cookbook\Db\RecipeDb->insertRecipes()
7. /var/www/nextcloud/apps/cookbook/lib/Service/DbCacheService.php line 102
   OCA\Cookbook\Service\DbCacheService->applyDbReceipeChanges()
8. /var/www/nextcloud/apps/cookbook/lib/Service/DbCacheService.php line 69
   OCA\Cookbook\Service\DbCacheService->carryOutUpdate()
9. /var/www/nextcloud/apps/cookbook/lib/Service/DbCacheService.php line 403
   OCA\Cookbook\Service\DbCacheService->updateCache("*** sensitive parameters replaced ***")
10. /var/www/nextcloud/apps/cookbook/lib/Service/DbCacheService.php line 392
    OCA\Cookbook\Service\DbCacheService->checkSearchIndexUpdate()
11. /var/www/nextcloud/apps/cookbook/lib/Controller/MainController.php line 56
    OCA\Cookbook\Service\DbCacheService->triggerCheck()
12. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 230
    OCA\Cookbook\Controller\MainController->index()
13. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 137
    OC\AppFramework\Http\Dispatcher->executeController()
14. /var/www/nextcloud/lib/private/AppFramework/App.php line 183
    OC\AppFramework\Http\Dispatcher->dispatch()
15. /var/www/nextcloud/lib/private/Route/Router.php line 315
    OC\AppFramework\App::main()
16. /var/www/nextcloud/lib/base.php line 1055
    OC\Route\Router->match()
17. /var/www/nextcloud/index.php line 36
    OC::handleRequest()

GET /apps/cookbook/

[christianlupus]

The problem is most probably, that you had not changed the default location of the recipes. Thus, the SQL table is removed successfully but rebuilt upon reinstalling the app triggering the exact same error as before.

If you know the offending recipe, you can uninstall the cookbook app, move the corresponding recipe folder out of the top folder for recipes (by default the localized version of /Recipes). Then, you should be able to install the app again without running into the issue. This issue is on the agenda for the next release, so it should be solved soon.

[chribre]

Changing the path of the /Recipes directory to make a fresh start did not work in my case. Instead I just had to delete the broken individual directory of recipe. Thank you for your hint and support!