Błąd w podsumowaniu zakupu.

Data zgłoszenia: 16 12 2010

Status: Rozwiazany

Wersja systemu: 0.9.2154

Priorytet: Wysoki

Autor: viktor455

Po zatwierdzeniu zakupu przesłanego mailem, gdy wchodzę na swoje konto i sprawdzam zakładkę “zamówienia klienta” pojawia się błąd: Could not execute query [Native Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘AES_DECRYPT(companyname, ‘9173fe19a12b085811318a218e86d141’) as companyname, ‘ at line 13] [User Info: SELECT OST.name as orderstatusname, O.idorder, O.adddate as orderdate, O.dispatchmethodname, O.paymentmethodname, O.dispatchmethodprice, O.globalprice, O.price, O.globalpricenetto, AES_DECRYPT(firstname, ‘9173fe19a12b085811318a218e86d141’) as firstname, AES_DECRYPT(surname, ‘9173fe19a12b085811318a218e86d141’) as surname, AES_DECRYPT(email, ‘9173fe19a12b085811318a218e86d141’) as email, AES_DECRYPT(street, ‘9173fe19a12b085811318a218e86d141’) as street, AES_DECRYPT(streetno, ‘9173fe19a12b085811318a218e86d141’) as streetno, AES_DECRYPT(placeno, ‘9173fe19a12b085811318a218e86d141’) as placeno, AES_DECRYPT(phone, ‘9173fe19a12b085811318a218e86d141’) as phone, AES_DECRYPT(place, ‘9173fe19a12b085811318a218e86d141’) as placename, AES_DECRYPT(postcode, ‘9173fe19a12b085811318a218e86d141’) as postcode AES_DECRYPT(companyname, ‘9173fe19a12b085811318a218e86d141’) as companyname, AES_DECRYPT(nip, ‘9173fe19a12b085811318a218e86d141’) as nip, FROM `order` O LEFT JOIN orderclientdata OCD ON OCD.orderid=O.idorder LEFT JOIN orderstatus OS ON OS.idorderstatus=O.orderstatusid LEFT JOIN orderstatustranslation OST ON OST.orderstatusid=OS.idorderstatus WHERE O.clientid= 7 AND idorder= ‘0’]



Komentarze

Dodaj swój komentarz