No, I am getting
OperationalError: (1071, 'Specified key was too long; max key length
is 767 bytes')
Yes, I do get the unscriptable error if I use auth.user... I think I caught
that after I made the post and got tired and went to sleep :)
But I still get the OperationalError with this: It works if I change my db
to sqlite, but not on mysql.
db =
DAL('mysql://username:alphanumericpassw...@mysql.thadeusb.com<username%3aalphanumericpassw...@mysql.thadeusb.com>
')
db.define_table("test_table",
Field('id_user', db.auth_user),
Field('name'),
Field('email', length=300),
Field('about', 'text'),
Field('count', 'integer'),
)
-Thadeus
On Fri, Oct 23, 2009 at 10:52 AM, DenesL <denes1...@yahoo.ca> wrote:
>
>
> So just to be clear, you are not getting
> TypeError: 'NoneType' object is unsubscriptable ?
>
> I get the same error using your posted code with MSSQL (and it will
> blow up with any other DB), so it is not something with the MySQL DAL.
>
> Denes.
>
> On Oct 23, 11:42 am, Thadeus Burgess <thade...@thadeusb.com> wrote:
> > Yeah that was just a typo when I wrote it in gmail, I did not copy/paste
> it
> > from my code. It is db.auth_user in my code.
> >
> > -Thadeus
> >
> > On Fri, Oct 23, 2009 at 8:30 AM, DenesL <denes1...@yahoo.ca> wrote:
> >
> > > Hi Thadeus,
> >
> > > On Oct 23, 2:08 am, Thadeus Burgess <thade...@thadeusb.com> wrote:
> > > > I might just be doing something wrong, but I think there is something
> > > with
> > > > the MySQL DAL...
> >
> > > > Nothing with this define_table will pass... listed below are the
> errors.
> >
> > > > db.define_table("test_table",
> > > > Field('id_user', auth.user),
> > > > Field('name'),
> > > > Field('email', length=300),
> > > > Field('about', 'text'),
> > > > Field('count', 'integer'),
> > > > )
> >
> > > ...
> > > Field('id_user', db.auth_user),
> > > ...
> >
> > > Denes
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
