templatesyntax error

[Shankar Dhanasekaran]

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 %}

[Chris Moffitt]

Which version of Satchmo are you using? I believe we fixed this here -
http://www.satchmoproject.com/trac/ticket/661

-Chris

[Shankar Dhanasekaran]

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