Now I've dropped the table and deleted the "define_table" command in
models/db.py.
Nevertheless, table 'mercado' is still listed in appadmin console's table
list.
But when I click on it I get an error with a long Traceback which ends with:
File "/opt/web2py/gluon/contrib/pymysql/err.py", line 107, in
raise_mysql_exception
raise errorclass(errno, errval)
ProgrammingError: (1146, u"Table 'cotsima.mercado' doesn't exist")
Then I included the db.define_table('mercado', ... again, in db.py
After that I get no errors clicking on db.mercado at appadmin, but still
have only two fields at Insert New Record form.
On Wednesday, 16 May 2018 16:24:02 UTC+1, Luís Guilherme F wrote:
>
> Here's the output of the Query db.mercado.id>0 :
>
> mercado.id mercado.cod_m mercado.nome
> 136 5 Beira Litoral
> 137 7 Alentejo
> 138 8 Entre Douro e...
> 139 14 Centro (Aveir...
> 140 15 Norte (Viseu)
> 141 16 Oeste
>
> Luís
>
> On Wednesday, 16 May 2018 15:54:27 UTC+1, Luís Guilherme F wrote:
>>
>> Anthony,
>> What I see are only the two first columns (cod_m, nome), on a table query
>> on appadmin (database administration).
>> The two new columns (regiao, tipo) are not shown.
>>
>> Thank you
>> Luís
>>
>> On Wednesday, 16 May 2018 14:51:41 UTC+1, Anthony wrote:
>>>
>>> It's not quite clear what the current problem is. Are you getting an
>>> error? What do you see, and what are you expecting instead?
>>>
>>> On Wednesday, May 16, 2018 at 9:20:23 AM UTC-4, Luís Guilherme F wrote:
>>>>
>>>> Hello,
>>>> I had a table with two fields. My app was fine.
>>>> Then I added two more but web2py/appadmin doesn't show them.
>>>> I used mysql tools to change it.
>>>> Then I corrected my models/db.py, and ONLY then I ran appadmin.
>>>> I've tried migrate=False (and True) and fake_migrate=True.
>>>>
>>>> Original table:
>>>>
>>>> db.define_table('mercado',
>>>> Field('cod_m', type='integer'),
>>>> Field('nome', type='string')
>>>> migrate=False)
>>>>
>>>> Now:
>>>>
>>>> db.define_table('mercado',
>>>> Field('cod_m', type='integer'),
>>>> Field('nome', type='string'),
>>>> Field('regiao', type='integer'),
>>>> Field('tipo', type='integer'),
>>>> fake_migrate=True)
>>>>
>>>> Best regards,
>>>> Luís
>>>>
>>>
--
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.
