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.
