Loading...
 
Skip to main content

error if inserting tracker item from wiki plugin (simple tracker)

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
error if inserting tracker item from wiki plugin (simple tracker)
Version
1.9.x
Category
  • Error
Feature
Database MySQL (MyISAM)
Trackers
Resolution status
Works For Me
Submitted by
Xavi (as xavidp - admin)
Lastmod by
Xavi (as xavidp - admin)
Rating
(0)
Description

I created a tracker with several fields, mainly rating, textareas, dropdown, user selector, date selector.

Id position name type options isMain Tbl vis Searchable Public Hidden Mandatory
291 0 Rating system -2,-1,0,1,2 - y - y - -
293 edit 20 Descricpión de la incidencia textarea 1,60,5,1000 y y y y n y remove
294 edit 21 Tipología de redacción colaborativa drop down elegir uno,documentos de ofimática solo... n y y y n y remove
295 edit 22 Comentarios textarea 1,60,5,1000 n y y y n n remove
297 edit 27 Dia jscalendar n y y y n n remove
296 edit 30 Informante user selector 1 n y y y n n remove


Called all fields from a wiki TRACKER plugin (the data field and user selector are not shown through plugin, even if configured as "public"), and submit some data (required and visible fields).

Then I got this error:

Copy to clipboard
Warning: mysql error: Duplicate entry '240-296' for key 1 in query:

insert into `tiki_tracker_item_fields`(`itemId`,`fieldId`,`value`) values(?,?,?)


in /var/lib/gforge/chroot/home/groups/gclub/htdocs/lib/tikidblib.php on line 134
			

Context:
File	/tiki-index.php
Url	/tiki-index.php?trackit=10&page=prova&refresh=1&track%5B293%5D=prueba&track%5B294%5D=Wiki&track%5B295%5D=prueba&authorfieldid=296&track%5B296%5D=Xavi&action=Envia-ho
Query:
insert into `tiki_tracker_item_fields`(`itemId`,`fieldId`,`value`) values(?,?,?)
Values:
0	240
1	296
2	Xavi
Message:
Error Message	Duplicate entry '240-296' for key 1


array(6) {
  [0]=>
  array(6) {
    ["file"]=>
    string(65) "/var/lib/gforge/chroot/home/groups/gclub/htdocs/lib/tikidblib.php"
    ["line"]=>
    int(84)
    ["function"]=>
    string(9) "sql_error"
    ["class"]=>
    string(10) "trackerlib"
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(3) {
      [0]=>
      &string(80) "insert into `tiki_tracker_item_fields`(`itemId`,`fieldId`,`value`) values(?,?,?)"
      [1]=>
      &array(3) {
        [0]=>
        int(240)
        [1]=>
        int(296)
        [2]=>
        string(4) "Xavi"
      }
      [2]=>
      &bool(false)
    }
  }
  [1]=>
  array(6) {
    ["file"]=>
    string(75) "/var/lib/gforge/chroot/home/groups/gclub/htdocs/lib/trackers/trackerlib.php"
    ["line"]=>
    int(619)
    ["function"]=>
    string(5) "query"
    ["class"]=>
    string(10) "trackerlib"
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(2) {
      [0]=>
      &string(80) "insert into `tiki_tracker_item_fields`(`itemId`,`fieldId`,`value`) values(?,?,?)"
      [1]=>
      &array(3) {
        [0]=>
        int(240)
        [1]=>
        int(296)
        [2]=>
        string(4) "Xavi"
      }
    }
  }
  [2]=>
  array(6) {
    ["file"]=>
    string(87) "/var/lib/gforge/chroot/home/groups/gclub/htdocs/lib/wiki-plugins/wikiplugin_tracker.php"
    ["line"]=>
    int(69)
    ["function"]=>
    string(12) "replace_item"
    ["class"]=>
    string(10) "trackerlib"
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(4) {
      [0]=>
      &string(2) "10"
      [1]=>
      ∫(0)
      [2]=>
      &array(1) {
        ["data"]=>
        array(6) {
          [0]=>
          array(3) {
            ["fieldId"]=>
            int(293)
            ["value"]=>
            string(6) "prueba"
            ["type"]=>
            int(1)
          }
          [1]=>
          array(3) {
            ["fieldId"]=>
            int(294)
            ["value"]=>
            string(4) "Wiki"
            ["type"]=>
            int(1)
          }
          [2]=>
          array(3) {
            ["fieldId"]=>
            int(295)
            ["value"]=>
            string(6) "prueba"
            ["type"]=>
            int(1)
          }
          [3]=>
          array(3) {
            ["fieldId"]=>
            int(296)
            ["value"]=>
            string(4) "Xavi"
            ["type"]=>
            int(1)
          }
          [4]=>
          array(4) {
            ["fieldId"]=>
            string(3) "296"
            ["value"]=>
            string(4) "Xavi"
            ["type"]=>
            string(1) "u"
            ["options"]=>
            int(1)
          }
          [5]=>
          array(2) {
            ["fieldId"]=>
            bool(false)
            ["value"]=>
            string(5) "prova"
          }
        }
      }
      [3]=>
      &string(1) "o"
    }
  }
  [3]=>
  array(4) {
    ["file"]=>
    string(63) "/var/lib/gforge/chroot/home/groups/gclub/htdocs/lib/tikilib.php"
    ["line"]=>
    int(4117)
    ["function"]=>
    string(18) "wikiplugin_tracker"
    ["args"]=>
    array(2) {
      [0]=>
      &string(156) "Formulari per informar d'incidències durant la redacció colaborativa de la "Guia Erasmus", segons la tipologia de redacció colaborativa emprada"
      [1]=>
      &array(7) {
        ["trackerId"]=>
        string(2) "10"
        ["fields"]=>
        string(23) "291:293:294:295:297:296"
        ["action"]=>
        string(8) "Envia-ho"
        ["showtitle"]=>
        string(1) "y"
        ["showdesc"]=>
        string(1) "y"
        ["showmandatory"]=>
        string(1) "y"
        ["embedded"]=>
        string(1) "y"
      }
    }
  }
  [4]=>
  array(6) {
    ["file"]=>
    string(63) "/var/lib/gforge/chroot/home/groups/gclub/htdocs/lib/tikilib.php"
    ["line"]=>
    int(4399)
    ["function"]=>
    string(11) "parse_first"
    ["class"]=>
    string(7) "tikilib"
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(3) {
      [0]=>
      &string(752) "{img src="img/wiki_up/Categories-ADMIN-001.png" }

img src="img/wiki_up/Categories-ADMIN-001.png"

{TRACKER(trackerId=>10,fields=>291:293:294:295:297:296,action=>Envia-ho,showtitle=>y,showdesc=>y,showmandatory=>y,embedded=>y)}Formulari per informar d'incidències durant la redacció colaborativa de la "Guia Erasmus", segons la tipologia de redacció colaborativa emprada{TRACKER}

{TRACKERLIST(trackerId=>10,fields=>291:293:294:295:297:296,showtitle=>y,showlinks=>y,showdesc=>y,showinitials=>y,showstatus=>n,status=>opc,sort_mode=>asc,max=>3,filterfield=>294,filtervalue=>documentos de ofimática solo acesibles en local,exactvalue=>)}Notice{TRACKERLIST}"
      [1]=>
      &array(2) {
        ["data"]=>
        array(0) {
        }
        ["key"]=>
        array(0) {
        }
      }
      [2]=>
      &array(2) {
        ["data"]=>
        array(0) {
        }
        ["key"]=>
        array(0) {
        }
      }
    }
  }
  [5]=>
  array(6) {
    ["file"]=>
    string(62) "/var/lib/gforge/chroot/home/groups/gclub/htdocs/tiki-index.php"
    ["line"]=>
    int(401)
    ["function"]=>
    string(10) "parse_data"
    ["class"]=>
    string(7) "tikilib"
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(2) {
      [0]=>
      &string(752) "{img src="img/wiki_up/Categories-ADMIN-001.png" }

img src="img/wiki_up/Categories-ADMIN-001.png"

{TRACKER(trackerId=>10,fields=>291:293:294:295:297:296,action=>Envia-ho,showtitle=>y,showdesc=>y,showmandatory=>y,embedded=>y)}Formulari per informar d'incidències durant la redacció colaborativa de la "Guia Erasmus", segons la tipologia de redacció colaborativa emprada{TRACKER}

{TRACKERLIST(trackerId=>10,fields=>291:293:294:295:297:296,showtitle=>y,showlinks=>y,showdesc=>y,showinitials=>y,showstatus=>n,status=>opc,sort_mode=>asc,max=>3,filterfield=>294,filtervalue=>documentos de ofimática solo acesibles en local,exactvalue=>)}Notice{TRACKERLIST}"
      [1]=>
      &string(1) "0"
    }
  }
}
Solution
it seems to work already
Importance
5
Priority
25
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
498
Created
Wednesday 01 February, 2006 01:27:41 UTC
by Unknown
LastModif
Tuesday 16 January, 2007 10:26:16 UTC


Show PHP error messages