I noticed on my part,if I can remember, that the error comes because you are recreating another table. That's why you can rename are restart web2py and see if it works.
On Thu, 25 Oct 2018, 13:52 mostwanted <[email protected]> wrote: > 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 <[email protected]> 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 [email protected]. >>> 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 [email protected]. > 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
