on sql.log in your databases folder there is the excerpt of the statements
used to create the table.
I'm guessing that you implemented your app adding here and there tables but
never defining them "in order" .
This seems the kind of problem when you try to create a table with foreign
keys pointing to a table that doesn't yet exist (i.e. Field('detail_id',
db.details) without the db.details be defined already).
On Saturday, July 21, 2012 11:55:10 AM UTC+2, Marek Mollin wrote:
>
> other info:
> I am using postgres 9.1
>
> No migrate is not set to false. + it creates all other tables it just
> stops at certain point and skips a few of them.
>
> error stack:
>
> Traceback (most recent call last):
> File "G:\mac-backup\CLIENTS 2\paczkon\web2py\gluon\restricted.py", line 205,
> in restricted
> exec ccode in environment
> File "G:/mac-backup/CLIENTS
> 2/paczkon/web2py/applications/menzo/models/db.py"
> <http://127.0.0.1:8000/admin/default/edit/menzo/models/db.py>, line 212, in
> <module>
> format=lambda r: '%s %s %s' % (r.user.email, r.status, r.price)
> File "G:\mac-backup\CLIENTS 2\paczkon\web2py\gluon\dal.py", line 6320, in
> define_table
> polymodel=polymodel)
> File "G:\mac-backup\CLIENTS 2\paczkon\web2py\gluon\dal.py", line 719, in
> create_table
> self.create_sequence_and_triggers(query,table)
> File "G:\mac-backup\CLIENTS 2\paczkon\web2py\gluon\dal.py", line 1954, in
> create_sequence_and_triggers
> self.execute(query)
> File "G:\mac-backup\CLIENTS 2\paczkon\web2py\gluon\dal.py", line 1392, in
> execute
> return self.log_execute(*a, **b)
> File "G:\mac-backup\CLIENTS 2\paczkon\web2py\gluon\dal.py", line 1386, in
> log_execute
> ret = self.cursor.execute(*a, **b)
> ProgrammingError: relation "delivery_type" does not exist
>
>
> W dniu piątek, 20 lipca 2012 23:30:00 UTC+2 użytkownik rochacbruno napisał:
>>
>>
>> are you sure the migrate is not False in db = DAL(...) ?
>>
>> try including migrate=True in your define_table
>>
>> On Fri, Jul 20, 2012 at 6:17 PM, Marek Mollin <rog...@gmail.com> wrote:
>>
>>> Hey,
>>> Problem is as follows.
>>> I start a clean db in psql. Test the connection + delete all the
>>> /databases files to fresh with remote db.
>>> When I launch index page tables start getting created then I get error
>>> regarding some table is missing. I check sql.log and it did not even start
>>> creating the table (this + a few more get ommited).
>>>
>>> I have check_reserved in my DAL declaration. Table is not ill named:
>>>
>>> db.define_table('delivery_type',
>>> Field('name','string'),
>>> Field('price','double'),
>>> format=lambda r: r.name
>>> )
>>>
>>> but there are others not getting created
>>> version 1.99.7
>>>
>>> --
>>>
>>>
>>>
>>>
>>
>>
--
