Django Unknown column

Question

I have a model with the following fields

class UserProfile(models.Model):

  user = models.OneToOneField(User, unique=True, db_index=True, 
  related_name='profile')
  Email = models.EmailField(max_length=255, db_index=True, null=True)
  name = models.CharField(blank=True, max_length=255, db_index=True)

class Meta(object):
    db_table = "auth_userprofile"

in my Users panel inside the Django Adminsitration i have multiple users, when i try to acces one of them i get this following error

(1054, "Unknown column 'auth_userprofile.user_id' in 'field list'")

should i drop the table to fix this issue or there is another solution for this

Morten Bork Morten Bork · Accepted Answer · 2017-04-28T13:11:17

Dropping the table will require you to recreate it. And if you recreate it precisely as it is now, the issue will not be resolved.

This error: (1054, "Unknown column 'auth_userprofile.user_id' in 'field list'")

Is refering to a specified column, very likely in a SQL statement, where you claiming a table, auth_userprofile, has the column: user_id.

Or it could be a syntax error, and you are including the table name in the column name section, or actually quite a lot of possible errors come to mind.

The point is deleting the table will only help if you re-create it with altered column names. And dropping an entire table to either alter a column name in your code, or simply creating the column in the table seems a bit excessive?

Django Unknown column

1 Answers