Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-5452

Can't execute images.sql when upgrading from 1.8.8 to 2.0.2

    Details

      Description

      After upgrade from 1.8.8 to 2.0.2 new icons not appear in frontend. I try to execute zabbix-2.0.2/database/mysql/images.sql, but they show me this:
      :~# mysql -u root zabbix < /root/zabbix-2.0.2/database/mysql/images.sql
      ERROR 1062 (23000) at line 1: Duplicate entry '1' for key 'PRIMARY'

      Ok, maybe delete all from images:
      mysql> delete from images;
      ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`zabbix`.`sysmaps_elements`, CONSTRAINT `c_sysmaps_elements_2` FOREIGN KEY (`iconid_off`) REFERENCES `images` (`imageid`))

      Export all maps from Zabbix frontend and delete it. After thar try to delete images:
      mysql> delete from images;
      Query OK, 24 rows affected (0.48 sec)

      Import maps in Zabbix frontend and see error:
      ERROR: Import failed
      Invalid argument supplied for foreach() [include/classes/import/CConfigurationImport.php:357]
      Invalid argument supplied for foreach() [include/classes/import/CConfigurationImport.php:357]
      Invalid argument supplied for foreach() [include/classes/import/CConfigurationImport.php:357]
      Cannot find background image for map "Filial Cisco.

      Ok, open exported xml and search for image name.
      background>
      <name>RB 2</name>
      </background>

      Upload image from administration again and get error:
      ERROR: Cannot add image
      Error in query [INSERT INTO images (imageid, name, imagetype, image) VALUES (26, 'RB 2', 2, 'GIF89a6??\0\0???????????f??3??\0???????????g??3??\0???????????}??3??\0?f??f??f??ff?h5?f\0?3??3??3??3f?33?3\0?\0??\0??\0??\0f?\03?\0\0???????????f??3??\0???????????o??3??\0???????????5?\0?f??w??????q?f\0?3??3??3??3f?33?3\0?\0??\0??\0??\0f?\03?\0\0??????????f??3??\0??????????z??3??\0?????????????M??\0?f?????????????l\n?3??3?G??q????\\6?\0??\0?\0??\0f?7????n??f??f?ff?3f?\0???????v?vf?3f?\0i????????????if?\0ff?pp??????????9f3?f3?i???????k?f\0?f\0?h?4??]y?ikE??3??3??3?f3?33?\0t??e??A?5?g3?33?\03?????¦t?t7?3f?3f??????t33?33?77??????3\0?3\0?3\0?Q*y????\0\0??\0?f\0?3\0?\0J??-?? ?\0?f\0?3\0?\0\0??x??t??B?E?\0f?\0f????????\03?\03?\03??????\0\0?\0\0?\0\0?h??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????Unable to render embedded object: File (?\0\0?\0,\0\0\0\06?@?\0H???*\\??C#J?H???3j???I C?I??(S?\\Q???0c?I???%Ub????8-?Jh?H?*]???(Y?J??O?U\n4\Z?h?VV?RE?cQ?h?]??eJ?p?Z?yu?N?\'??7lJ?]Q??p?E;?????S?U?Ly*????7?5EC?mq???L????@??vM???u????/`????????\\??jR????) not found.^VX]?f?w??d5???????,vV?{]:\\??]KO?o??]c_U??&]xgTJoF?O&?
      :d e?\r{?M?\ng\\?O?2??b?\n?Zs??H?;\"%h8^@z6c??5??q,sO?Xe] ?N????b??aI?Fnx?q?h#?a]?,)>?q):?\\??I?}a?j\'+W?9hi2u\Z?{?O???\"w\r}?9?@A#\'d?q7?e?6?cUI????T??J?q?\n?Z)+m?}P??*p*Yk??R\n,R&`V{g?zF?r?aP@Q?gU\ne??Z?n????f?{?:\'?w?2;Z?!n)??:?]?k^P?0n_n?i? c?1O?L??r|_S=Z??1GKW??L?<?=}u4?q???7?IEc`y:?rV;Vv?,o?:?R*?X?Yw\\PY??xk\n?<Y?p???:??](4vV?/r*?%8??G??E?\n\"Nr;v\\??L8??j?S?s?e&W9\'??g?? {zm?N{?\n?\\?3?t?>?6?\r?lb?_Y5??\ng??YGT ?Y??\0H??~\'[U8?[??)?????\\d8??G|?,c!??-]?XRr?-

      {k?F?h0G2???5H?R?!u???%1?~6qJ?B?a?1??IrC.O[g????.0?p\0r?? ?aT?U:H?Zc\nhDq? ??}

      ?B(?E2?b?\"?4??)?t?a?`x?)?4)?p!?mf?S`?s?/?p:?|l#YXjV?.?CL?G??b??pt?B??B?N?4=??(U?)?,5?c?I)vL}?0\"5L$_d?\'Y#@Unable to render embedded object: File (???%2??w??8=2??Y7?&\'?el{??$\'????b??#ybO\refm?gc?) not found.?+?qR??G?]c? ?a?f?nq(?i??P??y??$%C?%C[?i?$/?X?x?9?F??j(79??s~X??wz??n?RLaUf??
      S???(jwb??2?Z??dN)<=m5F Ew?.?^?UC?&rd??g?9^Q?\'?@e??t?JSY?\r?Z?\0????h?F??B
      +C?A\"?y?<?A??5$*$?df???h???[?>K?$,b?Z?B9Ve?il?&?o??T?f?e???|rW6?HT?)?T?|??aU?k??Ty5B?t?|?P?K??R??oo???f??eQ??)\'\Z
      ?F?+ ?x?I????

      {w???:y(?y?o?k?!?_@mI??d?T???AKIK*T???!*l?n???E-???dc?9??u\r?F???K?????d}

      ???fGvR?o??R?I??c??he?-
      ?U??|?.?Yb?J?#?G??u?g??K? ?dL?g?Vc?iP?

      {J???fS,??w???B???B?W?;?)?\'?jO??N?\'S~??,=?\nk?K[k6z??\Z??nuU.???x???R]??????bj4?zl???T?J??^ge???Jr?Rt?>^\Z???b?T??\"????a?A?`V?nmb???r?\"?oAGV?v?b???6?Th????q?NJt?Z?I@?\'gL??#x?oV??F?????B\"L?????7Z;?? ?? ???#??+?I??6??P?????g?5?6?\"^?Y?3O?x??[?V??r??<2}

      R{f\nI\"dG??u?gt?5lnir?&?Vp?|.?n/W?g?fE?\rn?k??Z)-<iZ>0?$?n?G??v ???:?\0,{?5??GbT??l?x?V??g%?%?^>??Y?g}?|N??=???q??6?R76?\n?zt?\'?i?\0?T??t?@?;2?(\"??o?g^?rZ?N?\'?93h?z>?b?k\'a\0x?C{6?H1?N?]3?=??2?j&?pYPvcZ?\\6?(X?x?@K?6??6C9??A??VR?VY2fS??S??4?f??`?WP~FX?Y??`?J?z??yf?x?v?^?|?F\\rX?~?7\r?1??]R?X{t}h%?Yt?]=xu?N?>!*hnI8w?%??H d??h\\;?c?W+?F1C8g??O?8p?fH?6?&8)?(D????i?(&z??q??F4\" _W???????]`?+\0`?a?!nSF?\r\'??p??75?3C?`NuF???w?9{?&?E?z?W\r?v?X?

      {x>?n r??l?q???9?V?p?????*G?.?E??h?h?&???:)??k?$?T???;Y??2Zs?pKC<??\\ ?F???W?lr?m??O5T?o?R?`????`y?M?t}

      +3?h?m?IpiH?$c\'?|I\Z$4*1?$Q?te9\"?]#?Unable to render embedded object: File (?\0(.? ?G???(QG?{\'?????Y??mPA?C?R????9??Y???g?<?94{g???Pny8??q?y??tp@\"??Q????w???) not found.?i;?]?Q\r?,Py?\'?s?XG??N^(??wYH?K?@?fLH:~BLA??{??c?X?)V?y,?$?h?7GU?\r?h\"e!?c?J?TJ? jfIvv%?J?8?5J?J?Tz??)!|B??(?? d?q??G?wR(??O}1?]^R?7=??rPB$\0&??Y|9Jd?07 Mp?8_??XK4e6?vK??yAS?v#?p#pS?`?\r?skGV??ML\n?o(?$x?l?g<l

      {r?????8?a?z?)q5y???q??v???\"cq?*?#?`I?,S?qP??8&?~???aT?2\n|1*[oI?;??L?\n(T\r?4wl?i?H??6?0t?\n??O?j,lJ?I8???I?=?e7?Tj%k???V??.W8OF?U?9??H??VF????J5?*Uv?????????#%n?Y?.?\n&?Qn?$?%\r???J) ?z\0?u?W\n?K}

      ??%12?K?j\nhY?%g?w5?yC?\nWz\'?W?mu3q.S(;?\":[?T?f0&0?;V?[?rc??t????B?C?I?4*????^R|9O#;?A\0,?Y+?.:uq?1?Q4??9R\'I5??HKU??G?+^\'??J?1?uh4?:R??FC?|?{?e7$?8?yH]??k@[?r??8!?2F??P3b?$?1&?[\\???4?4q??s?;?y?sa\r?[v??j)v??j~???]7y???6F?1r1<[\nV??\r?????X4??7??1??H??]?j%?\'?BV?4=?)I,7??wE0T?Q?\'?6lH?0?sJ??Z??5X+?E??Xv?K??\r?t?ZY?jo???T?K\'??\0?? C??5?Wm??G,?\"?`?P*?? ?d??A\Z??y\0?J??n??r%Ni??s?Fg??Qxs?:?\n?[y:?+??7?6?h9OB??\"?xn?W??|8?%???@??_?EVG?\Z????????,@%P$$??\Z?Z??Q?s?3????U?D?4?*?K?\\\\?<0|??\"b??7??2V??IkV@JME?\\8?ps??#Q01?????i?j?L?s?$A?7F*?F?????]z?Fp?A?z???h??yz?K?.Ou\0%?u?9,?,j??<?v?7?Y?cQ\nG?y?3?y??\\t???\n =)??B3?m??k?=o?l?N?\"$li;m??6?vm?<Hz\na??pB?C??GM??emD??q??Dw\"?zF?rP\"|?ZM6?+8Unable to render embedded object: File (?????LO?;?) not found.}|kr\r?u?\'?z?FL??c=???5Mz?T,6?yk?pbN?\'Z\r#??*?%]v?7??Et-?jU?R\"?]59[?\'???)??h?x??pN??U?I:O?t????O?}???+)Xkk~?-??B?\"?GP??3?f?\n#???O?88kx??Pd????b?B,/?-?tK`??#4??\r(?a?????6\nP.b\rN?;?86x???#???7?JV?U???N???????Rg0?$t\Z????Q?=cY????-?w?*?RN?}r,?+P??6?&???)???\0??U?nl^?n?=>???{3=?{???????:?O~(MJ?&?<M?{?aws7??]??O??a?]?(RO??KW]a??-?{?L.?%]x&N1?G)a>8[6??=?3?\\5} .??f?y??_????<|H?N?D*????_t????#*r^?Z?????\nZH??%?^5s?v?A?mx?2?zrtY??`?????B?x?x4~x???-on??>??>??????$DN?:??`=??r?n?\":Y.Z????~??pWj,%rJb?jL+????(?j??Vo????z?_+d?$?j\r???`???????K??2??$r? ???W?\\??3??$??k?V\'??:??I?d??\0????v?>??M0¶?\'?,?>|]??{e?C?C~??0.@(?T?B?I?1f<,?v/?9??6?<?.q?x?\0?9??a?CzF3B??F?)J?L?????Oik?/?|<s?E?JK?Qg:?r+X?De?\r?n9\Z?q?]7?\'\\}??}O?DA\"??H?8?/~?V? 7N???=O?FH??O?w\r_[?????!??b#X??A? \rVc?!?h?N?X??E??V????A?!?$Y??I?)U?d???K?1e?Y??M?9u??y2????b5??P??4\"eJPP?M?v?bEO?Y?n????W?am?\\:?\"+??N????AVk????,?@r??e*R?_?&\\?0?|c????~\rO?\\??e?\\?<5???E#????i?U??x4?k?#`3???f???u???\'^????;??4?\n=zn?????q??o7m?\n???!?e~??]3/{?\n?4:\0?I??6pAt?A#?pB\n+B3?pC;??C?qDK4\'?b?[t?E?(8WX?Fs?qgZ??6\0?Cm???oG$?|P??,<?|???XT?J,?H9??RD?~\n??xJ?,?T3\'???? (\'M\"???j???2???O???r?j??A??39??????H?N@+%???9M\r2pND??R0??)?S-U?S;?\ZkdsN\"M?r1?>?V??\\?W?n+?\Z?f}?!)?e?#?\n ???vZg%??1???bS????V!YC??V+BLHj?e?m?J??y??h?r??W9]|S(i[??]t?UL/{?j?56`??QQj?W?3S?kn?8U?6)??E?7?M?!m?]XS?dx§[;?N????>f?*I?M?>?a\n)^?@VbP]9x;?¬j??W:?Z?W?R/+h?#??S?E}P4G??l??ny7?`\rY?&6Y?yjhzK???QMl:?5J??DS?j??V+l??y\"o?]?r?dk?)?I??KhnW?<?]?F?tr??n?>Y?Fvn?Q~#l??kv??z~?\Z?=)}?u_f?\\??\"?s?j`?eP??R}).f??_G? a??a?R?=?Unable to render embedded object: File (o/??o??) not found.Unable to render embedded object: File (e8?jh?#??? ?.??w?\n?\r7\Zq?t?+??C??) not found.?H?hI??B<?#C?Unable to render embedded object: File (??1???QV?PxI??A??-\Z???&lD~???CL7Ihr?vi??6?NY-\"g<??=s>??\\??,j??>?8=?I?2i=f???DdN?\'?G;*??r???[?r\r?k??L??i)F???Z<?R\"?\"??i?B??ed???*??zk?4K???b\'??~$???Km??I.s) not found.??Z?q???\'?Q?Unable to render embedded object: File (ft1$Z???2?P?C) not found.??MEx?\"??6VH<?p??M?
      ????U-?-6C:<
      ?]&K@B?.??G[6?dS`r?`K+??m?f??E?R?b5f^?

      {.?R?\r;^???n![??\Z?? ??\'?!?;Wbm\'?kB?5?\r?n?Q?????w?Y?T?#y??C?`???[Hy=?6P\"tp??/ ?D>?p?Q?5|a??p?+\\?4?aV?S??/qWF????,??y?(????1?d<\Z?X????-?dV?JN\"?]?$dR44h???3/??ho?5??| U??\ZWt\"???%??UD?Kd)\'??i?j\0%??????\"???*?Kh2v?#?e???\Z;???lmb+?DN?w??& ??y??V?R}

      Hm!G?XF!\niuG??9M&?B?Mc?\"?xZy&??E??6e?? ?|Vh0?D?>????kExm??T??b?<\'?L=dBZ?B1??5?v7^??LUnable to render embedded object: File (+(??h(q?qn??6??$w???s????\0%?\n1?y?n???????]T?qt??.2?0?g????\r?a??) not found.?vhN6|?o??Z??I?j@c?M29aV@`???4?)4\"?6
      ????e?[??wK?{? >:?\r?|?^?V??N/??7?jJ??YD?`?j?[?)???\Z??\'k?R?? c??7 ))>???\0?lS!\Z?,?{??????=^b??????\\????B?Q?#R??jA?z?+? ??????)?????0?b???+?A=?;p??3??K#?? ?!??*??+ttB?h???`?<\\C\\?2??{????%D?A?Y*??`?k?&eQA?0C?x????????1???Q+?c ??C??._?x>????O?@???? \0?????0.??@?\n5??,{?5.;?S??b>c\"??D??8????\rbD{??B:?hS?\"???>??y????3?A?1??YY??r??5l??,??y??rF??_??*?,???y?(c?,?k?;?3?qz???\n? 9>?\04?? R$???#y?}??}L???ZH?kH?0????w?(?(?,V<9?<??%??B??U$?hD????$k\"P$l?mt,D??d?\0?o?\r?k?\r??.???l??tH??@???h:I????c?9T?\Z???(2*Y?S?t???o??,???G7+???\Z?T???AW0S?O?0?P??K\Zc??17?j?B???X???\r??? ???$????m+7bi?l??K 0?%?d????????=???J?j?O??;????$\Z??Y???o+???;??r??|L?|??$?i?!?K?Z??9B?4??$?j@?j??R\n????\\??\r^???#?A5?C?????TN?l?M d??hE%???X?:bM??4?$C???O????<??Q???4??Lb!D??x I?????{???yO\n???????xH?8???H?2??\nPE+???)????)\Z?:???OM?<\"?l-????s?\"}??!?|BW????(rr?K??\",?6???Glz??;:8??\nM?t?z$???!d?`X??e?$?BM&6:??0?{???,;?1\'?P?>5@?l?&2????\n??H???I??????/?Ak??U\00U??qQ????j??-?;?aT?Y??L??SML???????1??MQ???i]0DX?U\0?Od\r=z-??Sf\r?%?5Nl?l?m?Te??WL??X?m?L?Wy?B?X8P?BF|?5]??f?Wf<??Wn<
      ,S5??\ZK??U??O? E?PU????uk??Y?N??,?2\\?2??X?l?\'?Y??J$Z|?^LR&#?=????? ???

      {=??6Y8?U??4??5??WM5ZW1?m?????Z1#??????S)???\"U?BY??Q?}

      ?S?{;[?8?9????M?RD=??gl?Ce??4????k9?v??$??!????4z??/:o?!?UnI:?d¤???2????qZ??C??: ??>?d?7?<?????4\r]z??eE\"]]c!?YI?K?Dc????-D|?m?\n?(??aUnable to render embedded object: File (`) not found.\\??0?&9M`???Y?3mH??9?T??Uz=jJ?x?Z?,l>?$?#???aIE#?mab?O\nzbB?m2>?)$?n??d?C*?#}}??k
      ?k?&?ZO;.)? N?Gy;] V k?P??cjc ???zrYn#pZ?d??RUH??@?v)?;?@?a=?,?4&????;?d?`?D^DK0?Unable to render embedded object: File (On?S??>iAN?F%???E??hnr?2???fwe?o?????-?ic?-?\",?XI?(???2?^j???P]B?GK&???b?) not found.?\nD\0c ?e??b??\'\Z?3NX?~ui3K?W?~Q.A??8????Tf?(?NH?.!?+?U??V??YFM?*?i$mlG>?X?H?\r?-??b?)?I?A??k?e??P\"fn?N??hjpA??(Nt??KpD?

      {>n??l???M9%??D?*???K??YIl??[?]?k?:?}

      Eo?)i?T?l?qM??%?*?(>fd?\0Uc?4n>?6?f?pL<?\Z??]?Y?C???4??J??/?n}i?$??#\n?P?P?.?J3?L0??j?F?*q?Y?>?dJ?vZ?Kn=?\n?.!?n2?KT?r.7\r??p.?;??k?T? ??;=:?\0ijm]?;~?-d??t??R??Ft\n?E?>\rC?t? ?GL7\'?=uT7ge1??h?ny?????H??f??qri{?(?G?r@?P??]vf?g??I>sK?m?k?H?@H42JW?|[?q;??j\"I?<c?uw??x?ce?V?F??o?\\N?????T6I:?^A\r?5C??w???\0?B!?k??n-9V?\nYu?.?j?k?xY?y?A?y@?X?oGHkG???jc1?I??l?*s??O ??L\r?k<U1L??IKy??sLi?k??NT>?YL?JL{m_?=?{\r?2?W{?g?t?\'b??\nIfo?\Z??p??MH,?6!?p?}??s?G???/U?????B??L????\r?`??mr???????#?a?`?x?X??\"}??W?*P?-LI??\'}??7??????o??7)?Wb+h? ?\n[??f*P V??b?-??\Z7r??1a???>?,ip?@\0*W?l??%?2g?i?&?:w????\'?B]?(j?\0O??L2?Xmd?R9\n?\r??Y]K9?+?bo-k?,?J?je?r=Z?s?M/??.?r?Z?

      {\r?^????5lgl??2f?(\rs???3??h?f.??r?j?>?????n?>.]Z???w??M8?m????f}

      ?O,|?p??D??7?s?5u??K?Rm?\Z?3^?=??I??8?>?W????>?`?
      ?? SY ?J?b(1?W?]F?M?!?!?V??v?`V?$F??Zy(\"?1??R-j?
      \"?,?R 3\n9$?j\r?W!?n<UX??W$?UZ?T\'?R?eG=??e?y?KB[.?B?i??4?WP?J?&?}??}??m]U??J%\0?ba??\'JJ?>??Kw?z?iw?_?,\"?t???6x??TE?@?)G???$[?N??*?,?C?)T\0=ZQT??Z{??j???z?;.@T????;(+?ke?\n?U?;G?)0??B0R?7|1?(??5?j7f?$-\"?1W?oT<?<

      {qP??cR???g%??S\r?\'X??t|?5?mN???6)???5\r??P?????Y???\n??c????x?@?????k???8?}

      s?8?+A41K4?xM??????zr2.y?w?W?L??3?jk>??9B?4?9u??d?G]?Unable to render embedded object: File (??.?I??e~?cj) not found.?;?n?/??o?\n?Vo^v?<C?m??dMq?}?\\?{V????t?R>??s%?p(e?5??G?A?o1?Zds??W??F4?`?`?>?m?o?\"?0/T4?-h?\Z?Ng*F?H?h?\Zv?7#@v?}\Z?? ?T?e/T??D?/\'<@?=?Yq*cLR?L?; k!?;?0\rcmt?Yhi??)c??? ?d??S?on?6??)?p?K \nB&C?#J4\"?|??J&D?gD??Z\'?2#h??l4%l?C?C( R? ??7K??9LC??n?K?n?a??N??6\Z?;?v?
      A!
      ??e??9r ?`?%????2?7?B?r&?H?,\'??$XL?)K81s?m5I\\??\\??)M?K?<E?d?????w?u(Ib*m?A3?S\"??O?|r::?x?Y?{?(y??hu.???)J/U?5?Pg]?NdF?s\n?,?L\r?\Z6?s$fN??@?T+`k?Y??F?4>=?Z1?;Y??u_U??v?6?}\rkt?E?f?
      ?Unable to render embedded object: File (?\'?O)D??N??-B2??+??~??E?1)??????y?<5?z??E???p?a ?+H?4P?\") not found..D_7V??[?@!}?k?C??0.V?~?u?7??5B?W/X/R 3lU9?7wID/?Uke??@?g?c?n??RX?<7C?b?.D,.i?Xfj?q}?)H?I\".\Z5?9?\\C?\')?4?,??{?Ey? ??*g?`?seMB^=KT?v3?ze@&??y.:e?qLch?4e??rvA??i?oL?l?;?4D\r :?K%?WQN:?M.T!?}e?,?$!CE?f?>?,?[Iu??????zx???_ijl?????j????$S:@w)?????? ?t?]?u??^5W\r?r6????X.w??m.c?9?R?z/?U?\'?\\\\?.Deb??s/\rIy?~km?)?f?F?? B0?i(CY$?.q??i#??A9\"/?L??J?r??[nnr?9o~[I?;?N]Y??`?$G?l??pVq???}7?O?t?<c?C1L]Z?K_E?G??Q+^x?JW?xqA?#?1?)?+?\\?&:?>7?;?:Lh?+5?o??t?g?!e/d??q\"?W2???+g?<~p?y?Et??PR4?\r;? e\\l]D????\'~Nx????z?q?,?m?0I??9 ?1C??n)s`p??i ?i
      ??
      ))Q?A?G ????1F?kUnable to render embedded object: File (?g???@?H?????i???=????]GT??r???\n*W) not found.`?$\"&?Q?#?|Q&??b?U?}??T?]OIT1?n?O??A?A\'R?Unable to render embedded object: File (rHZ\"(e?t\r? ?bp(\"??) not found.?R4Q?t,?\\W#?%\ZiQ? z#;}?z??;m?Q?????c?[?T??v?$?7:TY?3r?;J?9? ?6?8O\"6????c3R?d4?a?$[?-?^df-?I ?\"?fUR\\?eFjiI???:]?-I??EexWMv?Dp!0?Lf?e[\"?}?bMX\ryZ\'#x,?M??C??Ae\"M5$?,?J5?t4?Y??mDb~H?B?XZ?H? ?d7&c?Uef?U!\"?M?Mdfa?\0?%??9!,UA?H\\a
      ?????? l?`\0?LK?)S[n?c??/c?yf^D??Vt?$2&?U??cAV?W??dB?;e?K?U?y??i?QE\'?s?#\n??t?k??%??sQ?U\';/=?5N?V?m\\>6?%?$?@??eIN!??XL=??un?/?Z^YP?T4?jUd???A\nOO?Vr??B???4??y?}??K??g?9)?cbFH\"?f\r)E?\'8?\"E??8?T?f?cl?(?\'=M?;ii[d^Qi*?x?#?H?}?E$?? ck?V?%?~i$?\ry?\'Q:\0?%?bdp?h62Px%c\0?$??M?F\nb\n%enqjs?Z%?|?\r?\n?Pi?Lq?A
      ??pY?IY?*I?dy?(??F?J? ?%\'?Z??T??????|O)R?/jI,?:$|???\"?1?}8hpV#Unable to render embedded object: File (??&\r??F?+??*?6?\Z1???2????/???T???????????V?\ZD?e?g???}?gA?e?\\????~?????????n???P??A?!jHpn?h?j?kYTL??n?(\0x\Z+) not found.?*G??J?VN?F?U??Sx?t?ld9RLJR|?%?i-R???j??7??pi?s]?.\\??f??fD~e3??Hv?????q\Z{?wm.
      [`?\"?>?%?o8?X???H?H\\????G?y??0??D?K?SZ?[!?49?$I?(?W\\.L\"\\b??4P??oDa?`Q?l]\Z\'?E_?m??ps?`?\'W??3?r?m?J? 2?\ZS?cH\n\n?X?sB?(S:?|\0??i??:G?k7?)r\\?S\"??wf]2?&V?cI]o?OG?j9o?!E?gp??*?%?\\?L,XJ?W?)$?m??B+w?=[*?JV?????]??V??7\Z?\Z?h??F?LR??e?k?[?/?iEls??NRi_?-?:?36??F??????\01x?d?lC?DT7?9??r7$3?v?w??7y?R?&?WI?G??r?D?{?? Q?}?/k5o??{D?PN#[-O?NfG??oB]xvq0?y ?n???,a

      {cn?6}

      t8P?qC??U?f??s?d?ss)6?xk?)?Pui[B(ve???\'R?/????ja???:????U???\'?p7#?}?Xc???3???R& ??B??\Z?#nV?r?w|1b9???wj??9??Jt??O?qd?=F?Xw?@?bLW?H??l}6]??d?x?=?=??T:?8?+??\0 ?y?FgSu?s?fFyD]?\n??;^?\"?E-Qcnn=?^8j??v1ss?mg?+8??0(?G.?yY??\';?D??I?o@.???b?\'Fp?4I7W@?>?f?J?u?R?F?z|U?G\n$?m?dq?Z\'??6{?,?\"?\nD) ?_?;N=-1~?x?r??{y??l?K?t?O?vgW??ra???D$?>?5?C)<b?i?n?o?C?^2?f3!?E?{?_?K6{?????2B\"?oO??Qu:N?88?e?C?F???65=

      {h6???A?]R?Pq????5?1?m>\Z???4?u?;V?!?<uXAh?e?S????frS???=Kzqo,?#?6?;??l5?mH??:\Z??PMMu?\Z?N?=?/=???NmfJ>????>\0??1?C??KP(%??^nD5l 4xaB?Y??bA?(VpcF?9v?X??B?=f??J??)Y?$?\ndI?3ij?g?u????\'?jV??\\U\r)R???]SYMPQ??*l?Z?[?Z?U?d?YVj??8?fD??JV,??+X??b??k?5?r?&??2n??r?t???=W:=xM?R?`??|p??c??//???\\J?X???K?l?i V?b?v??\Zl??_??=zx?k??B??w??? ?Mm?-??hu?%M????+/?xO??\r??P??M?O?5???Gc?_1??zo2?PM@??\"0?????kP??fa???J.????\Zk?Bl?J?h????V?s(????-*k;[?I?G?H?0?z?i???4(??n??D$?\ZR??X??+(??F9[??u?F qD?K??p\nK????@?$?C$?L*????2mK3?l\"S?+?A$9+?&???U?D(?xl????E3?@V?lQ??PKD?t%T\'gc?>l?\Z?5???>??c?2??r;TS?)>/+????6l??2[?*?jd?+\n?q??\'\'??_??MX?\\?:??JN?,/???DXq?4\"?z;?\\?\\?j%h????k?0=???g???C?)?G:,1?l???B? D6_??H??/?eM?e???????wjt ?}

      V?y*????7:6??l+XTV{f@&=K?Y?6?j??#h?wM??n?`;:y?R?Unable to render embedded object: File (Y???\"?FhM???+?&??{??????&?2??;?JI?jeRdZ) not found.}V?K\Z??S??C?v?u\n?I??;wmp??C?a??o??p?c\r?k+?;%?P7^(?/?sy?=w?}?L?KvkO?kJ}R?D??w?????#oX?hlg4??H)?@??U?Y??7?@????Z?*T?\'?6?xkl?$??0VF?\\?DD|a?h#E%~5\r?n@,?U0X\n%\n?g??l?%\ZW?I?DEQ?6?]??T%%?k?(@V?)\"%C?A@\\?\n???a??G)Z??\\A?CT?U|?\Z?:?;?U?G?Y ?\rqa\"eD??t?:?d?@z:??\".x?C?H;3?:N??0#1m???D?L?E\'?L?\Z8?)??lQ?\'4e??E*o?I?m??%?d?W??n\ZL?R?%;iGM???T*?Q\n?=?4?9$x?P?-TR\"5??XY4g??U??G:G?=?M?$?t?K}??Q?N?B?)?s??s?^B?Ya+e?3k?? MSKFV??(0?\nD?5?4?~Z??W?\Z?O??gf?Ia?]eU?_?C?2T?+r\Zd?=Q,?f\'U\npv?]l???;\n?P??1r-cf ?Y??4?l63?3p-?D?S?`?9@?K?s?k??Z??? V?@H?Y?g?%??e??A+F?3dA.M??3>?n?i??V?)?p?tZ??????6?w??y?#}\'3?+qmt?f<?L??I]?N?o
      }0czP
      ??)7c_L%F ?z{?&&&U|a???sB?Unable to render embedded object: File (E??l??) not found./X?XwZx_2b4\n
      ?= l?}YGVx`C?Q??y?Z??=?Q?t?w??n??5!W?w?\Z2,?v?
      \"3?5P1{??wQ??AS{D?2!??iD?e?\"Oo\0?C?3?Fy?C?1??KzKE4&?Unable to render embedded object: File (??1???? ?/?V3HX) not found.-A\'L)?zA??sH:))?\n?v?3zV?f?w`\"{/?A?\nI??~g:?ib??6?v?H??L]Y<?.9?J\0?O5?n?s?x?mq?-W?&?d?\Z?5?L=?=?\\???\'x?uN?A?X_?@?>??? jNX?~W?F=?5?!RK6LU4/}???Y?2??j??8p?OxH?/?HM??f??H??lQ<?/?\n?M=?\"N4P\"?/?Y??@d?\0?\Z??m?p+R??d?$i??H0U?mp?.?\Z??Z?C?h/?\n??o??`?%F??P?@?H\n\nhld??rc??P????p[%m?2L2?OO?0I?\\?\"X^.\'\"?z?1?wj??0Zx\r%(m\'/?\"?N?f?r?V?\\??w??2?N^P;h?`6?????1V?\"\n1EV?>ZA?F????0h???I dPe??quf?d\n??A?y,?0?j0$Qo??\n\n?oq2?Pd??B7?p?\nC\ZM)?e??=?\'?\r?%h??6ks\"?_B$?.\"?\0r??h#?1u?O\'c?Ph1%Unable to render embedded object: File (b???\n?G???4Keb???P??\'?o\") not found.\"?`?~R?0Z?1\"{?\r??q? \n?/Vj??4?\0?V0?\'\'?\r?x?\",%( !?\\?\ZQ?^E\'#UJ @zf1#\"?/Q??H<?/?X?%La>>2?6?0\Z?2?pN\'?l\'UH2[?gH*/?*yI#2s-\0??d?n?\'\'?c???U.?$??4?f?$??B?D.\r#??6m??tS&2?,\0????N??.!?R?I?^fZB+W?:?(=R?k|b1??%U*??\'??\'?P??T?b~?D^???i?d??\Z&&???!?/B?h???3#??0??O??2@??D?3abs$?????(i?SCm3(??=P?Ii?????\\c?Z?_4F3?3????\n?????t??,??????+`?9?????????e`F!?\r?(,?sN?k?/J?93?PI+?S??~??????eL?4 o????L?eP?HSP?P?Q?4??gJ??FK?K?CD>U??tR?4?^?6??4%?2??/??!?Q?fPK?%?4SW??v? N6??d?7???\"?+?cGCFD?jS??T?qY ??b?&???)??n???l!??A!??zQ???q???E5O?OK?\Z??Ly???\'?6*%???:c?4q??B?*z(%?a1???DBU?O?2j?GT?mL4???\0\nL?VVF?RGDS@ *%?????\"??:u%Ud??a??N_??D3??Be\r\'dg?,k?(??c?%YS0v?Z?CtDH??^?Vq?\\wQg??i??,eVj?SU??L??B-??8KL>*??r?^??k#_C?b?i?f? ?@bPFv,n?K?P???8?n]?\nA??Q?v ?@o?r$\Z???rS)2?.?r#w?v[.?` :Pt??j?P?(Z[?u+\"\n??u?3v.?p??x?5?c?\0y?C?vWJ?6?W\"?z??<?6)?e^<??u??2{??w??r?&>gw??N?

      {c|%?t?IRSRX?7rY??D?R=*?P?}

      ?d[cZue?F?B??a?I?m? ???S?\n??Po?\Z?N?&??r\Z??b??EX!u??G?Nw+?H+?f?{??K$[?$??n??p?$/??i?PU?^ ??K?F?M@?|b8?([\"?_c,Yb?$??HYAcme{?8n??I>?eAT1?\n?[2\'J?]??? ?%?? W?g7
      ?d ???bc?v
      $T%?9V??\'0B7??T??C?.?S!!?|?){?b ?nk3/?\rb]?\n?6?ww??t???Z? )?\r?jo??w?T?uUR??Z?7?V?/?g\n??b???][n~?q?U??nJ?\0? \0??y?8??4??5??M??Oi ?ZjI?z|\r?1?g??^Ju1??t?*??9???@:??4p?h?y?ghl}fx?g?%?d?e?6?o\Z~?C?x?::?y?e?TZ?r%A#?X?Bc???sp17ZFt9?V??BW?z+?z??r? ?p?Z\0yM????r??Qs?\"E??+?[d-~-??]?L??? 0?f?`X?<W@???3W+?3?R3F?0?D?J[?\Z?7?\Z?-?3\\SO2QGj:?GW??\Zf??\"\'1?K??7{j?n?*5?N+y?CJ?E???O\n;?*?:J??W?{?\Za?sU?X?\"?[?7??u$?4N??Nc$?? z??????

      {RO\"?}

      \r7??y?{`??5¦\ZfP?9???M?3??EUa?.\n?4??bVZ?$?{?gb?p;?uU;5T??RS?k????9??eZ?<%?|??XZz|Unable to render embedded object: File (<???l?????;u5?uBe3??]YKC????F?<4???M?????) not found.?;????T?_U?e8?]rA????M??1??d?g?*QB?UJ?r&?M??==IY{]??j?g[1?\\R??i\Z????? %?????|?^T?<5?t+?F?????+Mu-<??

      {mV?????????x?b?]U?h???????At??}

      \"?*?]??#??e??B??X????y?i?o?W?I??F??CAH?l??S?W^?%D?\\n?6?8??w?q?b0??Q?5\\tC?}]IR?,?]?s\\?L<(???$?9???m??gk?7??????F}?<?>@??A?\0??a???)-_?|V?\n?;k==&??s3(?Q???]a`<K?.?e???[Td?e?i??}??.?4XW>???O_????{\'?? ????_??bB]?7?&s??v?????^i?\Z?l?O??\Z<?0:|1?c+Z??1#EW]a?2??$K??X?,[?<?\Z?4?k?<{ 4??D?\\?Q??\'[US?4????¦r?V?8s?4\n6??d?=???V?U??}k???p????|???k4-?\"??]Z?R?R:~|X+V\0??9?{?kX2\\V?\Z[N?[?\r[?g?[>R?L?:?c??#T??y[7V??d???f??#?>??^?K?5k?v?*?I\'}?\Z?????8>????x??]UB?\\H*?D?=U??h?h?_?YN?Dh6b?[K?V?qx?b?cy??,1?u??\"c?b?>?:?F#?J.CH?t$?\0FI?H?5?e?M?`E?V?U%6?Mf??i?f?)X?f?;r?f?v??d?r?)I? h???H?Yh?\n?h?}U?U?IcT??6iM?:?i?aUe?\"??tb*?I?z?j?>?\Z?2u\0?c?y?????J*Mg?PEP?\0?Vy%Nk?Y?d?B&Rn\ru[f?Q?u?\nz?*cG??o?\n?\Z??Ky?n?y\nYSs?p???Kp??z\"?U?/QU????Zp??p@????-??P?$??&?LQ?\ZOq]m??o+?(?sD-?]+?c,?t? ???ie?\0@e?\"?^Vl}?<U??o?L1?j??@76?o??v?vg????v??Mg]P ??D??y`Q7?@?^?v??y?H?.T?er?J?QA?cs??Dlj?z\\??9?{#?\n$`?/?Y>7}??OO}_?}o?}{\0;')] [Duplicate entry '26' for key 'PRIMARY']
      DBerror

      Oh, Zabbix frontand dont use identity! Ok, search where they store it and found in table "ids". Change for "image" table to last id in /root/zabbix-2.0.2/database/mysql/images.sql
      mysql> update ids set nextid=187 where table_name='images' and field_name='imageid';
      Query OK, 1 row affected (0.00 sec)
      Rows matched: 1 Changed: 1 Warnings: 0

      Again add image and get:
      Image added

      Lets try to import maps. It again show error that cant find image with some name, so i add it manually. After that my maps imported succesfully, but with some errors:
      Imported successfully
      Invalid argument supplied for foreach() [include/classes/import/CConfigurationImport.php:357]
      Invalid argument supplied for foreach() [include/classes/import/CConfigurationImport.php:357]
      Invalid argument supplied for foreach() [include/classes/import/CConfigurationImport.php:357]
      Invalid argument supplied for foreach() [api/classes/CMap.php:702]
      Invalid argument supplied for foreach() [api/classes/CMap.php:702]
      Invalid argument supplied for foreach() [api/classes/CMapElement.php:624]
      Invalid argument supplied for foreach() [api/classes/CMapElement.php:624]
      Invalid argument supplied for foreach() [api/classes/CMapElement.php:624]
      Invalid argument supplied for foreach() [api/classes/CMapElement.php:624]
      Invalid argument supplied for foreach() [api/classes/CMapElement.php:624]
      Invalid argument supplied for foreach() [api/classes/CMapElement.php:624]
      Invalid argument supplied for foreach() [api/classes/CMapElement.php:624]
      Invalid argument supplied for foreach() [api/classes/CMapElement.php:624]
      Invalid argument supplied for foreach() [api/classes/CMapElement.php:624]
      Invalid argument supplied for foreach() [api/classes/CMapElement.php:624]

      Dont understand errors, but maps looks like ok. And now, if you are not tire, this is a problem: images not appears in Zabbix frontend after upgrade from 1.8.8 version.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              alonnya alon
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: