Hi!
I got quite the same problem with postgresql. I tried to add a field to
an already defined table but I fot this error:
ProgrammingError: ERRORE: la colonna
plugin_lookout_fields.table_meta_data non esiste
LINE 1: ...s.field_comment, plugin_lookout_fields.is_active, plugin_loo...
(it says that column plugin_lookout_fields.table_meta_data do not exists
which is the one I've added)
the solution hereunder suggested did not solved... is there a way to
solve this problem?
Thank you very mutch
cheers
Manuele
Il 08/04/11 22:04, Massimo Di Pierro ha scritto:
> 1) get trunk
> 2) comment the missing fields
> 3) run with DAL(...,fake_migrate_all=True)
> 4) visit appadmin
> 5) uncomment the missing fields
> 6) remove fake_migrate_all=True from DAL(...)
> 7) visit appadmin
>
> did it fix it?
>
>
>
> On Apr 8, 2:21 pm, Lennon <[email protected]> wrote:
>> I added the follow fields to my table:
>>
>> Field('rooming_requests','string', length=500, label='Do you have any
>> rooming requests?', widget=SQLFORM.widgets.text.widget,
>> requires=[IS_LENGTH(500)]),
>>
>> Field('misc_info','string', length=500, label='Anything else you would
>> like us to know?', widget=SQLFORM.widgets.text.widget,
>> requires=[IS_LENGTH(500)]),
>>
>> Field('us_citizen','boolean', label='Are you a US citizen?',
>> requires=IS_IN_SET(['T', 'F'],zero='Choose One')),
>>
>> Field('dietary_restrict','string', length=500, label='Do you have any
>> dietary restrictions?', widget=SQLFORM.widgets.text.widget,
>> requires=[IS_LENGTH(500)]),
>>
>> When I did a migrate, the "rooming_requests" field and the "misc_info"
>> fields were added to the table file and to the MySQL database but the
>> "us_citizen" field and the "dietary_restrict" field was not.
>>
>> Subsequent migration attempts have had no effect.
>>
>> Please advise,
>>
>> ~Lennon
--
---
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/groups/opt_out.
