Error when editing products

[cwells]

If I create a product, leave the price blank, then go back and try to
set the price, I get the following:

Traceback (most recent call last):
File "/var/www/virtual/twisty-designs.com/lib/python2.4/site-packages/
django/core/handlers/base.py" in get_response
77. response = callback(request, *callback_args, **callback_kwargs)
File "/var/www/virtual/twisty-designs.com/lib/python2.4/site-packages/
django/contrib/admin/views/decorators.py" in _checklogin
55. return view_func(request, *args, **kwargs)
File "/var/www/virtual/twisty-designs.com/lib/python2.4/site-packages/
django/views/decorators/cache.py" in _wrapped_view_func
39. response = view_func(request, *args, **kwargs)
File "/var/www/virtual/twisty-designs.com/lib/python2.4/site-packages/
django/contrib/admin/views/main.py" in change_stage
336. new_object = manipulator.save(new_data)
File "/var/www/virtual/twisty-designs.com/lib/python2.4/site-packages/
django/db/models/manipulators.py" in save
202. new_rel_obj.save()
File "/var/www/virtual/twisty-designs.com/lib/python2.4/site-packages/
satchmo/product/models.py" in save
651. if prices.exclude(id=self.id).count():
File "/var/www/virtual/twisty-designs.com/lib/python2.4/site-packages/
django/db/models/query.py" in count
242. cursor.execute("SELECT COUNT(*)" + sql, params)
File "/var/www/virtual/twisty-designs.com/lib/python2.4/site-packages/
django/db/backends/util.py" in execute
19. return self.cursor.execute(sql, params)

ProgrammingError at /admin/product/product/8/
invalid input syntax for integer: ""

The post data is as follows:

weight u''
height u''
meta u''
full_name u'Nginx Logo T-shirt (Medium, white)'
productimage.0.caption u''
productattribute.0.id u''
taxClass u''
price.0.id u''
productimage.0.id u''
width u''
items_in_stock u'100'
short_description u''
price.0.quantity u'1'
description u''
productattribute.0.value u''
price.0.expires u''
active u'on'
date_added u'2007-08-06'
productimage.0.sort u''
slug u'nginx-logo-t-shirt-medium-white'
price.0.price u'15.00'
length u''
productattribute.0.name u''
productimage.0.picture u''

If you need any more info, let me know.

Regards,
Cliff

[Bruce Kroeze]

I can't reproduce that, Cliff.  Could you give a step-by-step?

[cwells]

Hi Bruce,

Here's the steps:

1. Add new product.
2. Set the following attributes: name, slug, date added, number in
stock. Leave all other options at defaults. (I'm not setting
category, description, etc as this product is a variation).
3. Save

Note that at this point on the products listing, the price is
currently displayed as None.

4) Edit the product, change the price to 15 (or any value) and save.
5) See the traceback.

Just FYI, this is on PostgreSQL via psycopg2.

Regards,
Cliff

On Aug 6, 11:40 am, "Bruce Kroeze" <bkro...@gmail.com> wrote:
> I can't reproduce that, Cliff. Could you give a step-by-step?
>

[Chris Moffitt]

This may be ticket #91.  Does the proposed change fix it?

-Chris

[cwells]

Sorry it took so long to reply, but yes, this seems to solve the
issue.

Thanks