Yeah that looks like the case. This cart has a lot of option groups per product. I am guessing those are generating keys longer than 60.
I suppose I can just change that in the models and rerun sync db. Or if there is a better fix I am open. Suggestions welcome. Thanks, Matt On Jan 17, 7:37 pm, mattym <[email protected]> wrote: > 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.
