Goal: To export citation templates from Wikipedia and successfully import them into a non-WMF wiki
Found instructions: https://www.mediawiki.org/wiki/VisualEditor/Citation_tool cursory instructions on how to import citation templates
Info: The Mediawiki is an "empty" MW 1.35 set up just for testing changes. The MW was not installed via git clone and has been upgraded to the current version.
Steps to Reproduce:
Installed and enabled these extensions from git:
mw:Extension:TemplateData mw:Extension:TemplateStyles
Ran composer in extensions/TemplateData and extensions/TemplateStyles: composer update --no-dev
Ran php maintenance/update.php and php maintenance/runJobs.php
Export templates needed with Special:Export, choose only latest versions, not full histories and ticked the box "include templates" and asked it to export
w:Template:Cite web w:Template:Cite news w:Template:Cite journal w:Template:Cite book w:Template:Cite AV media w:Template:Citation
Did try to alter the database and insert the following values to content_models as per what Vulpix had in his database.
INSERT INTO content_models VALUES (2, 'css'); INSERT INTO content_models VALUES (3, 'javascript'); INSERT INTO content_models VALUES (4, 'Scribunto'); INSERT INTO content_models VALUES (5, 'sanitized.css'); commit;
Import the templates with Special:Import finishes fine, but the citation templates are not working
Irc snippets from helpful people in the mediawiki-channel on freenode on 2020-11-19
[20:52] <Vulpix> This would be the case if scribunto or TemplateStyles relies on update.php to populate the content_models table instead of "lazy-populating" it [20:53] <Vulpix> Still, requesting a greater model_id than the greatest one present on the database is odd [20:55] <onejukeboksi> Vulpix: I can confirm that it is trying to access an id that doesn't exist, because now the Internal error dump complains about 'id = 6' not being there. I just inserted values for 2,3,4 and 5 [20:58] <Vulpix> or maybe the contents of the content_models get cached on a service/memory/class, the new model gets inserted, but the internal cache doesn't get populated. When it tries to access the new created model from the cache, it's not found, crashes, and roll-backs the entire transaction [20:58] <Vulpix> that would make more sense
Actual Results:
Any page (?) with citation templates an internal error:
''[5fbc8a084c204cb4609b0020] /w/index.php?title=Testing&action=submit MediaWiki\Storage\NameTableAccessException from line 43 of /var/www/kunsolan.fi/testing/wiki/w/includes/Storage/NameTableAccessException.php: Failed to access name from content_models using id = 6''
If I did not touch the content_model the error was seemingly the same, except complaining about inability to access record with id=2
Expected Results:
Successfully importing the templates
Log of export-imported articles
On 2020-11-19 the following templates were exported from Wikipedia to the private testwiki
w:Template:Cite web w:Template:Cite news w:Template:Cite journal w:Template:Cite book w:Template:Cite AV media w:Template:Citation
Selecting "Include templates" in the Special:Export lead to the following additional templates and modules to be exported
w:Template:Cite web w:Template:Cite news w:Template:Cite journal w:Template:Cite book w:Template:Cite AV media w:Template:Citation w:Template:!xt w:Template:= w:Template:AWB standard installation w:Template:Anchor w:Template:Category link w:Template:Citation Style 1 w:Template:Citation Style documentation w:Template:Citation Style documentation/agency w:Template:Citation Style documentation/author w:Template:Citation Style documentation/auto-date-format w:Template:Citation Style documentation/coins w:Template:Citation Style documentation/cs1 w:Template:Citation Style documentation/date w:Template:Citation Style documentation/deprecated w:Template:Citation Style documentation/display w:Template:Citation Style documentation/editor w:Template:Citation Style documentation/id1 w:Template:Citation Style documentation/id2 w:Template:Citation Style documentation/journal w:Template:Citation Style documentation/language w:Template:Citation Style documentation/lay w:Template:Citation Style documentation/lead w:Template:Citation Style documentation/lua w:Template:Citation Style documentation/pages w:Template:Citation Style documentation/publisher w:Template:Citation Style documentation/quote w:Template:Citation Style documentation/ref w:Template:Citation Style documentation/registration w:Template:Citation Style documentation/required w:Template:Citation Style documentation/sep period w:Template:Citation Style documentation/series w:Template:Citation Style documentation/syntax w:Template:Citation Style documentation/type w:Template:Citation Style documentation/url w:Template:Citation Style documentation/usage w:Template:Citation Style documentation/usage common w:Template:Citation Style documentation/usage full w:Template:Citation Style documentation/usage vertical w:Template:Citation Style documentation/usage vertical common w:Template:Citation Style documentation/usage vertical end w:Template:Citation Style documentation/usage vertical mid w:Template:Citation Style documentation/web w:Template:Citation Style documentation/whats new w:Template:Cite web/doc w:Template:Cl w:Template:Code w:Template:Crossref w:Template:Crossreference w:Template:Cs1 w:Template:Csdoc w:Template:Date w:Template:Diff w:Template:Documentation w:Template:Documentation subpage w:Template:Em w:Template:End w:Template:Hatnote inline w:Template:Hatnote inline/invoke w:Template:High-use w:Template:Infobox w:Template:Lang w:Template:Lua w:Template:Main other w:Template:Markup2 w:Template:Mbox w:Template:MediaWiki URL rules w:Template:NCJ w:Template:Navbox w:Template:NotRef w:Template:Nowrap w:Template:Ombox w:Template:Para w:Template:Paren w:Template:Pipe w:Template:Purge w:Template:R w:Template:R/ref w:Template:Reflist w:Template:Sandbox other w:Template:Section link w:Template:Sfnote w:Template:Slink w:Template:Str left w:Template:Sup w:Template:Tag w:Template:TemplateData header w:Template:Template link with link off w:Template:Template other w:Template:Template parameter usage w:Template:Tl w:Template:Tlf w:Template:Tlg w:Template:Tlx w:Template:Trim w:Template:UF-COinS w:Template:Var w:Template:Warning w:Template:Wikipedia referencing w:Template:Xt w:Template:Xtd w:Template:Yesno w:Template:Yesno-no w:Help:CS1 errors w:Module:Anchor w:Module:Arguments w:Module:Check for unknown parameters w:Module:Citation/CS1 w:Module:Citation/CS1/COinS w:Module:Citation/CS1/Configuration w:Module:Citation/CS1/Date validation w:Module:Citation/CS1/Identifiers w:Module:Citation/CS1/Utilities w:Module:Citation/CS1/Whitelist w:Module:Citation/CS1/styles.css w:Module:Color contrast w:Module:Color contrast/colors w:Module:Cs1 documentation support w:Module:Documentation w:Module:Documentation/config w:Module:Effective protection expiry w:Module:Effective protection level w:Module:Exponential search w:Module:File link w:Module:Hatnote w:Module:Hatnote inline w:Module:High-use w:Module:Infobox w:Module:Lang w:Module:Lang/ISO 639 synonyms w:Module:Lang/data w:Module:Language/data/iana languages w:Module:Language/data/iana regions w:Module:Language/data/iana scripts w:Module:Language/data/iana suppressed scripts w:Module:Language/data/iana variants w:Module:List w:Module:Lua banner w:Module:Message box w:Module:Message box/configuration w:Module:Navbar w:Module:Navbox w:Module:No globals w:Module:Protection banner w:Module:Protection banner/config w:Module:Purge w:Module:Section link w:Module:String w:Module:TableTools w:Module:Template wrapper w:Module:Tlg w:Module:Transclusion count w:Module:Transclusion count/data/C w:Module:Unicode data w:Module:Unicode data/scripts w:Module:Yesno w:Template:Citation Style documentation/edition w:Template:Citation Style documentation/title w:Template:Citation Style documentation/volume w:Template:Cite news/doc w:Template:High-risk w:Template:Cite journal/doc w:Template:Vcite w:Template:' w:Template:Citation Style documentation/chapter w:Template:Citation Style documentation/chapterurl w:Template:Cite book/TemplateData w:Template:Cite book/doc w:Template:Collapse bottom w:Template:Collapse top w:Template:Hover title w:Template:Citation Style documentation/time w:Template:Cite AV media/doc w:Template:Pre2 w:Template:Abbr w:Template:Cascade-protected template w:Template:Category handler w:Template:Citation/doc w:Template:Citation Style documentation/sep comma w:Template:Define w:Template:Delink w:Template:Edit w:Template:Fake citation needed w:Template:Fake fix w:Template:Fix w:Template:Fmbox w:Template:For2 w:Template:Harv w:Template:Harvard citation w:Template:Harvard citation no brackets w:Template:Harvid w:Template:Harvnb w:Template:Hatnote w:Template:Nbsp w:Template:Notice w:Template:Protected page text w:Template:Resize w:Template:SfnRef w:Template:Smaller w:Template:Spaces w:Template:Wikipedia help pages w:Module:Category handler w:Module:Category handler/blacklist w:Module:Category handler/config w:Module:Category handler/data w:Module:Category handler/shared w:Module:Delink w:Module:Footnotes w:Module:Footnotes/anchor id list w:Module:Footnotes/anchor id list/data w:Module:Footnotes/whitelist w:Module:Namespace detect/config w:Module:Namespace detect/data