After some grep action my guess is that a value greater than 60 got entered into the "key" field of model, ProductPriceLookup. I am not quite sure how to track this down, but just typing this out is giving me ideas :)
Too be continued... On Jan 17, 6:25 pm, mattym <[email protected]> wrote: > Hi All - > > A client started populating his cart with configurable products and > did something in a strange order. Now after we create a product and > run rebuild pricing we get the following error: > > psycopg2.DataError: value too long for type character varying(60) > > We are also emailed the following errors > > ValueError: invalid literal for int() with base 10: '18553/js/ > jquery.validate.min.js' > > This is on satchmo 0.9.0. I was able to create products fine. But now > the client is stuck. > > Has anyone seen this before? Thanks > > Traceback below: > > Adding 589 products > Traceback (most recent call last): > File "manage.py", line 27, in <module> > execute_manager(settings) > File "/home/hiiq/webapps/myshop2/lib/python2.5/django/core/ > management/__init__.py", line 362, in execute_manager > utility.execute() > File "/home/hiiq/webapps/myshop2/lib/python2.5/django/core/ > management/__init__.py", line 303, in execute > self.fetch_command(subcommand).run_from_argv(self.argv) > File "/home/hiiq/webapps/myshop2/lib/python2.5/django/core/ > management/base.py", line 195, in run_from_argv > self.execute(*args, **options.__dict__) > File "/home/hiiq/webapps/myshop2/lib/python2.5/django/core/ > management/base.py", line 222, in execute > output = self.handle(*args, **options) > File "/home/hiiq/webapps/myshop2/lib/python2.5/Satchmo-0.9_0- > py2.5.egg/product/management/commands/satchmo_rebuild_pricing.py", > line 48, in handle > prices = > ProductPriceLookup.objects.smart_create_for_product(product) > File "/home/hiiq/webapps/myshop2/lib/python2.5/Satchmo-0.9_0- > py2.5.egg/product/models.py", line 2013, in smart_create_for_product > return self.create_for_configurableproduct(product) > File "/home/hiiq/webapps/myshop2/lib/python2.5/Satchmo-0.9_0- > py2.5.egg/product/models.py", line 1966, in > create_for_configurableproduct > objs.extend(self.create_for_variation(pv, configproduct)) > File "/home/hiiq/webapps/myshop2/lib/python2.5/Satchmo-0.9_0- > py2.5.egg/product/models.py", line 1988, in create_for_variation > obj.save() > File "/home/hiiq/webapps/myshop2/lib/python2.5/django/db/models/ > base.py", line 410, in save > self.save_base(force_insert=force_insert, > force_update=force_update) > File "/home/hiiq/webapps/myshop2/lib/python2.5/django/db/models/ > base.py", line 495, in save_base > result = manager._insert(values, return_id=update_pk) > File "/home/hiiq/webapps/myshop2/lib/python2.5/django/db/models/ > manager.py", line 177, in _insert > return insert_query(self.model, values, **kwargs) > File "/home/hiiq/webapps/myshop2/lib/python2.5/django/db/models/ > query.py", line 1087, in insert_query > return query.execute_sql(return_id) > File "/home/hiiq/webapps/myshop2/lib/python2.5/django/db/models/sql/ > subqueries.py", line 320, in execute_sql > cursor = super(InsertQuery, self).execute_sql(None) > File "/home/hiiq/webapps/myshop2/lib/python2.5/django/db/models/sql/ > query.py", line 2369, in execute_sql > cursor.execute(sql, params) > psycopg2.DataError: value too long for type character varying(60) -- 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.
