1)
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)
2) run appadmin
3) uncomment the line above and set fake_migrate=False
4) run appadmin again
On Sep 23, 1:51 am, Neveen Adel <[email protected]> wrote:
> 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
