loading appadmin informix table

[Wouter Pronk]

Hello,

I'm connected to a Informix-dynamic-server database and I have a problem loading the appadmin view for a table. I've tried if my model will run trough the web2py-shell and it does, but when I try in the web-interface web2py seems to be crashing. This is my model:

db = DAL('Informix://user:passwd@host/database', migrate=False)
db.define_table('tl',
    Field('rowid','id'),
    Field('land_code','string', length=3),
    Field('land_nummer_ed','integer'),
    Field('land_naam_nederl','string', length=30),
    Field('land_naam_engels','string', length=30),
    Field('bijvoegelijk_vnw','string', length=30),
    Field('eg_lid','boolean'),
    Field('valuta_code','string', length=3),
    Field('valuta_koers','float'),
    Field('taal_code','string', length=1),
    Field('land_naam_duits','string', length=30),
    Field('land_naam_frans','string', length=30),
    Field('land_naam_spaans','string', length=30),
    Field('cvo_oorsprong','string', length=1),
    Field('cvo_bestemming','string', length=1),
    Field('pytho','boolean'),
    Field('bijv_vnw_engels','string', length=30),
    Field('bijv_vnw_duits','string', length=30),
    Field('bijv_vnw_frans','string', length=30),
    Field('bijv_vnw_spaans','string', length=30),
    Field('inkoop_koers','float'),
    Field('koers_lijst','boolean'),
    Field('afwijk_deb_rek_nr','integer'),
    Field('euroland','boolean'),
    Field('afrond_bedrag','float'),
    Field('communitair','boolean'),
    Field('eva_land','boolean'),
    Field('percentage_btw_l','float'),
    Field('rek_btw_l_te_bet','integer'),
    Field('percentage_btw_h','float'),
    Field('rek_btw_h_te_bet','integer'),
    Field('fact_soort_bana','string', length=1),
    Field('rek_btw_te_ont','integer'),
    Field('kantoor_bestemming','string', length=8),
    Field('kantoor_doorgang','string', length=8),
    Field('land_code_iso','string', length=3),
    Field('referentie_p_maat','boolean'),
    Field('landenstikker','string', length=3),
    Field('postcode_opbouw','string', length=10),
    Field('transito_dagen','integer'))

Anyone an idea?
 

[Niphlod]

anything specific reported in the "crashing" page ? 

[Wouter Pronk]

Hello Niphlod,

nothing. The browsers just tries to keep loading (message: waiting on
localhost) and the server-app is not responding (and blank).

Op 15-04-13 14:07, Niphlod schreef:

> anything specific reported in the "crashing" page ?

> --
>
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/web2py/2ZUWi8cSovU/unsubscribe?hl=en.
> To unsubscribe from this group and all its topics, send an email to
> web2py+un...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

[Niphlod]

something in the databases/sql.log file ?

PS: try to specify migrate=False in the table definition too. Shouldn't be needed but it's always a nice check to do when debugging such "locks"

[Wouter Pronk]

No, nothing. Already added migrate=False, but no change.

Op 15-04-13 14:15, Niphlod schreef:

[Niphlod]

any chance in changing the tablename (that I'm assuming is not "t1" in the reality) fixes the problem ?
What happens in the shell when you do db(db.t1.id > 0).select() and what when you do db(db.t1.id != '').select()

?

[Wouter Pronk]

Hello Niphlod,

my initial information was not correct. In the shell I tried
db.executesql('SELECT * FROM tl;') and this work but if I do things
=db(db.tl.id>0).select() than that's it. The prompt doesn't return and I
have to kill the shell.

Op 15-04-13 14:47, Niphlod schreef:

> ? --

[Niphlod]

well, this helps to understand why the appadmin is failing.... if it fails in the shell, there's no way it works in the appadmin.
Unfortunately I don't have an informix instance available, so you should try to debug the code (or wait for a user that has it)
ps: what is your informix version ?

[Wouter Pronk]

the version of informix is 12.10. Thanks for your help so far Niphlod.
Op 15-04-13 17:09, Niphlod schreef: