Go ahead and submit a ticket. We'll take a look at it. -Chris
On Tue, Jan 18, 2011 at 2:35 AM, mattym <[email protected]> wrote: > Changing the 'key' property of the ProductPriceLookup model to > max_length=200 - along with the associated column in the postgre db > table, product_productpricelookup - fixed the issue. > > Basically configurable products that have enough options to generate a > key over 60 characters will cause satchmo_rebuild_pricing to choke > when at line 48 of satchmo_rebuild_pricing.py > > As stated I am on satchmo 0.9.0, but if this property is still this > small in the current versions, and this is viewed as a bug, I am happy > to submit a fix. > > > On Jan 17, 7:49 pm, mattym <[email protected]> wrote: > > 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]<satchmo-users%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/satchmo-users?hl=en. > > -- 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.
