[web2py] Re: Databases problem

[Neveen Adel]

Thanks mdipierro for ur reply :)

Am using MySQL

but after i did the following:

db.define_table("member",
      Field("membership_id", "integer",notnull=True),
      Field("first_name", "string", notnull=True,length=100),
      Field("middle_name", "string", notnull=True,length=100),
      Field("last_name", "string", notnull=True,length=100),
      Field("birthdate", "date"),
      Field("degree",db.academic_degree), # the new field
      migrate=True,fake_migrate=True)


it cause an error :

OperationalError: (1054, "Unknown column 'member.degree' in 'field
list'")


because the field wasn't created into the database.



How can i fix this ?

Thanks in Advance