Hi Chris, Seems to me like a similar error. But doesnt seem to be solved fully.
I am using mysql (utf8_unicode_ci), satchmo (1920) django (9759). I am getting error after I click 'purchase items' button. Thanks, Shakthi On Mon, Jan 26, 2009 at 10:35 AM, Chris Moffitt <[email protected]> wrote: > Which version of Satchmo are you using? I believe we fixed this here - > http://www.satchmoproject.com/trac/ticket/661 > > -Chris > > > On Sun, Jan 25, 2009 at 10:10 PM, Shankar Dhanasekaran < > [email protected]> wrote: > >> Hi >> excuse me for pasting the code in the email, for some reason dpaste was >> not giving me an url to post this. >> >> I am getting template syntax error after clicking confirm payment. >> >> the error is: >> >> >> >> >> TemplateSyntaxError at /shop/checkout/dummy/success/ >> >> Caught an exception while rendering: Truncated incorrect DOUBLE value: >> '0E-10' >> >> Original Traceback (most recent call last): >> File "/home/shankar/src/django-trunk/django/template/debug.py", line 71, >> in render_node >> result = node.render(context) >> File "/home/shankar/src/django-trunk/django/template/defaulttags.py", >> line 129, in render >> len_values = len(values) >> File "/home/shankar/src/django-trunk/django/db/models/query.py", line >> 161, in __len__ >> self._result_cache = list(self.iterator()) >> File "/home/shankar/src/django-trunk/django/db/models/query.py", line >> 281, in iterator >> for row in self.query.results_iter(): >> File "/home/shankar/src/django-trunk/django/db/models/sql/query.py", line >> 238, in results_iter >> for rows in self.execute_sql(MULTI): >> File "/home/shankar/src/django-trunk/django/db/models/sql/query.py", line >> 1934, in execute_sql >> cursor.execute(sql, params) >> File "/home/shankar/src/django-trunk/django/db/backends/util.py", line >> 19, in execute >> return self.cursor.execute(sql, params) >> File "/home/shankar/src/django-trunk/django/db/backends/mysql/base.py", >> line 83, in execute >> return self.cursor.execute(query, args) >> File "/usr/lib/python2.5/site-packages/MySQLdb/cursors.py", line 168, in >> execute >> if not self._defer_warnings: self._warning_check() >> File "/usr/lib/python2.5/site-packages/MySQLdb/cursors.py", line 82, in >> _warning_check >> warn(w[-1], self.Warning, 3) >> File "/usr/lib/python2.5/warnings.py", line 62, in warn >> globals) >> File "/usr/lib/python2.5/warnings.py", line 102, in warn_explicit >> raise message >> Warning: Truncated incorrect DOUBLE value: '0E-10' >> >> Request Method: GET >> Request URL: http://127.0.0.1:8000/shop/checkout/dummy/success/ >> Exception Type: TemplateSyntaxError >> Exception Value: >> >> Caught an exception while rendering: Truncated incorrect DOUBLE value: >> '0E-10' >> >> Original Traceback (most recent call last): >> File "/home/shankar/src/django-trunk/django/template/debug.py", line 71, >> in render_node >> result = node.render(context) >> File "/home/shankar/src/django-trunk/django/template/defaulttags.py", >> line 129, in render >> len_values = len(values) >> File "/home/shankar/src/django-trunk/django/db/models/query.py", line >> 161, in __len__ >> self._result_cache = list(self.iterator()) >> File "/home/shankar/src/django-trunk/django/db/models/query.py", line >> 281, in iterator >> for row in self.query.results_iter(): >> File "/home/shankar/src/django-trunk/django/db/models/sql/query.py", line >> 238, in results_iter >> for rows in self.execute_sql(MULTI): >> File "/home/shankar/src/django-trunk/django/db/models/sql/query.py", line >> 1934, in execute_sql >> cursor.execute(sql, params) >> File "/home/shankar/src/django-trunk/django/db/backends/util.py", line >> 19, in execute >> return self.cursor.execute(sql, params) >> File "/home/shankar/src/django-trunk/django/db/backends/mysql/base.py", >> line 83, in execute >> return self.cursor.execute(query, args) >> File "/usr/lib/python2.5/site-packages/MySQLdb/cursors.py", line 168, in >> execute >> if not self._defer_warnings: self._warning_check() >> File "/usr/lib/python2.5/site-packages/MySQLdb/cursors.py", line 82, in >> _warning_check >> warn(w[-1], self.Warning, 3) >> File "/usr/lib/python2.5/warnings.py", line 62, in warn >> globals) >> File "/usr/lib/python2.5/warnings.py", line 102, in warn_explicit >> raise message >> Warning: Truncated incorrect DOUBLE value: '0E-10' >> >> Exception Location: >> /home/shankar/src/django-trunk/django/template/debug.py in render_node, line >> 81 >> Python Executable: /usr/bin/python >> Python Version: 2.5.2 >> Python Path: ['/home/shankar/Codes/visvakarma', '/usr/lib/python25.zip', >> '/usr/lib/python2.5', '/usr/lib/python2.5/plat-linux2', >> '/usr/lib/python2.5/lib-tk', '/usr/lib/python2.5/lib-dynload', >> '/usr/lib/python2.5/site-packages', >> '/usr/lib/python2.5/site-packages/Numeric', >> '/usr/lib/python2.5/site-packages/PIL', '/home/shankar/src/django-trunk', >> '/home/shankar/src/django-app-plugins', >> '/home/shankar/src/django-registration', '/home/shankar/src/typogrify', >> '/usr/lib/python2.5/site-packages/gst-0.10', >> '/usr/lib/python2.5/site-packages/gtk-2.0', >> '/home/shankar/src/satchmo-trunk/satchmo/apps', >> '/home/shankar/src/sorl-thumbnail', '/home/shankar/src/threaded_multihost', >> '/home/shankar/src/trml2pdf', '/usr/lib/python2.5/site-packages', >> '/usr/lib/python2.5/site-packages/scim-0.1', '../../apps', '.'] >> Server time: Sun, 25 Jan 2009 19:34:57 -0800 >> Template error >> >> In template >> /home/shankar/src/satchmo-trunk/satchmo/apps/payment/templates/payment/_order_payment_summary.html, >> error at line 4 >> Caught an exception while rendering: Truncated incorrect DOUBLE value: >> '0E-10' >> 1 {% load i18n %} >> 2 {% load satchmo_currency %} >> 3 {% load satchmo_checkout %} >> *4 {% for payment in order.payments_completed %}* >> 5 {% if forloop.first %} >> 6 <h4>{% trans 'Paid' %}</h4> >> 7 {% endif %} >> 8 {{ payment.time_stamp|date:"y-M-d H:i" }} {{ >> payment.payment|payment_label }} - {{ payment.amount|currency }}<br/> >> 9 {% if forloop.last %} >> 10 {% with order.balance|currency as balance %} >> 11 {% blocktrans %}Balance = {{ balance }} {% endblocktrans %} >> 12 {% endwith %} >> 13 {% endif %} >> 14 {% if paylink and not order.paid_in_full %} >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Satchmo users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/satchmo-users?hl=en -~----------~----~----~----~------~----~------~--~---
