Topic on Extension talk:LiquidThreads

Workaround for error 1071: Specified key was too long on install

1
IvanLanin (talkcontribs)

I'm running the latest SVN version on hosted server. They don't allow me to use InnoDB and I have to stick with MyISAM. I can't run update.php because "1071: Specified key was too long; max key length is 1000 bytes". The problem is with line 35 on lqt.sql

CREATE INDEX thread_article_title ON /*$wgDBprefix*/thread (thread_article_namespace, thread_article_title, thread_sortkey);

As per bugzilla:26517, this is a known bug waiting and will be fixed by rewriting the extension. Since I need it now, I change line 35 above to:

CREATE INDEX thread_article_title ON /*$wgDBprefix*/thread (thread_article_namespace, thread_article_title);

update.php ran smoothly and I can use the extension. Change in index surely will affect the performance, but since I only use it in very small wiki, this workaround works for me now.

Reply to "Workaround for error 1071: Specified key was too long on install"