[Owncloud] MySQL index issue

Andreas Schneider asn at cryptomilk.org
Mon Sep 24 16:00:16 UTC 2012


I get the following error:

{"app":"core","message":"Failed to update database structure (MDB2 Error: 
unknown error, _doQuery: [Error message: Could not execute statement]\n[Last 
executed query: CREATE INDEX `appconfig_appid_key_index` ON `cld_appconfig` 
(`appid`, `configkey`)]\n[Native code: 1071]\n[Native message: Specified key 
was too long; max key length is 1000 bytes]\n)","level":4,"time":1348502048}

The reason for this is cause appid and configkey are varchar(255) and you 
can't index them cause they are two big.

See http://bugs.mysql.com/bug.php?id=4541

Why needs the appid to be such a big key? Same for the configkey ...

	-- andreas

Andreas Schneider                   GPG-ID: F33E3FC6
www.cryptomilk.org                asn at cryptomilk.org

More information about the Owncloud mailing list