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

Background image upload fails with "Duplicate entry xx for key PRIMARY"

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 2.0.5
    • Frontend (F)
    • Debian 6.0.3
      mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (x86_64)
      PHP 5.3.3-7+squeeze3 with Suhosin-Patch (cli)

      When trying to upload a background image, I get the following error:
      Error in query [INSERT INTO images (imageid, name, imagetype, image) VALUES (42, 'Hintergrund Netzwerkplan', 2, '...')] [Duplicate entry '42' for key 'PRIMARY']

      Looking into table "images" shows me that the last image with imagetype "2" (background) has imageid 41.
      But there are icon images (imagetype "1") up until imageid 228.

      So it seems to me the import logic does something like "select imageid from images where imagetype = 2" instead of "select imageid from images".

            Unassigned Unassigned
            maxhq Jens Berthold
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: