!Hubzilla Support Forum
Hi there. I am posting this from a clone of my channel since the channel from my main installation doesn't seem to send out updates to other servers anymore. While investigating this I noticed some DB updates (mariadb) failed. Among them update 1192 which wants to do:
"ALTER TABLE item ADD INDEX (obj_type)"
It gives an error: Syntax error or access violation: 1069 Too many keys specified; max 64 keys allowed
. It seems to mean that there is a maximum of 64 indices. When checking the table I notice there are indeed already 64 indices. Among them are 6 named obj_type
. This is all rather new to me but I assume I should best remove these indices and let the script create a new one?
Through the admin interface probably. But since "assumption is the mother of all fuckups" I guessed a conformation here wouldn't hurt.
BTW: I have been running Hubzilla from a Raspberry Pi (3 by now) in the living room for the past two to three years, without any problem. (Until now that is
). Still: hats off to that!