I'm trying to migrate a web2py application to a new box. Source: WS2k8 http://gutsup.com = http://95.211.128.165/openbrief web2py: _w2p_246 using MySQL5.5
Target: WS2k8 R2 http://37.48.64.183 => welcome http://37.48.64.183/openbrief => crash _web2py281 mySQL 5.6 What did i do? I transferred the database (w2pyopenbrief) from source to target using workbench (export/import) Defined the same user /password in target mySQL (web2py / / DBA) Downloaded new Web2Py (281) Packed openbrief app in source, read it in target QUESTION: What did i do wrong????? ============================ ======== ERROR ========== Error ticket for "openbrief" Ticket ID 37.48.64.183.2013-11-28.19-01-02.5f015402-2f6b-4724-a2e8-b82886f49038 <class 'gluon.contrib.pymysql.err.InternalError'> (1071, u'Specified key was too long; max key length is 767 bytes') Version web2py™ Version 2.8.1-stable+timestamp.2013.11.27.20.07.10 Traceback Traceback (most recent call last): File "/home/mdipierro/make_web2py/web2py/gluon/restricted.py", line 217, in restricted File "S:/_web2py281/web2py/applications/openbrief/models/db.py", line 89, in <module> format='%(content)s') #NOTE, this error is in this fragment ie the first define_table statement # TESTIT # db.define_table('testit', # Field('content','string',notnull=True,unique=True), # format='%(content)s') File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 8139, in define_table File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 8176, in lazy_define_table File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1086, in create_table File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1194, in migrate_table File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1916, in execute File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1910, in log_execute File "/home/mdipierro/make_web2py/web2py/gluon/contrib/pymysql/cursors.py", line 117, in execute File "/home/mdipierro/make_web2py/web2py/gluon/contrib/pymysql/connections.py", line 202, in defaulterrorhandler InternalError: (1071, u'Specified key was too long; max key length is 767 bytes') In file: S:\_web2py281\web2py\applications\openbrief\models\db.py # -*- coding: utf-8 -*- ######################################################################### ## This scaffolding model makes your app work on Google App Engine too ## File is released under public domain and you can use without limitations ######################################################################### ## if SSL/HTTPS is properly configured and you want all HTTP requests to ## be redirected to HTTPS, uncomment the line below: # request.requires_https() if not request.env.web2py_runtime_gae: ## if NOT running on Google App Engine use SQLite or other DB db = DAL('mysql://web2py:1616359wp@127.0.0.1:3306/w2popenbrief') else: ## connect to Google BigTable (optional 'google:datastore://namespace') db = DAL('google:datastore') ## store sessions and tickets there session.connect(request, response, db = db) ## or store session in Memcache, Redis, etc. ## from gluon.contrib.memdb import MEMDB ## from google.appengine.api.memcache import Client ## session.connect(request, response, db = MEMDB(Client())) ## by default give a view/generic.extension to all actions from localhost ## none otherwise. a pattern can be 'controller/function.extension' response.generic_patterns = ['*'] if request.is_local else [] ## (optional) optimize handling of static files # response.optimize_css = 'concat,minify,inline' # response.optimize_js = 'concat,minify,inline' ######################################################################### ## Here is sample code if you need for ## - email capabilities ## - authentication (registration, login, logout, ... ) ## - authorization (role based authorization) ## - services (xml, csv, json, xmlrpc, jsonrpc, amf, rss) ## - old style crud actions ## (more options discussed in gluon/tools.py) ######################################################################### from gluon.tools import Auth, Crud, Service, PluginManager, prettydate auth = Auth(db) crud, service, plugins = Crud(db), Service(), PluginManager() ## create all tables needed by auth if not custom tables auth.define_tables(username=False, signature=False) ## configure email mail=auth.settings.mailer mail.settings.server = 'logging' or 'smtp.gmail.com:587' mail.settings.sender = 'y...@gmail.com' mail.settings.login = 'username:password' ## configure auth policy auth.settings.registration_requires_verification = False auth.settings.registration_requires_approval = False auth.settings.reset_password_requires_verification = True ## if you need to use OpenID, Facebook, MySpace, Twitter, Linkedin, etc. ## register with janrain.com, write your domain:api_key in private/janrain.key from gluon.contrib.login_methods.rpx_account import use_janrain use_janrain(auth,filename='private/janrain.key') ######################################################################### ## Define your tables below (or better in another model file) for example ## ## >>> db.define_table('mytable',Field('myfield','string')) ## ## Fields can be 'string','text','password','integer','double','boolean' ## 'date','time','datetime','blob','upload', 'reference TABLENAME' ## There is an implicit 'id integer autoincrement' field ## Consult manual for more options, validators, etc. ## ## More API examples for controllers: ## ## >>> db.mytable.insert(myfield='value') ## >>> rows=db(db.mytable.myfield=='value').select(db.mytable.ALL) ## >>> for row in rows: print row.id, row.myfield ######################################################################### # coding: utf8 # tables for openbrief # in file: OPENBRIEF/MODELS/DB_OPENBRIEF.PY # TESTIT db.define_table('testit', Field('content','string',notnull=True,unique=True), format='%(content)s') # CATEGORY db.define_table('category', Field('name','string',notnull=True,unique=True), format='%(name)s') # LETTER db.define_table('letter', Field('addressee','string',notnull=True), Field('title','string',notnull=True), Field('category','reference category',readable=False,writable=False), Field('body','text',notnull=True), Field('link',requires=IS_URL()), Field('votes','integer',readable=False,writable=False), Field('posted_by','reference auth_user',readable=False,writable=False), Field('posted_on','datetime',readable=False,writable=False), format='%(title)s') # COMMENT db.define_table('comment', Field('body','text',notnull=True), Field('letter','reference letter',readable=False,writable=False), Field('posted_by','reference auth_user',readable=False,writable=False), Field('posted_on','datetime',readable=False,writable=False)) # VOTE db.define_table('vote', Field('value','integer'), Field('letter','reference letter',readable=False,writable=False), Field('posted_by','reference auth_user',readable=False,writable=False), Field('posted_on','datetime',readable=False,writable=False), format='%(value)s') ## after defining tables, uncomment below to enable auditing auth.enable_record_versioning(db) mail.settings.server = settings.email_server mail.settings.sender = settings.email_sender mail.settings.login = settings.email_login : -- 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.