some additional information: the SQL statement out of the postgres
logfile
SELECT
"users_artist"."id","users_artist"."name","users_artist"."abstract","users_artist"."logo","users_artist"."image","users_artist"."myspace_link","users_artist"."youtube_link","users_artist"."home_dir","users_artist"."slug"
FROM "users_artist" LEFT OUTER JOIN "users_artist_members" AS
"m2m_users_artist__members" ON "users_artist"."id" =
"m2m_users_artist__members"."artist_id" WHERE
("m2m_users_artist__members"."user_id" = ARRAY['2', '1'])
On 25 Mrz., 14:11, tom <[EMAIL PROTECTED]> wrote:
> Sorry, did forget to mention that I am using postgresql8.2 on Mac OS X
> Leopard. The web server is running through the ./manage.py script.
>
> cheers
>
> On 25 Mrz., 14:08, tom <[EMAIL PROTECTED]> wrote:
>
> > Hi,
>
> > I try to add some data through theAdmininterface but I get an SQL
> > Error when I try to add a ManyToMany Relation.
>
> > The model:
> > class Artist(models.Model):
> > name = models.CharField(max_length=200, blank=True)
> > abstract = models.TextField(blank=True, help_text=_('Give a short
> > introduction about your music.'))
> > logo = UserImageField(upload_to='%(base_path)s/Artist/Logo/',
> > blank=True)
> > image = UserImageField(upload_to='%(base_path)s/Artist/Image/',
> > blank=True)
> > myspace_link = models.URLField(verify_exists=True, blank=True,
> > help_text=_('You can specify your MySpace link here.'))
> > youtube_link = models.URLField(verify_exists=True, blank=True,
> > help_text=_('You can specify a link to your Youtube videos here.'))
> > home_dir = models.CharField(max_length=200, editable=False)
> > slug = models.SlugField(prepopulate_from=('members', 'name'))
> > members = models.ManyToManyField(User, unique=True,
> > related_name='users_artist_members')
> > fans = models.ManyToManyField(User, blank=True, unique=True,
> > symmetrical=False, related_name='users_artist_fans')
>
> > The Traceback:
> > Environment:
>
> > Request Method: POST
> > Request URL:http://localhost:8030/admin/users/artist/add/
> > Django Version: 0.97-pre-SVN-unknown
> > Python Version: 2.5.1
> > Installed Applications:
> > ['django.contrib.auth',
> > 'django.contrib.contenttypes',
> > 'django.contrib.sessions',
> > 'django.contrib.sites',
> > 'django.contrib.admin',
> > 'django.contrib.webdesign',
> > 'django.contrib.comments',
> > 'fetchedup.schedule',
> > 'fetchedup.users',
> > 'fetchedup.music',
> > 'fetchedup.registration']
> > Installed Middleware:
> > ('django.middleware.common.CommonMiddleware',
> > 'django.contrib.sessions.middleware.SessionMiddleware',
> > 'django.middleware.locale.LocaleMiddleware',
> > 'django.contrib.auth.middleware.AuthenticationMiddleware',
> > 'django.middleware.doc.XViewMiddleware',
> > 'fetchedup.middleware.threadlocals.ThreadLocals')
>
> > Traceback:
> > File "/Library/Python/2.5/site-packages/django/core/handlers/base.py"
> > in get_response
> > 82. response = callback(request, *callback_args,
> > **callback_kwargs)
> > File "/Library/Python/2.5/site-packages/django/contrib/admin/views/
> > decorators.py" in _checklogin
> > 56. return view_func(request, *args, **kwargs)
> > File "/Library/Python/2.5/site-packages/django/views/decorators/
> > cache.py" in _wrapped_view_func
> > 39. response = view_func(request, *args, **kwargs)
> > File "/Library/Python/2.5/site-packages/django/contrib/admin/views/
> > main.py" in add_stage
> > 260. errors = manipulator.get_validation_errors(new_data)
> > File "/Library/Python/2.5/site-packages/django/oldforms/__init__.py"
> > in get_validation_errors
> > 62. errors.update(field.get_validation_errors(new_data))
> > File "/Library/Python/2.5/site-packages/django/oldforms/__init__.py"
> > in get_validation_errors
> > 379. self.run_validator(new_data, validator)
> > File "/Library/Python/2.5/site-packages/django/oldforms/__init__.py"
> > in run_validator
> > 367. validator(new_data.getlist(self.field_name),
> > new_data)
> > File "/Library/Python/2.5/site-packages/django/utils/functional.py" in
> > _curried
> > 3. return _curried_func(*(args+moreargs), **dict(kwargs,
> > **morekwargs))
> > File "/Library/Python/2.5/site-packages/django/db/models/fields/
> > __init__.py" in manipulator_validator_unique
> > 47. old_obj = self.manager.get(**{lookup_type: field_data})
> > File "/Library/Python/2.5/site-packages/django/db/models/manager.py"
> > in get
> > 69. return self.get_query_set().get(*args, **kwargs)
> > File "/Library/Python/2.5/site-packages/django/db/models/query.py" in
> > get
> > 261. obj_list = list(clone)
> > File "/Library/Python/2.5/site-packages/django/db/models/query.py" in
> > __iter__
> > 114. return iter(self._get_data())
> > File "/Library/Python/2.5/site-packages/django/db/models/query.py" in
> > _get_data
> > 483. self._result_cache = list(self.iterator())
> > File "/Library/Python/2.5/site-packages/django/db/models/query.py" in
> > iterator
> > 189. cursor.execute("SELECT " + (self._distinct and
> > "DISTINCT " or "") + ",".join(select) + sql, params)
> > File "/Library/Python/2.5/site-packages/django/db/backends/util.py" in
> > execute
> > 18. return self.cursor.execute(sql, params)
>
> > Exception Type: ProgrammingError at /admin/users/artist/add/
> > Exception Value: operator does not exist: integer = text[]
> > LINE 1: ..._id" WHERE ("m2m_users_artist__members"."user_id" =
> > ARRAY['2...
> > ^
> > HINT: No operator matches the given name and argument type(s). You
> > may need to add explicit type casts.
>
> > Many thanks for your help!
> > Tom
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django 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/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
