Yes now it does work properly, both for auth tables and application tables. I'll let you know if I notice something else wrong..
Thank you very much for your quick support! G. On Nov 14, 1:20 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > is it fixed now? > > On Nov 13, 4:19 pm, Gabriele Alberti <gabriele.albe...@gmail.com> > wrote: > > > Same line, NameError: global name 'field_name' is not defined. I could > > even guess the patch ;) > > > G. > > > On Nov 13, 10:52 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > fixed. try again. > > > > On Nov 13, 3:06 pm, Gabriele Alberti <gabriele.albe...@gmail.com> > > > wrote: > > > > > Uhmmm.. I get this > > > > > File "/home/dbtest/web2py-trunk/gluon/sql.py", line 1535, in _create > > > > costraint_name = '%s_%s__constraint' % (table_name, field_name) > > > > NameError: global name 'table_name' is not defined > > > > > with the welcome app.. > > > > > G. > > > > > On Nov 13, 8:40 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > > > another option in trunk. > > > > > > On Nov 13, 11:48 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > > > > I think I found a more permanent and automatic fix. It is in trunk. > > > > > > Please delete your db and try the trunk web2py with default > > > > > > settings. > > > > > > I willowed your suggestion of hashing for oracle only if len>30 so > > > > > > it > > > > > > is backward compatible. > > > > > > > Massimo > > > > > > > On Nov 13, 11:29 am, Gabriele Alberti <gabriele.albe...@gmail.com> > > > > > > wrote: > > > > > > > > Hello, > > > > > > > your hack seems to be partially working, for those who need it I > > > > > > > had > > > > > > > to shorten even more your suggestion, so: > > > > > > > > auth.settings.table_membership_name = 'auth_memb' > > > > > > > auth.settings.table_permission_name = 'auth_perm' > > > > > > > > So far this worked. I'll let you know if anything else gives > > > > > > > problems > > > > > > > as I will be working heavily with Oracle in the next days. > > > > > > > > Grazie mille! > > > > > > > > G. > > > > > > > > On Nov 13, 6:11 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > > > > > > For now I would just do in db.py > > > > > > > > > auth=Auth() > > > > > > > > auth.settings.table_membership_name = 'auth_membr' > > > > > > > > auth.settings.table_permission_name = 'auth_perms' > > > > > > > > > before > > > > > > > > > auth.define_tables() > > > > > > > > > Don't we all love Oracle quirks? > > > > > > > > > Massimo > > > > > > > > > On Nov 13, 9:59 am, Gabriele Alberti > > > > > > > > <gabriele.albe...@gmail.com> > > > > > > > > wrote: > > > > > > > > > > Hi, > > > > > > > > > it is 30 chars. I did not read the DAL code yet, but a simple > > > > > > > > > temporary workaround would be to shorten the suffix string.. > > > > > > > > > maybe a > > > > > > > > > more definitive thing would be a simple checksum (shorter > > > > > > > > > than 30 > > > > > > > > > chars) against the long names ? > > > > > > > > > > I'll be glad to give you any support to help. > > > > > > > > > > Thanks, > > > > > > > > > > G. > > > > > > > > > > On Nov 13, 3:59 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > > > > > > > > There will not be a new DAL anytime soo because we have > > > > > > > > > > cleaned up the > > > > > > > > > > current DAL a lot functionality already so the new DAL is > > > > > > > > > > already > > > > > > > > > > obsolete in comparison. Let's try adress this specific > > > > > > > > > > problem for > > > > > > > > > > now. > > > > > > > > > > > What is the max length for a constraint name in oracle? > > > > > > > > > > > On Nov 13, 5:29 am, Gabriele Alberti > > > > > > > > > > <gabriele.albe...@gmail.com> > > > > > > > > > > wrote: > > > > > > > > > > > > Hello web2py users, > > > > > > > > > > > recently using Oracle as DB I hit the notorious problem > > > > > > > > > > > "ORA-00972: > > > > > > > > > > > identifier is too long". I understood the problem, I > > > > > > > > > > > modified my code > > > > > > > > > > > to comply the Oracle limit, then I hit the same problem > > > > > > > > > > > in "CONSTRAINT > > > > > > > > > > > auth_membership_user_id__constraint", which is not my > > > > > > > > > > > code :) > > > > > > > > > > > I have noticed an old post stating soon a new DAL will be > > > > > > > > > > > ready and it > > > > > > > > > > > will address this issue. > > > > > > > > > > > Any news about that? > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
