from django.db import models
from django.contrib.auth.models import User
name = models.CharField(max_length=30, blank=False)
users = models.ManyToManyField(User, related_name='reports')
It seems like you've added to the Report model after the first sync. Thus you're dealing with a migration, which django doesn't do natively.
First, Inspect the sql output, make sure that the create table instruction for your many to many relationship is there.
python manage.py sqlall
Assuming the problem is that this is a migration, which django doesn't handle natively, you've got three options: 1) Delete all db tables for this app, then run syncdb again. 2) Manually create the tables (fairly easy to copy paste the create sql from the sqlall command) 3) Start using a migration framework like South.
In the long run you'll appreciate the investment in learning south. In the short term, deleting the DB file is the fastest.-