Hi I'd first look at your design. Depending on the database being used you'll likely be hitting a limit on the width of a row or the size of a query. Every database has different limits some more than others but all have limits to the size of queries and the size of rows returned.
If you want to share more detail about these extra fields and why there are so many we might be able to suggest other approaches. Regards, Shaun Laughey. On 24 September 2010 10:26, Hobica Bobjob <hobicabob...@gmail.com> wrote: > I made a custom product which extends the base product by 54 fields. I > have 11,108 of these products entered (although that's just for the > test, the final version should hold around 35,000). > > They are all in the same category. When I pull up the category, I get > the error "Too many SQL Variables". > > Specifically, the problem occurs here: > > python manage.py shell> > ... > category = Category.objects.get_by_site(slug="myproduct") > product_list = list(category.active_products()) > sale = find_best_auto_discount(product_list) > > Traceback (most recent call last): > File "<console>", line 1, in <module> > File > "/usr/local/lib/python2.6/dist-packages/Satchmo-0.9_2-py2.6.egg/product/utils.py", > line 35, in find_best_auto_discount > if len(discs) > 0: > File "/usr/lib/pymodules/python2.6/django/db/models/query.py", line > 81, in __len__ > self._result_cache = list(self.iterator()) > File "/usr/lib/pymodules/python2.6/django/db/models/query.py", line > 269, in iterator > for row in compiler.results_iter(): > File "/usr/lib/pymodules/python2.6/django/db/models/sql/compiler.py", > line 672, in results_iter > for rows in self.execute_sql(MULTI): > File "/usr/lib/pymodules/python2.6/django/db/models/sql/compiler.py", > line 727, in execute_sql > cursor.execute(sql, params) > File "/usr/lib/pymodules/python2.6/django/db/backends/util.py", line > 15, in execute > return self.cursor.execute(sql, params) > File "/usr/lib/pymodules/python2.6/django/db/backends/sqlite3/base.py", > line 200, in execute > return Database.Cursor.execute(self, query, params) > DatabaseError: too many SQL variables > > How would I go about fixing this? > > Thanks in advance! > > On 9/6/10, > satchmo-users+nore...@googlegroups.com<satchmo-users%2bnore...@googlegroups.com> > <satchmo-users+nore...@googlegroups.com<satchmo-users%2bnore...@googlegroups.com>> > wrote: > > > ============================================================================= > > Today's Topic Summary > > > ============================================================================= > > > > Group: satchmo-users@googlegroups.com > > Url: http://groups.google.com/group/satchmo-users/topics > > > > - Users are only able to post one comment each per 'product' [1 Update] > > http://groups.google.com/group/satchmo-users/t/84ba3b812da1bed4 > > > > > > > ============================================================================= > > Topic: Users are only able to post one comment each per 'product' > > Url: http://groups.google.com/group/satchmo-users/t/84ba3b812da1bed4 > > > ============================================================================= > > > > ---------- 1 of 1 ---------- > > From: Alex Robbins <alexander.j.robb...@gmail.com> > > Date: Sep 05 10:16PM -0500 > > Url: http://groups.google.com/group/satchmo-users/msg/ddaf6e282babb64f > > > > My guess is that this has something to do with the productratings > > module. I think it makes sure that each user can only rate items one > > time. I don't remember if it uses comment moderation or a signal > > handler. It has been a little while since I looked at the code. > > > > Alex > > > > > > > > > > > > -- > > You received this message because you are subscribed to the Google Groups > > "Satchmo users" group. > > To post to this group, send email to satchmo-us...@googlegroups.com. > > To unsubscribe from this group, send email to > > satchmo-users+unsubscr...@googlegroups.com<satchmo-users%2bunsubscr...@googlegroups.com> > . > > 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 satchmo-us...@googlegroups.com. > To unsubscribe from this group, send email to > satchmo-users+unsubscr...@googlegroups.com<satchmo-users%2bunsubscr...@googlegroups.com> > . > 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 satchmo-us...@googlegroups.com. To unsubscribe from this group, send email to satchmo-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/satchmo-users?hl=en.
