-
Incident report
-
Resolution: Won't fix
-
Trivial
-
None
-
2.0.2
-
Debian 6.0, MySQL database
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?-
?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#@!?%2??w??8=2??Y7?&\'?el{$\'??b#ybO\refm?gc?!?+?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????
???fGvR?o??R?I??c??he?-
?U??|?.?Yb?J?#?G??u?g??K? ?dL?g?Vc?iP?
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\"?]#?!?\0(.? ?G?(QG?{\'???Y??mPA?C?R????9??Y?g?<?94{g?Pny8??q?y??tp@\"Qw?!?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?=?!o/o|q?d?C??B??%.\ZWU8??}M
>?9?1%? sC??i?f?4?a?[?L?q?9?B/?@4A|?Lc?0?D? Qre?\Z?\0
q%ECl B*9`E?xD)2??h\\L5????k??JBA\"?#??A!Unable to render embedded object: File (e8?jh?#??? ?.??w?\n?\r7\Zq?t?+??C??) not found.?H?hIB<?#C?!.??s?%??o??E??j??Oa?6?j\n?:??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!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^?
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&#?=????? ???
?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?(??a!X@?????Ch?&3?????\'?H?2?x:`!\\??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?!??1??AVe)??D6 E3?]N#??m?B<?? ?Au?Z?S?g?1?\'S V?3hhX??Z?4?eK?W?T;Bt?@c:?#?uL3 C?E?O?L??zF??U?;\\?2f{mJ.\nM%?^On?S??>iAN?F%???E??hnr?2?fwe?o??ic??\",?XI?(?2?^j?P]B?GK&?b?!?\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?
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?
?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<?<
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?\\?!?\'?O)D??N-B2??+??E?1)??y?<5?z??E?p?a ?+H?4P?\"!.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?k!?g?@?H???i?=??]GT??r?\n*W|<?/??iTaJ?K^?????? |?\0??[?B4???????o]?hMJT?A?_]W( ?kD??W+$`Z}?gy (Y?)?=??a?[??e?0g!`?$\"&?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#!?,T???L?&??Dk??N?l?Q?~a?H?SFC?^A??B??@I?.??L@??U ??l?Ef? \'?b6?HYm^?v>+l??????.?R$g??L??j?ME%>:&\r??F??6?\Z1?2??/?T?????????V?\ZD?e?g?}?gA?e?\\???????n?P??A?!jHpn?h?j?kYTL??n?(\0x\Z+|lZb??X??\0?CU??B:/?j?.S?my?)j?a??2?F?8`?????????9??nbbC BFd(?????K??P?,p?DN?.G?/?ih?4.?[P?\'?& ??J?,?.?Dn}?h?y]?/~?:O??n?h!M??4?P4<`?ULf?p??0u?\'?BH?wN?y??P?X?p?+??rqp??qez? ?????X?u%3f?\\?\n-g??0??? ?!j@b?t?f\0? I!?*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
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?!Y?\"?FhM??&{????&?2;?JI?jeRdZ!}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?= 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$?.\"?
}0czP??)7c_L%F ?z{?&&&U|a???sB?!E??l|c?% ?{?K.:#a?a??XqK??T??7?g,?)Z
m?E?G? ?0u?3|??5??U?l??#W:?4R?0?$?=?g??5Y)??UEKY??wD?h?AVaVV?s\r&?E?P?u?5V?H*$?p?pE?J?`X?????dl_u?0?4uj??!??/X?XwZx_2b4\n\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?
?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??????
\r7??y?{`??5¦\ZfP?9???M?3??EUa?.\n?4??bVZ?$?{?gb?p;?uU;5T??RS?k????9??eZ?<%?|??XZz|!<?l?;u5?uBe3]YKC??F?<4?M???!?;??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.