Why does 512 result in "Specified key was too long; max key length is 767
bytes". Is one counting unicode and one bytes? If setting this length to
128 is the only option, I will change it but I am afraid it may be too
short to store .table files. Did you encounter any problem after this
change?
On Friday, 6 January 2012 18:43:22 UTC-6, howesc wrote:
>
> i don't know if i'm gonna regret this later, but in dal.py i changed that
> field length to 128:
>
> self.db.executesql("CREATE TABLE IF NOT EXISTS
> web2py_filesystem (path VARCHAR(128), content LONGTEXT, PRIMARY KEY(path) )
> ENGINE=InnoDB;")
>
> now it works again.
>
--
