IIS: When trying to add a new language, we are running into a error.

Could you please try adding image/icon while adding language and see if it works or not?

We'll cover this bug in 2.1 release that will be live shortly.

As of now, go to DB Manager and in database make SQL request if you didn't change table prefix while installation:

1. ALTER TABLE `ur_languages` CHANGE `image` `image` VARCHAR(38) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;

Hi Stas,

could you please clarify your last comment?

Also, we have to report that the update to v2.1 did not fix this issue for us – the error still occurs as described above.

Luckily, this is not crucial for us as we're currently highjacking the Russian localization (just with a changed language-code – "de" in our case).

Stas, I noticed a thing when browsing your documentation - and thus finally can make sense of your comment regarding "trying to add an image/icon while adding the language": What you mean with that is clearly visible in the screenshot for "Add New Language" in your documentation:

Let me show you a screenshot of our UseResponse-installation (2.1 on IIS, running in the latest Google Chrome) - the field to add an icon/image when adding a new lanugage is completely missing:

It's also not present in the code itself:

1. <form id="system-form-language" enctype="multipart/form-data" class="system-form-language" accept-charset="utf-8" action="http://localhost/portal/admin/languages/add" method="post">
2. <i class="preloader right"></i>
3. <label for="" class="label">
4. Name<span class="required">*</span>
5. </label>
6. <div class="textInput">
7. <input type="text" name="name" id="name" value="" />
8. </div>
9. <label for="" class="label">
10. Code
11. </label>
12. <div class="selectInput">
13. <select name="code" id="code">
14. <option value="aa" label="aa">aa</option>
15. <option value="af" label="af">af</option>
16. <option value="ak" label="ak">ak</option>
17. <option value="am" label="am">am</option>
18. <option value="ar" label="ar">ar</option>
19. <option value="as" label="as">as</option>
20. <option value="az" label="az">az</option>
21. <option value="be" label="be">be</option>
22. <option value="bg" label="bg">bg</option>
23. <option value="bn" label="bn">bn</option>
24. <option value="bo" label="bo">bo</option>
25. <option value="bs" label="bs">bs</option>
26. <option value="ca" label="ca">ca</option>
27. <option value="cs" label="cs">cs</option>
28. <option value="cy" label="cy">cy</option>
29. <option value="da" label="da">da</option>
30. <option value="de" label="de">de</option>
31. <option value="dv" label="dv">dv</option>
32. <option value="dz" label="dz">dz</option>
33. <option value="ee" label="ee">ee</option>
34. <option value="el" label="el">el</option>
35. <option value="en" label="en">en</option>
36. <option value="eo" label="eo">eo</option>
37. <option value="es" label="es">es</option>
38. <option value="et" label="et">et</option>
39. <option value="eu" label="eu">eu</option>
40. <option value="fa" label="fa">fa</option>
41. <option value="fi" label="fi">fi</option>
42. <option value="fo" label="fo">fo</option>
43. <option value="fr" label="fr">fr</option>
44. <option value="ga" label="ga">ga</option>
45. <option value="gl" label="gl">gl</option>
46. <option value="gu" label="gu">gu</option>
47. <option value="gv" label="gv">gv</option>
48. <option value="ha" label="ha">ha</option>
49. <option value="he" label="he">he</option>
50. <option value="hi" label="hi">hi</option>
51. <option value="hr" label="hr">hr</option>
52. <option value="hu" label="hu">hu</option>
53. <option value="hy" label="hy">hy</option>
54. <option value="ia" label="ia">ia</option>
55. <option value="id" label="id">id</option>
56. <option value="ig" label="ig">ig</option>
57. <option value="ii" label="ii">ii</option>
58. <option value="in" label="in">in</option>
59. <option value="is" label="is">is</option>
60. <option value="it" label="it">it</option>
61. <option value="iu" label="iu">iu</option>
62. <option value="iw" label="iw">iw</option>
63. <option value="ja" label="ja">ja</option>
64. <option value="ka" label="ka">ka</option>
65. <option value="kk" label="kk">kk</option>
66. <option value="kl" label="kl">kl</option>
67. <option value="km" label="km">km</option>
68. <option value="kn" label="kn">kn</option>
69. <option value="ko" label="ko">ko</option>
70. <option value="ku" label="ku">ku</option>
71. <option value="kw" label="kw">kw</option>
72. <option value="ky" label="ky">ky</option>
73. <option value="ln" label="ln">ln</option>
74. <option value="lo" label="lo">lo</option>
75. <option value="lt" label="lt">lt</option>
76. <option value="lv" label="lv">lv</option>
77. <option value="mk" label="mk">mk</option>
78. <option value="ml" label="ml">ml</option>
79. <option value="mn" label="mn">mn</option>
80. <option value="mo" label="mo">mo</option>
81. <option value="mr" label="mr">mr</option>
82. <option value="ms" label="ms">ms</option>
83. <option value="mt" label="mt">mt</option>
84. <option value="my" label="my">my</option>
85. <option value="nb" label="nb">nb</option>
86. <option value="ne" label="ne">ne</option>
87. <option value="nl" label="nl">nl</option>
88. <option value="nn" label="nn">nn</option>
89. <option value="no" label="no">no</option>
90. <option value="nr" label="nr">nr</option>
91. <option value="ny" label="ny">ny</option>
92. <option value="oc" label="oc">oc</option>
93. <option value="om" label="om">om</option>
94. <option value="or" label="or">or</option>
95. <option value="pa" label="pa">pa</option>
96. <option value="pl" label="pl">pl</option>
97. <option value="ps" label="ps">ps</option>
98. <option value="pt" label="pt">pt</option>
99. <option value="ro" label="ro">ro</option>
100. <option value="ru" label="ru">ru</option>
101. <option value="rw" label="rw">rw</option>
102. <option value="sa" label="sa">sa</option>
103. <option value="se" label="se">se</option>
104. <option value="sh" label="sh">sh</option>
105. <option value="si" label="si">si</option>
106. <option value="sk" label="sk">sk</option>
107. <option value="sl" label="sl">sl</option>
108. <option value="so" label="so">so</option>
109. <option value="sq" label="sq">sq</option>
110. <option value="sr" label="sr">sr</option>
111. <option value="ss" label="ss">ss</option>
112. <option value="st" label="st">st</option>
113. <option value="sv" label="sv">sv</option>
114. <option value="sw" label="sw">sw</option>
115. <option value="ta" label="ta">ta</option>
116. <option value="te" label="te">te</option>
117. <option value="tg" label="tg">tg</option>
118. <option value="th" label="th">th</option>
119. <option value="ti" label="ti">ti</option>
120. <option value="tl" label="tl">tl</option>
121. <option value="tn" label="tn">tn</option>
122. <option value="to" label="to">to</option>
123. <option value="tr" label="tr">tr</option>
124. <option value="ts" label="ts">ts</option>
125. <option value="tt" label="tt">tt</option>
126. <option value="ug" label="ug">ug</option>
127. <option value="uk" label="uk">uk</option>
128. <option value="ur" label="ur">ur</option>
129. <option value="uz" label="uz">uz</option>
130. <option value="ve" label="ve">ve</option>
131. <option value="vi" label="vi">vi</option>
132. <option value="wo" label="wo">wo</option>
133. <option value="xh" label="xh">xh</option>
134. <option value="yo" label="yo">yo</option>
135. <option value="zh" label="zh">zh</option>
136. <option value="zu" label="zu">zu</option>
137. </select>
138. </div>
139. <button id="submit" class="button-type2" type="submit">
140. Submit
141. </button>
142. </form>

Screenshot in documentation was made long time ago when we had that option. But later we removed icon for language as we didn't find any application to it, just forgot to replace screenshot in docs.

Thanks for reporting it. Will revise article screenshot shortly.