Anomalie #1723: Picture is not stored when creating a new object - Prêt d'objets - Galette bugs & features

Actions

Copier le lien

Anomalie #1723

fermé

Picture is not stored when creating a new object

Ajouté par Guillaume AGNIERAY il y a 7 mois. Mis à jour il y a 6 mois.

Statut:

Fermé

Priorité:

Normal

Assigné à:

Johan Cwiklinski

Début:

12/10/2023

Echéance:

% réalisé:

100%

Temps estimé:

Description

The object is created, but with the default picture.
The picture can however be modifed afterwards.

127.0.0.1 - 2023-10-12 12:11:47 - ERROR - Query error: INSERT INTO `devel_lend_rents` (`object_id`, `date_begin`, `date_forecast`, `date_end`, `status_id`, `adherent_id`, `comments`) VALUES ('3', '2023-10-12 14:11:47', NULL, NULL, '-1', NULL, '') PDOException: SQLSTATE\[22003\]: Numeric value out of range: 1264 Out of range value for column 'status_id' at row 1 in /var/www/galette/galette/vendor/laminas/laminas-db/src/Adapter/Driver/Pdo/Connection.php:376
Stack trace:
#0 /var/www/galette/galette/vendor/laminas/laminas-db/src/Adapter/Driver/Pdo/Connection.php(376): PDO->query()
#1 /var/www/galette/galette/vendor/laminas/laminas-db/src/Adapter/Adapter.php(194): Laminas\Db\Adapter\Driver\Pdo\Connection->execute()
#2 /var/www/galette/galette/lib/Galette/Core/Db.php(789): Laminas\Db\Adapter\Adapter->query()
#3 /var/www/galette/galette/plugins/plugin-objectslend/lib/GaletteObjectsLend/Entity/LendRent.php(179): Galette\Core\Db->execute()
#4 /var/www/galette/galette/plugins/plugin-objectslend/lib/GaletteObjectsLend/Controllers/Crud/ObjectsController.php(440): GaletteObjectsLend\Entity\LendRent->store()
#5 /var/www/galette/galette/plugins/plugin-objectslend/lib/GaletteObjectsLend/Controllers/Crud/ObjectsController.php(105): GaletteObjectsLend\Controllers\Crud\ObjectsController->doEdit()
#6 [internal function]: GaletteObjectsLend\Controllers\Crud\ObjectsController->doAdd()
#7 /var/www/galette/galette/vendor/php-di/invoker/src/Invoker.php(74): call_user_func_array()
#8 /var/www/galette/galette/vendor/php-di/slim-bridge/src/ControllerInvoker.php(47): Invoker\Invoker->call()
#9 /var/www/galette/galette/vendor/slim/slim/Slim/Routing/Route.php(358): DI\Bridge\Slim\ControllerInvoker->_invoke()
#10 /var/www/galette/galette/lib/Galette/Middleware/Authenticate.php(200): Slim\Routing\Route->handle()
#11 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(269): Galette\Middleware\Authenticate->_invoke()
#12 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#13 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(65): Slim\MiddlewareDispatcher->handle()
#14 /var/www/galette/galette/vendor/slim/slim/Slim/Routing/Route.php(315): Slim\MiddlewareDispatcher->handle()
#15 /var/www/galette/galette/vendor/slim/slim/Slim/Routing/RouteRunner.php(68): Slim\Routing\Route->run()
#16 /var/www/galette/galette/vendor/akrabat/rka-slim-session-middleware/RKA/SessionMiddleware.php(66): Slim\Routing\RouteRunner->handle()
#17 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): RKA\SessionMiddleware->process()
#18 /var/www/galette/galette/vendor/slim/csrf/src/Guard.php(476): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#19 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\Csrf\Guard->process()
#20 /var/www/galette/galette/lib/Galette/Middleware/Language.php(86): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#21 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(168): Galette\Middleware\Language->_invoke()
#22 /var/www/galette/galette/lib/Galette/Middleware/Telemetry.php(86): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#23 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(168): Galette\Middleware\Telemetry->_invoke()
#24 /var/www/galette/galette/includes/main.inc.php(212): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#25 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(269): Closure->{closure}()
#26 /var/www/galette/galette/vendor/slim/slim/Slim/Middleware/RoutingMiddleware.php(45): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#27 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\Middleware\RoutingMiddleware->process()
#28 /var/www/galette/galette/vendor/slim/slim/Slim/Middleware/ErrorMiddleware.php(76): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#29 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\Middleware\ErrorMiddleware->process()
#30 /var/www/galette/galette/vendor/slim/twig-view/src/TwigMiddleware.php(115): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#31 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\Views\TwigMiddleware->process()
#32 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#33 /var/www/galette/galette/vendor/slim/slim/Slim/App.php(199): Slim\MiddlewareDispatcher->handle()
#34 /var/www/galette/galette/vendor/slim/slim/Slim/App.php(183): Slim\App->handle()
#35 /var/www/galette/galette/includes/main.inc.php(244): Slim\App->run()
#36 /var/www/galette/galette/webroot/index.php(57): require_once('...')
#37 {main}
127.0.0.1 - 2023-10-12 12:11:47 - ERROR - Something went wrong :'( | SQLSTATE²²⁰⁰³: Numeric value out of range: 1264 Out of range value for column 'status_id' at row 1
#0 /var/www/galette/galette/vendor/laminas/laminas-db/src/Adapter/Driver/Pdo/Connection.php(376): PDO->query()
#1 /var/www/galette/galette/vendor/laminas/laminas-db/src/Adapter/Adapter.php(194): Laminas\Db\Adapter\Driver\Pdo\Connection->execute()
#2 /var/www/galette/galette/lib/Galette/Core/Db.php(789): Laminas\Db\Adapter\Adapter->query()
#3 /var/www/galette/galette/plugins/plugin-objectslend/lib/GaletteObjectsLend/Entity/LendRent.php(179): Galette\Core\Db->execute()
#4 /var/www/galette/galette/plugins/plugin-objectslend/lib/GaletteObjectsLend/Controllers/Crud/ObjectsController.php(440): GaletteObjectsLend\Entity\LendRent->store()
#5 /var/www/galette/galette/plugins/plugin-objectslend/lib/GaletteObjectsLend/Controllers/Crud/ObjectsController.php(105): GaletteObjectsLend\Controllers\Crud\ObjectsController->doEdit()
#6 [internal function]: GaletteObjectsLend\Controllers\Crud\ObjectsController->doAdd()
#7 /var/www/galette/galette/vendor/php-di/invoker/src/Invoker.php(74): call_user_func_array()
#8 /var/www/galette/galette/vendor/php-di/slim-bridge/src/ControllerInvoker.php(47): Invoker\Invoker->call()
#9 /var/www/galette/galette/vendor/slim/slim/Slim/Routing/Route.php(358): DI\Bridge\Slim\ControllerInvoker->_invoke()
#10 /var/www/galette/galette/lib/Galette/Middleware/Authenticate.php(200): Slim\Routing\Route->handle()
#11 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(269): Galette\Middleware\Authenticate->_invoke()
#12 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#13 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(65): Slim\MiddlewareDispatcher->handle()
#14 /var/www/galette/galette/vendor/slim/slim/Slim/Routing/Route.php(315): Slim\MiddlewareDispatcher->handle()
#15 /var/www/galette/galette/vendor/slim/slim/Slim/Routing/RouteRunner.php(68): Slim\Routing\Route->run()
#16 /var/www/galette/galette/vendor/akrabat/rka-slim-session-middleware/RKA/SessionMiddleware.php(66): Slim\Routing\RouteRunner->handle()
#17 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): RKA\SessionMiddleware->process()
#18 /var/www/galette/galette/vendor/slim/csrf/src/Guard.php(476): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#19 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\Csrf\Guard->process()
#20 /var/www/galette/galette/lib/Galette/Middleware/Language.php(86): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#21 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(168): Galette\Middleware\Language->_invoke()
#22 /var/www/galette/galette/lib/Galette/Middleware/Telemetry.php(86): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#23 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(168): Galette\Middleware\Telemetry->_invoke()
#24 /var/www/galette/galette/includes/main.inc.php(212): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#25 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(269): Closure->{closure}()
#26 /var/www/galette/galette/vendor/slim/slim/Slim/Middleware/RoutingMiddleware.php(45): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#27 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\Middleware\RoutingMiddleware->process()
#28 /var/www/galette/galette/vendor/slim/slim/Slim/Middleware/ErrorMiddleware.php(76): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#29 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\Middleware\ErrorMiddleware->process()
#30 /var/www/galette/galette/vendor/slim/twig-view/src/TwigMiddleware.php(115): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#31 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\Views\TwigMiddleware->process()
#32 /var/www/galette/galette/vendor/slim/slim/Slim/MiddlewareDispatcher.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#33 /var/www/galette/galette/vendor/slim/slim/Slim/App.php(199): Slim\MiddlewareDispatcher->handle()
#34 /var/www/galette/galette/vendor/slim/slim/Slim/App.php(183): Slim\App->handle()
#35 /var/www/galette/galette/includes/main.inc.php(244): Slim\App->run()
#36 /var/www/galette/galette/webroot/index.php(57): require_once('...')
#37 {main}
127.0.0.1 - 2023-10-12 12:11:47 - DEBUG - [GaletteObjectsLend\Entity\ObjectPicture] Filename and extension are OK, proceed.
127.0.0.1 - 2023-10-12 12:11:47 - DEBUG - [GaletteObjectsLend\Entity\ObjectPicture] Filesize is OK, proceed
127.0.0.1 - 2023-10-12 12:11:47 - DEBUG - [GaletteObjectsLend\Entity\ObjectPicture] Mimetype is allowed, proceed
127.0.0.1 - 2023-10-12 12:11:47 - ERROR - Unable to remove picture database entry for
127.0.0.1 - 2023-10-12 12:11:47 - ERROR - An error occurred storing picture in database: Statement could not be executed (23000 - 1048 - Column 'object_id' cannot be null)

Actions

Copier le lien

Mis à jour par Johan Cwiklinski il y a 7 mois

There are 2 issues here:
1- issue at creation when no status is defined (or a bad one)
2- issue at creation with image (object is not yeat created or its ID is not properly fetched)

For the 1st one, message from my demo test is more clear:

91.121.109.132 - 2023-10-12 12:34:49 - ERROR - Something went wrong :'( | SQLSTATE[23503]: Foreign key violation: 7 ERROR:  insert or update on table "galettedemo_lend_rents" violates foreign key constraint "galettedemo_lend_rents_status_id_fkey" 
DETAIL:  Key (status_id)=(-1) is not present in table "galettedemo_lend_status".

Actions

Copier le lien