If i delete it from the database folder and refresh my browser with the table using the same name will it not throw the *table exists *error?
On Thursday, October 25, 2018 at 11:13:31 AM UTC+2, Lovedie JC wrote: > > I used to get that. Delete the db from the database folder or rename it > brhe refresh or restart web2py. > > On Thu, 25 Oct 2018, 09:36 mostwanted <godir...@gmail.com <javascript:>> > wrote: > >> When i do all this it gives me error saying table Customer exists! >> >> On Friday, August 31, 2018 at 2:53:18 AM UTC+2, Anthony wrote: >>> >>> fake_migrate makes pyDAL think the model definition reflects the actual >>> schema in the database. Presumably the field in question does not actually >>> exist in the database. If that's the only field missing from the database, >>> do the following: >>> >>> 1. Delete the *.table file for this table in the /databases folder. >>> 2. Comment out the line defining the missing field. >>> 3. Leave fake_migrate=True and run one request -- that will >>> re-create the *.table file, but without the missing field, so pyDAL will >>> know to add the field in the next real migration. >>> 4. Remove fake_migrate everywhere -- you don't need it unless you >>> are correcting a migration problem. >>> 5. Set migrate=True. >>> 6. Remove the comment from #2 above and run another request -- pyDAL >>> will now create the missing field. >>> >>> Anthony >>> >>> On Thursday, August 30, 2018 at 4:13:02 PM UTC-4, mostwanted wrote: >>>> >>>> I have a database which i recently updated by adding a new table called >>>> *tlamelo*, the new table is referenced in one of the old tables called >>>> *company, >>>> *when i try to save data into the table *company* i get the error >>>> bellow *(table company has no column named tlamelo)!* I do not >>>> understand why i am getting this error, i am not sure if it has anything >>>> to >>>> do with the >>>> fake_migrate=True >>>> or not! Can anyone please help me, thank you. >>>> >>>> <class 'sqlite3.OperationalError'> table company has no column named >>>> tlamelo >>>> >>>> This is the code for my table tlamelo >>>> db.define_table('tlamelo', >>>> Field('leina_la_tlamelo', requires=IS_NOT_EMPTY()), >>>> format='%(leina_la_tlamelo)s', migrate=False, >>>> fake_migrate=True) >>>> >>>> This is the code for my table company >>>> db.define_table('company', >>>> Field('logo', 'upload'), >>>> Field('company_name', requires=IS_NOT_EMPTY()), >>>> Field('services', 'reference services'), >>>> Field('tlamelo', 'reference tlamelo'), #tlamelo is >>>> referenced here >>>> Field('product', 'reference product'), >>>> Field('tel', requires=IS_NOT_EMPTY()), >>>> Field('email', requires=IS_NOT_EMPTY()), >>>> Field('fax', requires=IS_NOT_EMPTY()), >>>> Field('cell', requires=IS_NOT_EMPTY()), >>>> Field('facebook', requires=IS_NOT_EMPTY()), >>>> Field('twitter', requires=IS_NOT_EMPTY()), >>>> Field('website', requires=IS_NOT_EMPTY()), >>>> Field('postal_address', requires=IS_NOT_EMPTY()), >>>> Field('located_at', requires=IS_NOT_EMPTY()), migrate= >>>> False, fake_migrate=True) >>>> >>>> >>>> -- >> Resources: >> - http://web2py.com >> - http://web2py.com/book (Documentation) >> - http://github.com/web2py/web2py (Source code) >> - https://code.google.com/p/web2py/issues/list (Report Issues) >> --- >> You received this message because you are subscribed to the Google Groups >> "web2py-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to web2py+un...@googlegroups.com <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.