THELIA Forum

Welcome to the THELIA support and discusssion forum

Announcement

Rejoignez la communauté sur le Discord Thelia : https://discord.gg/YgwpYEE3y3

Offline


J'ai un petit soucis sur Thelia qui se produit de façon de très étrange, n'ayant pas l'intégralité de la requête SQL je ne vois pas très bien d'ou pourrait venir le problème.
Cela se produit lors du paiement (order/pay) :

Exception: Propel\Runtime\Exception\PropelException
Message: Unable to execute INSERT statement [INSERT INTO `order_version` (`ID`, `REF`, `CUSTOMER_ID`, `INVOICE_ORDER_ADDRESS_ID`, `DELIVERY_ORDER_ADDRESS_ID`, `CURRENCY_ID`, `CURRENCY_RATE`, `DISCOUNT`, `POSTAGE`, `POSTAGE_TAX`, `POSTAGE_TAX_RULE_TITLE`, `PAYMENT_MODULE_ID`, `DELIVERY_MODULE_ID`, `STATUS_ID`, `LANG_ID`, `CART_ID`, `CREATED_AT`, `UPDATED_AT`, `VERSION`, `VERSION_CREATED_AT`, `CUSTOMER_ID_VERSION`) VALUES (:p0, :p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :p11, :p12, :p13, :p14, :p15, :p16, :p17, :p18, :p19, :p20)]
Code: 0
File: /srv/files/monsite/core/lib/Thelia/Model/Base/OrderVersion.php
Date: 11-12-2015 17:31:49

#0 /srv/files/www.monsite.com/core/lib/Thelia/Model/Base/OrderVersion.php(1712): Thelia\Model\Base\OrderVersion->doInsert(Object(Propel\Runtime\Connection\ConnectionWrapper))
#1 /srv/files/www.monsite.com/core/lib/Thelia/Model/Base/OrderVersion.php(1660): Thelia\Model\Base\OrderVersion->doSave(Object(Propel\Runtime\Connection\ConnectionWrapper))
#2 /srv/files/www.monsite.com/core/lib/Thelia/Model/Base/Order.php(3982): Thelia\Model\Base\OrderVersion->save(Object(Propel\Runtime\Connection\ConnectionWrapper))
#3 /srv/files/www.monsite.com/core/lib/Thelia/Model/Base/Order.php(1802): Thelia\Model\Base\Order->addVersion(Object(Propel\Runtime\Connection\ConnectionWrapper))
#4 /srv/files/www.monsite.com/core/lib/Thelia/Action/Order.php(236): Thelia\Model\Base\Order->save(Object(Propel\Runtime\Connection\ConnectionWrapper))
#5 /srv/files/www.monsite.com/core/lib/Thelia/Action/Order.php(407): Thelia\Action\Order->createOrder(Object(Symfony\Component\EventDispatcher\ContainerAwareEventDispatcher), Object(Thelia\Model\Order), Object(Thelia\Model\Currency), Object(Thelia\Model\Lang), Object(Thelia\Model\Cart), Object(Thelia\Model\Customer), true)
#6 [internal function]: Thelia\Action\Order->create(Object(Thelia\Core\Event\Order\OrderEvent))
#7 /srv/files/www.monsite.com/core/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/EventDispatcher.php(164): call_user_func(Array, Object(Thelia\Core\Event\Order\OrderEvent))
#8 /srv/files/www.monsite.com/core/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/EventDispatcher.php(53): Symfony\Component\EventDispatcher\EventDispatcher->doDispatch(Array, 'action.order.pa...', Object(Thelia\Core\Event\Order\OrderEvent))
#9 /srv/files/www.monsite.com/core/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/ContainerAwareEventDispatcher.php(167): Symfony\Component\EventDispatcher\EventDispatcher->dispatch('action.order.pa...', Object(Thelia\Core\Event\Order\OrderEvent))
#10 /srv/files/www.monsite.com/local/modules/Front/Controller/OrderController.php(341): Symfony\Component\EventDispatcher\ContainerAwareEventDispatcher->dispatch('action.order.pa...', Object(Thelia\Core\Event\Order\OrderEvent))
#11 [internal function]: Front\Controller\OrderController->pay()
#12 /srv/files/www.monsite.com/core/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpKernel.php(117): call_user_func_array(Array, Array)
#13 /srv/files/www.monsite.com/core/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpKernel.php(61): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Thelia\Core\HttpFoundation\Request), 1)
#14 /srv/files/www.monsite.com/core/lib/Thelia/Core/TheliaHttpKernel.php(77): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Thelia\Core\HttpFoundation\Request), 1, true)
#15 /srv/files/www.monsite.com/core/lib/Thelia/Core/Stack/ParamInitMiddleware.php(86): Thelia\Core\TheliaHttpKernel->handle(Object(Thelia\Core\HttpFoundation\Request), 1, true)
#16 /srv/files/www.monsite.com/core/lib/Thelia/Core/Stack/SessionMiddleware.php(80): Thelia\Core\Stack\ParamInitMiddleware->handle(Object(Thelia\Core\HttpFoundation\Request), 1, true)
#17 /srv/files/www.monsite.com/core/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Thelia\Core\Stack\SessionMiddleware->handle(Object(Thelia\Core\HttpFoundation\Request), 1, true)
#18 /srv/files/www.monsite.com/core/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/Kernel.php(188): Stack\StackedHttpKernel->handle(Object(Thelia\Core\HttpFoundation\Request), 1, true)
#19 /srv/files/www.monsite.com/web/index.php(34): Symfony\Component\HttpKernel\Kernel->handle(Object(Thelia\Core\HttpFoundation\Request))
#20 {main}

Avez-vous une idée de ce qui pourrait provoquer cette erreur ?

Offline


Normalement, la cause primaire de l'exception (l'erreur sql, donc) se trouve après l'exception que tu nous donnes.


OpenStudio Toulouse