On Tue, Mar 25, 2008 at 9:08 AM, tom <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I try to add some data through the Admin interface 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')
>
You've specified unique=True on your ManyToManyFields. unique=True means
"this field must be unique throughout the table" but ManyToMany
relationships are stored in an intermediate table, so unique=True doesn't
really make sense for a ManyToManyField. Try removing it and see if it
fixes the problem.
Karen
> 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
-~----------~----~----~----~------~----~------~--~---
