**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
```
```
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.
```lang=sql
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
```lang=irc
[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
```lines=10
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
```