I created today a sql cloud database. And I got the same error.
I changed to path VARCHAR(255) and now it works. Anybody else having the
same problem?
-rif
marți, 7 august 2012, 18:27:13 UTC+3, Massimo Di Pierro a scris:
>
> 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.
>>
>
--
