I found it.
It was in db.py
db.define_table('frame',
Field('framename', type='string',
# #unique=True,
<-------------------------------------------------------- the problem. Is it
a bug ?
label=T('Framename')),
Field('description', type='string',
label=T('Description')),
Field('netboot', type='string',default="None",
label=T('Netboot information')),
Field('ip', type='string',
#unique=True,
label=T('IP Address')),
Field('servermodel', type='string',default="p6",
label=T('Server model')),
Field('serial', type='string',default="None",
label=T('Serial Number')),
Field('lvname', type='string',default="FRAMEx",
label=T('Frame extension for storage logical volumes')),
Field('framestaterecord_ID', type='integer',
label=T('Frame State record ID')),
Field('created_on','datetime',default=request.now,
label=T('Created On'),writable=False,readable=False),
Field('modified_on','datetime',default=request.now,
label=T('Modified On'),writable=False,readable=False,
update=request.now),
format='%(framename)s',
migrate=True)
On Tuesday 08 October 2013 13:41:31 Mike Veltman wrote:
Ok, I am now fighting with it for two days and it drives me crazy.
My gut feeling says mysql 5.1 --> mysql 5.5 upgrade is the cause. Am I right ?
And how do I solve it. :-)
*Error ticket for "adeploy"*
*Ticket ID*
192.168.2.106.2013-10-08.12-46-19.24f3f1a5-d637-4522-965b-fed4958115ed
*<class '_mysql_exceptions.OperationalError'> (1071, 'Specified key was too
long; max key length is 767 bytes')*
*Version*
*web2py™*
Version 2.7.2-stable+timestamp.2013.10.07.13.52.24
*Traceback*
1.
Traceback *(*most recent call last*): *File
"/srv/web-apps/web2py/gluon/restricted.py"*, *line 217*, in *restricted
*exec *ccode *in *environment File
"/srv/web-apps/web2py/applications/adeploy/compiled/models/db.py"*, *line 178*,
in <*module*> *File "/srv/web-apps/web2py/gluon/dal.py"*, *line 7911*, in
*define_table table *=
**self.*lazy_define_table*(*tablename*,**fields*,***args*) *File
"/srv/web-apps/web2py/gluon/dal.py"*, *line 7948*, in *lazy_define_table
polymodel*=*polymodel*) *File "/srv/web-apps/web2py/gluon/dal.py"*, *line
1029*, in *create_table fake_migrate*=*fake_migrate*) *File
"/srv/web-apps/web2py/gluon/dal.py"*, *line 1136*, in *migrate_table
*self.*execute*(*sub_query*) *File "/srv/web-apps/web2py/gluon/dal.py"*, *line
1836*, in *execute *return self.*log_execute*(**a*, ***b*) *File
"/srv/web-apps/web2py/gluon/dal.py"*, *line 1830*, in *log_execute ret *=
**self.*cursor*.*execute*(*command*, **a*[*1*:], ***b*) *File
"/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py"*, *line 173*, in
*execute *self.*errorhandler*(self, *exc*, *value*) *File
"/usr/lib64/python2.6/site-packages/MySQLdb/connections.py"*, *line 36*, in
*defaulterrorhandler *raise *errorclass*, *errorvalueOperationalError*:
(*1071*, *'Specified key was too long; max key length is 767 bytes'*)
*
*In file: /srv/web-apps/web2py/applications/adeploy/compiled/models/db.pyc*
1.
*<*code object *<*module*> *at 0x168c468*, *file
"/srv/web-apps/web2py/applications/adeploy/compiled/models/db.py"*, *line 28*>*
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
