Hello all,
I have a ForeignKey that may be NULL in a table editable inline, see http://www.radix50.net/~ibr/mysite/myapp/models.py (the whole project with the data is available at http://www.radix50.net/~ibr/mysite.tar.gz ). When I fill in the first Price in the Admin Home -> Object page, saving results in the error below. Sometimes (when I change something) I get an error message about aborted transaction with similar symptoms (myapp_attr.id being ''), the backtrace mentions Attr.__str__(). I tried django trunk 3709 and 4276. What is wrong? Thanks in advance, -- Baurzhan Ismagulov http://www.kz-easy.com/ ----- Forwarded message from [EMAIL PROTECTED] ----- Date: Wed, 03 Jan 2007 18:50:28 GMT From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [Django] Error (EXTERNAL IP): /mysite-admin/myapp/object/2/ Traceback (most recent call last): File "/home/ibr/tmp/w/h/kz-ez/download/django/django/trunk/django/core/handlers/base.py", line 77, in get_response response = callback(request, *callback_args, **callback_kwargs) File "/home/ibr/tmp/w/h/kz-ez/download/django/django/trunk/django/contrib/admin/views/decorators.py", line 55, in _checklogin return view_func(request, *args, **kwargs) File "/home/ibr/tmp/w/h/kz-ez/download/django/django/trunk/django/views/decorators/cache.py", line 39, in _wrapped_view_func response = view_func(request, *args, **kwargs) File "/home/ibr/tmp/w/h/kz-ez/download/django/django/trunk/django/contrib/admin/views/main.py", line 329, in change_stage new_object = manipulator.save(new_data) File "/home/ibr/tmp/w/h/kz-ez/download/django/django/trunk/django/db/models/manipulators.py", line 209, in save self.fields_added.append('%s "%s"' % (related.opts.verbose_name, new_rel_obj)) File "/home/ibr/tmp/w/h/kz-ez/mysite/myapp/models.py", line 42, in __str__ if self.attr: File "/home/ibr/tmp/w/h/kz-ez/download/django/django/trunk/django/db/models/fields/related.py", line 171, in __get__ rel_obj = self.field.rel.to._default_manager.get(**params) File "/home/ibr/tmp/w/h/kz-ez/download/django/django/trunk/django/db/models/manager.py", line 67, in get return self.get_query_set().get(*args, **kwargs) File "/home/ibr/tmp/w/h/kz-ez/download/django/django/trunk/django/db/models/query.py", line 211, in get obj_list = list(clone) File "/home/ibr/tmp/w/h/kz-ez/download/django/django/trunk/django/db/models/query.py", line 103, in __iter__ return iter(self._get_data()) File "/home/ibr/tmp/w/h/kz-ez/download/django/django/trunk/django/db/models/query.py", line 430, in _get_data self._result_cache = list(self.iterator()) File "/home/ibr/tmp/w/h/kz-ez/download/django/django/trunk/django/db/models/query.py", line 172, in iterator cursor.execute("SELECT " + (self._distinct and "DISTINCT " or "") + ",".join(select) + sql, params) File "/home/ibr/tmp/w/h/kz-ez/download/django/django/trunk/django/db/backends/postgresql/base.py", line 43, in execute return self.cursor.execute(sql, [smart_basestring(p, self.charset) for p in params]) ProgrammingError: ERROR: invalid input syntax for integer: "" SELECT "myapp_attr"."id","myapp_attr"."slug","myapp_attr"."description" FROM "myapp_attr" WHERE ("myapp_attr"."id" = '') <ModPythonRequest path:/mysite-admin/myapp/object/2/, GET:<MultiValueDict: {}>, POST:<MultiValueDict: {'description': ['obj2'], 'price.0.cents': ['0'], 'price.0.t': ['2'], 'price.0.attr': [''], 'price.0.dollars': ['2'], 'price.0.id': [''], 'slug': ['obj2']}>, COOKIES:{'sessionid': 'b5acb55462fc026c69438a56e9a8eb85'}, META:{'AUTH_TYPE': None, 'CONTENT_LENGTH': 0L, 'CONTENT_TYPE': None, 'GATEWAY_INTERFACE': 'CGI/1.1', 'HTTP_ACCEPT': 'text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5', 'HTTP_ACCEPT_CHARSET': 'KOI8-R,utf-8;q=0.7,*;q=0.7', 'HTTP_ACCEPT_ENCODING': 'gzip,deflate', 'HTTP_CONNECTION': 'keep-alive', 'HTTP_CONTENT_LENGTH': '98', 'HTTP_CONTENT_TYPE': 'application/x-www-form-urlencoded', 'HTTP_COOKIE': 'sessionid=b5acb55462fc026c69438a56e9a8eb85', 'HTTP_HOST': 'medeu', 'HTTP_KEEP_ALIVE': '300', 'HTTP_REFERER': 'http://medeu/mysite-admin/myapp/object/2/', 'HTTP_USER_AGENT': 'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.8) Gecko/20060926 Debian/1.7.8-1sarge7.3.1', 'PATH_INFO': '/myapp/object/2/', 'PATH_TRANSLATED': None, 'QUERY_STRING': None, 'REMOTE_ADDR': '192.168.0.7', 'REMOTE_HOST': None, 'REMOTE_IDENT': None, 'REMOTE_USER': None, 'REQUEST_METHOD': 'POST', 'SCRIPT_NAME': None, 'SERVER_NAME': 'medeu.radix50.net', 'SERVER_PORT': 0, 'SERVER_PROTOCOL': 'HTTP/1.1', 'SERVER_SOFTWARE': 'mod_python'}> ----- End forwarded message ----- --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---