THELIA Forum

Welcome to the THELIA support and discusssion forum

Announcement

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

Offline

#1 erreur cote Back [2.0.3]

(29-07-2014 12:39:16)


Bonjour,

Cote back, lorsque l'on veut changer le statut d'une commande, on obtient une erreur
(commande non payee -> payée)

1: INFO [ConnectionWrapper.php:log()] {653} 2014-07-29 13:31:48: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='session_config.save_path' LIMIT 1
2: INFO [ConnectionWrapper.php:log()] {653} 2014-07-29 13:31:48: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='rewriting_enable' LIMIT 1
3: INFO [ConnectionWrapper.php:log()] {653} 2014-07-29 13:31:48: SELECT `ID`, `REF`, `CUSTOMER_ID`, `INVOICE_ORDER_ADDRESS_ID`, `DELIVERY_ORDER_ADDRESS_ID`, `INVOICE_DATE`, `CURRENCY_ID`, `CURRENCY_RATE`, `TRANSACTION_REF`, `DELIVERY_REF`, `INVOICE_REF`, `DISCOUNT`, `POSTAGE`, `PAYMENT_MODULE_ID`, `DELIVERY_MODULE_ID`, `STATUS_ID`, `LANG_ID`, `CREATED_AT`, `UPDATED_AT`, `VERSION`, `VERSION_CREATED_AT`, `VERSION_CREATED_BY` FROM `order` WHERE `ID` = '135'
4: INFO [ConnectionWrapper.php:log()] {653} 2014-07-29 13:31:48: SELECT `ID`, `CODE`, `CREATED_AT`, `UPDATED_AT` FROM `order_status` WHERE `ID` = '2'
5: INFO [ConnectionWrapper.php:log()] {653} 2014-07-29 13:31:48: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='asset_dir_from_web_root' LIMIT 1
6: INFO [ConnectionWrapper.php:log()] {653} 2014-07-29 13:31:48: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='smtp.enabled' LIMIT 1
7: INFO [ConnectionWrapper.php:log()] {653} 2014-07-29 13:31:48: SELECT order_version.ID, order_version.REF, order_version.CUSTOMER_ID, order_version.INVOICE_ORDER_ADDRESS_ID, order_version.DELIVERY_ORDER_ADDRESS_ID, order_version.INVOICE_DATE, order_version.CURRENCY_ID, order_version.CURRENCY_RATE, order_version.TRANSACTION_REF, order_version.DELIVERY_REF, order_version.INVOICE_REF, order_version.DISCOUNT, order_version.POSTAGE, order_version.PAYMENT_MODULE_ID, order_version.DELIVERY_MODULE_ID, order_version.STATUS_ID, order_version.LANG_ID, order_version.CREATED_AT, order_version.UPDATED_AT, order_version.VERSION, order_version.VERSION_CREATED_AT, order_version.VERSION_CREATED_BY FROM `order_version` WHERE order_version.ID=135 ORDER BY order_version.VERSION DESC LIMIT 1
8: INFO [ConnectionWrapper.php:log()] {653} 2014-07-29 13:31:48: UPDATE `order` SET `STATUS_ID`=2, `UPDATED_AT`='2014-07-29 13:31:48', `VERSION`=2, `VERSION_CREATED_AT`='2014-07-29 13:31:48' WHERE order.ID=135
9: INFO [ConnectionWrapper.php:log()] {653} 2014-07-29 13:31:48: SELECT order_version.ID, order_version.REF, order_version.CUSTOMER_ID, order_version.INVOICE_ORDER_ADDRESS_ID, order_version.DELIVERY_ORDER_ADDRESS_ID, order_version.INVOICE_DATE, order_version.CURRENCY_ID, order_version.CURRENCY_RATE, order_version.TRANSACTION_REF, order_version.DELIVERY_REF, order_version.INVOICE_REF, order_version.DISCOUNT, order_version.POSTAGE, order_version.PAYMENT_MODULE_ID, order_version.DELIVERY_MODULE_ID, order_version.STATUS_ID, order_version.LANG_ID, order_version.CREATED_AT, order_version.UPDATED_AT, order_version.VERSION, order_version.VERSION_CREATED_AT, order_version.VERSION_CREATED_BY FROM `order_version` WHERE order_version.ID=135 ORDER BY order_version.VERSION DESC LIMIT 1
10: INFO [ConnectionWrapper.php:log()] {653} 2014-07-29 13:31:48: UPDATE `order` SET `INVOICE_DATE`='2014-07-29', `UPDATED_AT`='2014-07-29 13:31:48', `VERSION_CREATED_AT`='2014-07-29 13:31:48' WHERE order.ID=135
11: INFO [ConnectionWrapper.php:log()] {653} 2014-07-29 13:31:48: INSERT INTO `order_version` (`ID`, `REF`, `CUSTOMER_ID`, `INVOICE_ORDER_ADDRESS_ID`, `DELIVERY_ORDER_ADDRESS_ID`, `INVOICE_DATE`, `CURRENCY_ID`, `CURRENCY_RATE`, `INVOICE_REF`, `DISCOUNT`, `POSTAGE`, `PAYMENT_MODULE_ID`, `DELIVERY_MODULE_ID`, `STATUS_ID`, `LANG_ID`, `CREATED_AT`, `UPDATED_AT`, `VERSION`, `VERSION_CREATED_AT`) VALUES (135, 'O-14/000135', 1, 276, 275, '2014-07-29 13:31:48', 1, 1, 'I-14/000135', 18, 7.36000000000000031974423109204508364200592041015625, 3, 2, 2, 1, '2014-07-29 11:40:48', '2014-07-29 13:31:48', 2, '2014-07-29 13:31:48')
12: ERROR [Propel.php:log()] {284} 2014-07-29 13:31:48: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '135-2' for key 'PRIMARY'

Edit:
Cela genere cette erreur que si on veut passer en 'Payée'
avec les autres choix aucun probleme

Last edited by zzuutt (29-07-2014 13:22:57)

Offline

#2 Re: erreur cote Back [2.0.3]

(29-07-2014 13:44:55)


Je crois que c'est corrigé en 2.0.3: https://github.com/thelia/thelia/pull/555


OpenStudio Toulouse

Offline

#3 Re: erreur cote Back [2.0.3]

(29-07-2014 14:10:31)


Parfait!!!!

Last edited by zzuutt (29-07-2014 14:14:42)