don't know precisely how dal works, but if a table have a field referenced in a table defined after that, wouldn't that cause a problem ?
i.e. db.define_table('route', Field('photo_id', 'reference pictures', readable=False, writable=False) ) db.define_table('pictures', Field('name')) does not work, where db.define_table('pictures', Field('name')) db.define_table('route', Field('photo_id', 'reference pictures', readable=False, writable=False) ) instead works ? Not using web2py, for normal sql development, you have to create "child" tables before declaring a "parent" with references to it.