Thanks Lovedie
On Thursday, October 25, 2018 at 1:27:08 PM UTC+2, Lovedie JC wrote:
>
> 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 <godir...@gmail.com <javascript:>>
> 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 <godir...@gmail.com> 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.
>>>> 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+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.
