Hello *
I'm using django svn, revision 5991.
when trying to save this model,
from django.db import models
from django.contrib.auth.models import User
# Create your models here.
class mg_user(models.Model):
userid = models.PositiveIntegerField()
name = models.CharField(max_length=255)
server = models.PositiveIntegerField()
class Admin:
pass
class sitting(models.Model):
user = models.OneToOneField(mg_user,related_name='gets_sitted')
sitter = models.ForeignKey(mg_user,related_name='sittet')
start = models.DateTimeField()
end = models.DateTimeField()
committed = models.DateTimeField()
committed_by = models.OneToOneField(User,related_name='commited_sittings')
last_edited = models.DateTimeField()
last_edited_by = models.OneToOneField(User,related_name='edited_sittings')
comment = models.TextField()
class Admin:
pass
I get an error:
./manage.py syncdb
Creating table hp_mg_user
Creating table hp_sitting
Traceback (most recent call last):
File "./manage.py", line 11, in <module>
execute_manager(settings)
File
"/usr/lib64/python2.5/site-packages/django/core/management/__init__.py",
line 180, in execute_manager
utility.execute(argv)
File
"/usr/lib64/python2.5/site-packages/django/core/management/__init__.py",
line 124, in execute
command.execute(*args[1:], **options.__dict__)
File
"/usr/lib64/python2.5/site-packages/django/core/management/base.py",
line 33, in execute
output = self.handle(*args, **options)
File
"/usr/lib64/python2.5/site-packages/django/core/management/base.py",
line 115, in handle
return self.handle_noargs(**options)
File
"/usr/lib64/python2.5/site-packages/django/core/management/commands/syncdb.py",
line 66, in handle_noargs
cursor.execute(statement)
File "/usr/lib64/python2.5/site-packages/django/db/backends/util.py",
line 19, in execute
return self.cursor.execute(sql, params)
File "/usr/lib64/python2.5/site-packages/MySQLdb/cursors.py", line
163, in execute
self.errorhandler(self, exc, value)
File "/usr/lib64/python2.5/site-packages/MySQLdb/connections.py", line
35, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1068, 'Multiple primary key defined')
then I asked it to print the sql it wanted to use:
./manage.py sqlreset hp
BEGIN;
DROP TABLE `hp_mg_user`;
CREATE TABLE `hp_mg_user` (
`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
`userid` integer UNSIGNED NOT NULL,
`name` varchar(255) NOT NULL,
`server` integer UNSIGNED NOT NULL
)
;
CREATE TABLE `hp_sitting` (
`user_id` integer NOT NULL PRIMARY KEY REFERENCES `hp_mg_user` (`id`),
`sitter_id` integer NOT NULL REFERENCES `hp_mg_user` (`id`),
`start` datetime NOT NULL,
`end` datetime NOT NULL,
`committed` datetime NOT NULL,
`committed_by_id` integer NOT NULL PRIMARY KEY REFERENCES
`auth_user` (`id`),
`last_edited` datetime NOT NULL,
`last_edited_by_id` integer NOT NULL PRIMARY KEY REFERENCES
`auth_user` (`id`),
`comment` longtext NOT NULL
)
;
CREATE INDEX `hp_sitting_user_id` ON `hp_sitting` (`user_id`);
CREATE INDEX `hp_sitting_sitter_id` ON `hp_sitting` (`sitter_id`);
CREATE INDEX `hp_sitting_committed_by_id` ON `hp_sitting`
(`committed_by_id`);
CREATE INDEX `hp_sitting_last_edited_by_id` ON `hp_sitting`
(`last_edited_by_id`);
COMMIT;
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
