try run once with:
db.define_table("member",
SQLField("membership_id", "integer",notnull=True),
SQLField("first_name", "string", notnull=True,length=100),
SQLField("middle_name", "string", notnull=True,length=100),
SQLField("last_name", "string", notnull=Tru
SQLField("health_problems", "string", default=None),
,migrate=True,fake_migrate=True)
On Jun 21, 3:47 am, Neveen Adel <[email protected]> wrote:
> Hello,
>
> I have a created table as :
>
> """
> Table definition
> """
> db.define_table("member",
> SQLField("membership_id", "integer",notnull=True),
> SQLField("first_name", "string", notnull=True,length=100),
> SQLField("middle_name", "string", notnull=True,length=100),
> SQLField("last_name", "string", notnull=Tru
> SQLField("health_problems", "string", default=None),
> ,migrate=False)
>
> so the table is created.
>
> Then i want to add new field into that table so i did the following:
>
> """
> Table definition
> """
> db.define_table("member",
> SQLField("membership_id", "integer",notnull=True),
> SQLField("first_name", "string", notnull=True,length=100),
> SQLField("middle_name", "string", notnull=True,length=100),
> SQLField("last_name", "string", notnull=Tru
> SQLField("health_problems", "string", default=None),
> SQLField("photo", "upload"),
> )
>
> 1- add the new field
> 2- remove the migrate statements
>
> then am trying to run my application it cause
> "
> OperationalError: (1060, "Duplicate column name
> 'health_problems__tmp'")
> "
>
> How can i fix this? and adding a new field into "member" table.
>
> Thanks In Advance
> Neveen
