[web2py] Re: Databases problem

2010-10-17 Thread Neveen Adel
Dear mdipierro, I faced the previous problem again when i tried to deploy the application into another machine has old version of my application, so i followed the previous steps , in sql log ALTER TABLE member ADD degree INT; faked! then ALTER TABLE member DROP COLUMN degree; so by this it

[web2py] Re: Databases problem

2010-09-23 Thread Neveen Adel
Thanks a alot mdipierro it works fine with me :)

[web2py] Re: Databases problem

2010-09-23 Thread mdipierro
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", "dat

[web2py] Re: Databases problem

2010-09-23 Thread 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(

[web2py] Re: Databases problem

2010-09-23 Thread 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(

[web2py] Re: Databases problem

2010-09-22 Thread 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(

[web2py] Re: Databases problem

2010-09-22 Thread mdipierro
Are you using SQLite? If this is the only field you added and it existed try replace db.define_table(,migrate=False) with db.define_table(,migrate=True,fake_migrate=True) Use Field, not SQLField On Sep 22, 7:37 am, Neveen Adel wrote: > Hello all, > > I have a deployed application.