THELIA Forum

Welcome to the THELIA support and discusssion forum

Announcement

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

Offline

#1 Bug version 2.0.2

(13-06-2014 10:45:13)

Bonjour,

je viens de passer en 2.0.2
cote back
j'ai un bug lorsque je veux afficher les details de la commande

2/2 PropelException: Unable to execute SELECT statement [SELECT order_coupon.ID, order_coupon.ORDER_ID, order_coupon.CODE, order_coupon.TYPE, order_coupon.AMOUNT, order_coupon.TITLE, order_coupon.SHORT_DESCRIPTION, order_coupon.DESCRIPTION, order_coupon.EXPIRATION_DATE, order_coupon.IS_CUMULATIVE, order_coupon.IS_REMOVING_POSTAGE, order_coupon.IS_AVAILABLE_ON_SPECIAL_OFFERS, order_coupon.SERIALIZED_CONDITIONS, order_coupon.PER_CUSTOMER_USAGE_COUNT, order_coupon.CREATED_AT, order_coupon.UPDATED_AT FROM `order_coupon` WHERE order_coupon.ORDER_ID=:p1 ORDER BY order_coupon.ID ASC LIMIT 2147483647]

    in /home/xxxxxx/www/shop/core/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php line 2442
    at Criteria->doSelect(object(ConnectionWrapper)) in /home/xxxxxx/www/shop/core/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php line 1821
    at ModelCriteria->doSelect(object(ConnectionWrapper)) in /home/xxxxxx/www/shop/core/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php line 975
    at ModelCriteria->find() in /home/xxxxxx/www/shop/core/lib/Thelia/Core/Template/Element/BaseLoop.php line 355
    at BaseLoop->searchWithOffset(object(OrderCouponQuery)) in /home/xxxxxx/www/shop/core/lib/Thelia/Core/Template/Element/BaseLoop.php line 307
    at BaseLoop->search(object(OrderCouponQuery), null) in /home/xxxxxx/www/shop/core/lib/Thelia/Core/Template/Element/BaseLoop.php line 423
    at BaseLoop->exec(null) in /home/xxxxxx/www/shop/core/lib/Thelia/Core/Template/Smarty/Plugins/TheliaLoop.php line 144
    at TheliaLoop->theliaLoop(array('type' => 'order_coupon', 'name' => 'couponcode', 'order' => '58'), null, object(Smarty_Internal_Template), true) in /home/xxxxxx/www/shop/cache/dev/smarty/compile/e3ac62958e631bfecc9e58724b26529290504156.file.order-edit.html.php line 566
    at content_539ac6dd190267_42595076(object(Smarty_Internal_Template)) in /home/xxxxxx/www/shop/core/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php line 180
    at Smarty_Internal_TemplateBase->fetch('file:order-edit.html') in /home/xxxxxx/www/shop/core/lib/Thelia/Core/Template/Smarty/SmartyParser.php line 231
    at SmartyParser->internalRenderer('file', 'order-edit.html', array('order_id' => '58', 'locale' => 'fr_FR', 'lang_code' => 'fr', 'lang_id' => '1', 'edit_language_id' => '1', 'edit_language_locale' => 'fr_FR', 'edit_currency_id' => '1', 'current_url' => 'http://www.zzuutt.com/shop/web/index_dev.php/admin/order/update/58')) in /home/xxxxxx/www/shop/core/lib/Thelia/Core/Template/Smarty/SmartyParser.php line 247
    at SmartyParser->render('order-edit.html', array('order_id' => '58', 'locale' => 'fr_FR', 'lang_code' => 'fr', 'lang_id' => '1', 'edit_language_id' => '1', 'edit_language_locale' => 'fr_FR', 'edit_currency_id' => '1', 'current_url' => 'http://www.zzuutt.com/shop/web/index_dev.php/admin/order/update/58')) in /home/xxxxxx/www/shop/core/lib/Thelia/Controller/Admin/BaseAdminController.php line 460
    at BaseAdminController->renderRaw('order-edit', array('order_id' => '58')) in /home/xxxxxx/www/shop/core/lib/Thelia/Controller/Admin/BaseAdminController.php line 406
    at BaseAdminController->render('order-edit', array('order_id' => '58')) in /home/xxxxxx/www/shop/core/lib/Thelia/Controller/Admin/OrderController.php line 47
    at OrderController->viewAction('58')
    at call_user_func_array(array(object(OrderController), 'viewAction'), array('58')) in /home/xxxxxx/www/shop/core/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpKernel.php line 129
    at HttpKernel->handleRaw(object(Request), '1') in /home/xxxxxx/www/shop/core/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpKernel.php line 73
    at HttpKernel->handle(object(Request), '1', true) in /home/xxxxxx/www/shop/core/lib/Thelia/Core/TheliaHttpKernel.php line 82
    at TheliaHttpKernel->handle(object(Request), '1', true) in /home/xxxxxx/www/shop/core/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/Kernel.php line 197
    at Kernel->handle(object(Request)) in /home/xxxxxx/www/shop/web/index_dev.php line 37

1/2 PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'order_coupon.PER_CUSTOMER_USAGE_COUNT' in 'field list'

    in /home/xxxxxx/www/shop/core/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php line 196
    at PDOStatement->execute(null) in /home/xxxxxx/www/shop/core/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php line 196
    at StatementWrapper->execute() in /home/xxxxxx/www/shop/core/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php line 2436
    at Criteria->doSelect(object(ConnectionWrapper)) in /home/xxxxxx/www/shop/core/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php line 1821
    at ModelCriteria->doSelect(object(ConnectionWrapper)) in /home/xxxxxx/www/shop/core/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php line 975
    at ModelCriteria->find() in /home/xxxxxx/www/shop/core/lib/Thelia/Core/Template/Element/BaseLoop.php line 355
    at BaseLoop->searchWithOffset(object(OrderCouponQuery)) in /home/xxxxxx/www/shop/core/lib/Thelia/Core/Template/Element/BaseLoop.php line 307
    at BaseLoop->search(object(OrderCouponQuery), null) in /home/xxxxxx/www/shop/core/lib/Thelia/Core/Template/Element/BaseLoop.php line 423
    at BaseLoop->exec(null) in /home/xxxxxx/www/shop/core/lib/Thelia/Core/Template/Smarty/Plugins/TheliaLoop.php line 144
    at TheliaLoop->theliaLoop(array('type' => 'order_coupon', 'name' => 'couponcode', 'order' => '58'), null, object(Smarty_Internal_Template), true) in /home/xxxxxx/www/shop/cache/dev/smarty/compile/e3ac62958e631bfecc9e58724b26529290504156.file.order-edit.html.php line 566
    at content_539ac6dd190267_42595076(object(Smarty_Internal_Template)) in /home/xxxxxx/www/shop/core/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php line 180
    at Smarty_Internal_TemplateBase->fetch('file:order-edit.html') in /home/xxxxxx/www/shop/core/lib/Thelia/Core/Template/Smarty/SmartyParser.php line 231
    at SmartyParser->internalRenderer('file', 'order-edit.html', array('order_id' => '58', 'locale' => 'fr_FR', 'lang_code' => 'fr', 'lang_id' => '1', 'edit_language_id' => '1', 'edit_language_locale' => 'fr_FR', 'edit_currency_id' => '1', 'current_url' => 'http://www.zzuutt.com/shop/web/index_dev.php/admin/order/update/58')) in /home/xxxxxx/www/shop/core/lib/Thelia/Core/Template/Smarty/SmartyParser.php line 247
    at SmartyParser->render('order-edit.html', array('order_id' => '58', 'locale' => 'fr_FR', 'lang_code' => 'fr', 'lang_id' => '1', 'edit_language_id' => '1', 'edit_language_locale' => 'fr_FR', 'edit_currency_id' => '1', 'current_url' => 'http://www.zzuutt.com/shop/web/index_dev.php/admin/order/update/58')) in /home/xxxxxx/www/shop/core/lib/Thelia/Controller/Admin/BaseAdminController.php line 460
    at BaseAdminController->renderRaw('order-edit', array('order_id' => '58')) in /home/xxxxxx/www/shop/core/lib/Thelia/Controller/Admin/BaseAdminController.php line 406
    at BaseAdminController->render('order-edit', array('order_id' => '58')) in /home/xxxxxx/www/shop/core/lib/Thelia/Controller/Admin/OrderController.php line 47
    at OrderController->viewAction('58')
    at call_user_func_array(array(object(OrderController), 'viewAction'), array('58')) in /home/xxxxxx/www/shop/core/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpKernel.php line 129
    at HttpKernel->handleRaw(object(Request), '1') in /home/xxxxxx/www/shop/core/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpKernel.php line 73
    at HttpKernel->handle(object(Request), '1', true) in /home/xxxxxx/www/shop/core/lib/Thelia/Core/TheliaHttpKernel.php line 82
    at TheliaHttpKernel->handle(object(Request), '1', true) in /home/xxxxxx/www/shop/core/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/Kernel.php line 197
    at Kernel->handle(object(Request)) in /home/xxxxxx/www/shop/web/index_dev.php line 37

vu que c'est lie au code promo
meme erreur pour acceder a outils/codes promo

Last edited by zzuutt (13-06-2014 10:48:10)

Offline

#2 Re: Bug version 2.0.2

(13-06-2014 11:06:56)

Column not found: 1054 Unknown column 'order_coupon.PER_CUSTOMER_USAGE_COUNT' in 'field list'

Cette colonne est ajoutée par le script SQL de mise à jour vers la 2.0.2 (setup/update/2.0.2.sql) :

ALTER TABLE `coupon` ADD `per_customer_usage_count` BOOLEAN NOT NULL DEFAULT FALSE AFTER `serialized_conditions`;
ALTER TABLE `order_coupon` ADD `per_customer_usage_count` BOOLEAN NOT NULL DEFAULT FALSE AFTER `serialized_conditions`;
ALTER TABLE `coupon_version` ADD `per_customer_usage_count` BOOLEAN NOT NULL DEFAULT FALSE AFTER `serialized_conditions`;

La mise à jour de la base de données n'est sans doute pas complète sur ton installation.

OpenStudio Toulouse

  • manu
  • faï tot petar miladiu

Offline

#3 Re: Bug version 2.0.2

(13-06-2014 11:08:23)

Tu as vidé ton cache ?

Je n'ai pas de soucis sur mon Thelia

http://doc.thelia.net/
http://thelia.net/modules
http://raynaud.io
PGP public Key : 0xC6E546A6

Offline

#4 Re: Bug version 2.0.2

(13-06-2014 11:09:19)

pourtant je n'ai pas eu d'erreur lors de l'update

je vais faire cette update des 3 lignes
via phpmyadmin

Offline

#5 Re: Bug version 2.0.2

(13-06-2014 11:13:46)

Manu oui j'ai vide avec les commande habituelles (comme indique dans update.md)
avant et apres update

par doute, j'ai execute le sql directement dans phpmyadmin

tout est ok

MERCI  wink

Last edited by zzuutt (13-06-2014 11:38:22)