BenL's picture
BenL - Tue, 2014/01/07 - 07:32

Hi, sorry if this is not the right place this.

Bug concerning web2py ISO appliance: CSS is not functioning correctly in admin page of web2py

Fix: in /etc/apache2/sites-enabled/web2py ..

change this line 

AliasMatch ^/([^/]+)/static/(.*) /var/www/web2py/applications/$1/static/$2

to

AliasMatch ^/([^/]+)/static/(?:_[\d]+.[\d]+.[\d]+/)?(.*) /var/www/web2py/applications/$1/static/$2

Solution in

https://groups.google.com/forum/#!topic/web2py/thSs622POoA

 

 

Forum: 
Support
Tags: 
web2py
BenL's picture

BenL - Sun, 2014/02/02 - 03:00

Just another note when using this appliance: you might get an mysql error when following the tutorial 

http://web2py.com/books/default/chapter/29/03/overview#Startup

The error is 

1071, 'Specified key was too long; max key length is 767 bytes'

Culprit : 

db.define_table('image',
   Field('title',unique=True),   <-----
   Field('file', 'upload'),
   format = '%(title)s')

either use 
   Field('title',unique=True,length=255)

or 

db.image.title.requires = IS_NOT_IN_DB(db, db.image.title)

after the statement.

reference: https://groups.google.com/forum/#!msg/web2py/9AwEHOeLbds/5IzHL50LD2gJ

 


Jeremy Davis's picture

Jeremy Davis - Sun, 2014/02/02 - 12:04
I have lodged it as a bug on the TKL Issue Tracker
BenL's picture

BenL - Sun, 2014/02/02 - 21:17

Hi Jeremy, Yes, the first post is a bug, but for the  mysql problem,  it is more of a mysql bug-feature than anything to do with TKL. It applies to anything running web2py-mysql not just TKL. Other database servers dont have this problem.  regards!


Add new comment