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
-~----------~----~----~----~------~----~------~--~---
