if module template type was not "module" (if its type was admin) it will created countless duplicate templates with each update.
you can easily find this bug by updating system module several times then go to phpmyadmin and table "tplfile" and search for tpl_module = system
SELECT * FROM PREFIX_tplfile WHERE tpl_module = "system"
See also:
http://sourceforge.net/p/xoops/bugs/1221/
See more info here:
http://xoops.org/modules/newbb/viewtopic.php?topic_id=76065
Committed to SVN
TODO: provide Upgrade for existing installation
As far as I have been able to determine, the patch as supplied works fine. When you update the system module it cleans up the duplicates and then adds the new index, so existing installations should be covered. Seems solid to me.
Are there any known cases where that fails?