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'),
)
I either get the below traceback, or the one in my previous post. I'm
confused O.O Considering that the Auth.define_tables goes through. I am
clearing everything under databases folder each time to test, as well as
manually dropping the tables.
Traceback (most recent call last):
File "/home/thadeusb/Applications/web2py-devel/gluon/restricted.py",
line 184, in restricted
exec ccode in environment
File
"/home/thadeusb/Applications/web2py-devel/applications/welcome/models/db.py"
<http://127.0.0.1:8000/admin/default/edit/welcome/models/db.py>, line
54, in <module>
Field('count', 'integer'),
File "/home/thadeusb/Applications/web2py-devel/gluon/sql.py", line
1130, in define_table
query = t._create(migrate=migrate)
File "/home/thadeusb/Applications/web2py-devel/gluon/sql.py", line
1396, in _create
elif field.type[:10] == 'reference ':
TypeError: 'NoneType' object is unsubscriptable
-Thadeus
On Thu, Oct 22, 2009 at 11:34 PM, Thadeus Burgess <[email protected]>wrote:
> Wow I am just having lots of problems tonight, Ok so creating my table on a
> fresh mysql database causes this error.
>
>
> This key error happens on the following fields
>
> Field('booty_url', length=300), Field('tank_data', 'text'))
>
>
> Traceback (most recent call last):
> File "/home/thadeusb/Applications/web2py-devel/gluon/restricted.py", line
> 184, in restricted
>
>
> exec ccode in environment
> File
> "/home/thadeusb/Applications/web2py-devel/applications/bootygrab/models/db.py"
> <http://127.0.0.1:8000/admin/default/edit/bootygrab/models/db.py>, line 76,
> in <module>
>
>
> Field('tank_data', 'text'))
>
>
> File "/home/thadeusb/Applications/web2py-devel/gluon/sql.py", line 1130, in
> define_table
>
>
> query = t._create(migrate=migrate)
>
>
> File "/home/thadeusb/Applications/web2py-devel/gluon/sql.py", line 1470, in
> _create
>
>
> self._db._execute(query)
>
>
> File "/home/thadeusb/Applications/web2py-devel/gluon/sql.py", line 805, in
> <lambda>
>
>
> self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
>
>
> File "/usr/lib/python2.6/site-packages/MySQLdb/cursors.py", line 173, in
> execute
>
>
> self.errorhandler(self, exc, value)
>
>
> File "/usr/lib/python2.6/site-packages/MySQLdb/connections.py", line 36, in
> defaulterrorhandler
>
>
> raise errorclass, errorvalue
> OperationalError: (1071, 'Specified key was too long; max key length is 767
> bytes')
>
>
> -Thadeus
>
>
>
>
>
> On Thu, Oct 22, 2009 at 10:34 PM, mdipierro <[email protected]>wrote:
>
>>
>> No because the web2py <1.68 did not enforce size, 1.68 does.
>>
>> Massimo
>>
>> On Oct 22, 10:11 pm, Thadeus Burgess <[email protected]> wrote:
>> > That was it. It was the tank_data field.
>> >
>> > Here is an example of what gets stored in the field. It seems like if I
>> am
>> > able to insert this much data, import_from_csv should be able to import
>> it
>> > as well?
>> >
>> >
>> http://gaiaonline.com/chat/gsi/gateway.php?v=json&m=[[6500,[1]],[6510,[%222137385%22,0]],[6511,[%222137385%22,1]],[6512,[%222137385%22,1]],[107,[%22null%22]]]&X=1256164219
>> >
>> > -Thadeus
>> >
>> > On Thu, Oct 22, 2009 at 10:07 PM, Thadeus Burgess <
>> [email protected]>wrote:
>> >
>> > > I tried changing 'wb', to 'w'
>> >
>> > > Unfortunately, open office freezes when trying to open it....
>> >
>> > > here is my sql.loghttp://pastebin.com/m4ea163df
>> >
>> > > I did not alter any columns that would have truncated data.
>> >
>> > > There is however, the text field in table booty. tank_data.
>> >
>> > > This is a massive string of JSON.. massive. like... thats what takes
>> up
>> > > 40mb of my 62mb database.
>> >
>> > > If anything, this field is causing the error.
>> >
>> > > Is there any way to not export this column (I don't need the JSON, it
>> will
>> > > get replaced on the next update). Is it save to remove the Field()
>> from the
>> > > db.define_table, delete the database files (to start from fresh) and
>> then
>> > > add the Field declaration again right before import?
>> >
>> > > -Thadeus
>> >
>> > > On Thu, Oct 22, 2009 at 9:50 PM, mdipierro <[email protected]
>> >wrote:
>> >
>> > >> think the problem may be that you had corrupted data in the db in
>> > >> the first place (like you stored somet
>> >>
>>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
